PY_XRPTDEFN_VW(SQL View) |
Index Back |
|---|---|
PNA Fusion Pub Rpt DefnPNA Fusion Published Report Definition |
| SELECT REPORT_DEFN_ID , DESCR , PT_REPORT_STATUS , DS_TYPE , DS_ID , PT_TEMPLATE_TYPE , OUTDESTTYPE FROM PSXPRPTDEFN WHERE PT_REPORT_STATUS = 'A' AND DS_TYPE = 'XML' AND PT_TEMPLATE_TYPE = 'RTF' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REPORT_DEFN_ID |
Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | REPORT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Report Status
A=Active I=Inactive P=In Progress |
| 4 | 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 |
| 5 | DS_ID | Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| 6 | PT_TEMPLATE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
ETX=eText PDF=PDF RTF=RTF XLS=Excel XSL=XSL |
| 7 | OUTDESTTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node |