SCH_SHIFT_BRA

(SQL Table)
Index Back

Shifts Record BRA

Shifts Record BRA

  • Parent record: SCH_SHIFT_TBL
  • # 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 SCH_TYPE_BRA Character(2) VARCHAR2(2) NOT NULL Work Shift Type field.
    00=Regular
    01=Scale of work 12x36
    02=Scale of work 24x72
    03=Rotating shift
    04=Regular Sunday Off
    05=Regular Except Sunday Off
    06=Regular Periodic Sunday Off
    07=Uninterrupted Rotation Shift
    99=Others