DW_WRKFRC_ASG_SUPERVISOR_F

Workforce Assignment Supervisor Fact

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ASSIGNMENT_SUPERVISOR_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_SUPERVISOR_ID NUMBER 38 0 True Supervisor identifier for the Assignment  
EFFECTIVE_START_DATE DATE     True Start date of supervisor for the assignment  
EFFECTIVE_END_DATE DATE     True End date of supervisor for the assignment  
SOURCE_RECORD_ID VARCHAR2 64     Source Record Identifier It is a unique combination of Assignment Supervisor ID, Start Date and End Date  
ASSIGNMENT_ID NUMBER 38 0   Worker Assignment Identifier  
PERSON_ID NUMBER 38 0   Worker Person Identifier DW_PERSON_D PERSON_ID
PRIMARY_FLAG VARCHAR2 32     Flag to indicate if this is the main supervisor. Y indicates main supervisor.  
MANAGER_TYPE VARCHAR2 32     Identifies the role this supervisor has with regards to the overall organization structure.  
MANAGER_ASSIGNMENT_ID NUMBER 38 0   Supervisors Assignment Identifier  
MANAGER_ID NUMBER 38 0   Supervisors Person Identifier DW_PERSON_D PERSON_ID
ACTION_OCCURRENCE_ID NUMBER 38 0   HR Assignment Occurence Identifier  
ACTION_ID NUMBER 38 0   HR Assignment Action Identifier DW_ACTION_D ACTION_ID
ACTION_REASON_ID NUMBER 38 0   HR Assignment Action Reason Identifier DW_ACTION_REASON_D ACTION_REASON_ID
DW_DATE_FROM DATE       Warehouse Effective From Date for the Assignment Event. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used.    
DW_DATE_TO DATE       Warehouse Effective To Date for the Assignment Event. This is equal to EFFECTIVE_END_DATE    
DW_INITIAL_RECORD_IND NUMBER 38 0   This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user.    

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