# DW_WRKFRC_GAIN_LOSS_MGRH_F

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

## Details

Module: Global Human Resources

## Key Columns

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

## 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 |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |
PRIMARY_WORK_RELATIONSHIP_FLAG | VARCHAR2 | 32 |  |  | Primary Work Relationship Flag |  |
WORK_AT_HOME | VARCHAR2 | 32 |  |  | Work At Home Flag |  |

## 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, 2026, Oracle and/or its affiliates.