Monday 4 March 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. Rifath4 October 2019 at 00:39

    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 Institute11 October 2019 at 04:17

    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. yamuna20 November 2019 at 05:37

    This comment has been removed by the author.

    ReplyDelete
  4. Rainbow Training Institute10 February 2020 at 03:09

    Thank you for sharing such a nice and interesting blog.

    Oracle Fusion HCM Online Training

    ReplyDelete
  5. Amelia11 September 2020 at 01:44

    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. kavya16 April 2021 at 22:07

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

    ReplyDelete
  7. Click4learning20 July 2021 at 05:20

    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)