# DW_LM_OUTCOME_EF (Preview)

This table requires activation of Learning Management functional area. This table stores the profile rating for the compietencies achieved through the learning module and also gives the previous rating if any exists

## Details

Module: Work Life

## Key Columns

PROFILE_ITEM_ID, ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROFILE_ITEM_ID | NUMBER | 38 | 0 | True | Key to Profile items |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique identifier |  |
PREV_PROFILE_ITEM_ID | NUMBER | 38 | 0 |  | Previous profile item ID if previous rating exists.This is for Internal use only | DW_PRFL_PROFILE_ITEM_D | PROFILE_ITEM_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group |  |
PROFILE_ID | NUMBER | 38 | 0 |  | Profile Identifier | DW_PRFL_PROFILE_D | PROFILE_ID
CONTENT_TYPE_ID | NUMBER | 38 | 0 |  | Content type Identifier | DW_CONTENT_TYPE_D | CONTENT_TYPE_ID
CONTENT_ITEM_ID | NUMBER | 38 | 0 |  | Content item Identifier | DW_CONTENT_ITEM_D | CONTENT_ITEM_ID
LEARNING_ITEM_ID | NUMBER | 38 | 0 |  | Learning Item identifier | DW_LM_LEARNING_ITEM_D | LEARNING_ITEM_ID
ANCHOR_DATE | DATE |  |  |  | Anchoring Date to workforce attributes |  |
RATING_MODEL_ID1 | NUMBER | 38 | 0 |  | The rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
RATING_MODEL_ID2 | NUMBER | 38 | 0 |  | The rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
RATING_MODEL_ID3 | NUMBER | 38 | 0 |  | The rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
RATING_LEVEL_ID1 | NUMBER | 38 | 0 |  | Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
RATING_LEVEL_ID2 | NUMBER | 38 | 0 |  | Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
RATING_LEVEL_ID3 | NUMBER | 38 | 0 |  | Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
PREV_RATING_MODEL_ID1 | NUMBER | 38 | 0 |  | Previous rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
PREV_RATING_MODEL_ID2 | NUMBER | 38 | 0 |  | Previous rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
PREV_RATING_MODEL_ID3 | NUMBER | 38 | 0 |  | Previous rating model | DW_RATING_LEVEL_D | RATING_MODEL_ID
PREV_RATING_LEVEL_ID1 | NUMBER | 38 | 0 |  | Previous Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
PREV_RATING_LEVEL_ID2 | NUMBER | 38 | 0 |  | Previous Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
PREV_RATING_LEVEL_ID3 | NUMBER | 38 | 0 |  | Previous Rating Level | DW_RATING_LEVEL_D | RATING_LEVEL_ID
PREV_RATING_EXIST_IND | NUMBER | 38 | 0 |  | Previous rating exist indicator |  |
SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source Type. For example, HRTR |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person identifier | DW_PERSON_D | PERSON_ID
FREQUENCY | VARCHAR2 | 32 |  |  | Frequency of normal working hours:week,month,year |  |
NORMAL_HOURS | NUMBER |  |  |  | Normal working hours |  |
BARGAINING_UNIT_CODE | VARCHAR2 | 32 |  |  | Bargaining Unit Code |  |
PROBATION_PERIOD | NUMBER |  |  |  | Duration of probation period |  |
PROBATION_UNIT | VARCHAR2 | 32 |  |  | Units of probation period duration |  |
REPORTING_ESTABLISHMENT_ID | NUMBER | 38 | 0 |  | Reporting Establishment Identifier#5 | DW_REPORTING_EST_D | REPORTING_EST_ID
DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier#4 | DW_DEPARTMENT_D | DEPARTMENT_ID
JOB_ID | NUMBER | 38 | 0 |  | Workers Job Identifier | DW_JOB_D | JOB_ID
LOCATION_ID | NUMBER | 38 | 0 |  | Workers Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
POSITION_ID | NUMBER | 38 | 0 |  | Workers Position Identifier | DW_POSITION_D | POSITION_ID
GRADE_ID | NUMBER | 38 | 0 |  | Workers Grade Identifier | DW_PAY_GRADE_D | GRADE_ID
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal Employer Identifier#6 | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier#7 | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 |  | Workers Period of Service Identifier | DW_SERVICE_PERIOD_D | PERIOD_OF_SERVICE_ID
PERSON_TYPE_ID | NUMBER | 38 | 0 |  | Workers Person Type Identifier | DW_PERSON_TYPE_D_TL | PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 |  | Workers Assignment Status Type Identifier | DW_ASSIGNMENT_STATUS_D_TL | ASSIGNMENT_STATUS_TYPE_ID
PERFORMANCE_RATING_LEVEL_ID | NUMBER | 38 | 0 |  | Performance rating level identifier | DW_RATING_LEVEL_D | RATING_LEVEL_ID
POTENTIAL_RATING_LEVEL_ID | NUMBER | 38 | 0 |  | Potential rating level identifier | DW_RATING_LEVEL_D | RATING_LEVEL_ID
ASSIGNMENT_NUMBER | VARCHAR2 | 32 |  |  | Workers Assignment Number |  |
ASSIGNMENT_NAME | VARCHAR2 | 128 |  |  | Workers Assignment Name |  |
WORKER_TYPE | VARCHAR2 | 32 |  |  | Indicates type of records for worker like assignment or employment terms | DW_WORKER_TYPE_D_TL | WORKER_TYPE
WORKER_CATEGORY | VARCHAR2 | 32 |  |  | Workers category like Blue collar or Civil Servant etc | DW_WORKER_CATEGORY_D_TL | WORKER_CATEGORY
ASSIGNMENT_CATEGORY | VARCHAR2 | 32 |  |  | Workers assignment defined category. For example Full-Time Permanent or Part-Time Permanent | DW_ASSIGNMENT_CATEGORY_D_TL | ASSIGNMENT_CATEGORY
LEGISLATION_CODE | VARCHAR2 | 256 |  |  | Workers Legislation |  |
SEX | VARCHAR2 | 32 |  |  | Worker Sex |  |
ETHNICITY | VARCHAR2 | 32 |  |  | Worker Ethnicity |  |
PRIMARY_FLAG | VARCHAR2 | 32 |  |  | Represents workers overall Primary assignment |  |
PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | 32 |  |  | Workers Primary assignment Flag |  |
SYSTEM_PERSON_TYPE | VARCHAR2 | 32 |  |  | Workers Person Type in System |  |
PAY_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | Workers Payroll status indicating whether the assignment is processed in payroll runs. |  |
PER_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | Workers HR status used to determine how the assignment is processed |  |
FULL_PART_TIME_FLAG | VARCHAR2 | 32 |  |  | Workers Full Part Time Flag |  |
PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 32 |  |  | Workers Permanent Temporary Flag |  |
MANAGER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Workers Line Manager Assignment Identifier | DW_PERSON_D | PERSON_ID
MANAGER_ID | NUMBER | 38 | 0 |  | Workers Line Manager Person Identifier | DW_PERSON_D | PERSON_ID
HEADCOUNT | NUMBER |  |  |  | Workers Headcount Value |  |
FTE | NUMBER |  |  |  | Workers FTE Value |  |
AGE_IN_YEARS | NUMBER | 38 | 0 |  | Workers Age as of doc end Date in Years |  |
AGE_IN_MONTHS | NUMBER | 38 | 0 |  | Workers Age as of doc end Date in months |  |
TENURE_IN_YEARS | NUMBER | 38 | 0 |  | Workers Tenure as of doc end Date in years |  |
TENURE_IN_MONTHS | NUMBER | 38 | 0 |  | Workers Tenure as of doc end Date in Months |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |
AGE_IN_YEARS_ID | NUMBER | 38 | 0 |  | Age in Years of the Worker associated with the Assignment. Null stamped with default |  |
TENURE_IN_YEARS_ID | NUMBER | 38 | 0 |  | Tenure in Years of the Worker associated with the Assignment. Null stamped with default |  |
PRIMARY_WORK_RELATIONSHIP_FLAG | VARCHAR2 | 32 |  |  | Primary Work Relationship Flag |  |
WORK_AT_HOME | VARCHAR2 | 32 |  |  | Work At Home Flag |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.