PROPRIETARY
Compatible Version(s)
AC v4.202501 onwards
Data Elements -- Table to Field Mapping
Table Name: DB.HR_EMP_CSTMR_STG
| Attribute Properties | CSV Column Header | Descriptive Name of the Attribute | Data Type | Length | Comments |
| Required | LAST_NME | Last Name | Text | 40 | |
| Required | FIRST_NME | First Name | Text | 40 | |
| MIDDLE_NME | Middle Name | Text | 40 | ||
| SUFFIX | Suffix | Text | 128 | Has an associated System Profile (Drop Down). If Personnel has no Suffix, pass as an Empty String or NULL. | |
| NICK_NME | Nickname | Text | 40 | ||
| Required | FCLTY_CD | Facility Code | Text | 25 | Facility must exist in Facility Management module as a Host Facility |
| Required Unique | SSN | Social Security Number | Text | 11 | Must be formatted as ###-##-#### |
| Required | EMP_NMR_TXT | Employee Number | Text | 15 | |
| Required | EMP_TYP_DESC | Employee Type | Text | 128 | Has an associated System Profile (Drop Down) |
| Required | EMP_STS_DESC | Status | Text | 128 | Has an associated System Profile (Drop Down) |
| WORK_PHONE_NMR | Work Phone | Numeric | 20 | Only Numbers allowed | |
| Required Unique | WORK_EMAIL_TXT | Work Email | Text | 384 | |
| HIRE_DT | Hire Date | Date | Must be formatted as YYYY-MM-DD | ||
| REHIRE_DT | Rehire Date | Date | Must be formatted as YYYY-MM-DD | ||
| START_DT | Start Date | Date | Must be formatted as YYYY-MM-DD | ||
| TRMNTN_DT | Termination Date | Date | Must be formatted as YYYY-MM-DD | ||
| KEY_MGMT_PRSNL_FLG | Key Management Personnel | Bit | Expects 1 for True and 0 for False | ||
| SR_MGMT_OFFCL_FLG | Senior Management Official | Bit | Expects 1 for True and 0 for False | ||
| Required Unique | NTWRK_LOGIN_ID_TXT | Login Id | Text | 384 | This column helps define the username for any future User Accounts used by any of our products. Customers with SSO configuration should have this match the UPN in the IdP. |
| GNDR_DESC | Gender | Text | 1 | Expects M for Male, F for Female or U for Unknown | |
| Required | CTZNSHP_DESC | Citizenship Description | Text | 128 | Has an associated System Profile (Drop Down) |
| BIRTH_DT | Date of Birth | Date | Must be formatted as YYYY-MM-DD | ||
| BIRTH_CNTRY | Country of Birth | Text | 128 | Has an associated System Profile (Drop Down) | |
| BIRTH_CITY | City of Birth | Text | 60 | ||
| BIRTH_ST_CD | State of Birth | Text | 60 | ||
| LCTN_TXT | Location | Text | 128 | ||
| BSNS_UNIT_TXT | Business Unit | Text | 128 | ||
| ORG_NME_TXT | Organization | Text | 128 | ||
| DVSN_TXT | Division | Text | 128 | ||
| TITLE_TXT | Title | Text | 128 | ||
| GRADE_TXT | Grade | Text | 128 | ||
| COST_CENTER | Cost Center | Text | 25 | ||
| HOME_ADDR1 | Home Address 1 | Text | 60 | ||
| HOME_ADDR2 | Home Address 2 | Text | 30 | ||
| HOME_CITY | Home City | Text | 20 | ||
| HOME_STATE_CD | Home State | Text | 2 | Only US State Abbreviations Allowed | |
| HOME_ZIP5 | Home Zip | Text | 5 | Only Numbers Allowed | |
| PERSNL_EMAIL_TXT | Personal Email | Text | 50 | ||
| CELL_NMR | Cell Phone Number | Text | 20 | ||
| MGR_EMP_NMR | Manager Employee Number | Text | 15 | For purposes of Portal Commander, this individual will be granted the Supervisor Role | |
| WORK_CLASS | Field Available for Legacy Customers (Pre 2013) Only | ||||
| HR_AREA_FULL | Field Available for Legacy Customers (Pre 2013) Only | ||||
| PRJCT_NMR_TXT | Field Available for Legacy Customers (Pre 2013) Only |