PSXPTRNSRCH_VW

index back

SELECT B.TMPLDEFN_ID , D.EFFDT , A.DS_TYPE , A.DS_ID , A.OPRID , A.REPORT_DEFN_ID , A.DESCR , A.REPORT_CATEGORY_ID , C.DESCR , C.TMPLLANGCD , C.DIST_CHANNEL , C.PT_TEMPLATE_TYPE , E.USERFILENAME , D.TMPLFILE_STATUS , C.IS_SUBTEMPLATE FROM PSXPRPTSRCH_VW A , PSXPRPTTMPL B , PSXPTMPLDEFN C , PSXPTMPLFILEDEF D , PSFILEDEFN E WHERE A.REPORT_DEFN_ID = B.REPORT_DEFN_ID AND B.TMPLDEFN_ID = C.TMPLDEFN_ID AND C.TMPLDEFN_ID = D.TMPLDEFN_ID AND D.TEMPLATE_FILEID = E.FILEID AND C.PT_TEMPLATE_TYPE <> 'PDF' AND C.IS_SUBTEMPLATE = 'N' AND A.PT_REPORT_STATUS IN ('A', 'P') AND D.TMPLFILE_STATUS IN ('A', 'P')

PeopleSoft Field NameField TypeColumn TypeDescription
TMPLDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLTemplate ID (see PSXPTMPLDEFN).
EFFDTDate(10)DATEEffective Date
DS_TYPECharacter(3)VARCHAR2(3) NOT NULLData Source Type
CQR=Connected Query
QRY=Query
RST=Rowset
XMD=XMLDoc Object
XML=XML File
DS_IDCharacter(30)VARCHAR2(30) NOT NULLData Source ID
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
REPORT_DEFN_IDCharacter(12)VARCHAR2(12) NOT NULLReport Name (see PSXPRPTDEFN).
DESCR2Character(30)VARCHAR2(30) NOT NULLDescr2
REPORT_CATEGORY_IDCharacter(18)VARCHAR2(18) NOT NULLReport Category ID
DESCR1Character(30)VARCHAR2(30) NOT NULLDescr
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
DIST_CHANNELCharacter(3)VARCHAR2(3) NOT NULLChannel
0=Web Posting
1=EFT
2=Printer
3=Email
4=Fax
5=SMS
PSXPTRTMPLTYPECharacter(3)VARCHAR2(3) NOT NULLTemplate Type
ETX=eText
RTF=RTF
XSL=XSL
TEMPLATEFILECharacter(64)VARCHAR2(64) NOT NULLTemplate File
TMPLFILE_STATUSCharacter(1)VARCHAR2(1) NOT NULLTemplate file effective status
A=Active
I=Inactive
P=In Progress
IS_SUBTEMPLATECharacter(1)VARCHAR2(1) NOT NULLSubtemplate?
N=Report Template
Y=Sub-Template
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19