RT_RATE_INDEX10=Exchange Rate
20=Interest Rate
30=Economic Indicator
40=Stock Exchange Index
50=Stock Price
60=Commodity Price
70=Futures Price
99=Other
Y/N Table Edit
Default Value: N
RT_INDEX_TBL(SQL Table) |
Index Back |
|---|---|
Market Rate IndiciesMarket Rate Indicies |
| # | 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_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Rate Category
10=Exchange Rate 20=Interest Rate 30=Economic Indicator 40=Stock Exchange Index 50=Stock Price 60=Commodity Price 70=Futures Price 99=Other |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 5 | DEFAULT_INDEX | Character(1) | VARCHAR2(1) NOT NULL |
Default Exchange Rate Index
Y/N Table Edit Default Value: N |