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