RT_RATE_INDEXDefault Value: ASSET_RT.RT_RATE_INDEX
Prompt Table: RT_INDEX_TBL
RT_TYPEDefault Value: ASSET_RT.RT_TYPE
Prompt Table: RT_TYPE_TBL
TERMRT_RATE_VIEW(SQL View) |
Index Back |
|---|---|
View for Inflation Rates |
| SELECT DISTINCT RT_RATE_INDEX, RT_TYPE, TERM FROM PS_RT_RATE_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RT_RATE_INDEX |
Character(10) | VARCHAR2(10) NOT NULL |
Market Rate Index
Default Value: ASSET_RT.RT_RATE_INDEX Prompt Table: RT_INDEX_TBL |
| 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.
Default Value: ASSET_RT.RT_TYPE Prompt Table: RT_TYPE_TBL |
| 3 | TERM |
Number(5,0) | INTEGER NOT NULL | Term |