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.