RE_PTY_PM

(SQL View)
 Index Back

Portfolio Managers by Key


SELECT A.PARTY_KEY , B.OPRDEFNDESC , A.OPRID FROM PS_RE_INT_PARTY A , PSOPRDEFN_VW B WHERE A.OPRID = B.OPRID AND A.STATUS = 'A' AND A.APPROVE_FLG = 'Y' AND A.PARTY_TYPE_CD IN ( SELECT B.PARTY_TYPE_CD FROM PS_RE_INTPARTY B WHERE B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'RE_INTPARTY') AND B.PARTY_TYPE_CD = A.PARTY_TYPE_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key
2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).