SCHEDULE_TBL

(SQL Table)
 Index Back

Schedules

Schedules definitions for integration with Contracts.

  • 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 This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule for integration with Contracts.
    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 Y/N flag for providing the Start and End Time for Monday

    Y/N Table Edit

    Default Value: Y

    9 TUES Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Tuesday.

    Y/N Table Edit

    Default Value: Y

    10 WED Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Wednesday.

    Y/N Table Edit

    Default Value: Y

    11 THURS Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Thursday.

    Y/N Table Edit

    Default Value: Y

    12 FRI Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Friday.

    Y/N Table Edit

    Default Value: Y

    13 SAT Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Saturday.

    Y/N Table Edit

    Default Value: N

    14 SUN Character(1) VARCHAR2(1) NOT NULL Y/N flag for providing the Start and End Time for Sunday

    Y/N Table Edit

    Default Value: N

    15 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month of the Year
    01=January
    02=February
    03=March
    04=April
    05=May
    06=June
    07=July
    08=August
    09=September
    10=October
    11=November
    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