RT_IND_IR_VWLNG(SQL View) |
Index Back |
---|---|
Interest Rate Market Index VWUsed 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' |
# | 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 |