SCHEDULE_TBL

(SQL Table)
 Index Back

Schedules

Schedule definition

  • Related Language Record: SCHEDULE_LANG

  • Parent Record Of EVENTS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 FREQUENCY Character(1) VARCHAR2(1) NOT NULL Frequency
    A=Annually
    D=Daily
    M=Monthly
    U=User Defined
    W=Weekly
    5 DAY_OF_WK Character(2) VARCHAR2(2) NOT NULL Determines the day of the week for which route schedule dates will be generated when the weekly route scheduling option is chosen on the Route Calendar Maintenance Panel.
    1=Monday
    2=Tuesday
    3=Wednesday
    4=Thursday
    5=Friday
    6=Saturday
    7=Sunday
    6 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month
    7 LAST_DAY_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Last Day of the Month

    Y/N Table Edit

    Default Value: N

    8 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: Y

    9 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: Y

    10 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: Y

    11 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: Y

    12 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: Y

    13 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    14 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    15 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    16 JANUARY Character(1) VARCHAR2(1) NOT NULL January

    Y/N Table Edit

    Default Value: Y

    17 FEBRUARY Character(1) VARCHAR2(1) NOT NULL February

    Y/N Table Edit

    Default Value: Y

    18 MARCH Character(1) VARCHAR2(1) NOT NULL March

    Y/N Table Edit

    Default Value: Y

    19 APRIL Character(1) VARCHAR2(1) NOT NULL April

    Y/N Table Edit

    Default Value: Y

    20 MAY Character(1) VARCHAR2(1) NOT NULL May

    Y/N Table Edit

    Default Value: Y

    21 JUNE Character(1) VARCHAR2(1) NOT NULL June

    Y/N Table Edit

    Default Value: Y

    22 JULY Character(1) VARCHAR2(1) NOT NULL July

    Y/N Table Edit

    Default Value: Y

    23 AUGUST Character(1) VARCHAR2(1) NOT NULL August

    Y/N Table Edit

    Default Value: Y

    24 SEPTEMBER Character(1) VARCHAR2(1) NOT NULL September

    Y/N Table Edit

    Default Value: Y

    25 OCTOBER Character(1) VARCHAR2(1) NOT NULL October

    Y/N Table Edit

    Default Value: Y

    26 NOVEMBER Character(1) VARCHAR2(1) NOT NULL November

    Y/N Table Edit

    Default Value: Y

    27 DECEMBER Character(1) VARCHAR2(1) NOT NULL December

    Y/N Table Edit

    Default Value: Y

    28 DESCRLONG Long Character CLOB Long Description