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.