XPOUTDESTFORMAT

index back

Request Dialog - Output Type

This view is used by the Process Scheduler Request Dialog to filter Output Types.
SELECT O.REPORT_DEFN_ID , %Substring(X.FIELDVALUE, 1, 3) , O.PT_FORMAT_TYPE , O.IS_DEFAULT FROM PSXPRPTOUTFMT O , PSXLATITEM X WHERE X.XLATSHORTNAME = O.PT_FORMAT_TYPE AND X.FIELDNAME = 'OUTDESTFORMAT'

PeopleSoft Field NameField TypeColumn TypeDescription
REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).

Prompt Table: XPQRYRPTDEFN_VW

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)
OUTDESTFORMATDESCRCharacter(10)VARCHAR2(10) NOT NULLProcess Scheduler Destination Format
IS_DEFAULTCharacter(1)VARCHAR2(1) NOT NULLDefault Template
N=No
Y=Yes
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19