This table requires activation of Learning Management functional area. This table stores the learning item information
Module: Work Life
EFFECTIVE_END_DATE, LEARNING_ITEM_ID, EFFECTIVE_START_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 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.