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

HRT_PROFILE_ITEMS

SharedUsed in 4 subject areas166 reporting columnsBICC incremental-ready

Talent Profile (HRT).

Likely primary key: PROFILE_ITEM_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): CONTENT_ITEM_ID → HRT_CONTENT_ITEMS_B · PROFILE_ID → HRT_PROFILES_B · SOURCE_ID → HRT_SOURCES_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_ID●Identifier for the content item.
CONTENT_TYPE_ID●Identifier for the content type.
COUNTRY_CODE●Code identifying the country.
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_IDPK?●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_CODE●Code identifying the state province.
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.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.

Need the extract + dbt staging for HRT_PROFILE_ITEMS?
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