# 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

DATE_FROM, MANAGER_ASSIGNMENT_ID

## 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 |  |

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