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