RT_RATE_INDEXRT_TYPERT_TYPE_FX_VW(SQL View) |
Index Back |
|---|---|
View For FX Rt Index and Type |
| select distinct r.rt_rate_index, r.rt_type, I.descr from ps_rt_rate_tbl R, ps_rt_index_tbl I where I.RT_Category = '10' and R.RT_RATE_INDEX = I.RT_RATE_INDEX and term = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RT_RATE_INDEX |
Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 2 | 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. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |