PeopleSoft HR Talent Management Data Load Parameters

You must configure the ODI variable HR_PSFT_TLNT_PROFILE_TYPES_FILTER and HR_PSFT_TLNT_CONTENT_TYPES_FILTER, which are used for extraction of HR-PeopleSoft Talent Management data.

Optional or Mandatory

This is a mandatory step. Data will not be loaded into Talent Management Fact tables if this setup step is not done.

Applies to

This applies to PeopleSoft 9.0, 9.1 and 9.2 extracts.

Task description in detail

  • ETL Variable: HR_PSFT_TLNT_CONTENT_TYPES_FILTER

    Use the following SQL to identify the Talent Content Types to be used for ETL

    SELECT DISTINCT JPM_CAT_TYPE 
FROM  PS_JPM_CAT_TYPES;

    Select the relevant types to be extracted.

  • ETL Variable: HR_PSFT_TLNT_PROFILE_TYPES_FILTER

    In PeopleSoft, profiles are categorized as person and non-person profiles. Use the following SQL to identify the Profile Types to be used for ETL:

    SELECT DISTINCT JPM_JP_TYPE 
FROM PS_JPM_JP_TYPES;

    Select the relevant types to be extracted.

Dependency

None.