PSXPRTMPSRCH_VW

Return to Index

PlatformView Text
DefaultSELECT R.REPORT_DEFN_ID , A.TMPLDEFN_ID , A.DESCR , A.TMPLLANGCD , A.PT_TEMPLATE_TYPE , A.DIST_CHANNEL , A.REPORT_CATEGORY_ID FROM PSXPTMPLDEFN A , PSXPRPTTMPL R WHERE R.TMPLDEFN_ID = A.TMPLDEFN_ID

PeopleSoft Field NameDescription
REPORT_DEFN_IDReport Name
TMPLDEFN_IDTemplate ID
DESCRDescription
LANGUAGE_CDLanguage Code translate values
PT_TEMPLATE_TYPETemplate Type
ETX=eText
PDF=PDF
RTF=RTF
XSL=XSL
DIST_CHANNELChannel
0=Web Posting
1=EFT
2=Printer
3=Email
4=Fax
5=SMS
REPORT_CATEGORY_IDReport Category ID

Prompt Table: PSXPRPTCAT_DVW

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010