PSPRCSRQST

index back

Process Request

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

  • Parent record of PSPRCSRQSTXFER
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    JOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLJob Instance
    MAINJOBINSTANCENumber(10,0)DECIMAL(10) NOT NULLMain Job Instance
    PRCSJOBSEQNumber(5,0)INTEGER NOT NULLProcess Job Item
    PRCSJOBNAMECharacter(8)VARCHAR2(8) NOT NULLProcess Job Name

    Prompt Table: PRCSJOBDEFN

    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type

    Prompt Table: PRCSTYPE_VW

    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name

    Prompt Table: PRCSDEFN

    PRCSITEMLEVELNumber(4,0)SMALLINT NOT NULLProcess Item Level
    MAINJOBNAMECharacter(30)VARCHAR2(30) NOT NULLMain Job Name
    MAINJOBSEQNumber(10,0)DECIMAL(10) NOT NULLMain Job Sequence
    RUNLOCATIONCharacter(1)VARCHAR2(1) NOT NULLRun Location
    0=Both
    1=Client
    2=Server
    OPSYSCharacter(1)VARCHAR2(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
    DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
    0=SQLBase
    1=DB2
    2=Oracle
    3=Informix
    4=DB2/UNIX
    5=AllBase
    6=Sybase
    7=Microsoft
    8=DB2/400
    DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
    SERVERNAMERQSTCharacter(8)VARCHAR2(8) NOT NULLServer Name Request

    Prompt Table: SERVERDEFN

    SERVERNAMERUNCharacter(8)VARCHAR2(8) NOT NULLServer Name - Runtime
    RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
    RECURNAMECharacter(30)VARCHAR2(30) NOT NULLRecurrence Name

    Prompt Table: PRCSRECUR

    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    PRCSVERSIONNumber(5,0)INTEGER NOT NULLProcess Version
    RUNSTATUSCharacter(2)VARCHAR2(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
    RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    BEGINDTTMDateTime(26)TIMESTAMPBegin Date/Time
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    RUNCNTLIDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    PRCSRTNCDNumber(5,0)INTEGER NOT NULLProcess Return Code
    CONTINUEJOBNumber(1,0)SMALLINT NOT NULLContinue Job
    USERNOTIFIEDNumber(1,0)SMALLINT NOT NULLUser Notified
    INITIATEDNEXTNumber(1,0)SMALLINT NOT NULLInitiated Next Process
    OUTDESTTYPECharacter(3)VARCHAR2(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
    9=IB Node
    OUTDESTFORMATCharacter(3)VARCHAR2(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
    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)
    ORIGPRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLOriginal Process Instance
    GENPRCSTYPECharacter(2)VARCHAR2(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
    RESTARTENABLEDCharacter(1)VARCHAR2(1) NOT NULLRestart Enabled?
    TIMEZONECharacter(9)VARCHAR2(9) NOT NULLTime Zone
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
    SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
    RETRYCOUNTNumber(10,0)DECIMAL(10) NOT NULLPub/Sub Retry Count
    RECURORIGPRCSINSTNumber(10,0)DECIMAL(10) NOT NULLRecurrence Original Instance
    P_PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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
    PRCSCATEGORYCharacter(30)VARCHAR2(30) NOT NULLProcess Category
    PRCSCURREXPIREDTTMDateTime(26)TIMESTAMPCurrent Expiration Datetime
    RUNSERVEROPTIONCharacter(1)VARCHAR2(1) NOT NULLRun Server Option
    1=Any Server
    2=Specific Server
    3=Specific OS
    4=Primary Server
    PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
    CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
    PTNONUNPRCSIDCharacter(100)VARCHAR2(100) NOT NULLDistinct Prcs Id
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19