DW_CONTENT_ITEM_D

This table stores content item informations like individual competency, skill or qualification within a content type.

Details

Module: Performance Management

Key Columns

BUSINESS_GROUP_ID, CONTENT_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTENT_ITEM_ID NUMBER 38 0 True Content item Identifier
BUSINESS_GROUP_ID NUMBER 38 0 True Business Group Identifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier with CONTENT_ITEM_ID and BUSINESS_GROUP_ID.
CONTENT_TYPE_ID NUMBER 38 0 Key to Content Type DW_CONTENT_TYPE_D CONTENT_TYPE_ID
CONTENT_ITEM_CODE VARCHAR2 32 Content Item code
DATE_FROM DATE Start date of Content Item
DATE_TO DATE End date of Content Item