Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AHROR012
Product: Human Resources (414)
Series:
Display Name: Archive_HR_I9 Group Display Name: HR Third Party
Physical Name: AHROR012
Technical Name: Archive_HR_I9
Group Technical Name: HR_Third_Party
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | EMPID_I | Emp ID | String | STR15_Employee_ID_I | 15 |
2 | MAIDENNAME_I | Maiden Name | String | STR20 | 20 |
3 | I9ALIENUNTILCB_I | i9 Alien until CB | Boolean | CB_I9_Alien | 0 |
4 | I9CITIZENCB_I | i9 Citizen CB | Boolean | CB_I9_Citizen/National | 0 |
5 | I9LPRESIDENT_I | i9 LPResident | Boolean | CB_I9_Lawful Perm Res | 0 |
6 | ISTARTDATE_I | IStart Date | Date | DT | 8 |
7 | DOCUMENT#A1_I | Document # A1 | String | STR30_I0 | 30 |
8 | DOCUMENT#A2_I | Document #A2 | String | STR30_I0 | 30 |
9 | DOCUMENT#B_I | Document #B | String | STR30_I0 | 30 |
10 | DOCUMENT#C_I | Document #C | String | STR30_I0 | 30 |
11 | DOCUMENTTITLEA_I | Document Title A | String | STR30_I0 | 30 |
12 | DOCUMENTTITLEB_I | Document Title B | String | STR30_I0 | 30 |
13 | DOCUMENTTITLEC_I | Document Title C | String | STR30_I0 | 30 |
14 | EXPIRATIONA1_I | Expiration A1 | Date | DT | 8 |
15 | EXPIRATIONA2_I | Expiration A2 | Date | DT | 8 |
16 | EXPIRATIONB_I | Expiration B | Date | DT | 8 |
17 | EXPIRATIONC_I | Expiration C | Date | DT | 8 |
18 | ISSUEAUTHORITYA_I | Issue Authority A | String | STR30_I0 | 30 |
19 | ISSUEAUTHORITYB_I | Issue Authority B | String | STR30_I0 | 30 |
20 | ISSUEAUTHORITYC_I | Issue Authority C | String | STR30_I0 | 30 |
21 | ALIENADMINNUMBER_I | AlienAdmin Number | String | STR20 | 20 |
22 | ALIENNUMBER_I | AlienNumber | String | STR20 | 20 |
23 | ALIENUNTILDATE_I | Alien Until Date | Date | DT | 8 |
24 | DATEFILED_I | Date Filed | Date | DT | 8 |
25 | PREPARERSNAME_I | Preparers Name | String | STR60 | 60 |
26 | PREPARERADDRESS_I | Preparer Address | String | STR255 | 255 |
27 | DATEIN_I | Date In | Date | DT | 8 |
28 | EMPLOYERNAME_I | Employer Name | String | STR30_I0 | 30 |
29 | TITLE1_I | Title1 | String | STR20 | 20 |
30 | TITLE2_I | Title2 | String | STR20 | 20 |
31 | BUSNAMEADDR_I | Bus Name & Addr | String | STR80 | 80 |
32 | NEWNAME_I | New Name | String | STR50_I | 50 |
33 | REHIREDATE_I | Rehire Date | Date | DT | 8 |
34 | O3CDATEEXPIRE_I | 3c Date Expire | Date | DT | 8 |
35 | O3CDOCU#_I | 3c Docu# | String | STR20 | 20 |
36 | O3CDOCUTITLE_I | 3c DocuTitle | String | STR20 | 20 |
37 | DATESIGNED_I | Date Signed | Date | DT | 8 |
38 | DATEOFLASTCHANGE_I | Date OF Last Change | Date | DT | 8 |
39 | EXITDATE | Date Of Exit | Date | DT | 8 |
40 | REENTRYDATE | Date of Reentry | Date | DT | 8 |
41 | i9_Non_Citizen_CB | i9 Non Citizen CB | Boolean | CB_I9_National | 0 |
42 | CCodeDesc | Country Code Description | String | STR30 | 30 |
43 | FOREIGNPASSNUMBER | Foreign Passport Number | String | STR12 | 12 |