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

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