This table requires activation of Learning Management functional area. Base fact for enrollments table
Module: Work Life
ASSIGNMENT_RECORD_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ASSIGNMENT_RECORD_ID | NUMBER | 38 | 0 | True | Enrollment Identifier | ||
EFFECTIVE_START_DATE | DATE | True | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||||
EFFECTIVE_END_DATE | DATE | True | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source Record Identifier | ||||
PRE_ASSIGNMENT_RECORD_ID | NUMBER | 38 | 0 | Predecessor assignment record id related to renewals | |||
SUCC_ASSIGNMENT_RECORD_ID | NUMBER | 38 | 0 | Successor assignment record id related to renewals | |||
LEARNER_PERSON_ID | NUMBER | 38 | 0 | Person identifier | DW_PERSON_D | PERSON_ID | |
LEARNING_ITEM_ID | NUMBER | 38 | 0 | Learning item identifier | DW_LM_LEARNING_ITEM_D | LEARNING_ITEM_ID | |
ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise Identifier | |||
PRICING_RULE_ID | NUMBER | 38 | 0 | pricing rule identifier | DW_LM_PRICING_D | PRICING_RULE_ID | |
ATTRIBUTION_ID | NUMBER | 38 | 0 | Attribution identifier | |||
ATTRIBUTION_PERSON_ID | NUMBER | 38 | 0 | Attribution identifier. Person id of the person who enrolled the learner | DW_PERSON_D | PERSON_ID | |
ATTRIBUTION_TYPE | VARCHAR2 | 32 | Attribution type indicates the type of attribution_id, such as person, admin etc | ||||
ATTRIBUTION_LOOKUP_CODE | VARCHAR2 | 32 | Attribution Lookup Code | ||||
ASSIGNMENT_RECORD_NUMBER | VARCHAR2 | 32 | Assignment record number | ||||
STATUS | VARCHAR2 | 32 | Current status of the enrollment {ACTIVE, COMPLETED, EXPIRED, REVOKED, DELETED}. | ||||
SUB_STATUS | VARCHAR2 | 32 | Substatus of assignment record. | ||||
EVENT_TYPE | VARCHAR2 | 32 | Indicates the Type of event such as voluntary or required assignemnet | ||||
EVENT_SUB_TYPE | VARCHAR2 | 32 | indicates the sub type of event | ||||
DATE_STATUS_CHANGED | TIMESTAMP | Date of status change | |||||
COMPLETION_DATE | TIMESTAMP | The date and time of the completion of the enrollment. | |||||
ASSIGNED_ON_DATE | TIMESTAMP | The date that the assignment is assigned and visible to the learner. | |||||
CALCULATED_DUE_DATE | DATE | The due date which is calculated based on the rules for the assignment. | |||||
DW_DATE_FROM | DATE | Warehouse Effective From Date for the Assignment Event. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used. | |||||
DW_DATE_TO | DATE | Warehouse Effective To Date for the Assignment Event. This is equal to EFFECTIVE_END_DATE | |||||
DW_INITIAL_RECORD_IND | NUMBER | 38 | 0 | This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user. |
Copyright © 2019, 2022, Oracle and/or its affiliates.