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

ASSIGNMENT_RECORD_ID, EFFECTIVE_END_DATE, 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     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.