Fusion Analytics Warehouse

Products Banner

Adding People Group and Service Dates using Data Augmentation

Received Response
59
Views
5
Comments

Summary:

Adding People Group and Service Dates using Data Augmentation

Content (required):

We are trying to bring the people group field and service dates (Enterprise Start Date, Legal employer Start Date, etc,.) using Data Augmentation. Can you please guide me to select the source tables (refer the attached screenshot).

Thanks in advance.

Version (include the version you are using, if applicable):

22.R4.P1

Code Snippet (add any code snippets that support your topic, if applicable):


Answers

  • Hello Vasanth ,


    Services dates are already available in Workforce Core subject area. Additional seniority dates ( Enterprise Hire Date ,Enterprise Seniority Date , Legal Employer Seniority Date & Person Start Date ) will be exposed in the upcoming FAW release.


    The list that you have in your screenshots is BI VO list. So you need to select appropriate VO.

    Also , on people group - would you be able to share the exact use case that you are trying to achieve by getting this additional information in the subject area ?

  • Hi @Nupur Joshi-Oracle

    Thanks for the reply.

    On people group - we have a requirement to use this field into DV Filter condition and Parameters. Can you please share the VO name if you have.

    Regards,

    Vasanth

  • Orange
    Orange ✭✭✭

    Hi Vasanth,

    Please try source table HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO. It has an attribute name AssignmentPEOPeopleGroupId.

    Kind regards

  • Hi @Orange ,

    Thanks for the update.

    We have tried this HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO source table but its not returning any data also this source table is not showing the Segment columns.

    Please help on the same.

    Regards,

    Vasanth

  • Amrit
    Amrit ✭✭✭

    Hi Vasantha,

    Did you get the any solution to this?

    Thanks and Regards,

    Amrit