RT_IND_IR_VWLNG

(SQL View)
Index Back

Interest Rate Market Index VW

Used as a Prompt Table whenever Interest Rate Market Rates only are required. (Floating rate instrument resets)

SELECT a.rt_rate_index , b.language_cd , b.descr FROM ps_rt_index_tbl a , ps_rt_index_lang b WHERE rt_category = '20'

  • Related Language Record for RT_INDEX_IR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description