DW_ASG_MANAGER_STATUS_D

Workforce Assignment manager status, This table stores time range when the manager assignment was present.

Details

Module: Global Human Resources

Key Columns

MANAGER_ASSIGNMENT_ID, DATE_FROM

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
MANAGER_ASSIGNMENT_ID NUMBER 38 0 True Supervisors Assignment Identifier  
DATE_FROM DATE     True Supervisor from date  
SOURCE_RECORD_ID VARCHAR2 64     Source Record Identifier, It is a unique combination of manager supervisor ID and supervisor from date  
DATE_TO DATE       Supervisor to date  
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_ID NUMBER 38 0   Supervisors Person Identifier DW_PERSON_D PERSON_ID
MANAGER_FLAG VARCHAR2 16     Flag to indicate if for given period manager assignment is present or not    

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