Query to get content_item_id for HDL

 select hci.name,
hci.content_item_code,
hci.content_item_id
from hrt_content_tp_valuesets_vl hctv,
hrt_content_items_vl hci
where hctv.value_set_name like 'Degrees'
and hctv.content_type_id = (select content_type_id from HRT_CONTENT_TYPES_TL CT where 1=1 and CONTENT_TYPE_NAME ='Degrees')
and hci.content_value_set_id = hctv.content_value_set_id
order by hci.content_item_code, hci.name

Talent Profile Item HDL

 When loading Talent Profile Data, first go thru doc id - Load Talent Profile Data For Persons Using HDL (Doc ID 2798626.1)

Use the queries to get relevant data for HDL from above DOC id.

Sample HDL 

METADATA|ProfileItem|ProfileCode|SourceSystemOwner|SourceSystemId|ContentTypeId|SectionId|DateFrom|ItemText2401|ItemText2409|ItemDate1|ItemDate2

MERGE|ProfileItem|PERS_1234|SSOWNER|1234_PREVEMP2|129|300000001994419|2021/11/22|MS Industries|Manager|2011/01/01|2011/01/01

METADATA|ProfileItem|ProfileItemId|ProfileId|ItemDate2

MERGE|ProfileItem|300000040539722|300000040539720|2017/12/31

METADATA|ProfileItem|ProfileItemId|ProfileId

DELETE|ProfileItem|300000056889089|300000044616273