This table requires activation of Learning Management functional area. Table stores learning item content details
Module: Work Life
EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, CONTENT_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.