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

HRT_CONTENT_ITEMS_B

SharedUsed in 0 subject areas134 reporting columnsBICC incremental-ready

Talent Profile (HRT), base table, language-neutral data (paired with _TL labels and the _VL view).

Likely primary key: CONTENT_ITEM_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): RATING_MODEL_ID → HRT_RATING_MODELS_B

Columns

ColumnKeyIn reportsDescription (inferred)
ATTRIBUTE1●Descriptive flexfield segment.
ATTRIBUTE10●Descriptive flexfield segment.
ATTRIBUTE11●Descriptive flexfield segment.
ATTRIBUTE12●Descriptive flexfield segment.
ATTRIBUTE13●Descriptive flexfield segment.
ATTRIBUTE14●Descriptive flexfield segment.
ATTRIBUTE15●Descriptive flexfield segment.
ATTRIBUTE16●Descriptive flexfield segment.
ATTRIBUTE17●Descriptive flexfield segment.
ATTRIBUTE18●Descriptive flexfield segment.
ATTRIBUTE19●Descriptive flexfield segment.
ATTRIBUTE2●Descriptive flexfield segment.
ATTRIBUTE20●Descriptive flexfield segment.
ATTRIBUTE21●Descriptive flexfield segment.
ATTRIBUTE22●Descriptive flexfield segment.
ATTRIBUTE23●Descriptive flexfield segment.
ATTRIBUTE24●Descriptive flexfield segment.
ATTRIBUTE25●Descriptive flexfield segment.
ATTRIBUTE26●Descriptive flexfield segment.
ATTRIBUTE27●Descriptive flexfield segment.
ATTRIBUTE28●Descriptive flexfield segment.
ATTRIBUTE29●Descriptive flexfield segment.
ATTRIBUTE3●Descriptive flexfield segment.
ATTRIBUTE30●Descriptive flexfield segment.
ATTRIBUTE4●Descriptive flexfield segment.
ATTRIBUTE5●Descriptive flexfield segment.
ATTRIBUTE6●Descriptive flexfield segment.
ATTRIBUTE7●Descriptive flexfield segment.
ATTRIBUTE8●Descriptive flexfield segment.
ATTRIBUTE9●Descriptive flexfield segment.
ATTRIBUTE_CATEGORY●Descriptive flexfield context (structure definition).
ATTRIBUTE_DATE1●Descriptive flexfield segment.
ATTRIBUTE_DATE10●Descriptive flexfield segment.
ATTRIBUTE_DATE11●Descriptive flexfield segment.
ATTRIBUTE_DATE12●Descriptive flexfield segment.
ATTRIBUTE_DATE13●Descriptive flexfield segment.
ATTRIBUTE_DATE14●Descriptive flexfield segment.
ATTRIBUTE_DATE15●Descriptive flexfield segment.
ATTRIBUTE_DATE2●Descriptive flexfield segment.
ATTRIBUTE_DATE3●Descriptive flexfield segment.
ATTRIBUTE_DATE4●Descriptive flexfield segment.
ATTRIBUTE_DATE5●Descriptive flexfield segment.
ATTRIBUTE_DATE6●Descriptive flexfield segment.
ATTRIBUTE_DATE7●Descriptive flexfield segment.
ATTRIBUTE_DATE8●Descriptive flexfield segment.
ATTRIBUTE_DATE9●Descriptive flexfield segment.
ATTRIBUTE_NUMBER1●Descriptive flexfield segment.
ATTRIBUTE_NUMBER10●Descriptive flexfield segment.
ATTRIBUTE_NUMBER11●Descriptive flexfield segment.
ATTRIBUTE_NUMBER12●Descriptive flexfield segment.
ATTRIBUTE_NUMBER13●Descriptive flexfield segment.
ATTRIBUTE_NUMBER14●Descriptive flexfield segment.
ATTRIBUTE_NUMBER15●Descriptive flexfield segment.
ATTRIBUTE_NUMBER16●Descriptive flexfield segment.
ATTRIBUTE_NUMBER17●Descriptive flexfield segment.
ATTRIBUTE_NUMBER18●Descriptive flexfield segment.
ATTRIBUTE_NUMBER19●Descriptive flexfield segment.
ATTRIBUTE_NUMBER2●Descriptive flexfield segment.
ATTRIBUTE_NUMBER20●Descriptive flexfield segment.
ATTRIBUTE_NUMBER3●Descriptive flexfield segment.
ATTRIBUTE_NUMBER4●Descriptive flexfield segment.
ATTRIBUTE_NUMBER5●Descriptive flexfield segment.
ATTRIBUTE_NUMBER6●Descriptive flexfield segment.
ATTRIBUTE_NUMBER7●Descriptive flexfield segment.
ATTRIBUTE_NUMBER8●Descriptive flexfield segment.
ATTRIBUTE_NUMBER9●Descriptive flexfield segment.
BUSINESS_GROUP_ID●Identifier for the business group.
CONTENT_ITEM_CODE●Code identifying the content item.
CONTENT_ITEM_IDPK?●Identifier for the content item.
CONTENT_KEYFLEX_ID●Identifier for the content keyflex.
CONTENT_SUPPLIER_CODE●Code identifying the content supplier.
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.
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_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_TEXT_1●Item text 1.
ITEM_TEXT_10●Item text 10.
ITEM_TEXT_11●Item text 11.
ITEM_TEXT_12●Item text 12.
ITEM_TEXT_13●Item text 13.
ITEM_TEXT_14●Item text 14.
ITEM_TEXT_15●Item text 15.
ITEM_TEXT_16●Item text 16.
ITEM_TEXT_17●Item text 17.
ITEM_TEXT_18●Item text 18.
ITEM_TEXT_19●Item text 19.
ITEM_TEXT_2●Item text 2.
ITEM_TEXT_20●Item text 20.
ITEM_TEXT_21●Item text 21.
ITEM_TEXT_22●Item text 22.
ITEM_TEXT_23●Item text 23.
ITEM_TEXT_24●Item text 24.
ITEM_TEXT_25●Item text 25.
ITEM_TEXT_26●Item text 26.
ITEM_TEXT_27●Item text 27.
ITEM_TEXT_28●Item text 28.
ITEM_TEXT_29●Item text 29.
ITEM_TEXT_3●Item text 3.
ITEM_TEXT_30●Item text 30.
ITEM_TEXT_4●Item text 4.
ITEM_TEXT_5●Item text 5.
ITEM_TEXT_6●Item text 6.
ITEM_TEXT_7●Item text 7.
ITEM_TEXT_8●Item text 8.
ITEM_TEXT_9●Item text 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.
MODULE_ID●Identifier for the module.
OBJECT_VERSION_NUMBER●Optimistic-locking version number, incremented on each update.
RATING_MODEL_ID●Identifier for the rating model.
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_CONTENT_ITEMS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
The report that lies quietly · Approval history vanishes · What the extract does not carry