PSXPTRNSRCH_VW |
| Platform | View Text |
|---|---|
| Default | 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 Name | Description |
|---|---|
| TMPLDEFN_ID | Template ID |
| EFFDT | Effective Date |
| DS_TYPE | Data Source Type QRY=PS Query RST=Rowset XMD=XMLDoc Object XML=XML File |
| DS_ID | Data Source ID |
| OPRID | A user's ID |
| REPORT_DEFN_ID | Report Name |
| DESCR2 | Descr2 |
| REPORT_CATEGORY_ID | Report Category ID |
| DESCR1 | Descr |
| LANGUAGE_CD | Language Code translate values |
| DIST_CHANNEL | Channel 0=Web Posting 1=EFT 2=Printer 3=Email 4=Fax 5=SMS |
| PSXPTRTMPLTYPE | Template Type ETX=eText RTF=RTF XSL=XSL |
| TEMPLATEFILE | Template File |
| TMPLFILE_STATUS | Template file effective status A=Active I=Inactive P=In Progress |
| IS_SUBTEMPLATE | Subtemplate? N=Report Template Y=Sub-Template |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |