Table Name for On-Prem Customers -- DB.HR_EMP_CSTMR_STG
Required | Unique | Database 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 | 128 | 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 | Text | 20 | Only Numbers Allowed | ||
Yes | Yes | WORK_PHONE_NMR | 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 attribute helps define the username for any current & 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 | 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 | 2 | 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 | |||
WORK_CLASS | Text | 50 |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article