SETIDINSTRUMENT_TYPEINSTRMNT_TEMPLATEDELIVERY_YEARINSTR_FUTTYR_VW(SQL View) |
Index Back |
|---|---|
Prompt Futures Year Template |
| SELECT DISTINCT SETID ,INSTRUMENT_TYPE ,INSTRMNT_TEMPLATE ,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 | INSTRMNT_TEMPLATE |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier associated with an instrument that describes a separate template version of a pre |
| 4 | TRANSACTION_LINE | Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
| 5 | DELIVERY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Delivery Year |