HR Data Load - Data Elements (On-Prem Customers)

Modified on Tue, 06 Jun 2023 at 12:13 AM


Table Name for On-Prem Customers -- DB.HR_EMP_CSTMR_STG


RequiredUniqueDatabase Column NameData TypeLengthComments
Yes LAST_NMEText40 
Yes FIRST_NMEText40 
  MIDDLE_NMEText40 
  SUFFIXText128Has an associated System Profile (Drop Down)
  NICK_NMEText40 
Yes FCLTY_CDText128Facility must exist in Facility Management module as a Host Facility
YesYesSSNText11Must be formatted as ###-##-####
Yes EMP_NMR_TXTText15 
Yes EMP_TYP_DESCText128Has an associated System Profile (Drop Down)
Yes EMP_STS_DESCText128Has an associated System Profile (Drop Down)
  WORK_PHONE_NMRText20Only Numbers Allowed
YesYesWORK_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
YesYesNTWRK_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
Yes CTZNSHP_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

Feedback sent

We appreciate your effort and will try to fix the article