INSTR_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 <> ' '

  • Parent record: INSTR_DETAIL_TR
  • # 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