PTNVSQRY_VW(SQL View) |
Index Back |
|---|---|
Nvision Query View record |
| SELECT DISTINCT LAYOUT_ID ,QRYNAME FROM PS_PTNVSLYTQRY WHERE LAYOUT_ID IN ( SELECT DISTINCT LAYOUT_ID FROM PS_NVS_REPORT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LAYOUT_ID | Character(50) | VARCHAR2(50) NOT NULL | nVision Layout |
| 2 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |