SP_ASETID_CLSVW

(SQL View)
 Index Back

PO Valid Item Setid View

This view identifies which SETID values are valid for Item related tables.

SELECT DISTINCT B.OPRCLASS , A.SETID FROM PS_SET_CNTRL_REC A , PS_SEC_SETID_CLS B WHERE A.SETID = B.SETID AND A.REC_GROUP_ID = 'FS_18'

# 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 SetID