DW_LM_ACTIVITY_D (Preview)
This table requires activation of Learning Management functional area. Table to store details of activities in a class
Details
Module: Work Life
Key Columns
EFFECTIVE_END_DATE, ACTIVITY_ID, EFFECTIVE_START_DATE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | NUMBER | 38 | 0 | True | Activity Identifier | ||
| 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 Identifier | |||
| PARENT_LEARNING_ITEM_ID | NUMBER | 38 | 0 | The learning item that this activity is the child of | |||
| RELATED_CONTENT_ID | NUMBER | 38 | 0 | Related content identifier | |||
| COMPLETION_TYPE | VARCHAR2 | 128 | Indicate the completion type of this activity (Required, Optional) | ||||
| DUE_TIMESTAMP | TIMESTAMP | Indicates the due date of the activity | |||||
| ACTIVITY_TYPE | VARCHAR2 | 128 | Indicates what type of activity this is | ||||
| CONTENT_TYPE | VARCHAR2 | 128 | Indicates what type of content | ||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Identifier of Enterprise | |||
| SELF_COMPLETE_FLAG | VARCHAR2 | 16 | Flag to indicate if the learner able to mark this activity complete | ||||
| TIME_ZONE | VARCHAR2 | 128 | Activity Time zone |