CP_QUERY_NAMECP_SYSQRY_VW(SQL View) |
Index Back |
|---|---|
CP System Query Name ViewThe view is built over the tools table PSQRYDEFN. |
| select D.QRYNAME, R.RECNAME, D.DESCR from PSQRYDEFN D, PSQRYRECORD R where D.QRYNAME = R.QRYNAME and R.SELNUM = 1 and R.RCDNUM = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CP_QUERY_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Internal Variable Query Name Field |
| 2 | TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |