RE_PORTFL_MGR

(SQL View)
Index Back

Portfolio Manager View

Portfolio Manager View: Portfolio Manager Name as Search Key field

SELECT DISTINCT OPR.OPRDEFNDESC ,OPR.OPRID ,LEASE.PRTFL_MGR FROM PSOPRDEFN OPR , PS_RE_INT_PARTY PARTY , PS_RE_LS LEASE WHERE OPR.OPRID=PARTY.OPRID AND PARTY.PARTY_KEY=LEASE.PRTFL_MGR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DESCR Character(30) VARCHAR2(30) NOT NULL Description
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager