PSXPTRNSRCH_VW2 |
index back |
|---|
| SELECT C.TMPLDEFN_ID , D.EFFDT , '' , '' , '' , '' , '' , C.REPORT_CATEGORY_ID , C.DESCR , C.TMPLLANGCD , C.DIST_CHANNEL , C.PT_TEMPLATE_TYPE , E.USERFILENAME , D.TMPLFILE_STATUS , C.IS_SUBTEMPLATE FROM PSXPTMPLDEFN C , PSXPTMPLFILEDEF D , PSFILEDEFN E WHERE C.TMPLDEFN_ID = D.TMPLDEFN_ID AND D.TEMPLATE_FILEID = E.FILEID AND C.IS_SUBTEMPLATE = 'Y' AND C.PT_TEMPLATE_TYPE <> 'PDF' AND D.TMPLFILE_STATUS IN ('A', 'P') |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| EFFDT | Date(10) | DATE | Effective Date |
| DS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Data Source Type
CPQ=Composite Query CQR=Connected Query QRY=Query RST=Rowset XMD=XMLDoc Object XML=XML File |
| DS_ID | Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| REPORT_CATEGORY_ID | Character(18) | VARCHAR2(18) NOT NULL | Report Category ID |
| DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code translate values |
| DIST_CHANNEL | Character(3) | VARCHAR2(3) NOT NULL |
Channel
0=Web Posting 1=EFT 2=Printer 3=Email 4=Fax 5=SMS |
| PSXPTRTMPLTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
ETX=eText RTF=RTF XSL=XSL |
| TEMPLATEFILE | Character(64) | VARCHAR2(64) NOT NULL | Template File |
| TMPLFILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Template file effective status
A=Active I=Inactive P=In Progress |
| IS_SUBTEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Subtemplate?
N=Report Template Y=Sub-Template |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |