AHR2AP12 - Archive_HR_Applicant
Dynamics GP table AHR2AP12 (Archive_HR_Applicant) contains 44 columns including APPLICANTNUMBER_I, SSN_I, LLASTNAME_I....
SQL Query Builder
44 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| APPLICANTNUMBER_I | Applicant Number | Currency | 10 | |
| SSN_I | ISSN | String | 16 | |
| LLASTNAME_I | LLast Name | String | 22 | |
| FFIRSTNAME_I | FFirst Name | String | 16 | |
| MIDLNAME | Middle Name | String | 16 | |
| ADDRESS1 | Address 1 | String | 62 | |
| ADDRESS2 | Address 2 | String | 62 | |
| CITY | City | String | 36 | |
| STATE | State | String | 30 | |
| ZIPCODE_I | IZip Code | String | 12 | |
| COUNTRY | Country | String | 62 | |
| HOMEPHONE | Home Phone | String | 22 | |
| WORKPHONE | Work Phone | String | 22 | |
| EXT_I | Ext | String | 6 | |
| ISEQUENCENUMBER_I | ISequence Number | Integer | 2 | |
| APPLYDATE_I | Apply Date | Date | 4 | |
| REQUISITIONNUMBER_I | Requisition Number | Long Integer | 4 | |
| COMPANYCODE_I | Company Code | String | 8 | |
| DIVISIONCODE_I | Division Code | String | 8 | |
| DEPARTMENTCODE_I | Department Code | String | 8 | |
| POSITIONCODE_I | Position Code | String | 8 | |
| LOCATNID | Location ID | String | 16 | |
| STATUS0_I | Status0 | Integer | 2 | |
| REJECTREASON_I | Reject Reason | Integer | 2 | |
| DSCRIPTN | Description | String | 32 | |
| RELOCATION_I | Relocation | Integer | 2 | |
| REPLYLETTERSENT_I | Reply Letter Sent | Boolean | 2 | |
| COLORCODE_I | Color Code | Integer | 2 | |
| COLORSTRING_I | Color String | String | 8 | |
| REFSOURCEDDL_I | Ref Source DDL | Integer | 2 | |
| REFERENCESOURCE_I | Reference Source | String | 32 | |
| EEOGENDER_I | EEO Gender | Integer | 2 | |
| EEOETHNICORIGIN_I | EEO Ethnic Origin | Integer | 2 | |
| EEOAGE_I | EEO Age | Integer | 2 | |
| HANDICAPPED | Handicapped | Boolean | 2 | |
| VETERAN | Veteran | Boolean | 2 | |
| DISABLEDVETERAN | Disabled Veteran | Boolean | 2 | |
| VIETNAMVETERAN | Vietnam Veteran | Boolean | 2 | |
| NOTESINDEX_I | Notes Index | Currency | 10 | |
| CHANGEBY_I | Change By | String | 16 | |
| CHANGEDATE_I | Change Date | Date | 4 | |
| OTHERVET | Other Veterans | Boolean | 2 | |
| AFSMVET | Armed Forces Service Medal Veteran | Boolean | 2 | |
| RECSEPVET | Recently-Separated Veteran | Boolean | 2 |
Related Tables
Tables that share columns with AHR2AP12. Click "Join" to add to your query.