SP_SETCU_CLSVW

(SQL View)
Index Back

CUSTOMER_SETID view


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description