Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AHR2AP12
Product: Human Resources (414)
Series:
Display Name: Archive_HR_Applicant Group Display Name: HR Multi-Company
Physical Name: AHR2AP12
Technical Name: Archive_HR_Applicant
Group Technical Name: HR_MultiCmp_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|---|---|---|---|---|
| 1 | APPLICANTNUMBER_I  | Applicant Number | Currency | DOLLAR | 0 |
| 2 | SSN_I | ISSN | String | STR15_Social_Security_Number | 15 |
| 3 | LLASTNAME_I | LLast Name | String | STR20 | 20 |
| 4 | FFIRSTNAME_I | FFirst Name | String | STR15_I | 15 |
| 5 | MIDLNAME | Middle Name | String | STR15 | 15 |
| 6 | ADDRESS1 | Address 1 | String | STR60 | 60 |
| 7 | ADDRESS2 | Address 2 | String | STR60 | 60 |
| 8 | CITY | City | String | STR35 | 35 |
| 9 | STATE | State | String | STR30_State | 29 |
| 10 | ZIPCODE_I | IZip Code | String | STR10 | 10 |
| 11 | COUNTRY | Country | String | STR60 | 60 |
| 12 | HOMEPHONE | Home Phone | String | STR10_Phone | 10 |
| 13 | WORKPHONE | Work Phone | String | STR10_Phone | 10 |
| 14 | EXT_I | Ext | String | STR4_I | 4 |
| 15 | ISEQUENCENUMBER_I | ISequence Number | Integer | IINT2 | 2 |
| 16 | APPLYDATE_I | Apply Date | Date | DT | 8 |
| 17 | REQUISITIONNUMBER_I | Requisition Number | Long Integer | INT60 | 6 |
| 18 | COMPANYCODE_I | Company Code | String | STR6_Payroll_Code | 6 |
| 19 | DIVISIONCODE_I | Division Code | String | STR6_Payroll_Code | 6 |
| 20 | DEPARTMENTCODE_I | Department Code | String | STR6_Payroll_Code | 6 |
| 21 | POSITIONCODE_I | Position Code | String | STR6_Payroll_Code | 6 |
| 22 | LOCATNID | Location ID | String | STR15_Location_ID | 15 |
| 23 | STATUS0_I | Status0 | Integer | DDL_Status_HRM | 0 |
| 24 | REJECTREASON_I | Reject Reason | Integer | DDL_Reject_Reason | 0 |
| 25 | DSCRIPTN | Description | String | STR30 | 30 |
| 26 | RELOCATION_I | Relocation | Integer | GB_I | 0 |
| 27 | REPLYLETTERSENT_I | Reply Letter Sent | Boolean | CB_Reply | 0 |
| 28 | COLORCODE_I | Color Code | Integer | VS_Color_Code | 0 |
| 29 | COLORSTRING_I | Color String | String | ISTR6 | 6 |
| 30 | REFSOURCEDDL_I | Ref Source DDL | Integer | DDL_Ref_Source | 0 |
| 31 | REFERENCESOURCE_I | Reference Source | String | STR30_I0 | 30 |
| 32 | EEOGENDER_I | EEO Gender | Integer | DDL_EEO_Gender | 0 |
| 33 | EEOETHNICORIGIN_I | EEO Ethnic Origin | Integer | DDL_EEO_Ethnic_Origin | 0 |
| 34 | EEOAGE_I | EEO Age | Integer | DDL_EEO_Age | 0 |
| 35 | HANDICAPPED | Handicapped | Boolean | CB_Handicap | 0 |
| 36 | VETERAN | Veteran | Boolean | CB_Military | 0 |
| 37 | DISABLEDVETERAN | Disabled Veteran | Boolean | CB_DisableVet | 0 |
| 38 | VIETNAMVETERAN | Vietnam Veteran | Boolean | CB_Vietnam | 0 |
| 39 | NOTESINDEX_I | Notes Index | Currency | DOLLAR | 0 |
| 40 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 |
| 41 | CHANGEDATE_I | Change Date | Date | DT | 8 |
| 42 | OTHERVET | Other Veterans | Boolean | CB_OtherVet | 0 |
| 43 | AFSMVET | Armed Forces Service Medal Veteran | Boolean | CB_Armed_Forces | 0 |
| 44 | RECSEPVET | Recently-Separated Veteran | Boolean | CB_Recently_Sep_Vet | 0 |
| 45 | INET1 | INet1 | String | STR200 | 200 |