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
Module: Work Life
PROFILE_ITEM_ID, ASSIGNMENT_ID
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 | 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, 2022, Oracle and/or its affiliates.