PSPRCSRQST

(SQL Table)
 Index Back

Process Request

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

  • Parent Record Of PSPRCSRQSTXFER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
    3 MAINJOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Main Job Instance
    4 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item
    5 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

    Prompt Table: PRCSJOBDEFN

    6 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: PRCSTYPE_VW

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

    Prompt Table: PRCSDEFN

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

    Prompt Table: SERVERDEFN

    16 SERVERNAMERUN Character(8) VARCHAR2(8) NOT NULL Server Name - Runtime
    17 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    18 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

    Prompt Table: PRCSRECUR

    19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    20 PRCSVERSION Number(5,0) INTEGER NOT NULL Process Version
    21 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
    22 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    23 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.
    24 BEGINDTTM DateTime(26) TIMESTAMP Begin Date/Time
    25 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    26 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    27 PRCSRTNCD Number(5,0) INTEGER NOT NULL Process Return Code
    28 CONTINUEJOB Number(1,0) SMALLINT NOT NULL Continue Job
    29 USERNOTIFIED Number(1,0) SMALLINT NOT NULL User Notified
    30 INITIATEDNEXT Number(1,0) SMALLINT NOT NULL Initiated Next Process
    31 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
    32 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)
    33 ORIGPRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Original Process Instance
    34 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
    35 RESTARTENABLED Character(1) VARCHAR2(1) NOT NULL Restart Enabled?
    36 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    37 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    38 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name
    39 RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
    40 RECURORIGPRCSINST Number(10,0) DECIMAL(10) NOT NULL Recurrence Original Instance
    41 P_PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    42 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
    43 PRCSCATEGORY Character(30) VARCHAR2(30) NOT NULL Process Category
    44 PRCSCURREXPIREDTTM DateTime(26) TIMESTAMP Current Expiration Datetime
    45 RUNSERVEROPTION Character(1) VARCHAR2(1) NOT NULL Run Server Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server
    46 PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
    47 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
    48 PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id