PRCSTYPEDEFN

(SQL Table)
 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 PeopleSoft Field Type Database Column Type Description
    1 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_VW

    2 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
    3 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
    4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 0

    5 PARMLIST Character(254) VARCHAR2(254) NOT NULL Parameter List
    6 CMDLINE Character(127) VARCHAR2(127) NOT NULL Command Line
    7 WORKINGDIR Character(127) VARCHAR2(127) NOT NULL Working Directory
    8 OUTPUTDEST Character(127) VARCHAR2(127) NOT NULL Output Destination
    9 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 Value: 0

    10 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 Value: 7

    11 MVSSHELLID Character(3) VARCHAR2(3) NOT NULL Job Shell ID
    12 AS4JOBDESCNAME Character(10) VARCHAR2(10) NOT NULL AS400 Job Description
    13 AS4JOBDESCLIB Character(10) VARCHAR2(10) NOT NULL AS400 Job Description Lib
    14 PRCSTYPEDESCR Character(30) VARCHAR2(30) NOT NULL Process Type Description
    15 RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
    16 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.
    17 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.
    18 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days