PSPRCSRQST

Return to Index

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

  • Parent record of PSPRCSRQSTXFER

    • PeopleSoft Field NameDescription
    PRCSINSTANCEProcess Instance
    JOBINSTANCEJob Instance
    MAINJOBINSTANCEMain Job Instance
    PRCSJOBSEQProcess Job Item
    PRCSJOBNAMEProcess Job Name

    Prompt Table: PRCSJOBDEFN

    PRCSTYPEProcess Type

    Prompt Table: PRCSTYPE_VW

    PRCSNAMEProcess Name

    Prompt Table: PRCSDEFN

    PRCSITEMLEVELProcess Item Level
    MAINJOBNAMEMain Job Name
    MAINJOBSEQMain Job Sequence
    RUNLOCATIONRun Location
    0=Both (inactive)
    1=Client (inactive)
    2=Server
    OPSYSOperating System
    0=DOS (inactive)
    1=NT/Win95 Client (inactive)
    2=NT/Win2000
    3=OS/2 (inactive)
    4=UNIX
    5=VMS (inactive)
    6=MPE/XL (inactive)
    7=OS390
    8=NT
    9=OS/400 (inactive)
    DBTYPEDatabase Type
    0=SQLBase (inactive)
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase (inactive)
    6=Sybase
    7=Microsoft
    8=DB2/400 (inactive)
    DBNAMEDatabase Name
    SERVERNAMERQSTServer Name Request

    Prompt Table: SERVERDEFN

    SERVERNAMERUNServer Name - Runtime
    RUNDTTMRun Date/Time
    RECURNAMERecurrence Name

    Prompt Table: PRCSRECUR

    OPRIDA user's ID
    PRCSVERSIONProcess Version
    RUNSTATUSProcess Scheduler Process Run Status
    1=Cancel
    2=Delete
    3=Error
    4=Hold
    5=Queued
    6=Initiated
    7=Processing
    8=Cancelled
    9=Success
    10=Not Successful
    11=Posted (inactive)
    12=Unable to post (inactive)
    13=Resend (inactive)
    14=Posting (inactive)
    15=Content Generated (inactive)
    16=Pending
    17=Success With Warning
    18=Blocked
    19=Restart

    Certain status relating to posting content to the Report Repository were made inactive at PeopleTools 8.4 when a new column (DISTSTATUS) was introduced.

    RQSTDTTMRequest Date/Time
    LASTUPDDTTMSpecifies 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.
    BEGINDTTMDate/Time at which the process began.
    ENDDTTMDate/Time at which the process ended.  However, this may be updated again by the Distribution Server (see Life Cycle of a Process Request).
    RUNCNTLIDRun Control ID
    PRCSRTNCDProcess Return Code
    CONTINUEJOBContinue Job
    USERNOTIFIEDUser Notified
    INITIATEDNEXTInitiated Next Process
    OUTDESTTYPEProcess Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    OUTDESTFORMATProcess 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)
    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)
    ORIGPRCSINSTANCEOriginal Process Instance
    GENPRCSTYPEGeneric 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 (inactive)
    RESTARTENABLEDRestart Enabled?
    TIMEZONETime Zone
    PSRF_FOLDER_NAMEReporting Folder's Name
    SCHEDULENAMESchedule Name
    RETRYCOUNTPub/Sub Retry Count
    RECURORIGPRCSINSTRecurrence Original Instance
    P_PRCSINSTANCEProcess Instance
    DISTSTATUSDistribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    PRCSCATEGORYProcess Category
    PRCSCURREXPIREDTTMCurrent Expiration Datetime
    RUNSERVEROPTIONRun Server Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server

    Author: David Kurtz

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 25 July 2010