TRD_HEADER_TR (SQL Table)	Index Back
Treasury Trade Header Treasury Trade header record

TRD_HEADER_TR

(SQL Table)

Treasury Trade Header

Treasury Trade header record

Parent Record Of TRD_DETAIL_TR TRX_HEADER_VW1 TRX_SELLBUY_MTC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TRD_TRADE_ID Character(12) VARCHAR2(12) NOT NULL Trade ID
Default Value: NEXT
Prompt Table: TRD_HEADER_TR

3 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
Prompt Table: INSTR_INST_H_VW

4 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
Prompt Table: INSTR_TMPL_H_VW

5 TRADE_TYPE Character(1) VARCHAR2(1) NOT NULL Trade Type
C=Close
O=Open
Default Value: O

6 TRADE_STATUS Character(2) VARCHAR2(2) NOT NULL Trade Status used on Trades
01=Under Negotiation
03=Open
05=Deactivated
Default Value: 01

7 BUY_SELL Character(1) VARCHAR2(1) NOT NULL Designates whether the deal transaction leg represents the buy or sell side of the transaction.
B=Buy/Issue
S=Sell/BuyBack
Default Value: B

8 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.
Prompt Table: TRX_PORTFLIO_TR

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

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

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

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

13 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.
Prompt Table: FCLTY_DFN

14 CPTY_DEALER Character(10) VARCHAR2(10) NOT NULL The assigned external dealer or trader associated with a given dealing counterparty.

15 CPTY_REFERENCE Character(15) VARCHAR2(15) NOT NULL A reference identifier associated with a dealing counterparty transaction.

16 TRANSACTION_ISSUER Character(5) VARCHAR2(5) NOT NULL The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre
Prompt Table: BANK_ISSUER_VW

17 TRANSACT_GUARANTOR Character(5) VARCHAR2(5) NOT NULL Entity that guarantees the credit worthiness of a financial instrument and its counterparty
Prompt Table: BANK_GURANTR_VW

18 TRANSACTION_BROKER Character(5) VARCHAR2(5) NOT NULL "The deal transaction intermediary
Prompt Table: BANK_BROKER_VW

19 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

20 ORIG_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the original creation and saving of a given transaction.

21 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

22 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

23 DEALER_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table: OPRID_VW

24 TRANSACTION_DTTM DateTime(26) TIMESTAMP Transaction Date-Time
Default Value: %DateTime

25 TRADE_CONF_STATUS Character(2) VARCHAR2(2) NOT NULL Trade Confirmation Status used on Trades
01=Pending
02=Confirmed
03=Invalid

26 TRADE_CONF_DTTM DateTime(26) TIMESTAMP Trade Confirm Date/Time

27 TRADE_CONF_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that confirmed a given trade transaction.

28 DEACTIVATED_DTTM DateTime(26) TIMESTAMP Deactivated Trade Date/Time

29 DEACTIVATED_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that deactivated a given trade transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	TRD_TRADE_ID	Character(12)	VARCHAR2(12) NOT NULL	Trade ID Default Value: NEXT Prompt Table: TRD_HEADER_TR
3	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type Prompt Table: INSTR_INST_H_VW
4	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 Prompt Table: INSTR_TMPL_H_VW
5	TRADE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Trade Type C=Close O=Open Default Value: O
6	TRADE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Trade Status used on Trades 01=Under Negotiation 03=Open 05=Deactivated Default Value: 01
7	BUY_SELL	Character(1)	VARCHAR2(1) NOT NULL	Designates whether the deal transaction leg represents the buy or sell side of the transaction. B=Buy/Issue S=Sell/BuyBack Default Value: B
8	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. Prompt Table: TRX_PORTFLIO_TR
9	TRANSACTION_DT	Date(10)	DATE NOT NULL	Transaction date (often used as trade date)
10	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
11	COUNTERPARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given dealing counterparty.
12	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart. Prompt Table: BANK_TR_CPTY_VW
13	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility. Prompt Table: FCLTY_DFN
14	CPTY_DEALER	Character(10)	VARCHAR2(10) NOT NULL	The assigned external dealer or trader associated with a given dealing counterparty.
15	CPTY_REFERENCE	Character(15)	VARCHAR2(15) NOT NULL	A reference identifier associated with a dealing counterparty transaction.
16	TRANSACTION_ISSUER	Character(5)	VARCHAR2(5) NOT NULL	The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre Prompt Table: BANK_ISSUER_VW
17	TRANSACT_GUARANTOR	Character(5)	VARCHAR2(5) NOT NULL	Entity that guarantees the credit worthiness of a financial instrument and its counterparty Prompt Table: BANK_GURANTR_VW
18	TRANSACTION_BROKER	Character(5)	VARCHAR2(5) NOT NULL	"The deal transaction intermediary Prompt Table: BANK_BROKER_VW
19	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
20	ORIG_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the original creation and saving of a given transaction.
21	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
22	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
23	DEALER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that originally created and saved a given deal tran Prompt Table: OPRID_VW
24	TRANSACTION_DTTM	DateTime(26)	TIMESTAMP	Transaction Date-Time Default Value: %DateTime
25	TRADE_CONF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Trade Confirmation Status used on Trades 01=Pending 02=Confirmed 03=Invalid
26	TRADE_CONF_DTTM	DateTime(26)	TIMESTAMP	Trade Confirm Date/Time
27	TRADE_CONF_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that confirmed a given trade transaction.
28	DEACTIVATED_DTTM	DateTime(26)	TIMESTAMP	Deactivated Trade Date/Time
29	DEACTIVATED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that deactivated a given trade transaction.