TRX_PORMTM_HIST

(SQL Table)
Index Back

Portfolio MTM History

Portfolio MTM History

# 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 ASOFDATE Date(10) DATE As of Date
4 TRX_PORT_MTM_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the portfolio MTM value.
5 TRX_PORT_BOOK_VAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the portfolio book value.
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 TRX_PORT_MTM_ZSW Character(1) VARCHAR2(1) NOT NULL Switch indicating whether a portfolio contained an MTM of zero for a deal.
N=No
Y=Yes