EO_SETID_CLSVW

(SQL View)
 Index Back

Oprclass Sec Vw - Set ID's

THIS VIEW IS OWNED BY CRM, even though it's prefixed by EO_. This view acts as a Operator Class security view for the AAF specific SETID prompt view EO_SETID_NONVW.

SELECT s.oprclass , a.setid , a.descr FROM ps_setid_tbl a , PS_SEC_SETID_CLS s WHERE a.setid = s.setid

  • Related Language Record: EO_SETIDOCVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description