EO_SETID_OPRVW

(SQL View)
 Index Back

Sec Vw - TableSet ID's

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

SELECT s.oprid , a.setid , a.descr FROM ps_setid_tbl a , PS_SEC_SETID_OPR s WHERE a.setid = s.setid

  • Related Language Record: EO_SETIDOPVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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