Analytics Catalog/Data dictionary/HRT_BI_WORK_PREFERENCE_ITEMS_V
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

HRT_BI_WORK_PREFERENCE_ITEMS_V

SharedUsed in 0 subject areas98 reporting columnsBICC incremental-ready

Talent Profile (HRT) — denormalized view.

Primary key: not yet catalogued for HRT_BI_WORK_PREFERENCE_ITEMS_V — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Columns

ColumnKeyIn reportsDescription (inferred)
BUSINESS_GROUP_ID●Identifier for the business group.
CONTENT_ITEM_ID●Identifier for the content item.
CONTENT_TYPE_ID●Identifier for the content type.
COUNTRY_ID●Identifier for the country.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DATE_FROM●Date from.
DATE_TO●Date to.
IMPORTANCE●Importance.
INTEREST_LEVEL●Interest level.
ITEM_CLOB_1●Item clob 1.
ITEM_CLOB_2●Item clob 2.
ITEM_CLOB_3●Item clob 3.
ITEM_CLOB_4●Item clob 4.
ITEM_CLOB_5●Item clob 5.
ITEM_DATE_1●Item date 1.
ITEM_DATE_10●Item date 10.
ITEM_DATE_2●Item date 2.
ITEM_DATE_3●Item date 3.
ITEM_DATE_4●Item date 4.
ITEM_DATE_5●Item date 5.
ITEM_DATE_6●Item date 6.
ITEM_DATE_7●Item date 7.
ITEM_DATE_8●Item date 8.
ITEM_DATE_9●Item date 9.
ITEM_DECIMAL_1●Item decimal 1.
ITEM_DECIMAL_2●Item decimal 2.
ITEM_DECIMAL_3●Item decimal 3.
ITEM_DECIMAL_4●Item decimal 4.
ITEM_DECIMAL_5●Item decimal 5.
ITEM_NUMBER_1●Item number 1.
ITEM_NUMBER_10●Item number 10.
ITEM_NUMBER_2●Item number 2.
ITEM_NUMBER_3●Item number 3.
ITEM_NUMBER_4●Item number 4.
ITEM_NUMBER_5●Item number 5.
ITEM_NUMBER_6●Item number 6.
ITEM_NUMBER_7●Item number 7.
ITEM_NUMBER_8●Item number 8.
ITEM_NUMBER_9●Item number 9.
ITEM_TEXT2000_1●Item text2000 1.
ITEM_TEXT2000_2●Item text2000 2.
ITEM_TEXT2000_3●Item text2000 3.
ITEM_TEXT2000_4●Item text2000 4.
ITEM_TEXT2000_5●Item text2000 5.
ITEM_TEXT240_1●Item text240 1.
ITEM_TEXT240_10●Item text240 10.
ITEM_TEXT240_11●Item text240 11.
ITEM_TEXT240_12●Item text240 12.
ITEM_TEXT240_13●Item text240 13.
ITEM_TEXT240_14●Item text240 14.
ITEM_TEXT240_15●Item text240 15.
ITEM_TEXT240_2●Item text240 2.
ITEM_TEXT240_3●Item text240 3.
ITEM_TEXT240_4●Item text240 4.
ITEM_TEXT240_5●Item text240 5.
ITEM_TEXT240_6●Item text240 6.
ITEM_TEXT240_7●Item text240 7.
ITEM_TEXT240_8●Item text240 8.
ITEM_TEXT240_9●Item text240 9.
ITEM_TEXT30_1●Item text30 1.
ITEM_TEXT30_10●Item text30 10.
ITEM_TEXT30_11●Item text30 11.
ITEM_TEXT30_12●Item text30 12.
ITEM_TEXT30_13●Item text30 13.
ITEM_TEXT30_14●Item text30 14.
ITEM_TEXT30_15●Item text30 15.
ITEM_TEXT30_2●Item text30 2.
ITEM_TEXT30_3●Item text30 3.
ITEM_TEXT30_4●Item text30 4.
ITEM_TEXT30_5●Item text30 5.
ITEM_TEXT30_6●Item text30 6.
ITEM_TEXT30_7●Item text30 7.
ITEM_TEXT30_8●Item text30 8.
ITEM_TEXT30_9●Item text30 9.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●Date and time the row was last updated (the incremental-extract key).
LAST_UPDATE_LOGIN●Session login of the user who last updated the row.
MANDATORY●Mandatory.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
PARENT_PROFILE_ITEM_ID●Identifier for the parent profile item.
PROFILE_ID●Identifier for the profile.
PROFILE_ITEM_ID●Identifier for the profile item.
QUALIFIER_ID1●Qualifier id1.
QUALIFIER_ID2●Qualifier id2.
RATING_LEVEL_ID1●Rating level id1.
RATING_LEVEL_ID2●Rating level id2.
RATING_LEVEL_ID3●Rating level id3.
RATING_MODEL_ID1●Rating model id1.
RATING_MODEL_ID2●Rating model id2.
RATING_MODEL_ID3●Rating model id3.
SECTION_ID●Identifier for the section.
SOURCE_ID●Identifier for the source.
SOURCE_KEY1●Source key1.
SOURCE_KEY2●Source key2.
SOURCE_KEY3●Source key3.
SOURCE_TYPE●Type of source.
STATE_PROVINCE_ID●Identifier for the state province.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Subject areas

Need the extract + dbt staging for HRT_BI_WORK_PREFERENCE_ITEMS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us