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
| 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 |