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