QRY_SEC_CAT_VW

(SQL View)
 Index Back

SELECT H1.QRY_CATEGORY ,H1.CATEGORY_DESCR ,H1.SELECTED_CB ,H1.PRIMARY_FIELDNAME FROM PS_QUERY_SEC_H_CAT H1 WHERE NOT EXISTS ( SELECT 'X' FROM PSDBFIELD B WHERE B.FIELDNAME=H1.PRIMARY_FIELDNAME AND B.FLDNOTUSED=1) AND H1.PRIMARY_FIELDNAME=' ' UNION SELECT H.QRY_CATEGORY ,H.CATEGORY_DESCR ,H.SELECTED_CB ,H.PRIMARY_FIELDNAME FROM PS_QUERY_SEC_H_CAT H , PS_SEC_FIELDS_TBL C1 WHERE NOT EXISTS ( SELECT 'X' FROM PSDBFIELD B WHERE B.FIELDNAME=H.PRIMARY_FIELDNAME AND B.FLDNOTUSED=1) AND H.PRIMARY_FIELDNAME=C1.FIELDNAME AND C1.ACTIVE_FLAG='A' UNION SELECT H2.QRY_CATEGORY ,H2.CATEGORY_DESCR ,H2.SELECTED_CB ,H2.PRIMARY_FIELDNAME FROM PS_QUERY_SEC_H_CAT H2 , PS_AQS_NON_CF_VW F1 WHERE NOT EXISTS ( SELECT 'X' FROM PSDBFIELD B WHERE B.FIELDNAME=H2.PRIMARY_FIELDNAME AND B.FLDNOTUSED=1) AND H2.PRIMARY_FIELDNAME=F1.FIELDNAME1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRY_CATEGORY Character(18) VARCHAR2(18) NOT NULL Used in Query Security Category
2 CATEGORY_DESCR Character(60) VARCHAR2(60) NOT NULL Category Description
3 SELECTED_CB Character(1) VARCHAR2(1) NOT NULL Row Selected Checkbox
N=Not Selected
Y=Selected
4 PRIMARY_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name