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 Name Field Type Column Type Description
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_VW

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

    Default: 0

    PARMLIST Character(254) VARCHAR2(254) NOT NULL Parameter List
    CMDLINE Character(127) VARCHAR2(127) NOT NULL Command Line
    WORKINGDIR Character(127) VARCHAR2(127) NOT NULL Working Directory
    OUTPUTDEST Character(127) VARCHAR2(127) NOT NULL Output Destination
    GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic 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

    WINPARM Character(1) VARCHAR2(1) NOT NULL WinExec 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

    MVSSHELLID Character(3) VARCHAR2(3) NOT NULL Job Shell ID
    AS4JOBDESCNAME Character(10) VARCHAR2(10) NOT NULL AS400 Job Description
    AS4JOBDESCLIB Character(10) VARCHAR2(10) NOT NULL AS400 Job Description Lib
    PRCSTYPEDESCR Character(30) VARCHAR2(30) NOT NULL Process Type Description
    RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
    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.
    PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20