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    

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