WM_SHIFT_TM_VW

(SQL View)
 Index Back

Shift Times

Shift Times converted from columnar to row format

SELECT SETID , SHIFT_ID , START_SUNDAY , END_SUNDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_MONDAY , END_MONDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_TUESDAY , END_TUESDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_WEDNESDAY , END_WEDNESDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_THURSDAY , END_THURSDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_FRIDAY , END_FRIDAY FROM PS_RS_SHIFT_TIME UNION SELECT SETID , SHIFT_ID , START_SATURDAY , END_SATURDAY FROM PS_RS_SHIFT_TIME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID
3 START_TIME Time(15) TIMESTAMP Start of Shift
4 END_TIME Time(15) TIMESTAMP End of Shift