SP_SETID_CLSVW

(SQL View)
Index Back

Sec Vw - TableSet ID's


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

# 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