# DW_WS_SCHEDULE_D

This table stores the schedule information of schedule units.

## Details

Module: Global Human Resources

## Key Columns

SCHEDULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SCHEDULE_ID | NUMBER | 38 | 0 | True | Unique system generated identifier for the schedule. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source record identifier for the schedule row. |  |
SCHEDULE_UNIT_ID | NUMBER | 38 | 0 |  | Schedule unit identifier for which the schedule is created. |  |
SCHEDULE_GEN_PROFILE_ID | NUMBER | 38 | 0 |  | Schedule generation profile identifier used for creating the schedule. |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier. |  |
OPEN_DATE | DATE |  |  |  | Date when the schedule is opened. |  |
PUBLISH_DUE_DATE | DATE |  |  |  | Date by which the schedule should be published. |  |
PUBLISHED_DATE | DATE |  |  |  | Date when the schedule was published. |  |
END_DATE | DATE |  |  |  | End date of the schedule period. |  |
COMMENTS | VARCHAR2 | 4096 |  |  | Notes/comments entered for the schedule. |  |
START_DATE | DATE |  |  |  | Start date of the schedule period. |  |
STATUS_CODE | VARCHAR2 | 32 |  |  | Schedule status code. | DW_WS_SCHEDULE_STATUS_D_TL | SCHEDULE_STATUS
SCHEDULE_UPDATE_DATE | TIMESTAMP |  |  |  | Date and time when schedule was updated. |  |
SELF_SCHEDULE_CLOSE_DATE | DATE |  |  |  | Date when self-scheduling closes. |  |
SELF_SCHEDULE_OPEN_DATE | DATE |  |  |  | Date when self-scheduling opens. |  |
UNPUBLISH_DATE | TIMESTAMP |  |  |  | Date and time when the schedule was unpublished. |  |
WORKLOAD_UPDATE_DATE | TIMESTAMP |  |  |  | Date and time when workload was updated. |  |
PUBLISHED_BY | NUMBER | 38 | 0 |  | Identifier of the worker who published the schedule. |  |
UNPUBLISHED_BY | NUMBER | 38 | 0 |  | Identifier of the worker who unpublished the schedule. |  |

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