This table requires activation of Learning Management functional area. Table stores learning item content details along with Learning Item details
Module: Work Life
CONTENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CONTENT_ID | NUMBER | 38 | 0 | True | Content Id | ||
| EFFECTIVE_START_DATE | DATE | True | Indicates the date at the beginning of the date range within which the row is effective | ||||
| EFFECTIVE_END_DATE | DATE | True | Indicates the date at the end of the date range within which the row is effective | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| LEARNING_ITEM_ID | NUMBER | 38 | 0 | Learning Item Id | |||
| TRACKING_TYPE | VARCHAR2 | 128 | Tracking Type | ||||
| PRICE | NUMBER | Price | |||||
| CURRENCY | VARCHAR2 | 128 | Currency | ||||
| MASTERY_SCORE | NUMBER | Mastery Score | |||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise Id | |||
| COMPLETION_ON_OPEN | VARCHAR2 | 16 | Indicates whether content should be marked complete upon open | ||||
| RELATED_CONTENT_ID | NUMBER | 38 | 0 | Stores related content id, ie questionnaire id | |||
| TIME_LIMIT | NUMBER | Stores time limit to complete content | |||||
| TIME_LIMIT_UOM | VARCHAR2 | 128 | Time limit unit of measure | ||||
| MAX_ATTEMPTS | NUMBER | Max attempts to retry content ie assessments | |||||
| STATUS | VARCHAR2 | 32 | Describes the current state of the content. | ||||
| CONTENT_NUMBER | VARCHAR2 | 999 | Content number | ||||
| START_DATE | TIMESTAMP | Indicates when the content becomes available to learners. | |||||
| END_DATE | TIMESTAMP | Specifies when the content will be retired or is no longer accessible to learners. |
Copyright © 2019, 2026, Oracle and/or its affiliates.