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 This column is for Oracle Internal use only. 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