Oracle Fusion · Data dictionary
HRT_BI_MEMBERSHIP_ITEMS_V
SharedUsed in 0 subject areas99 reporting columnsBICC incremental-ready
Talent Profile (HRT), denormalized view.
Primary key: not yet catalogued for HRT_BI_MEMBERSHIP_ITEMS_V, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): CONTENT_ITEM_ID → HRT_CONTENT_ITEMS_B · PROFILE_ID → HRT_PROFILES_B · PROFILE_ITEM_ID → HRT_PROFILE_ITEMS · SOURCE_ID → HRT_SOURCES_B
Columns
| Column | Key | In reports | Description (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. | |
| CONTEXT_NAME | ● | Name of the context. | |
| 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_DATE | INCR | ● | 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_MEMBERSHIP_ITEMS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table