EOQF_CRTQSTN_VW

(SQL View)
 Index Back

Create Question Privilege view

Create Question Privilege view

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