What table(s) stores the Dynamic Skills SYNONYMS that are configured for each skill?
Summary:
When you configure dynamic Skills under "My Client Groups" —> "Profiles" —> "Item Catalog" (and clicking on the "Oracle Dynamic Skills Library" template type) you can then add/edit skills which depending on configuration allows you to input SYNONYMS for each skill. I can write my own BIP to get the skills but for some reason cannot find where the synonym data is stored. Here is SQL for Skills:
select CIT.* | |
---|---|
from | |
HRT_CONTENT_ITEMS_B CIB, | |
HRT_CONTENT_ITEMS_TL CIT, | |
HRT_CONTENT_TYPES_B CTB | |
where 1=1 | |
AND CIB.CONTENT_ITEM_ID = CIT.CONTENT_ITEM_ID | |
AND CTB.CONTEXT_NAME = 'SKILL' |
Tagged:
0