SP_ASETID_OPRVW

(SQL View)
Index Back

PO Valid Item Setid View

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

SELECT DISTINCT B.OPRID , A.SETID FROM PS_SET_CNTRL_REC A , PS_SEC_SETID_OPR B WHERE A.SETID = B.SETID AND A.REC_GROUP_ID = 'FS_18'

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