TRX_SUB_VW (SQL View)	Index Back
Treasury Deal Header Treasury Deals header record view for internal deals that are not yet associated with a master deal.

TRX_SUB_VW

(SQL View)

Treasury Deal Header

Treasury Deals header record view for internal deals that are not yet associated with a master deal.

SELECT S.TREAS_MIRROR_ID , S.TREAS_HEADER_ID , S.BUSINESS_UNIT , S.DEAL_STATUS , S.DEAL_FAMILY_TYPE , S.TREAS_MAST_SUB_BU , S.TREAS_MAST_SUB_ID , S.TREAS_MIRROR_BU , S.TREAS_MIRROR_CPTY , S.COUNTERPARTY_SETID , S.COUNTERPARTY , D.TRANSACTION_AMT FROM PS_TRX_HEADER_TR S , PS_TRX_DETAIL_TR D WHERE D.BUSINESS_UNIT = S.BUSINESS_UNIT AND D.TREAS_HEADER_ID = S.TREAS_HEADER_ID AND D.TRANSACTION_LINE = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREAS_MIRROR_ID Character(12) VARCHAR2(12) NOT NULL The deal ID of the deal the is the offset for this deal.

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
Default Value: NEXT
Prompt Table: TRX_HEADER_TR

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW

4 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
Default Value: 01

5 DEAL_FAMILY_TYPE Character(4) VARCHAR2(4) NOT NULL When deals are linked together, a code is set to identify the nature of the linkage. (EG btb = back to back)
BTB=Back to Back
COPY=Other Purpose Deal Copy
MIR=Standard Mirror
MIRR=Other Purpose Deal Mirror
PART=Partial Sell/Buyback
RLFX=FX Swap Forward / Backward
RLPH=One Period Physical Rollover
SUB=Internal or Subsidiary

6 TREAS_MAST_SUB_BU Character(5) VARCHAR2(5) NOT NULL The business unit of the Treasury unit who controls a group of internal deals, soem of which may have different business units.

7 TREAS_MAST_SUB_ID Character(12) VARCHAR2(12) NOT NULL This field contains the first deal id in a series of deals that are related for interunit dealing, on behalf dealing, or deals between subsidiaries.

8 TREAS_MIRROR_BU Character(5) VARCHAR2(5) NOT NULL The business unit of the deal that is the opposite clearing deal of the current deal.

9 TREAS_MIRROR_CPTY Character(5) VARCHAR2(5) NOT NULL The counterparty in a mirror clearing deal.

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

11 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW

12 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREAS_MIRROR_ID	Character(12)	VARCHAR2(12) NOT NULL	The deal ID of the deal the is the offset for this deal.
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction. Default Value: NEXT Prompt Table: TRX_HEADER_TR
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
4	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 Default Value: 01
5	DEAL_FAMILY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	When deals are linked together, a code is set to identify the nature of the linkage. (EG btb = back to back) BTB=Back to Back COPY=Other Purpose Deal Copy MIR=Standard Mirror MIRR=Other Purpose Deal Mirror PART=Partial Sell/Buyback RLFX=FX Swap Forward / Backward RLPH=One Period Physical Rollover SUB=Internal or Subsidiary
6	TREAS_MAST_SUB_BU	Character(5)	VARCHAR2(5) NOT NULL	The business unit of the Treasury unit who controls a group of internal deals, soem of which may have different business units.
7	TREAS_MAST_SUB_ID	Character(12)	VARCHAR2(12) NOT NULL	This field contains the first deal id in a series of deals that are related for interunit dealing, on behalf dealing, or deals between subsidiaries.
8	TREAS_MIRROR_BU	Character(5)	VARCHAR2(5) NOT NULL	The business unit of the deal that is the opposite clearing deal of the current deal.
9	TREAS_MIRROR_CPTY	Character(5)	VARCHAR2(5) NOT NULL	The counterparty in a mirror clearing deal.
10	COUNTERPARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given dealing counterparty.
11	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart. Prompt Table: BANK_TR_CPTY_VW
12	TRANSACTION_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The nominal or actual deal transaction amount.