This table requires activation of Learning Management functional area. This table stores the learning item information
Module: Work Life
EFFECTIVE_START_DATE, LEARNING_ITEM_ID, EFFECTIVE_END_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| LEARNING_ITEM_ID | NUMBER | 38 | 0 | True | Learning Item Identifier | ||
| EFFECTIVE_START_DATE | DATE | True | Effective start date | ||||
| EFFECTIVE_END_DATE | DATE | True | Effective end date | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique record identifier | ||||
| ATTRIBUTION_ID | NUMBER | 38 | 0 | Identifier of a person,community etc responsible for creating the learning item | |||
| ATTRIBUTION_PERSON_ID | NUMBER | 38 | 0 | Populates when the attribution id is a person id | |||
| ATTRIBUTION_TYPE | VARCHAR2 | 32 | indicates the type of attribution such as person, community etc | ||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Identifier of Enterprise | |||
| LEARNING_ITEM_TYPE | VARCHAR2 | 64 | Type of learning item | ||||
| LEARNING_ITEM_SUB_TYPE | VARCHAR2 | 32 | Learning Item sub type for the learning item type like ELearning. eg: Tutorial, Video etc. | ||||
| LEARNING_ITEM_NUMBER | VARCHAR2 | 32 | Learning item number | ||||
| STATUS | VARCHAR2 | 32 | Current status of the learning item | ||||
| DURATION | NUMBER | Video section duration or description duration for non-video section. | |||||
| DURATION_UOM | VARCHAR2 | 32 | Duration unit of measurement | ||||
| START_DATE | TIMESTAMP | Start Date | |||||
| END_DATE | TIMESTAMP | End Date |
Copyright © 2019, 2024, Oracle and/or its affiliates.