DW_LM_ASG_REC_F (Preview)

This table requires activation of Learning Management functional area. Base fact for enrollments table

Details

Module: Work Life

Key Columns

EFFECTIVE_END_DATE, ASSIGNMENT_RECORD_ID, EFFECTIVE_START_DATE

Columns

Columns
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.