Archive_HR_I9 (AHROR012)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AHROR012

Product: Human Resources (414)
Series: 3rd Party

Display Name: Archive_HR_I9
Physical Name: AHROR012
Technical Name: Archive_HR_I9

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString1615
2MAIDENNAME_I SearchMaiden NameSTR20String2220
3I9ALIENUNTILCB_I Searchi9 Alien until CBCB_I9_AlienBoolean20
4I9CITIZENCB_I Searchi9 Citizen CBCB_I9_Citizen/NationalBoolean20
5I9LPRESIDENT_I Searchi9 LPResidentCB_I9_Lawful Perm ResBoolean20
6ISTARTDATE_I SearchIStart DateDTDate48
7DOCUMENT#A1_I SearchDocument # A1STR30_I0String3230
8DOCUMENT#A2_I SearchDocument #A2STR30_I0String3230
9DOCUMENT#B_I SearchDocument #BSTR30_I0String3230
10DOCUMENT#C_I SearchDocument #CSTR30_I0String3230
11DOCUMENTTITLEA_I SearchDocument Title ASTR30_I0String3230
12DOCUMENTTITLEB_I SearchDocument Title BSTR30_I0String3230
13DOCUMENTTITLEC_I SearchDocument Title CSTR30_I0String3230
14EXPIRATIONA1_I SearchExpiration A1DTDate48
15EXPIRATIONA2_I SearchExpiration A2DTDate48
16EXPIRATIONB_I SearchExpiration BDTDate48
17EXPIRATIONC_I SearchExpiration CDTDate48
18ISSUEAUTHORITYA_I SearchIssue Authority ASTR30_I0String3230
19ISSUEAUTHORITYB_I SearchIssue Authority BSTR30_I0String3230
20ISSUEAUTHORITYC_I SearchIssue Authority CSTR30_I0String3230
21ALIENADMINNUMBER_I SearchAlienAdmin NumberSTR20String2220
22ALIENNUMBER_I SearchAlienNumberSTR20String2220
23ALIENUNTILDATE_I SearchAlien Until DateDTDate48
24DATEFILED_I SearchDate FiledDTDate48
25PREPARERSNAME_I SearchPreparers NameSTR60String6260
26PREPARERADDRESS_I SearchPreparer AddressSTR255String256255
27DATEIN_I SearchDate InDTDate48
28EMPLOYERNAME_I SearchEmployer NameSTR30_I0String3230
29TITLE1_I SearchTitle1STR20String2220
30TITLE2_I SearchTitle2STR20String2220
31BUSNAMEADDR_I SearchBus Name & AddrSTR80String8280
32NEWNAME_I SearchNew NameSTR50_IString5250
33REHIREDATE_I SearchRehire DateDTDate48
34O3CDATEEXPIRE_I Search3c Date ExpireDTDate48
35O3CDOCU#_I Search3c Docu#STR20String2220
36O3CDOCUTITLE_I Search3c DocuTitleSTR20String2220
37DATESIGNED_I SearchDate SignedDTDate48
38DATEOFLASTCHANGE_I SearchDate OF Last ChangeDTDate48
39EXITDATE SearchDate Of ExitDTDate48
40REENTRYDATE SearchDate of ReentryDTDate48
41i9_Non_Citizen_CB Searchi9 Non Citizen CBCB_I9_NationalBoolean20
42CCodeDesc SearchCountry Code DescriptionSTR30String3230
43FOREIGNPASSNUMBER SearchForeign Passport NumberSTR12String1412
44DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *