SQL Query to identified content section name and content section id

In this blog post, I will show you how to query the Fusion.hrt_profile_typ_sections_vl view to get the names and IDs of the template-based sections. This view contains information about the sections that are defined in the profile-type templates. Template-based sections are those that have the template_based_section_flag set to 'Y'. To get the list of these sections, we can use the following SQL statement:

Select section_id, name 
From Fusion.hrt_profile_typ_sections_vl 
Where template_based_section_flag = 'Y' 
Order By Name

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.