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 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field
2 EOQF_ROLENAME Character(30) VARCHAR2(30) NOT NULL Rolename