SCH_EE_DAY_PREF

(SQL Table)
 Index Back

Employee Sched Pref - Day

Stores those employee scheduling preferences which are specific to the day of the week.

  • Parent record: SCH_EE_PREF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DAYOFWK_MON Character(1) VARCHAR2(1) NOT NULL Day of week, beginning with Monday
    1=Monday
    2=Tuesday
    3=Wednesday
    4=Thursday
    5=Friday
    6=Saturday
    7=Sunday
    3 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

    Prompt Table: SCH_SHIFT_TBL

    4 START_TIME Time(15) TIMESTAMP Interview Start Time
    5 END_TIME Time(15) TIMESTAMP Interview End Time
    6 OVERTIME_PREF Character(1) VARCHAR2(1) NOT NULL Willing to work overtime?
    N=No
    Y=Yes

    Default Value: N

    7 DBL_SHIFT_PREF Character(1) VARCHAR2(1) NOT NULL Willing to work double shifts?
    N=No
    Y=Yes

    Default Value: N