INSTR_FUTTMN_VW

(SQL View)
 Index Back

Prompt Futures Month Template


SELECT DISTINCT SETID ,INSTRUMENT_TYPE ,INSTRMNT_TEMPLATE ,INSTRUMENT_LINE ,DELIVERY_YEAR ,MONTHCD ,RT_RATE_INDEX ,RT_TYPE ,FIRST_TRADE_DT ,LAST_TRADE_DT ,FIRST_DELIVERY_DT ,LAST_DELIVERY_DT ,DESCR 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
    6 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    7 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
    8 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    9 FIRST_TRADE_DT Date(10) DATE The lfirst date on which a deal can be traded.
    10 LAST_TRADE_DT Date(10) DATE The last date on which a deal can be traded.
    11 FIRST_DELIVERY_DT Date(10) DATE Physical date of position.
    12 LAST_DELIVERY_DT Date(10) DATE Last delivery date for a contract .
    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description