# DW_WS_SCHEDULE_PRIMARY_PROFILE_MANAGER_D

This stores primary assignmnet information of SGP manager

## Details

Module: Global Human Resources

## Key Columns

SCHEDULE_PROFILE_MGR_ID, ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SCHEDULE_PROFILE_MGR_ID | NUMBER | 38 | 0 | True | System generated identifier for a schedule profile manager. |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment Identifier as of sgp manager start date |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source record identifier for the schedule profile manager row. |  |
SCHEDULE_GEN_PROFILE_ID | NUMBER | 38 | 0 |  | Schedule generation profile identifier. |  |
PROFILE_MGR_PERSON_ID | NUMBER | 38 | 0 |  | Person identifier of the schedule manager. |  |
START_DATE | DATE |  |  |  | Date when the manager can start generating and publishing schedules. |  |
END_DATE | DATE |  |  |  | Date when the manager can no longer generate and publish schedules. |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier. |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier as of sgp manager start date | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier as of sgp manager start date | DW_WORKER_LOCATION_D | LOCATION_ID
DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier as of sgp manager start date | DW_DEPARTMENT_D | DEPARTMENT_ID
PRIMARY_FLAG | VARCHAR2 | 32 |  |  | Represents overall Primary assignment as of sgp manager start date |  |
ASSIGNMENT_STATUS_TYPE | VARCHAR2 | 32 |  |  | Assignment status type |  |
DW_DATE_FROM | DATE |  |  |  | Warehouse start Date for the sgp manager start date. If Initial extract date is greater than START_DATE then Initial extract date is used.for null start date it is defaulted to start of time |  |
DW_DATE_TO | DATE |  |  |  | Warehouse end Date for sgp manager enddate . This is equal to end date. For null end date it will defaulted to end of time |  |
DW_INITIAL_RECORD_IND | NUMBER | 38 | 0 |  | This indicates the record where Initial extract date is greater than START_DATE |  |

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