PRCSRUNCNTL_VW

(SQL View)
 Index Back

Process Run Control

Process Run Control view

SELECT OPRID ,RUNCNTLID ,VERSION ,SERVERNAME ,OUTDESTTYPE ,OUTDESTFORMAT ,SRVRDESTFILE ,SRVRDESTPRINTER ,CLNTDESTFILE ,CLNTDESTPRINTER ,RUNLOCATION ,LASTUPDDTTM ,LASTUPDOPRID FROM PSPRCSRUNCNTL

  • Parent record: PSOPRDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
    5 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
    6 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)
    7 SRVRDESTFILE Character(127) VARCHAR2(127) NOT NULL Server File Destination
    8 SRVRDESTPRINTER Character(127) VARCHAR2(127) NOT NULL Server Destination Printer
    9 CLNTDESTFILE Character(127) VARCHAR2(127) NOT NULL Client Destination File
    10 CLNTDESTPRINTER Character(127) VARCHAR2(127) NOT NULL Client Destination Printer
    11 RUNLOCATION Character(1) VARCHAR2(1) NOT NULL Run Location
    0=Both
    1=Client
    2=Server
    12 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.
    13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.