PSXPTRNSRCH_VW(SQL View) |
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 Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 2 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | 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 |
| 4 | DS_ID | Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 7 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 8 | REPORT_CATEGORY_ID | Character(18) | VARCHAR2(18) NOT NULL | Report Category ID |
| 9 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 10 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | DIST_CHANNEL | Character(3) | VARCHAR2(3) NOT NULL |
Channel
0=Web Posting 1=EFT 2=Printer 3=Email 4=Fax 5=SMS |
| 12 | PSXPTRTMPLTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
ETX=eText RTF=RTF XSL=XSL |
| 13 | TEMPLATEFILE | Character(64) | VARCHAR2(64) NOT NULL | Template File |
| 14 | TMPLFILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Template file effective status
A=Active I=Inactive P=In Progress |
| 15 | IS_SUBTEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Subtemplate?
N=Report Template Y=Sub-Template |