You are currently viewing How to load Performance Rating and Career Potential using HDL in Talent Profiles?
How to load Performance Rating and Career Potential using HDL in Talent Profiles?

In this article we will look into loading the performance rating, career potential and talent agility rating using HDL.

This information can be seen using public profiles on the directory page.

We will use TalentProfile.dat to load this information. Performance Rating, Career Potential are different content types that are seeded by default. We can apply similar logic to load other content types as well.

We have to specify the below values on the HDL file to get the data loaded.
PROFILE_ID
SECTION_ID – not mandatory
CONTENT_TYPE_ID/ ContentType
RATING_MODEL_ID1/ RatingModelCode1
RATING_LEVEL_ID1/ RatingLevelCode1
QUALIFIER_ID1
DATE_FROM
DATE_TO

If the DATE_TO is null or if it is in the future then the item will be displayed in the UI without clicking on Show Previous Ratings
If the DATE_TO is in the past, then the item will be displayed in the UI only when you click on Show Previous Ratings

Table of Contents

Mapping of Content Type Codes and Content Type IDs:

CONTENT_TYPE_IDCONTENT_TYPE_NAME
101Accomplishments
102Areas of Study
103Licenses and Certifications
104Competencies
106Degrees
107Education Levels
108Honors and Awards
109Languages
110Memberships
111Special Projects
112Career Preferences
113Career Potential
114Advancement Readiness
115Risk of Loss
116Career Statement
117Work Requirements
118Categories
119Products
120Components
121Platforms
122Problem Codes
123Product Problem Codes
124Goals
125Performance Rating
126Talent Score
127Criticality
128N Box Cell Assignment
129Previous Employment
130Technical Post Details
131Highest Education Level
132Behaviors
133Development Goals
134Skill
135Establishment
136Projects
137Tags
138Goal Measurements
139Goal Tasks

SQL Query to identify the Talent Profile related application fields with backend tables mapping:

SELECT c.PROFILE_TYPE_ID ,
  d.NAME SECTION_NAME ,
  c.SECTION_CONTEXT ,
  c.SECTION_ID ,
  c.CONTENT_TYPE_ID ,
  a.FIELD_NAME ,
  b.ATTRIBUTE_LABEL LABEL_FROM_THE_UI ,
  '-->' IS_USING ,
  a.COLUMN_NAME ATTRIBUTE_USED_IN_HDL ,
  a.VALUE_SET_NAME ,
  a.INPUT_FIELD_TYPE_CODE ,
  a.DISPLAY_FLAG
FROM HRT_PROFILE_TYP_SECTIONS c ,
  HRT_PROFILE_TYP_SECTIONS_TL d,
  HRT_PROFILE_TP_SC_PRP_B a ,
  HRT_PROFILE_TP_SC_PRP_TL b
WHERE a.SECTION_PROP_ID =b.SECTION_PROP_ID
  AND a.SECTION_ID =c.SECTION_ID
  AND d.SECTION_ID =c.SECTION_ID
  AND b.LANGUAGE ='US'
  AND d.LANGUAGE ='US'
  AND a.SOURCE_CODE IS NULL
  AND a.DISPLAY_FLAG !='N'
  AND c.TEMPLATE_BASED_SECTION_FLAG='Y'
  AND (SECTION_CONTEXT LIKE '%PERSON_PERFORMANCE%' or SECTION_CONTEXT LIKE '%PERSON_POTENTIAL%')
  --AND d.NAME LIKE '%replace_with_section_name%'
  --AND b.ATTRIBUTE_LABEL LIKE '%replace_with_the_label_of_a_standard_field_as_you_see_it_in_ManageProfileTypes%'
ORDER BY c.PROFILE_TYPE_ID, c.SECTION_ID ,a.DISPLAY_ORDER

Output will look like:

image 24 1024x253 - How to load Performance Rating and Career Potential using HDL in Talent Profiles?

Sample HDL for loading the Career Potential using Talent Profile:

METADATA|TalentProfile|ProfileCode|ProfileStatusCode|ProfileUsageCode|OwnerPersonNumber|PersonNumber|ProfileTypeCode
MERGE|TalentProfile|PERS_12345|A||12345|12345|PERSON

METADATA|ProfileItem|ProfileId|ProfileItemId|ProfileCode|ContentItemId|ContentTypeId|ContentType|CountryId|ItemText2401|RatingLevelCode1|RatingLevelId1|RatingModelCode1|QualifierId1|DateFrom
MERGE|ProfileItem|300000031000093|300000032860739|PERS_12345|||POTENTIAL|||1||POTENTIAL|41|2021/01/01

The ContentType should be POTENTIAL, ProfileTypeCode should be PERSON and the RatingModelCode1 should be POTENTIAL.

DateFrom will be the start date of this potential rating.

RatingLevelCode1 stores the actual rating (1 – Low, 2 – Medium and 3 – High)

Sample HDL for loading the Performance Rating using Talent Profile:

METADATA|TalentProfile|ProfileCode|ProfileStatusCode|ProfileUsageCode|OwnerPersonNumber|PersonNumber|ProfileTypeCode
MERGE|TalentProfile|PERS_12345|A||12345|12345|PERSON

METADATA|ProfileItem|ProfileId|ProfileItemId|ProfileCode|ContentItemId|ContentTypeId|ContentType|CountryId|ItemText2401|RatingLevelCode1|RatingLevelId1|DateFrom|RatingModelCode1|QualifierId1
MERGE|ProfileItem|300000031000093|300000032800735|PERS_12345|||PERFORMANCE_RATING|||2|300000031720396|2021/01/01|Talent Performance Rating|33

ContentType should be PERFORMANCE_RATING.

DateFrom will be the start date of this potential rating.

RatingLevelCode1 stores the actual rating (1 – Low, 2 – Medium and 3 – High)

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.