DW_WRKFRC_GAIN_LOSS_ASG_F

Stores information about the Gain-Loss Events as happened in transaction system. The information is stored at the assignment level.

Details

Module: Global Human Resources

Key Columns

EVENT_ID, EVENT_DATE, NET_GAIN_LOSS_IND, ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True Assignment Identifier
EVENT_DATE DATE True Event Date
EVENT_ID NUMBER 38 0 True Event Identifier
NET_GAIN_LOSS_IND NUMBER 38 0 True 1 for Gain, -1 for Loss
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier,Event Date,Event ID and net gain loss indicator
GAIN_IND NUMBER 38 0 1 for Gain Event else 0
LOSS_IND NUMBER 38 0 1 for Loss Event else 0
GAIN_LOSS_DATE DATE Event Date for Gain Events, Event Date - 1 for Loss Events
ACTION_TYPE_CODE VARCHAR2 32 Action type code
ACTION_ID NUMBER 38 0 Event Action Identifier DW_ACTION_D ACTION_ID
ACTION_REASON_ID NUMBER 38 0 Event Action reason Identifier DW_ACTION_REASON_D ACTION_REASON_ID
ACTION_META_REASON_CODE VARCHAR2 128 Action Meta Reason Code
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
DEPARTMENT_ID NUMBER 38 0 Department Identifier#4 DW_DEPARTMENT_D DEPARTMENT_ID
PERSON_ID NUMBER 38 0 Person Identifier DW_PERSON_D PERSON_ID
LOCATION_ID NUMBER 38 0 Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
POSITION_ID NUMBER 38 0 Position Identifier DW_POSITION_D POSITION_ID
GRADE_ID NUMBER 38 0 Grade Identifier DW_PAY_GRADE_D GRADE_ID
SUPERVISOR_ID NUMBER 38 0 Person ID of the Immediate Line Manager DW_PERSON_D PERSON_ID
SUPERVISOR_ASSIGNMENT_ID NUMBER 38 0 Assignment ID of the Immediate Line Manager
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
REPORTING_ESTABLISHMENT_ID NUMBER 38 0 Reporting Establishment Identifier#5 DW_REPORTING_EST_D REPORTING_EST_ID
PERIOD_OF_SERVICE_ID NUMBER 38 0 Period of Service Identifier DW_SERVICE_PERIOD_D PERIOD_OF_SERVICE_ID
PERSON_TYPE_ID NUMBER 38 0 Person Type Identifier DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
SYSTEM_PERSON_TYPE VARCHAR2 32 Person Type in System
WORKER_TYPE VARCHAR2 32 Indicates type of records- assignment , employment terms DW_WORKER_TYPE_D_TL WORKER_TYPE
LEGISLATION_CODE VARCHAR2 256 Legislation of Assignment
ASSIGNMENT_CATEGORY VARCHAR2 32 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 Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
PAY_SYSTEM_STATUS VARCHAR2 32 Payroll status indicating whether the assignment is processed in payroll runs.
PER_SYSTEM_STATUS VARCHAR2 32 HR status used to determine how the assignment is processed
WORKER_CATEGORY VARCHAR2 32 Employee category example: Blue collar, Civil Servant, etc DW_WORKER_CATEGORY_D_TL WORKER_CATEGORY
FULL_PART_TIME_FLAG VARCHAR2 32 Full/Part Time Flag associated with the Assignment
AGE_IN_YEARS NUMBER 38 0 Person Age as of Event Date in Years
TENURE_IN_YEARS NUMBER 38 0 Person Tenure as of Event Date in years
AGE_IN_MONTHS NUMBER 38 0 Person Age as of Event Date in months
TENURE_IN_MONTHS NUMBER 38 0 Person Tenure as of Event Date in Months
ASSIGNMENT_NUMBER VARCHAR2 32 Assignment Number
ASSIGNMENT_NAME VARCHAR2 128 Assignment Name
PRIMARY_FLAG VARCHAR2 32 Represents overall Primary assignment
PRIMARY_ASSIGNMENT_FLAG VARCHAR2 32 Primary assignment flag
HEADCOUNT NUMBER Headcount at the time of Event
FTE NUMBER FTE at the time of Event
EVENT_ASG_COUNT NUMBER 38 0 1
JOB_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the job else 0
FROM_JOB_ID NUMBER 38 0 Identifier of the Job where there is a loss DW_JOB_D JOB_ID
TO_JOB_ID NUMBER 38 0 Identifier of the Job where there is a gain DW_JOB_D JOB_ID
GRADE_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the grade else 0
FROM_GRADE_ID NUMBER 38 0 Identifier of the grade where there is a loss DW_PAY_GRADE_D GRADE_ID
TO_GRADE_ID NUMBER 38 0 Identifier of the grade where there is a gain DW_PAY_GRADE_D GRADE_ID
LOCATION_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the location else 0
FROM_LOCATION_ID NUMBER 38 0 Identifier of the location where there is a loss DW_WORKER_LOCATION_D LOCATION_ID
TO_LOCATION_ID NUMBER 38 0 Identifier of the location where there is a gain DW_WORKER_LOCATION_D LOCATION_ID
POSITION_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the position else 0
FROM_POSITION_ID NUMBER 38 0 Identifier of the position where there is a loss DW_POSITION_D POSITION_ID
TO_POSITION_ID NUMBER 38 0 Identifier of the position where there is a gain DW_POSITION_D POSITION_ID
DEPARTMENT_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the department else 0
FROM_DEPARTMENT_ID NUMBER 38 0 Identifier of the department where there is a loss DW_DEPARTMENT_D DEPARTMENT_ID
TO_DEPARTMENT_ID NUMBER 38 0 Identifier of the department where there is a gain DW_DEPARTMENT_D DEPARTMENT_ID
SUPERVISOR_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the immediate manager else 0
FROM_SUPERVISOR_ASG_ID NUMBER 38 0 Assignment Identifier of the Manager (Immediate) who has a loss
TO_SUPERVISOR_ASG_ID NUMBER 38 0 Assignment Identifier of the Manager(Immediate) who has a gain
FROM_SUPERVISOR_PERSON_ID NUMBER 38 0 Person Identifier of the Manager(Immediate) who has a loss DW_PERSON_D PERSON_ID
TO_SUPERVISOR_PERSON_ID NUMBER 38 0 Person Identifier of the Manager(Immediate) who has a gain DW_PERSON_D PERSON_ID
BUSINESS_UNIT_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the business unit else 0
FROM_BUSINESS_UNIT_ID NUMBER 38 0 Identifier of the business unit where there is a loss DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
TO_BUSINESS_UNIT_ID NUMBER 38 0 Identifier of the business unit where there is a gain DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
FULL_PART_TIME_GAIN_LOSS_IND NUMBER 38 0 1 when there is a gain or loss to the full or part time status else 0
FROM_FULL_PART_TIME_FLAG VARCHAR2 32 Full/Part time flag where there is a loss
TO_FULL_PART_TIME_FLAG VARCHAR2 32 Full/Part time flag where there is a gain
HIRE_EVENT_IND NUMBER 38 0 1 for hire event else 0 (based on action type)
REHIRE_EVENT_IND NUMBER 38 0 1 for rehire event else 0 (based on action type)
TERM_EVENT_IND NUMBER 38 0 1 for termination event else 0 (based on action type)
GLB_TRANSFER_IN_IND NUMBER 38 0 1 when there is a gain due to global transfer event else 0 (based on action type and active/inactive status)
GLB_TRANSFER_OUT_IND NUMBER 38 0 1 when there is a loss due to global transfer event else 0 (based on action type and active/inactive status)
GLB_TEMP_TRANSFER_IN_IND NUMBER 38 0 1 when there is a gain due to global temporary transfer event else 0 (based on action type)
GLB_TEMP_TRANSFER_OUT_IND NUMBER 38 0 1 when there is a loss due to global temporary transfer event else 0 (based on action type)
TRANSFER_EVENT_IND NUMBER 38 0 1 for transfer event else 0 (based on action type)
PROMOTION_EVENT_IND NUMBER 38 0 1 for promotion event else 0 (based on action type)
REORG_EVENT_IND NUMBER 38 0 1 for reorganization event else 0 (based on action attribute)
OTHER_EVENT_IND NUMBER 38 0 1 for events not captured with the above indicators else 0
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
PERMANENT_TEMPORARY_FLAG VARCHAR2 32 Permanent Temporary 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