| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 PRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Type
Prompt Table:
PRCSTYPE_ALT_VW
|
| PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 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
|
| PARMLISTTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parameter List Type
0=None
1=Override
2=Prepend
3=Append
Default: 0
|
| CMDLINE |
Character(127) |
VARCHAR2(127) NOT NULL |
Command Line
|
| CMDLINETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Command Line Type
0=None
1=Override
2=Prepend
3=Append
Default: 0
|
| WORKINGDIR |
Character(127) |
VARCHAR2(127) NOT NULL |
Working Directory
|
| WORKINGDIRTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Working Directory Type
0=None
1=Override
2=Prepend
3=Append
Default: 0
|
| OUTDESTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
Default: 0
|
| OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| OUTDESTSRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Request output destination source
0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
Default: 3
Prompt Table:
OUTDESTSRC
|
| SQRRTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
SQR Runtime
0=No
1=Yes
Default: 0
|
| LOGRQST |
Character(1) |
VARCHAR2(1) NOT NULL |
Log client request
0=No
1=Yes
Default: 1
|
| APIAWARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Scheduler API Aware
0=No
1=Yes
Default: 1
|
| PRCSPRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Priority
1=Low
5=Medium
9=High
Default: 5
|
| RUNLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location
0=Both
1=Client
2=Server
Default: 2
|
| SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| MVSSHELLID |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Shell ID
|
| MSGLOGTBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Message Log Table
Prompt Table:
PSRECDEFN
|
| RQSTTBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Run Control Request Table
Prompt Table:
PSRECDEFN
|
| RECURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Recurrence Name
Prompt Table:
PRCSRECUR
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 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.
|
| DESCRLONG |
Long Character |
CLOB |
Long Description
|
| RECVRYPRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Recovery Process Type
Prompt Table:
PRCSTYPE_ALT_VW
|
| RECVRYPRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Recovery Process Name
Prompt Table:
PRCSDEFN_VW3
Set Control Field: RECVRYPRCSTYPE
|
| RETENTIONDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Retention Days
|
| PT_RETENTIONDAYS |
Number(4,0) |
SMALLINT NOT NULL |
Retention Days
|
| OUTDESTFORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output format
0=Any
1=(None)
10=Postscript (*.lis)
11=Crystal Report (*.rpt)
12=Rich Text File (*.rtf)
13=SQR Portable Format (*.spf)
14=Text Files (*.txt)
15=Other
16=Default
17=XML Format(*.xml)
18=Data Mover Data File (*.dat)
19=Crystal Report Explorer(*.rpt)
2=Acrobat (*.pdf)
20=XMLP
21=Atom
22=Transformation
23=Printer Command Lang. (*.pcl)
24=PostScript (*.ps)
3=Comma delimited (*.csv)
4=HP Format (*.lis)
5=HTML Documents (*.htm)
6=Line Printer Format (*.lis)
7=Lotus 1-2-3 Files (*.wks)
8=Microsoft Excel Files (*.xls)
9=Microsoft Word (*.doc)
|
| PSRF_FOLDER_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Reporting Folder's Name
Prompt Table:
PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME
|
| RESTARTENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart Enabled?
Default: 0
|
| RETRYCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pub/Sub Retry Count
Default: 0
|
| TIMEOUTMINUTES |
Number(5,0) |
INTEGER NOT NULL |
Time out minutes
Default: 0
|
| MAXCONCURRENT |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Concurrent Processes
Default: 0
|
| PRCSCATEGORY |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Category
Prompt Table:
PRCS_CAT_TBL
|
| FILEDEPEND |
Character(1) |
VARCHAR2(1) NOT NULL |
File Dependency
Default: 0
|
| PRCSFILENAME |
Character(254) |
VARCHAR2(254) NOT NULL |
FileName
|
| TIMEOUTMAXMINS |
Number(5,0) |
INTEGER NOT NULL |
Time Out Max Minutes
Default: 0
|
| PRCSSHOWURL |
Number(1,0) |
SMALLINT NOT NULL |
Show URL for current component
|
| PT_PRCS_EN_GEN_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Generic RunControl Page
Y/N Table Edit
Default: N
|
| PT_PRCS_RUNCNTLSEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Access By User With
0=Process Group Security
1=Full Process Security
Default: 0
|
| PRCSREADONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for MRO process
0=No
1=Yes
Default: 0
|
| TIMESTENMODE |
Character(1) |
VARCHAR2(1) NOT NULL |
TimesTen Mode
0=No
1=Yes
2=Exclusive
Default: 0
|
| PTSCHDL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Partition Schedule
Prompt Table:
PTPRTNSCHDL
|
| EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| PTPRCSIBMSGSLOGLEV |
Character(1) |
VARCHAR2(1) NOT NULL |
Integration Log Level
E=Error
I=Informational
N=None
Default: I
|