SCHDLDEFN

index back

Schedule Definition


  • Related language record: SCHDLDEFNLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
    JOBNAMESRCCharacter(8)VARCHAR2(8) NOT NULLJob Name Source

    Prompt Table: PRCSJOBDEFN
    Set Control Field: PRCSJOBNAME

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    SCHEDULESTATUSCharacter(1)VARCHAR2(1) NOT NULLSchedule Status
    0=Inactive
    1=Active
    2=Completed

    Default: 0

    SCHDLPRIORITYCharacter(1)VARCHAR2(1) NOT NULLSchedule Priority
    1=Low
    2=Medium
    3=High
    5=Medium
    9=High

    Default: 5

    RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    STARTDATETIMEDateTime(26)TIMESTAMPStart Datetime
    TIMEZONECharacter(9)VARCHAR2(9) NOT NULLTime Zone

    Prompt Table: PSTIMEZONE

    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name

    Prompt Table: PRCSRECUR

    SRVRRUNOPTIONCharacter(1)VARCHAR2(1) NOT NULLServer Run Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server

    Default: 1

    PRIMARYSRVRNAMECharacter(8)VARCHAR2(8) NOT NULLPrimary Server Name

    Prompt Table: SERVERDEFN
    Set Control Field: SERVERNAME

    OPSYSCharacter(1)VARCHAR2(1) NOT NULLOperating System
    0=DOS
    1=NT/Win95 Client
    2=Windows
    3=OS/2
    4=UNIX
    5=VMS
    6=MPE/XL
    7=OS390
    8=NT
    9=OS/400
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19