RECNAMEQRY_IMPT_RPT_VW(SQL View) |
Index Back |
|---|
| SELECT A.RECNAME ,A.QRYNAME ,B.DS_ID ,'Bi Publisher' FROM PSQRYRECORD A ,PSXPDATASRC B WHERE B.DS_TYPE='QRY' AND A.QRYNAME=B.DS_ID UNION SELECT A1.RECNAME ,A1.QRYNAME ,B1.PTPG_PGRIDTITLE ,'Pivot Grid' FROM PSQRYRECORD A1 ,PSPGCORE B1 WHERE B1.PTPG_DSTYPE='PSQUERY' AND A1.QRYNAME=B1.PTPG_PGRIDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 3 | PTPG_PGRIDTITLE | Character(30) | VARCHAR2(30) NOT NULL | Pivot Grid Title |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |