QRYNAMEACA_EXTRACT_QVW(SQL View) |
Index Back |
|---|---|
Safe Harbor Query prompt viewSafe Harbor Query prompt view |
| SELECT DISTINCT Q.QRYNAME ,Q.DESCR FROM PSQRYDEFN Q ,PSQRYFIELD F1 ,PSQRYFIELD F2 ,PSQRYBIND B WHERE Q.QRYTYPE = 1 AND Q.QRYNAME = F1.QRYNAME AND Q.QRYNAME = F2.QRYNAME AND Q.QRYNAME = B.QRYNAME AND F1.FIELDNAME = 'EMPLID' AND F1.COLUMNNUM = 1 AND F2.FIELDNAME = 'EMPL_RCD' AND F2.COLUMNNUM = 2 AND B.FIELDNAME = 'EFFDT' AND B.BNDNUM = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |