Workforce Assignment manager status, This table stores time range when the manager assignment was present.
Module: Global Human Resources
DATE_FROM, MANAGER_ASSIGNMENT_ID
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, 2023, Oracle and/or its affiliates.