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.