HDL – Sample HDL to load Performance Rating
Historical performance ratings can be loaded into Worker Talent Profile using TalentProfile.dat business object.
Below is the sample HDL (enhanced profiles (v2)), to load performance rating data:
METADATA|ProfileItem|ProfileItemId|ProfileId|ProfileCode|ContentItemId|ContentTypeId|ContentType|CountryId|DateFrom|DateTo|RatingModelId1|RatingModelCode1|RatingLevelId1|RatingLevelCode1|SectionId|SourceSystemOwner|SourceSystemId
MERGE|ProfileItem|||PER_0055|||PERFORMANCE_RATING||2018/01/01|2018/12/31||XXX_PERFORMANCE||3.75|9933|HRC_SQLLOADER|PR_0055
MERGE|ProfileItem|||PER_0031|||PERFORMANCE_RATING|| 2018/01/01|2018/12/31||XXX_PERFORMANCE||3.90|9933| HRC_SQLLOADER |PR _0055 In order to make the loaded performance rating visible in UI, Source Type and Qualifier ID should be passed. Values of source type and qualifier Id depend upon source of performance rating.
| Performance Rating Source | Additional Attributes required in HDL | Comments |
| Added Manually from Talent Rating | SourceType = HRT QualifierId1 = 33 | |
| From Performance Management | SourceType = HRA QualifierId1 = 31 SourceId = 103 SourceKey1 = EVALUATION_ID | |
| Talent Review Meeting | SourceType = HRTR QualifierId1 = 32 SourceKey1 = MEETING_ID | Conduct Meeting |
| Talent Review Meeting | SourceType = HRRMGR QualifierId1 = 35 SourceKey1 = MEETING_ID | Meeting Preparation |
Details of source type can be found in – hrt_sources_vl.
METADATA|ProfileItem|ProfileItemId|ProfileId|ProfileCode|ContentItemId|ContentTypeId|ContentType|CountryId|DateFrom|DateTo|RatingModelId1|RatingModelCode1|RatingLevelId1|RatingLevelCode1|SectionId|SourceSystemOwner|SourceSystemId|SourceType|QualifierId1
MERGE|ProfileItem|||PER_0055|||PERFORMANCE_RATING||2018/01/01|2018/12/31||XXX_PERFORMANCE||3.75|9933|HRC_SQLLOADER|PR_0055
MERGE|ProfileItem|||PER_0031|||PERFORMANCE_RATING|| 2018/01/01|2018/12/31||XXX_PERFORMANCE||3.90|9933| HRC_SQLLOADER |PR _0055|HRT|33