Our Office will be closed from December 24 to January 1 due to the Holidays.

HR Data Load - Data Elements (OEM)

Modified on Wed, Apr 10 at 9:54 AM


Table Name for OEM -- DB.HR_EMP_CSTMR_STG


RequiredDatabase Column NameData TypeLengthComments
YesLAST_NMEText40 
YesFIRST_NMEText40 
 MIDDLE_NMEText40 
 SUFFIXText128Has an associated System Profile (Drop Down)
 NICK_NMEText40 
YesFCLTY_CDText128Facility must exist in Facility Management module as a Host Facility
Yes
Unique
SSNText11Must be formatted as ###-##-####
YesEMP_NMR_TXTText15 
YesEMP_TYP_DESCText128Has an associated System Profile (Drop Down)
YesEMP_STS_DESCText128Has an associated System Profile (Drop Down)
 WORK_PHONE_NMRText20Only Numbers Allowed
Yes
Unique
WORK_PHONE_NMRText384 
 HIRE_DTDate  
 REHIRE_DTDate  
 START_DTDate  
 TRMNTN_DTDate  
 KEY_MGMT_PRSNL_FLGBit Expects 1 for True and 0 for False
 SR_MGMT_OFFCL_FLGBit Expects 1 for True and 0 for False
Yes
Unique
NTWRK_LOGIN_ID_TXTText384This 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_DESCText1Expects M for Male, F for Female or U for Unknown
YesCTZNSHP_DESCText128Has an associated System Profile (Drop Down)
 BIRTH_DTDate  
 BIRTH_CNTRYText128Has an associated System Profile (Drop Down)
 BIRTH_CITYText60 
 BIRTH_STText60 
 LCTN_TXTText128 
 BSNS_UNIT_TXTText128 
 ORG_NME_TXTText128 
 DVSN_TXTText128 
 TITLEText128 
 GRADEText128 
 COST_CENTERText25 
 HOME_ADDR1Text60 
 HOME_ADDR2Text30 
 HOME_CITYText20 
 HOME_STATE_CDText2Should be the 2 letter State Abbreviation
 HOME_ZIP5Text5Only Numbers Allowed
 PERSNL_EMAIL_TXTText50 
 CELL_NMRText20Only Numbers Allowed
 MGR_EMP_NMRText15 
 WORK_CLASSText50 
 WORK_CLASSText50