PRCSTYPEDEFN

index back

Process Type Defn

This record is used to define the process parameters that vary depending on the process type, database platform and operating system.

  • Related language record: PRCSTYPEDEFNLNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PRCSTYPE_VW

    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
    DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase
    6=Sybase
    7=Microsoft
    8=DB2/400
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 0

    PARMLISTCharacter(254)VARCHAR2(254) NOT NULLParameter List
    CMDLINECharacter(127)VARCHAR2(127) NOT NULLCommand Line
    WORKINGDIRCharacter(127)VARCHAR2(127) NOT NULLWorking Directory
    OUTPUTDESTCharacter(127)VARCHAR2(127) NOT NULLOutput Destination
    GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric Process Type
    0=Other
    1=SQR
    2=PeopleSoft COBOL
    3=Crystal Report
    4=Winword Macro
    5=Application Engine
    6=Cube Builder
    7=nVision
    8=Data Mover
    9=PSJob

    Default: 0

    WINPARMCharacter(1)VARCHAR2(1) NOT NULLWinExec Parameter
    0=Hide Window
    1=Show - Activate New
    2=Minimize - Activate New
    3=Maximize - Activate New
    4=Show - Activate Current
    7=Minimize - Activate Current

    Default: 7

    MVSSHELLIDCharacter(3)VARCHAR2(3) NOT NULLJob Shell ID
    AS4JOBDESCNAMECharacter(10)VARCHAR2(10) NOT NULLAS400 Job Description
    AS4JOBDESCLIBCharacter(10)VARCHAR2(10) NOT NULLAS400 Job Description Lib
    PRCSTYPEDESCRCharacter(30)VARCHAR2(30) NOT NULLProcess Type Description
    RESTARTENABLEDCharacter(1)VARCHAR2(1) NOT NULLRestart Enabled?
    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.
    PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19