TR_WC_PFLIO_VW

(SQL View)
Index Back

Portfolio search view


SELECT A.SETID , A.TREASURY_PORTFOLIO , A.DESCR FROM PS_TRX_PORTFLIO_TR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TREASURY_PORTFOLIO Character(15) VARCHAR2(15) NOT NULL A unique key identifier for a position portfolio that may be associated with a given deal transaction.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description