RE_PRTFL_NAME

(SQL View)
Index Back

Portfolio Managers by UserID


SELECT B.OPRDEFNDESC ,A.OPRID FROM PS_RE_INT_PARTY A , PSOPRDEFN_VW B WHERE A.OPRID = B.OPRID AND A.APPROVE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
2 PRTFL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Portfolio Manager