TRX_HEADER_VW (SQL View)	Index Back
View over trx_header View of trx_header_tr deals, grouped by portfolio.

TRX_HEADER_VW

(SQL View)

View over trx_header

View of trx_header_tr deals, grouped by portfolio.

SELECT a.business_unit , a.treasury_portfolio , a.treas_header_id , a.instrument_type , b.equity_symbol , a.instrmnt_template , a.counterparty_setid , a.counterparty , a.transaction_dt , a.descr150_mixed , a.deal_status , a.run_posn FROM PS_TRX_HEADER_TR a , ps_trx_detail_tr b WHERE a.business_unit=b.business_unit AND a.treas_header_id=b.treas_header_id

Parent record: TRX_PORTFLIO_TR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

4 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type

5 EQUITY_SYMBOL Character(15) VARCHAR2(15) NOT NULL Ticker symbol to identify an equity on the exchange that it is traded on

6 INSTRMNT_TEMPLATE Character(10) VARCHAR2(10) NOT NULL A unique key identifier associated with an instrument that describes a separate template version of a pre

7 COUNTERPARTY_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given dealing counterparty.

8 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

9 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)

10 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

11 DEAL_STATUS Character(2) VARCHAR2(2) NOT NULL Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back

12 RUN_POSN Character(1) VARCHAR2(1) NOT NULL A flag to check if position update to be run.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
4	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type
5	EQUITY_SYMBOL	Character(15)	VARCHAR2(15) NOT NULL	Ticker symbol to identify an equity on the exchange that it is traded on
6	INSTRMNT_TEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier associated with an instrument that describes a separate template version of a pre
7	COUNTERPARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given dealing counterparty.
8	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart.
9	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
10	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
11	DEAL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Represents the specific state or point in the life cycle of a deal transaction. 01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back
12	RUN_POSN	Character(1)	VARCHAR2(1) NOT NULL	A flag to check if position update to be run.