Table Name for OEM -- DB.HR_EMP_CSTMR_STG| Required | 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 Unique | 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 Unique | 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 Unique | 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 |