DW_WS_SCHEDULE_A

Workforce Schedule Aggregate fact

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 Schedule identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. unique key    
CALENDAR_DATE DATE       Calendar date on which the shift count is evaluated    
SHIFT_COUNT NUMBER 38 0   Count of shifts generated in schedule shifts for a schedule    

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