SP_ASETID_OPRVW(SQL View) |
Index Back |
---|---|
PO Valid Item Setid ViewThis 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 |