SEC_PERMNEW_VW

(SQL View)
Index Back

View of Opr IDs in PSOPRDEFN

User ID view

SELECT A.CLASSID , A.CLASSDEFNDESC FROM PSCLASSDEFN A WHERE NOT EXISTS ( SELECT 'X' FROM PS_SEC_PERM X WHERE X.OPRCLASS = A.CLASSID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

Prompt Table: OPRCLASS_VW

2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description