Stores Aggregate information about Gain & Loss Events for Managers (All levels)
Module: Global Human Resources
WORKER_CATEGORY, HRCHY_CHNG_WTHN_IND, PER_SYSTEM_STATUS, REPORTING_ESTABLISHMENT_ID, SYSTEM_PERSON_TYPE, DEPARTMENT_ID, LEGAL_EMPLOYER_ID, FULL_PART_TIME_FLAG, PERSON_TYPE_ID, ACTION_TYPE_CODE, HRCHY_IN_OUT_IND, PAY_SYSTEM_STATUS, JOB_ID, BUSINESS_UNIT_ID, ASSIGNMENT_CATEGORY, WORKER_TYPE, LEGISLATION_CODE, EVENT_DATE, GRADE_ID, POSITION_ID, ACTION_REASON_ID, ACTION_META_REASON_CODE, MANAGER_ASSIGNMENT_ID, ACTION_ID, MANAGER_ID, ASSIGNMENT_STATUS_TYPE_ID, LOCATION_ID
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 |
#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, 2022, Oracle and/or its affiliates.