INSTR_ADHOC_VW2 (SQL View)	Index Back
Instrument Ad-hoc Fields View Ad-hoc / User Defined "Catch All" Fields, with INSTRUMENT_LINE named TRANSACTION_LINE (to allow copy into Deal Capture panels) (Key fields stop at Instrument_Type!! to avoid "No matching buffer found for level. (15,26)" error)

INSTR_ADHOC_VW2

(SQL View)

Instrument Ad-hoc Fields View

Ad-hoc / User Defined "Catch All" Fields, with INSTRUMENT_LINE named TRANSACTION_LINE (to allow copy into Deal Capture panels) (Key fields stop at Instrument_Type!! to avoid "No matching buffer found for level. (15,26)" error)

select setid ,instrument_type ,instrument_line ,trx_adhoc_id ,trx_adhoc_datatype from PS_INSTR_ADHOC_ATR

Parent record: INSTR_DETAIL_TR

# 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 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

#	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	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