This table requires activation of Learning Management functional area. Table to store Activities details along with Learning Item and Content details
Module: Work Life
ACTIVITY_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
| 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 | ||||
| ACTIVITY_NUMBER | VARCHAR2 | 32 | Activity number | ||||
| DURATION | NUMBER | Activity duration | |||||
| DURATION_UOM | VARCHAR2 | 32 | UOM of the activity duration | ||||
| 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 | ||||
| ACTIVITY_START_DATE_UTC | TIMESTAMP | Activity Start Date in UTC Timezone | |||||
| ACTIVITY_END_DATE_UTC | TIMESTAMP | Activity End Date in UTC Timezone | |||||
| TIME_ZONE | VARCHAR2 | 128 | Activity Time zone | ||||
| MASTERY_SCORE | NUMBER | Mastery Score |
Copyright © 2019, 2024, Oracle and/or its affiliates.