Monday, March 4, 2019

Fusion HCM - Template for Loading Workers using HDL

METADATA|Worker|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|BloodType|CountryOfBirth
MERGE|Worker|SourceSystemOwnerName|PER-XXXX|2017/01/01|4712/12/31|XXXX|2017/01/01|1984/08/08|HIRE|A+|US
METADATA|PersonName|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|LegislationCode|NameType|LastName|FirstName|Title|EffectiveStartDate|EffectiveEndDate
MERGE|PersonName|SourceSystemOwnerName|PN-XXXX|PER-XXXX|XXXX|US|GLOBAL|Chan|Jackie|Mr.|2017/01/01|4712/12/31
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|PersonNumber|DateStart|LegalEmployerName|WorkerType|PrimaryFlag|ActionCode
MERGE|WorkRelationship|SourceSystemOwnerName|WR-XXXX|PER-XXXX|XXXX|2017/01/01|LegalEmployerName|E|Y|HIRE
METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|AssignmentNumber|PeriodOfServiceId(SourceSystemId)|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|PersonId(SourceSystemId)|PersonNumber|LegalEmployerName|DateStart|WorkerType|BusinessUnitShortCode
MERGE|WorkTerms|SourceSystemOwnerName|WT-XXXX|ETXXXX|WR-XXXX|2017/01/01|4712/12/31|1|Y|HIRE|PER-XXXX|XXXX|LegalEmployerName|2017/01/01|E|BusinessUnitShortCode
METADATA|Assignment|SourceSystemOwner|SourceSystemId|AssignmentNumber|WorkTermsAssignmentId(SourceSystemId)|PersonId(SourceSystemId)|PersonNumber|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|DateStart|ActionCode|PersonTypeCode|LegalEmployerName|BusinessUnitShortCode|JobCode|DepartmentName|LocationCode|PrimaryAssignmentFlag|PrimaryFlag|ManagerFlag
MERGE|Assignment|SourceSystemOwnerName|ASG-XXXX|EXXXX|WT-XXXX|PER-XXXX|XXXX|2017/01/01|4712/12/31|1|Y|2017/01/01|HIRE|Employee|LegalEmployerName|BusinessUnitShortCode|JobCode|DepartmentName|LocationCode|Y|Y|N
METADATA|PersonLegislativeData|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|PersonId(SourceSystemId)|LegislationCode|MaritalStatus|Sex
MERGE|PersonLegislativeData|SourceSystemOwnerName|PL-XXXX|2017/01/01|4712/12/31|PER-XXXX|US|M|M
Posted by at

7 comments:

  1. RifathOctober 4, 2019 at 12:39 AM

    Nice Blog, I saw Somany unknown topics in this Blog. Thanks For sharing,Keep it up.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  2. Rainbow Training InstituteOctober 11, 2019 at 4:17 AM

    Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion HCM Online Training

    ReplyDelete
  3. yamunaNovember 20, 2019 at 5:37 AM

    This comment has been removed by the author.

    ReplyDelete
  4. Rainbow Training InstituteFebruary 10, 2020 at 3:09 AM

    Thank you for sharing such a nice and interesting blog.

    Oracle Fusion HCM Online Training

    ReplyDelete
  5. AmeliaSeptember 11, 2020 at 1:44 AM

    Thanks a lot for sharing a valuable blog on Oracle Cloud Applications. I was browsing through the internet looking for Oracle PPM Cloud Training and read your blog. I am impressed by the information that you have on this topic. It shows how well you understand this subject, you can learn more about Oracle Cloud Fusion Apps by attending Oracle Fusion Apps.

    ReplyDelete
  6. kavyaApril 16, 2021 at 10:07 PM

    Great read! Thank you for such useful insights. Visit here for advanced technical courses on MICROSOFT POWERAPPS ONLINE TRAINING

    ReplyDelete
  7. Click4learningJuly 20, 2021 at 5:20 AM

    Nice information. Thanks for sharing such an amazing article. For online training and Self Paced courses visit our site click4learning.com/product/oracle-cpq/

    ReplyDelete

Subscribe to: Post Comments (Atom)