EOQF_CATEGORYEOQF_ROLENAMEEOQF_USEEXST_VW(SQL View) |
Index Back |
|---|---|
Use existing Privilege ViewUse existing Privilege View |
| SELECT SEC.EOQF_CATEGORY ,SEC.EOQF_ROLENAME FROM PS_EOQF_QF_SEC_TBL SEC ,PS_EOQF_CAT_VW CAT WHERE SEC.EOQF_USE_QA='Y' AND SEC.EOQF_CATEGORY=CAT.EOQF_CATEGORY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOQF_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL | Category Field |
| 2 | EOQF_ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | Rolename |