TRX_ADHOC_ATR (SQL Table)	Index Back
Deal Ad-Hoc Attributes Treasury Deal Ad-Hoc Attributes. Extra attributes not explicitly captured by the regular panels.

TRX_ADHOC_ATR

(SQL Table)

Deal Ad-Hoc Attributes

Treasury Deal Ad-Hoc Attributes. Extra attributes not explicitly captured by the regular panels.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

4 TRX_ADHOC_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the use of free form attribute fields that may be associat

5 TRX_ADHOC_DATATYPE Character(1) VARCHAR2(1) NOT NULL The types of field datatypes permissible to be created as ad-hoc deal attribute fields.
C=Small Character
D=Date
N=Small Integer
R=Market Rate

6 TRX_ADHOC_INTEGER Signed Number(6,0) DECIMAL(5) NOT NULL Represents a field that stores numeric data in the context of ad-hoc deal attribute fields.

7 TRX_ADHOC_CHAR Character(10) VARCHAR2(10) NOT NULL Represents a field that stores character text data in the context of ad-hoc deal attribute field

8 TRX_ADHOC_DATE Date(10) DATE Represents a field that stores date information in the context of ad-hoc deal attribute fields.

9 TRX_ADHOC_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Represents a field that stores market rate information in the context of ad-hoc deal attribute fields.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
3	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	TRX_ADHOC_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the use of free form attribute fields that may be associat
5	TRX_ADHOC_DATATYPE	Character(1)	VARCHAR2(1) NOT NULL	The types of field datatypes permissible to be created as ad-hoc deal attribute fields. C=Small Character D=Date N=Small Integer R=Market Rate
6	TRX_ADHOC_INTEGER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Represents a field that stores numeric data in the context of ad-hoc deal attribute fields.
7	TRX_ADHOC_CHAR	Character(10)	VARCHAR2(10) NOT NULL	Represents a field that stores character text data in the context of ad-hoc deal attribute field
8	TRX_ADHOC_DATE	Date(10)	DATE	Represents a field that stores date information in the context of ad-hoc deal attribute fields.
9	TRX_ADHOC_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Represents a field that stores market rate information in the context of ad-hoc deal attribute fields.