REPORT_DEFN_IDQRY=PS Query (default)
RST=Rowset
XMD=XMLDoc Object
XML=XML File
R=Private
U=Public
ETX=eText
PDF=PDF
RTF=RTF
XSL=XSL
Prompt Table: PSXPRPTCAT
A=Active
I=Inactive
P=In Progress
PSXPRPTSRCH_VW |
| Platform | View Text |
|---|---|
| Default | SELECT A.REPORT_DEFN_ID , A.DESCR , A.DS_TYPE , A.DS_ID , A.OPRID , 'U' , A.PT_TEMPLATE_TYPE , A.REPORT_CATEGORY_ID , A.OBJECTOWNERID , A.PT_REPORT_STATUS , A.BURST_FIELDNAME FROM PSXPRPTDEFN A , PSXPDATASRC B WHERE A.DS_TYPE = B.DS_TYPE AND A.DS_ID = B.DS_ID AND A.OPRID = B.OPRID AND B.ACTIVE_FLAG = 'A' |
| PeopleSoft Field Name | Description |
|---|---|
| REPORT_DEFN_ID | Report Name |
| DESCR | Description |
| DS_TYPE | Data Source Type QRY=PS Query (default) RST=Rowset XMD=XMLDoc Object XML=XML File |
| DS_ID | Data Source ID |
| OPRID | A user's ID |
| PSXPDSOWNER | Data Source Owner R=Private U=Public |
| PT_TEMPLATE_TYPE | Template Type ETX=eText PDF=PDF RTF=RTF XSL=XSL |
| REPORT_CATEGORY_ID | Report Category ID Prompt Table: PSXPRPTCAT |
| OBJECTOWNERID | Object owner identifier translate values |
| PT_REPORT_STATUS | Report Status A=Active I=Inactive P=In Progress |
| BURST_FIELDNAME | Burst Field Name |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |