HDL – Query to find sectionId for Talent Profile Item load

With enhanced profiles (v2), sectionId is a required attribute while loading the Profile Items to a worker’s profile. Section Id can be found using below query:

select SECTION_ID

 from HRT_PROFILE_TYP_SECTIONS

WHERE CONTENT_TYPE_ID=110

AND SECTION_CONTEXT LIKE 'PERSON%'

select * 
  from HRT_PROFILE_SECTIONS_b
 where content_type_id=125
 order by creation_date desc