PRCSRUNCNTLOUT

(SQL Table)
 Index Back

Output information run control

This record stores output information for non unique processes at a run control level

# 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 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
5 PTNONUNPRCSID Character(100) VARCHAR2(100) NOT NULL Distinct Prcs Id
6 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
7 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)
8 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
9 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
10 QRYXFORMNAME Character(30) VARCHAR2(30) NOT NULL Transformation Name
11 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
12 CDM_APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required

Default Value: N