Thursday 25 July 2019

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)


No comments:

Post a Comment

Docker - Container Cheat Sheet

Basic and advanced docker commands for reference. Use them as a cheat sheet Commands to install docker on Linux  curl -fsSL https://get.dock...