SETIDINSTRUMENT_TYPEDELIVERY_YEARINSTR_FUT_YR_VW(SQL View) |
Index Back |
|---|---|
Prompt Futures Year No Tmpl |
| SELECT DISTINCT SETID ,INSTRUMENT_TYPE ,INSTRUMENT_LINE ,DELIVERY_YEAR FROM PS_INSTR_FUTURE_TR WHERE INSTRMNT_TEMPLATE = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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 | DELIVERY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Delivery Year |