TRX_PORTFLIO_VW

(SQL View)
Index Back

Portfolio search view


SELECT A.SETID , A.TREASURY_PORTFOLIO , A.DESCR FROM PS_TRX_PORTFLIO_TR A WHERE A.EFFDT = ( SELECT MAX (B.EFFDT) FROM PS_TRX_PORTFLIO_TR B WHERE B.SETID = A.SETID AND B.TREASURY_PORTFOLIO = A.TREASURY_PORTFOLIO)

# 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

Prompt Table: SP_SETID_NONVW

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