| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Type
Prompt Table:
PRCSTYPE_ALT_VW
|
| 2 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 3 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
Default Value: 0
|
| 4 |
PARMLIST |
Character(254) |
VARCHAR2(254) NOT NULL |
Parameter List
|
| 5 |
PARMLISTTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parameter List Type
0=None
1=Override
2=Prepend
3=Append
Default Value: 0
|
| 6 |
CMDLINE |
Character(127) |
VARCHAR2(127) NOT NULL |
Command Line
|
| 7 |
CMDLINETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Command Line Type
0=None
1=Override
2=Prepend
3=Append
Default Value: 0
|
| 8 |
WORKINGDIR |
Character(127) |
VARCHAR2(127) NOT NULL |
Working Directory
|
| 9 |
WORKINGDIRTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Working Directory Type
0=None
1=Override
2=Prepend
3=Append
Default Value: 0
|
| 10 |
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 Value: 0
|
| 11 |
OUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Process Scheduler Output Destination
|
| 12 |
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 Value: 3
Prompt Table:
OUTDESTSRC
|
| 13 |
SQRRTFLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
SQR Runtime
0=No
1=Yes
Default Value: 0
|
| 14 |
LOGRQST |
Character(1) |
VARCHAR2(1) NOT NULL |
Log client request
0=No
1=Yes
Default Value: 1
|
| 15 |
APIAWARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Scheduler API Aware
0=No
1=Yes
Default Value: 1
|
| 16 |
PRCSPRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Priority
1=Low
5=Medium
9=High
Default Value: 5
|
| 17 |
RUNLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location
0=Both
1=Client
2=Server
Default Value: 2
|
| 18 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 19 |
MVSSHELLID |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Shell ID
|
| 20 |
MSGLOGTBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Message Log Table
Prompt Table:
PSRECDEFN
|
| 21 |
RQSTTBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Run Control Request Table
Prompt Table:
PSRECDEFN
|
| 22 |
RECURNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Recurrence Name
Prompt Table:
PRCSRECUR
|
| 23 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 24 |
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.
|
| 25 |
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.
|
| 26 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 27 |
RECVRYPRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Recovery Process Type
Prompt Table:
PRCSTYPE_ALT_VW
|
| 28 |
RECVRYPRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Recovery Process Name
Prompt Table:
PRCSDEFN_VW3
Set Control Field: RECVRYPRCSTYPE
|
| 29 |
RETENTIONDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Retention Days
|
| 30 |
PT_RETENTIONDAYS |
Number(4,0) |
SMALLINT NOT NULL |
Retention Days
|
| 31 |
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)
|
| 32 |
PSRF_FOLDER_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Reporting Folder's Name
Prompt Table:
PRCSDEFNFLDR_VW
Set Control Field: PSRF_FOLDER_NAME
|
| 33 |
RESTARTENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Restart Enabled?
Default Value: 0
|
| 34 |
RETRYCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pub/Sub Retry Count
Default Value: 0
|
| 35 |
TIMEOUTMINUTES |
Number(5,0) |
INTEGER NOT NULL |
Time out minutes
Default Value: 0
|
| 36 |
MAXCONCURRENT |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Concurrent Processes
Default Value: 0
|
| 37 |
PRCSCATEGORY |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Category
Prompt Table:
PRCS_CAT_TBL
|
| 38 |
FILEDEPEND |
Character(1) |
VARCHAR2(1) NOT NULL |
File Dependency
Default Value: 0
|
| 39 |
PRCSFILENAME |
Character(254) |
VARCHAR2(254) NOT NULL |
FileName
|
| 40 |
TIMEOUTMAXMINS |
Number(5,0) |
INTEGER NOT NULL |
Time Out Max Minutes
Default Value: 0
|
| 41 |
PRCSSHOWURL |
Number(1,0) |
SMALLINT NOT NULL |
Show URL for current component
|
| 42 |
PT_PRCS_EN_GEN_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Generic RunControl Page
Y/N Table Edit
Default Value: N
|
| 43 |
PT_PRCS_RUNCNTLSEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Access By User With
0=Process Group Security
1=Full Process Security
Default Value: 0
|
| 44 |
PRCSREADONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for MRO process
0=No
1=Yes
Default Value: 0
|
| 45 |
TIMESTENMODE |
Character(1) |
VARCHAR2(1) NOT NULL |
TimesTen Mode
0=No
1=Yes
2=Exclusive
Default Value: 0
|
| 46 |
PTSCHDL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Partition Schedule
Prompt Table:
PTPRTNSCHDL
|
| 47 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 48 |
PTPRCSIBMSGSLOGLEV |
Character(1) |
VARCHAR2(1) NOT NULL |
Integration Log Level
E=Error
I=Informational
N=None
Default Value: I
|