| PeopleSoft Field Name | Field Type | Description |
|---|
 PRCSTYPE | VARCHAR2(30) NOT NULL | Process Type Prompt Table: PRCSTYPE_VW |
| OPSYS | 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 | 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 | DECIMAL(10) NOT NULL | Version Default: 0 |
| PARMLIST | VARCHAR2(254) NOT NULL | Parameter List |
| CMDLINE | VARCHAR2(127) NOT NULL | Command Line |
| WORKINGDIR | VARCHAR2(127) NOT NULL | Working Directory |
| OUTPUTDEST | VARCHAR2(127) NOT NULL | Output Destination |
| GENPRCSTYPE | 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 | 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 | VARCHAR2(3) NOT NULL | Job Shell ID |
| AS4JOBDESCNAME | VARCHAR2(10) NOT NULL | AS400 Job Description |
| AS4JOBDESCLIB | VARCHAR2(10) NOT NULL | AS400 Job Description Lib |
| PRCSTYPEDESCR | VARCHAR2(30) NOT NULL | Process Type Description |
| RESTARTENABLED | VARCHAR2(1) NOT NULL | Restart Enabled? |
| LASTUPDDTTM | DATE | 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 | 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 | SMALLINT NOT NULL | Retention Days |