PSPRCSQUE

index back

Process Request Queue

This record contains the process request information to run a process request.

PeopleSoft Field Name Field Type Column Type Description
PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

Prompt Table: PRCSJOBDEFN

MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PRCSTYPE_VW

PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PRCSDEFN

MAINJOBNAME Character(30) VARCHAR2(30) NOT NULL Main Job Name
MAINJOBSEQ Number(10,0) DECIMAL(10) NOT NULL Main Job Sequence
PRCSITEMLEVEL Number(4,0) SMALLINT NOT NULL Process Item Level
RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
0=Both
1=Client
2=Server
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
SERVERNAMERQST Character(8) VARCHAR2(8) NOT NULL Server Name Request

Prompt Table: SERVERDEFN

SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
SERVERASSIGN Character(8) VARCHAR2(8) NOT NULL Assigned Remote Server
RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

Prompt Table: PRCSRECUR

OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PRCSPRTY Number(5,0) INTEGER NOT NULL Process Priority
SESSIONIDNUM Number(10,0) DECIMAL(10) NOT NULL Session ID Number
RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success
RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
RECURDTTM DateTime(26) TIMESTAMP Recur Date/Time
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.
RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PRCSRTNCD Number(5,0) INTEGER NOT NULL Process Return Code
CONTINUEJOB Number(1,0) SMALLINT NOT NULL Continue Job
USERNOTIFIED Number(1,0) SMALLINT NOT NULL User Notified
INITIATEDNEXT Number(1,0) SMALLINT NOT NULL Initiated Next Process
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
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)
ORIGPRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Original Process Instance
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
RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
EMAIL_WEB_RPT Character(1) VARCHAR2(1) NOT NULL Email Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
PRCSWINPOP Character(1) VARCHAR2(1) NOT NULL Window Popup
MCFREN_URL_ID Character(15) VARCHAR2(15) NOT NULL REN Server Cluster ID
RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
RECURORIGPRCSINST Number(10,0) DECIMAL(10) NOT NULL Recurrence Original Instance
P_PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PRCSCATEGORY Character(30) VARCHAR2(30) NOT NULL Process Category
PRCSCURREXPIREDTTM DateTime(26) TIMESTAMP Current Expiration Datetime
DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval

Default: 1

PRCSSTARTDTTM DateTime(26) TIMESTAMP Current Expiration Datetime
RUNSERVEROPTION Character(1) VARCHAR2(1) NOT NULL Run Server Option
1=Any Server
2=Specific Server
3=Specific OS
4=Primary Server
TUXSVCID Number(3,0) SMALLINT NOT NULL This represents the tuxedo service ID used in Optimization framework.
PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
PRCSRUNNOTIFY Character(1) VARCHAR2(1) NOT NULL Status Notification
PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id
QRYXFORMNAME Character(30) VARCHAR2(30) NOT NULL Transformation Name
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
CDM_APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required

Default: N

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19