SETIDPrompt Table: SP_SETID_NONVW
INSTRUMENT_TYPETRANSACTION_LINETRX_ADHOC_IDC=Small Character
D=Date
N=Small Integer
R=Market Rate
INSTR_ADHOC_VW(SQL View) |
Index Back |
|---|---|
Instrument Ad-hoc Fields ViewAd-hoc / User Defined "Catch All" Fields, with INSTRUMENT_LINE named TRANSACTION_LINE (use for Related Display) |
| select setid ,instrument_type ,instrument_line ,trx_adhoc_id ,shortname ,trx_adhoc_datatype from PS_INSTR_ADHOC_ATR |
| # | 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 | 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 |