PSPRCSRQST

Return to Index

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

  • Parent record of PSPRCSRQSTXFER
  • PeopleSoft Field NameField TypeDescription
    PRCSINSTANCEDECIMAL(10) NOT NULLProcess Instance
    JOBINSTANCEDECIMAL(10) NOT NULLJob Instance
    MAINJOBINSTANCEDECIMAL(10) NOT NULLMain Job Instance
    PRCSJOBSEQINTEGER NOT NULLProcess Job Item
    PRCSJOBNAMEVARCHAR2(8) NOT NULLProcess Job Name

    Prompt Table: PRCSJOBDEFN

    PRCSTYPEVARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PRCSTYPE_VW

    PRCSNAMEVARCHAR2(12) NOT NULLProcess Name

    Prompt Table: PRCSDEFN

    PRCSITEMLEVELSMALLINT NOT NULLProcess Item Level
    MAINJOBNAMEVARCHAR2(30) NOT NULLMain Job Name
    MAINJOBSEQDECIMAL(10) NOT NULLMain Job Sequence
    RUNLOCATIONVARCHAR2(1) NOT NULLRun Location
    0=Both
    1=Client
    2=Server
    OPSYSVARCHAR2(1) NOT NULLOperating 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
    DBTYPEVARCHAR2(1) NOT NULLDatabase Type
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase
    6=Sybase
    7=Microsoft
    8=DB2/400
    DBNAMEVARCHAR2(8) NOT NULLDatabase Name
    SERVERNAMERQSTVARCHAR2(8) NOT NULLServer Name Request

    Prompt Table: SERVERDEFN

    SERVERNAMERUNVARCHAR2(8) NOT NULLServer Name - Runtime
    RUNDTTMDATERun Date/Time
    RECURNAMEVARCHAR2(30) NOT NULLRecurrence Name

    Prompt Table: PRCSRECUR

    OPRIDVARCHAR2(30) NOT NULLA user's ID
    PRCSVERSIONINTEGER NOT NULLProcess Version
    RUNSTATUSVARCHAR2(2) NOT NULLProcess 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
    RQSTDTTMDATERequest Date/Time
    LASTUPDDTTMDATESpecifies 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.
    BEGINDTTMDATEBegin Date/Time
    ENDDTTMDATEEnd Date/Time
    RUNCNTLIDVARCHAR2(30) NOT NULLRun Control ID
    PRCSRTNCDINTEGER NOT NULLProcess Return Code
    CONTINUEJOBSMALLINT NOT NULLContinue Job
    USERNOTIFIEDSMALLINT NOT NULLUser Notified
    INITIATEDNEXTSMALLINT NOT NULLInitiated Next Process
    OUTDESTTYPEVARCHAR2(3) NOT NULLProcess Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    OUTDESTFORMATVARCHAR2(3) NOT NULLProcess 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
    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)
    ORIGPRCSINSTANCEDECIMAL(10) NOT NULLOriginal Process Instance
    GENPRCSTYPEVARCHAR2(2) NOT NULLGeneric 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
    RESTARTENABLEDVARCHAR2(1) NOT NULLRestart Enabled?
    TIMEZONEVARCHAR2(9) NOT NULLTime Zone
    PSRF_FOLDER_NAMEVARCHAR2(18) NOT NULLReporting Folder's Name
    SCHEDULENAMEVARCHAR2(30) NOT NULLSchedule Name
    RETRYCOUNTDECIMAL(10) NOT NULLPub/Sub Retry Count
    RECURORIGPRCSINSTDECIMAL(10) NOT NULLRecurrence Original Instance
    P_PRCSINSTANCEDECIMAL(10) NOT NULLProcess Instance
    DISTSTATUSVARCHAR2(2) NOT NULLDistribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    PRCSCATEGORYVARCHAR2(30) NOT NULLProcess Category
    PRCSCURREXPIREDTTMDATECurrent Expiration Datetime
    RUNSERVEROPTIONVARCHAR2(1) NOT NULLRun Server Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server
    PT_RETENTIONDAYSSMALLINT NOT NULLRetention Days
    CONTENTIDDECIMAL(15) NOT NULLReport ID
    PTNONUNPRCSIDVARCHAR2(100) NOT NULLDistinct Prcs Id

    Author: PeopleTools 8.52

    Return to Index

    © David Kurtz  Last updated 01 August 2015