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 | This column is for Oracle Internal use only. 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 | |
| TRANSACTION_PRICING_RULE_ID | NUMBER | 38 | 0 | Transaction Details Rule Identifier. Internal Column | |||
| 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. | |||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. |
Copyright © 2019, 2025, Oracle and/or its affiliates.