SCHDLDEFN

index back

Schedule Definition


  • Related language record: SCHDLDEFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
    JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source

    Prompt Table: PRCSJOBDEFN
    Set Control Field: PRCSJOBNAME

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    SCHEDULESTATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
    0=Inactive
    1=Active
    2=Completed

    Default: 0

    SCHDLPRIORITY Character(1) VARCHAR2(1) NOT NULL Schedule Priority
    1=Low
    2=Medium
    3=High
    5=Medium
    9=High

    Default: 5

    RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    STARTDATETIME DateTime(26) TIMESTAMP Start Datetime
    TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

    Prompt Table: PRCSRECUR

    SRVRRUNOPTION Character(1) VARCHAR2(1) NOT NULL Server Run Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server

    Default: 1

    PRIMARYSRVRNAME Character(8) VARCHAR2(8) NOT NULL Primary Server Name

    Prompt Table: SERVERDEFN
    Set Control Field: SERVERNAME

    OPSYS Character(1) VARCHAR2(1) NOT NULL Operating 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
    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19