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