CB_UNRESTRCT_VW

(SQL View)
 Index Back

Claimback Settlement Security


SELECT DISTINCT B.SETID , A.OPRID FROM PSOPRDEFN A , PS_CB_SETID_OPT B WHERE (A.OPRID IN ( SELECT C.CB_SECURITY_ID FROM PS_CB_UNRESTRICTED C WHERE C.CB_SECURITY_TYPE = 'U' AND C.SETID = B.SETID)) OR (A.OPRID IN ( SELECT D.ROLEUSER FROM PSROLEUSER D WHERE D.ROLENAME IN ( SELECT E.CB_SECURITY_ID FROM PS_CB_UNRESTRICTED E WHERE E.CB_SECURITY_TYPE = 'R' AND E.SETID = B.SETID)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).