EOQF_CRTANS_VW

(SQL View)
 Index Back

Create Answer Privilege view

Create Answer Privilege view

SELECT SEC.EOQF_CATEGORY ,SEC.EOQF_ROLENAME FROM PS_EOQF_QF_SEC_TBL SEC ,PS_EOQF_CAT_VW CAT WHERE SEC.EOQF_CREATE_ANS='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