DW_WRKFRC_GAIN_LOSS_MGRH_F

Stores Aggregate information about Gain & Loss Events for Managers (All levels)

Details

Module: Global Human Resources

Key Columns

EVENT_DATE, PERSON_TYPE_ID, ACTION_META_REASON_CODE, WORKER_CATEGORY, DEPARTMENT_ID, LEGISLATION_CODE, JOB_ID, BUSINESS_UNIT_ID, WORKER_TYPE, GRADE_ID, REPORTING_ESTABLISHMENT_ID, HRCHY_IN_OUT_IND, ASSIGNMENT_STATUS_TYPE_ID, ACTION_TYPE_CODE, LOCATION_ID, FULL_PART_TIME_FLAG, LEGAL_EMPLOYER_ID, PER_SYSTEM_STATUS, PAY_SYSTEM_STATUS, SYSTEM_PERSON_TYPE, POSITION_ID, MANAGER_ID, HRCHY_CHNG_WTHN_IND, MANAGER_ASSIGNMENT_ID, ACTION_REASON_ID, ACTION_ID, ASSIGNMENT_CATEGORY

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MANAGER_ASSIGNMENT_ID NUMBER 38 0 True Assignment Identifier of the Manager (All Levels) under whom there is a gain or loss event    
EVENT_DATE DATE     True Event Date    
HRCHY_IN_OUT_IND NUMBER 38 0 True 1 when there is a Gain or Loss to the Manager else 0    
HRCHY_CHNG_WTHN_IND NUMBER 38 0 True 1 when there is no net Gain or Loss to the Manager else 0    
ACTION_TYPE_CODE VARCHAR2 32   True Action type code    
ACTION_ID NUMBER 38 0 True Event Action Identifier DW_ACTION_D ACTION_ID
ACTION_REASON_ID NUMBER 38 0 True Event Action reason Identifier DW_ACTION_REASON_D ACTION_REASON_ID
ACTION_META_REASON_CODE VARCHAR2 128   True Action Meta Reason Code    
MANAGER_ID NUMBER 38 0 True Person Identifier of the Manager (All Levels) under whom there is a gain or loss event DW_PERSON_D PERSON_ID
JOB_ID NUMBER 38 0 True Job Identifier DW_JOB_D JOB_ID
DEPARTMENT_ID NUMBER 38 0 True Department Identifier#4 DW_DEPARTMENT_D DEPARTMENT_ID
LOCATION_ID NUMBER 38 0 True Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
POSITION_ID NUMBER 38 0 True Position Identifier DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0 True Grade Identifier DW_PAY_GRADE_D GRADE_ID
LEGAL_EMPLOYER_ID NUMBER 38 0 True Legal Employer Identifier#6 DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0 True Business Unit Identifier#7 DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
REPORTING_ESTABLISHMENT_ID NUMBER 38 0 True Reporting Establishment Identifier#5 DW_REPORTING_EST_D REPORTING_EST_ID
PERSON_TYPE_ID NUMBER 38 0 True Person Type Identifier DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
SYSTEM_PERSON_TYPE VARCHAR2 32   True Person Type in System    
WORKER_TYPE VARCHAR2 32   True Indicates type of records- assignment , employment terms DW_WORKER_TYPE_D_TL WORKER_TYPE
LEGISLATION_CODE VARCHAR2 256   True Legislation of Assignment    
ASSIGNMENT_CATEGORY VARCHAR2 32   True User defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0 True Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
PAY_SYSTEM_STATUS VARCHAR2 32   True Payroll status indicating whether the assignment is processed in payroll runs.    
PER_SYSTEM_STATUS VARCHAR2 32   True HR status used to determine how the assignment is processed    
WORKER_CATEGORY VARCHAR2 32   True Employee category example: Blue collar, Civil Servant, etc DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
FULL_PART_TIME_FLAG VARCHAR2 32   True Full/Part Time Flag associated with the Assignment    
HIRE_HDC NUMBER       Hire Headcount DW_WORKER_TYPE_D_TL WORKER_TYPE
HIRE_FTE NUMBER       Hire FTE    
HIRE_ASG_CNT NUMBER       Hire Assignment Count DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
REHIRE_HDC NUMBER       Rehire Headcount DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
REHIRE_FTE NUMBER       Rehire FTE    
REHIRE_ASG_CNT NUMBER       Rehire Assignment Count    
TERM_HDC NUMBER       Termination Headcount DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
TERM_FTE NUMBER       Termination Headcount    
TERM_ASG_CNT NUMBER       Termination Headcount    
GLB_TRANSFER_IN_HDC NUMBER       Headcount moved in due to Global Transfer    
GLB_TRANSFER_IN_FTE NUMBER       FTE moved in due to Global Transfer    
GLB_TRANSFER_IN_ASG_CNT NUMBER       Assignment Count of people moved in due to Global Transfer    
GLB_TRANSFER_OUT_HDC NUMBER       Headcount moved out due to Global Transfer    
GLB_TRANSFER_OUT_FTE NUMBER       FTE moved out due to Global Transfer    
GLB_TRANSFER_OUT_ASG_CNT NUMBER       Assignment Count of people moved out due to Global Transfer    
GLB_TEMP_TRANSFER_IN_HDC NUMBER       Headcount moved in due to Temporary Global Transfer    
GLB_TEMP_TRANSFER_IN_FTE NUMBER       FTE moved in due to Temporary Global Transfer    
GLB_TEMP_TRANSFER_IN_ASG_CNT NUMBER       Assignment Count of people moved in due to Temporary Global Transfer    
GLB_TEMP_TRANSFER_OUT_HDC NUMBER       Headcount moved out due to Temporary Global Transfer    
GLB__TEMP_TRANSFER_OUT_FTE NUMBER       FTE moved out due to Temporary Global Transfer    
GLB_TEMP_TRANSFER_OUT_ASG_CNT NUMBER       Assignment Count of people moved out due to Temporary Global Transfer    
TRANSFER_HDC NUMBER       Headcount of people transferred    
TRANSFER_FTE NUMBER       FTE of people transferred    
TRANSFER_ASG_CNT NUMBER       Assignment count of people transferred    
PROMOTION_HDC NUMBER       Headcount of people promoted    
PROMOTION_FTE NUMBER       FTE of people promoted    
PROMOTION_ASG_CNT NUMBER       Assignment count of people promoted    
REORG_HDC NUMBER       Headcount of people who have undergone Reorganization    
REORG_FTE NUMBER       FTE of people who have undergone Reorganization    
REORG_ASG_CNT NUMBER       Assignment count of people who have undergone Reorganization    
OTHER_EVENTS_HDC NUMBER       Headcount of people with Other Events (i.e. events not mentioned in the above measures)    
OTHER_EVENTS_FTE NUMBER       FTE of people with Other Events (i.e. events not mentioned in the above measures)    
OTHER_EVENTS_ASG_CNT NUMBER       Assignment Count of people with Other Events (i.e. events not mentioned in the above measures)    
JOB_GAIN_HDC NUMBER       Headcount Gain for the Job    
JOB_LOSS_HDC NUMBER       Headcount Loss for the Job    
JOB_NET_HDC NUMBER       Net Headcount Change for the Job    
JOB_GAIN_FTE NUMBER       FTE Gain for the Job    
JOB_LOSS_FTE NUMBER       FTE Loss for the Job    
JOB_NET_FTE NUMBER       Net FTE Change for the Job    
JOB_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Job    
JOB_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Job    
JOB_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Job    
GRADE_GAIN_HDC NUMBER       Headcount Gain for the Grade    
GRADE_LOSS_HDC NUMBER       Headcount Loss for the Grade    
GRADE_NET_HDC NUMBER       Net Headcount Change for the Grade    
GRADE_GAIN_FTE NUMBER       FTE Gain for the Grade    
GRADE_LOSS_FTE NUMBER       FTE Loss for the Grade    
GRADE_NET_FTE NUMBER       Net FTE Change for the Grade    
GRADE_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Grade    
GRADE_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Grade    
GRADE_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Grade    
LOCATION_GAIN_HDC NUMBER       Headcount Gain for the Location    
LOCATION_LOSS_HDC NUMBER       Headcount Loss for the Location    
LOCATION_NET_HDC NUMBER       Net Headcount Change for the Location    
LOCATION_GAIN_FTE NUMBER       FTE Gain for the Location    
LOCATION_LOSS_FTE NUMBER       FTE Loss for the Location    
LOCATION_NET_FTE NUMBER       Net FTE Change for the Location    
LOCATION_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Location    
LOCATION_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Location    
LOCATION_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Location    
POSITION_GAIN_HDC NUMBER       Headcount Gain for the Position    
POSITION_LOSS_HDC NUMBER       Headcount Loss for the Position    
POSITION_NET_HDC NUMBER       Net Headcount Change for the Position    
POSITION_GAIN_FTE NUMBER       FTE Gain for the Position    
POSITION_LOSS_FTE NUMBER       FTE Loss for the Position    
POSITION_NET_FTE NUMBER       Net FTE Change for the Position    
POSITION_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Position    
POSITION_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Position    
POSITION_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Position    
DEPARTMENT_GAIN_HDC NUMBER       Headcount Gain for the Department    
DEPARTMENT_LOSS_HDC NUMBER       Headcount Loss for the Department    
DEPARTMENT_NET_HDC NUMBER       Net Headcount Change for the Department    
DEPARTMENT_GAIN_FTE NUMBER       FTE Gain for the Department    
DEPARTMENT_LOSS_FTE NUMBER       FTE Loss for the Department    
DEPARTMENT_NET_FTE NUMBER       Net FTE Change for the Department    
DEPARTMENT_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Department    
DEPARTMENT_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Department    
DEPARTMENT_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Department    
BUSINESS_UNIT_GAIN_HDC NUMBER       Headcount Gain for the Business Unit    
BUSINESS_UNIT_LOSS_HDC NUMBER       Headcount Loss for the Business Unit    
BUSINESS_UNIT_NET_HDC NUMBER       Net Headcount Change for the Business Unit    
BUSINESS_UNIT_GAIN_FTE NUMBER       FTE Gain for the Business Unit    
BUSINESS_UNIT_LOSS_FTE NUMBER       FTE Loss for the Business Unit    
BUSINESS_UNIT_NET_FTE NUMBER       Net FTE Change for the Business Unit    
BUSINESS_UNIT_GAIN_ASG_CNT NUMBER       Number of Assignment Gain for the Business Unit    
BUSINESS_UNIT_LOSS_ASG_CNT NUMBER       Number of Assignment Loss for the Business Unit    
BUSINESS_UNIT_NET_ASG_CNT NUMBER       Net Number of Assigngment Change for the Business Unit    
FULL_TIME_GAIN_HDC NUMBER       Full Time Worker Headcount Gain    
FULL_TIME_LOSS_HDC NUMBER       Full Time Worker Headcount Loss    
FULL_TIME_NET_HDC NUMBER       Net Change of Headcount for Full Time Worker Status    
FULL_TIME_GAIN_FTE NUMBER       Full Time Worker FTE Gain    
FULL_TIME_LOSS_FTE NUMBER       Full Time Worker FTE Loss    
FULL_TIME_NET_FTE NUMBER       Net Change of FTE for Full Time Worker Status    
FULL_TIME_GAIN_ASG_CNT NUMBER       Assignment Count of Full Time Worker Gain    
FULL_TIME_LOSS_ASG_CNT NUMBER       Assignment Count of Full Time Worker Loss    
FULL_TIME_NET_ASG_CNT NUMBER       Net Assignment Count Change for Full Time Worker Status    
PART_TIME_GAIN_HDC NUMBER       Part Time Worker Headcount Gain    
PART_TIME_LOSS_HDC NUMBER       Part Time Worker Headcount Loss    
PART_TIME_NET_HDC NUMBER       Net Change of Headcount for Part Time Worker Status    
PART_TIME_GAIN_FTE NUMBER       Part Time Worker FTE Gain    
PART_TIME_LOSS_FTE NUMBER       Part Time Worker FTE Loss    
PART_TIME_NET_FTE NUMBER       Net Change of FTE for Part Time Worker Status    
PART_TIME_GAIN_ASG_CNT NUMBER       Assignment Count of Part Time Worker Gain    
PART_TIME_LOSS_ASG_CNT NUMBER       Assignment Count of Part Time Worker Loss    
PART_TIME_NET_ASG_CNT NUMBER       Net Assignment Count Change for Part Time Worker Status    

Notes

#1 DW_JOB_D is date effective. Join should also consider fact EFFECTIVE_START_DATE to get the correct dimension values.

#2 DW_POSITION_D is date effective. Join should also consider fact EFFECTIVE_START_DATE to get the correct dimension values.

#3DW_PAY_GRADE_D is date effective. Join should also consider fact EFFECTIVE_START_DATE to get the correct dimension values.

#4 For getting Organization hierarchy, DEPARTMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#5 For getting Organization hierarchy, REPORTING_ESTABLISHMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#6 For getting Organization hierarchy, LEGAL_EMPLOYER_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#7 For getting Organization hierarchy, BUSINESS_UNIT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

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