HCM LOADING WORKER RECORD

HDL - HCM Data Loader is the recommended way of loading data to HCM.

HDL load can be done manually or through Web Service.

Pre requisites are :

1. Configure Source System Owner
• Navigator  > Setup and Maintenance > Search
• Search for - Manage Common Lookups
• Lookup Type = HRC_SOURCE_SYSTEM_OWNER
• Update or add new source system owner.
• Use this value while loading worker data. 
2. Configure Legal employer and Business Units.  
• Verify existing LE and BU 
• Navigator  > Setup and Maintenance > Search
• Search for Manage Legal Entity HCM Information
• Lookup type = Use existing LE value 
3. Business Units
• Navigator  > Setup and Maintenance > Search
• Search for Manage Business Units
• Lookup type = Use existing BU value.  
4. Create a required worker files. 
5. Zip the files. 
6. Go to Menu > My Workforce > Data Exchange
7. Go to Tasks > Import and Load Data
8. Import the zip file. 
9. Load the Business Objects. 

Worker Data :

SourceSystemOwner	VK
SourceSystemId	VK_PER<SEQ> (example VK_PER1, VK_PER2)
PersonNumber	VK<SEQ> (example VK1, VK2...)
ActionCode	HIRE

PersonName :

SourceSystemOwner	VK
SourceSystemId	VK_PERNAME<SEQ> (example VK_PERNAME1, VK_PERNAME2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
NameType	GLOBAL

PersonNationalIdentifier :

SourceSystemOwner	VK
SourceSystemId	VK_NID<SEQ> (example VK_NID1, VK_NID2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
NationalIdentifierType	SSN

PersonEmail

SourceSystemOwner	VK
SourceSystemId	VK_EMAIL<SEQ> (example VK_EMAIL1, VK_EMAIL2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
EmailType	W1

 PersonPhone

SourceSystemOwner	VK
SourceSystemId	VK_WPH<SEQ> / VK_HPH<SEQ> (example VK_WPH1, VK_HPH1)
PhoneType	W1 / H1 (  W1 for WorkPhone and H1 for HomePhone)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)

PersonAddress

SourceSystemOwner	VK
SourceSystemId	VK_ADDR<SEQ>   (example VK_ADDR1, VK_ADDR2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
AddressType	HOME

 PersonEthnicity

SourceSystemOwner	VK
SourceSystemId	VK_ETHNIC<SEQ>   (example VK_ETHNIC1, VK_ETHNIC2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
Ethnicity	1 , 2, 8 , 6 , 7 (Check for valid codes in application)

 PersonLegislativeData

SourceSystemOwner	VK
SourceSystemId	VK_LEG<SEQ>   (example VK_LEG1, VK_LEG2)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
LegislationCode	US

 WorkRelationship

SourceSystemOwner	VK
SourceSystemId	VK_PDSERVICE<SEQ>(example VK_PDSERVICE1)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
LegalEmployerName	US1 Legal Entity
WorkerNumber	VK<SEQ> (example VK1, VK2 …)

WorkTerms

SourceSystemOwner	VK
SourceSystemId	VK_WRKTERM<SEQ>(example VK_WRKTERM1)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
PeriodOfServiceId(SourceSystemId)	VK_PDSERVICE<SEQ>  (example VK_PDSERVICE1)
ActionCode	HIRE
AssignmentNumber	VK_WRKTERM<SEQ>(example VK_WRKTERM1)
AssignmentType	ET / CT ( ET for Employee , CT for Contingent Worker)
BusinessUnitShortCode	US1 Business Unit
LegalEmployerName	US1 Legal Entity
SystemPersonType	EMP / CWK ( EMP for Employee , CWK for Contingent Worker)

Assignment

SourceSystemOwner	VK
SourceSystemId	VK_ASSIGN<SEQ>(example VK_ASSIGN1)
PersonId(SourceSystemId)	VK_PER<SEQ> (example VK_PER1, VK_PER2...)
ActionCode	HIRE
AssignmentName	E-VK<SEQ> (example E-VK1 , E-VK2 )
AssignmentNumber	VK_ASSIGN<SEQ>(example VK_ASSIGN1)
AssignmentType	E / C ( E for Employee , C for Contingent Worker)
BusinessUnitShortCode	US1 Business Unit
LegalEmployerName	US1 Legal Entity
SystemPersonType	EMP / CWK ( EMP for Employee , CWK for Contingent Worker)
JobId(SourceSystemId)	VK_JOB<SEQ> (example VK_JOB1)
LocationId(SourceSystemId)	VK_LOC<SEQ> (example VK_LOC1)
OrganizationId(SourceSystemId)	VK_DEPT<SEQ> (example VK_DEPT1)
PositionId(SourceSystemId)	VK_POS<SEQ> (example VK_POS1)
GradeId(SourceSystemId)	VK_GRADE<SEQ> (example VK_GRADE1)
PeriodOfServiceId(SourceSystemId)	VK_PDSERVICE<SEQ> (example VK_PDSERVICE1)
WorkTermsAssignmentId(SourceSystemId)	VK_WRKTERM<SEQ> (example VK_WRKTERM1)