Guidelines for Extracting Talent Review Data Using HCM Extracts

You can use HCM Extracts to extract Talent Review data.

Here's the data that you can extract with a few examples of the attributes that you can extract for each:

  • Meeting details: Meeting ID, meeting dashboard template ID, meeting date

  • Facilitators' details: Facilitator ID, facilitator person number, facilitator creation date

  • Participants' details: Participant ID, participant business group ID, participant person number

  • Talent pools' details: Talent pool ID, talent pool meeting ID, talent pool creation date

  • Prior rating details: Prior rating date range ID, prior rating date range meeting ID, prior rating date range creation date

  • Reviewees' details: Reviewee ID, reviewee meeting ID, reviewee person number

  • Review content details: Review content ID, review content meeting ID, review competencies

  • Succession plans' details: Succession Plan ID, succession plan meeting ID, succession plan creation date

In this topic, we discuss only the information that you need for extracting Talent Review data. For more information about creating an extract definition and publishing the extract results, see the related topics.

Create Talent Review Extract Definition

To create an extract definition, you must determine these details:

  • The user entity details to create data groups

  • The database item group details to create attributes

  • The extract definition type

You create an extract definition using the Manage Extract Definitions task in the Data Exchange work area.

This table lists the Talent Review related user entities and the starting characters of the database items that correspond to these user entities. You can search the Talent Review related database items using these characters.

Talent Review Data to Extract

User Entity

Database Items Start With

Meeting details

HRR_EXT_MEETINGS

HRR_MEETINGS_

Meeting facilitators

HRR_EXT_MEETING_FACILITATORS

HRR_MEETING_FACILITATORS_

Meeting participants

HRR_EXT_MEETING_PARTICIPANTS

HRR_MEETING_PARTICIPANTS_

Associated talent pools

HRR_EXT_MEETING_TALENTPOOLS

HRR_MEETING_TALENTPOOLS_

Meeting prior rating date ranges

HRR_EXT_PRIOR_RATING_DATE_RANGES

HRR_PRIOR_RATING_DATE_RANGES_

Meeting review population

HRR_EXT_MEETING_REVIEWEES

HRR_MEETING_REVIEWEES_

Meeting review content

HRR_EXT_MEETING_REVW_CONTENT

HRR_MEETING_REVW_CONTENT_

Associated succession plans

HRR_EXT_MEETING_SUCCPLANS

HRR_MEETING_SUCCPLANS_

While creating the Talent Review extract definition, select the extract definition type as HR Archive.

With the information in this topic, you're now ready to extract Talent Review data.