# 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_START_DATE, ASSIGNMENT_RECORD_ID, EFFECTIVE_END_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. |  |
EXPIRATION_DATE | DATE |  |  |  | The date that the assignment will expire. |  |
VALIDITY_DATE | DATE |  |  |  | The date from which the completed assignment is valid |  |
TOTAL_ACTUAL_EFFORT | NUMBER |  |  |  | Total actual effort learner has spent on the assignment record |  |
EFFORT_UOM | VARCHAR2 | 256 |  |  | Unit of measure for effort |  |
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, 2026, Oracle and/or its affiliates.