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

INSTR_ADHOC_ATR

(SQL Table)

Instrument Ad-hoc Attributes

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

Related Language Record: INSTR_ADHOC_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

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

3 INSTRUMENT_LINE Number(3,0) SMALLINT NOT NULL A sequential number that identifies each instrument base type defined within a given instrument.

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 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name

6 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type
3	INSTRUMENT_LINE	Number(3,0)	SMALLINT NOT NULL	A sequential number that identifies each instrument base type defined within a given instrument.
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	SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Field Short Name
6	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