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 TypeLength
1EMPID_I SearchEmp IDSTR15_Employee_ID_IString15
2MAIDENNAME_I SearchMaiden NameSTR20String20
3I9ALIENUNTILCB_I Searchi9 Alien until CBCB_I9_AlienBoolean0
4I9CITIZENCB_I Searchi9 Citizen CBCB_I9_Citizen/NationalBoolean0
5I9LPRESIDENT_I Searchi9 LPResidentCB_I9_Lawful Perm ResBoolean0
6ISTARTDATE_I SearchIStart DateDTDate8
7DOCUMENT#A1_I SearchDocument # A1STR30_I0String30
8DOCUMENT#A2_I SearchDocument #A2STR30_I0String30
9DOCUMENT#B_I SearchDocument #BSTR30_I0String30
10DOCUMENT#C_I SearchDocument #CSTR30_I0String30
11DOCUMENTTITLEA_I SearchDocument Title ASTR30_I0String30
12DOCUMENTTITLEB_I SearchDocument Title BSTR30_I0String30
13DOCUMENTTITLEC_I SearchDocument Title CSTR30_I0String30
14EXPIRATIONA1_I SearchExpiration A1DTDate8
15EXPIRATIONA2_I SearchExpiration A2DTDate8
16EXPIRATIONB_I SearchExpiration BDTDate8
17EXPIRATIONC_I SearchExpiration CDTDate8
18ISSUEAUTHORITYA_I SearchIssue Authority ASTR30_I0String30
19ISSUEAUTHORITYB_I SearchIssue Authority BSTR30_I0String30
20ISSUEAUTHORITYC_I SearchIssue Authority CSTR30_I0String30
21ALIENADMINNUMBER_I SearchAlienAdmin NumberSTR20String20
22ALIENNUMBER_I SearchAlienNumberSTR20String20
23ALIENUNTILDATE_I SearchAlien Until DateDTDate8
24DATEFILED_I SearchDate FiledDTDate8
25PREPARERSNAME_I SearchPreparers NameSTR60String60
26PREPARERADDRESS_I SearchPreparer AddressSTR255String255
27DATEIN_I SearchDate InDTDate8
28EMPLOYERNAME_I SearchEmployer NameSTR30_I0String30
29TITLE1_I SearchTitle1STR20String20
30TITLE2_I SearchTitle2STR20String20
31BUSNAMEADDR_I SearchBus Name & AddrSTR80String80
32NEWNAME_I SearchNew NameSTR50_IString50
33REHIREDATE_I SearchRehire DateDTDate8
34O3CDATEEXPIRE_I Search3c Date ExpireDTDate8
35O3CDOCU#_I Search3c Docu#STR20String20
36O3CDOCUTITLE_I Search3c DocuTitleSTR20String20
37DATESIGNED_I SearchDate SignedDTDate8
38DATEOFLASTCHANGE_I SearchDate OF Last ChangeDTDate8
39EXITDATE SearchDate Of ExitDTDate8
40REENTRYDATE SearchDate of ReentryDTDate8
41i9_Non_Citizen_CB Searchi9 Non Citizen CBCB_I9_NationalBoolean0
42CCodeDesc SearchCountry Code DescriptionSTR30String30
43FOREIGNPASSNUMBER SearchForeign Passport NumberSTR12String12
44DEX_ROW_ID Searchintint10

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 *