REPORT_DEFN_IDETX=eText
PDF=PDF
RTF=RTF
XLS=Excel
XSL=XSL
Default Value: RTF
Prompt Table: PSXPTMPLTYPE
Prompt Table: PSXPFLDLIST_VW
XPQRYRPTDEF_VW2(SQL View) |
Index Back |
|---|
| SELECT REPORT_DEFN_ID , DESCR , DS_ID , OPRID , PT_TEMPLATE_TYPE , BURST_FIELDNAME , TMPLCTRL_FIELDNAME , SECURITY_FIELDNAME FROM PSXPRPTDEFN WHERE DS_TYPE IN ('QRY', 'CQR', 'CPQ') AND PT_REPORT_STATUS = 'A' |
| # | 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 | DS_ID | Character(30) | VARCHAR2(30) NOT NULL | Data Source ID |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | PT_TEMPLATE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
ETX=eText PDF=PDF RTF=RTF XLS=Excel XSL=XSL Default Value: RTF Prompt Table: PSXPTMPLTYPE |
| 6 | BURST_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL |
Burst Field Name
Prompt Table: PSXPFLDLIST_VW |
| 7 | TMPLCTRL_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL | Template Control Field Name |
| 8 | SECURITY_FIELDNAME | Character(30) | VARCHAR2(30) NOT NULL | Security Field Name |