SP_DPTSET_CLSVW

(SQL View)
 Index Back

Department Table Set ID

This view is used to validate the Department Set ID by security class This view list only the Set ID's used by the Department table.

SELECT B.OPRCLASS , A.SETID , A.DESCR , A.DESCRSHORT , A.DESCRLONG FROM PS_SP_DPTSET_NONVW A , PS_SEC_SETID_CLS B WHERE A.SETID = B.SETID

  • Related Language Record: SP_DPTST_LCLSVW

    • # 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
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCRLONG Long Character CLOB Long Description