This table stores schedule managers at assignment grain
Module: Global Human Resources
SCHEDULE_PROFILE_MGR_ID, ASSIGNMENT_ID
| 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.