Compatible Version(s)
- AC v4.21 onwards
Data Elements
Table Name: DB.HR_EMP_CSTMR_STG
Required | Unique | Column Name | Data Type | Length | Comments |
Yes | LAST_NME | Text | 40 | ||
Yes | FIRST_NME | Text | 40 | ||
MIDDLE_NME | Text | 40 | |||
SUFFIX | Text | 128 | Has an associated System Profile (Drop Down) | ||
NICK_NME | Text | 40 | |||
Yes | FCLTY_CD | Text | 25 | Facility must exist in Facility Management module as a Host Facility | |
Yes | Yes | SSN | Text | 11 | Must be formatted as ###-##-#### |
Yes | EMP_NMR_TXT | Text | 15 | ||
Yes | EMP_TYP_DESC | Text | 128 | Has an associated System Profile (Drop Down) | |
Yes | EMP_STS_DESC | Text | 128 | Has an associated System Profile (Drop Down) | |
WORK_PHONE_NMR | Numeric | 20 | Only Numbers allowed | ||
Yes | Yes | WORK_EMAIL_TXT | Text | 384 | |
HIRE_DT | Date | ||||
REHIRE_DT | Date | ||||
START_DT | Date | ||||
TRMNTN_DT | Date | ||||
KEY_MGMT_PRSNL_FLG | Bit | Expects 1 for True and 0 for False | |||
SR_MGMT_OFFCL_FLG | Bit | Expects 1 for True and 0 for False | |||
Yes | Yes | NTWRK_LOGIN_ID_TXT | Text | 384 | This column helps define the username for any future Access Commander user accounts and/or ViSi Commander and Portal Commander accounts. If you currently use SSO/AD Authentication or plan to do so in the future, please align these with your SSO/AD usernames. |
GNDR_DESC | Text | 1 | Expects M for Male, F for Female or U for Unknown | ||
Yes | CTZNSHP_DESC | Text | 128 | Has an associated System Profile (Drop Down) | |
BIRTH_DT | Date | ||||
BIRTH_CNTRY | Text | 128 | Has an associated System Profile (Drop Down) | ||
BIRTH_CITY | Text | 60 | |||
BIRTH_ST_CD | Text | 60 | |||
LCTN_TXT | Text | 128 | |||
BSNS_UNIT_TXT | Text | 128 | |||
ORG_NME_TXT | Text | 128 | |||
DVSN_TXT | Text | 128 | |||
TITLE | Text | 128 | |||
GRADE | Text | 128 | |||
COST_CENTER | Text | 25 | |||
HOME_ADDR1 | Text | 60 | |||
HOME_ADDR2 | Text | 30 | |||
HOME_CITY | Text | 20 | |||
HOME_STATE_CD | Text | 5 | Should be the 2 letter State Abbreviation | ||
HOME_ZIP5 | Text | 5 | Only Numbers Allowed | ||
PERSNL_EMAIL_TXT | Text | 50 | |||
CELL_NMR | Text | 20 | Only Numbers Allowed | ||
MGR_EMP_NMR | Text | 15 | |||
WORK_CLASS | Text | 50 | |||
HR_AREA_FULL | Text | 50 |
Have further questions? Submit an Inquiry ticket for Support and select the most your version of Access Commander available and select HR Data Load as the Category.
Change Log
Last Updated: February 18, 2022
Published the Table Name that needs to be populated
Last Updated: November 24, 2021
Updated the Comments for HOME_STATE_CD data element
Last Updated: October 20, 2021
Updated the Title of the Article
Last Updated: May 24, 2021
Updated Data Elements List to support AC v4.11
Last Updated: Nov 3, 2020
Added Nickname as an option to the Data Elements list