Employee Import – Initial Load

Employee data will be extracted from HRM EMPLOYEE and PAEMPLOYEE files:

CSV Header	LMS Name	Suggested HCM Field	Examples	Type	Req	LMS Description / HRM Notes
Loginname	vch_loginname				Y	Login Name. this is the field which you will be using for SAML Token (SSO)
Email	vch_email	EMP-EMAIL-ADDRESS	Jane.Doe@email.com	A60	N	Employee email address
Password	vch_password				Y	Password for the User. If SSO integration using SAML will be used, then this field will not contain the user’s real password. This field can be populated with any data. If blackbox SSO is used, then this field must contain the password passed in the blackbox link.
Firstname	vch_firstname	EMP-FIRST-NAME	Jane	A15	Y	Employee’s first name
Lastname	vch_lastname	EMP-LAST-NAME	Doe	A30	Y	Employee’s last name
Active	b_active	EMP-EMP-STATUS	Value = 1, if no termination date, otherwise 0	A2	N	Status of employee
UniqueLevelId	vch_unique_level_id	PROCESS-LEVEL or DEPARTMENT	USA or FINU	A5	Y	Use the lowest level id
EmployeeId	vch_employee_id	EMP-EMPLOYEE	123456789	N9	N	Employee ID. Each employee must have a unique employee identifier
CompanyNbr	vch_companyname	EMP-COMPANY	ACME	N4	N	Company number
CompanyName		PRS-NAME	ACME	A30	N	Company name.
Address	vch_address	EMP-ADDR1	21 Main Street	A30	N	Employee’s address
Address2	vch_address2	EMP-ADDR2	Apt #2	A30	N	Employee’s 2nd address line
City	vch_city	EMP-CITY	Minneapolis	A18	N	Employee’s city
State	vch_state	EMP-STATE	MN	A2	N	Employee’s state
Zip	vch_zip	EMP-ZIP	55102	A10	N	Employee’s zip code
Country	vch_country	EMP-COUNTRY	USA	A25	N	Employee’s country
Title	vch_title	EMP-JOB-CODE or EMP-POSITION	FINACCTANT	A12	N	Use position; if blank use job code
Department	vch_department	PROCESS_LEVEL or DEPARTMENT	FINU	A5	N	Use department; if blank, use process level
Location	I_lcid	PEM-LOCAT-CODE	ABC Clinic	A10	N	Employee’s location code
Hired	dt_hired	EMP-DATE-HIRED	MM/DD/YYYY	D8	N	Employee’s hire date
Termination	dt_user_inactive	EMP-TERM-DATE	MM/DD/YYYY	D8	N	Employee’s termination date
Region	Custom 1	PDD-USER1			N	The employee location (PEM-LOCAT-CODE) is already part of the Users file. Using the value in PEM-LOCAT-CODE, find the record in PCODESDTL, PDDSET1 where: From that record, find the value of PDD-USER1 to add to Users csv file
Employee Pay Group	Custom 2	EMP-UNION-CODE			N	When reading the EMPLOYEE file, also capture field EMP-UNION-CODE and add to Users file.