HR Data Load - Data Elements (OEM)

Modified on Wed, 10 Apr 2024 at 09: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 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article