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

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