XML_XMLP_VW(SQL View) |
Index Back |
|---|---|
View to fetch XMLP objectsView to fetch XMLP objects. |
| SELECT REPORT_DEFN_ID , DESCR FROM PSXPRPTDEFN WHERE DS_TYPE = 'XML' AND OBJECTOWNERID IN ('HRR', 'HES', 'HGES') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | XMLP Template | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |