In this article we will look into how to bulk load the Educational Establishments using HCM Data Loader.
Educational establishments are used in Talent Management and Oracle Recruiting Modules to maintain the education information of the employee/candidate. Educational Establishments are the universities/colleges where candidates/employees pursue education. We have to load the list of establishments for the employees/candidates to choose from the values list. If we don’t enable the list of values for this field, the employees might enter the same school/ college name in different formats. Ex: Fusion HCM Knowledgebase can be entered in different variants as
- Fusion HCM Knowledge base
- FusionHCM Knowledgebase
- FusionHCMKnowlegebase
- FusionHCMKB
- HCM Knowledgebase
In order to avoid duplicates being entered, it’s better to have the establishment as a List of Values which restricts users from selecting the values that exist in the system.
Navigate to My Client Groups > Profiles > Item Catalogs
Chose Establishments and click search
We need to get the ContentItemValueSetId for the ContentValueSetCode of ‘CVS_ESTABLISHMENT_135‘.
Table of Contents
SQL Query to get the ContentItemValueSetId:
select * from HRT_CONTENT_TP_VALUESETS_B where content_value_set_code = 'CVS_ESTABLISHMENT_135'
Copy the ContentItemValueSetID and use it to prepare HDL
Sample HDL for loading Educational Establishments:
METADATA|ContentItem|SourceSystemOwner|SourceSystemId|ContentItemValueSetId|Name|ContextName|ContentItemCode|ItemDescription|DateFrom
MERGE|ContentItem|HRC_SQLLOADER|FUSIONHCMKB|100000000401458|Fusion HCM KB|EDUCATIONAL_ESTABLISHMENT|1234|Fusion HCM Knowledgebase|1900/01/01Once we load the HDL, we can come back to the Item Catalogs and view the information under Establishments.
