SCH_SHIFT_VW

(SQL View)
Index Back

Shift Table View

This view selects from the scheduling shift table to show all shifts. This view is used in Value list page.

SELECT DISTINCT SETID , SHIFT_ID , EFFDT , DESCR , START_TIME , END_TIME FROM PS_SCH_SHIFT_TBL

  • Related Language Record: SCH_S_LNG_VW
  • # 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 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 START_TIME Time(15) TIMESTAMP Shift Start Time
    6 END_TIME Time(15) TIMESTAMP Shift End Time