| # |
Name |
Data Type |
Length |
| 1 |
INDEX_CODE |
CHARACTER VARYING(20) |
20 |
| 2 |
EFFECTIVE_DATE |
TIMESTAMP |
8 |
| 3 |
INDEX_NAME |
CHARACTER VARYING(50) |
50 |
| 4 |
INDEX_DESC |
CHARACTER VARYING(120) |
120 |
| 5 |
DOMAIN_CODE |
CHARACTER VARYING(50) |
50 |
| 6 |
DOMAIN_CATEGORY_CODE |
CHARACTER VARYING(50) |
50 |
| 7 |
CCY_CODE |
CHARACTER VARYING(3) |
3 |
| 8 |
BESTOF_FLAG |
BYTEINT |
1 |
| 9 |
DERIVATIONSTRATEGY_CODE |
CHARACTER VARYING(50) |
50 |
| 10 |
INTEREST_TYPE_CODE |
CHARACTER VARYING(60) |
60 |
| 11 |
FREQUENCY_CODE |
CHARACTER VARYING(40) |
40 |
| 12 |
FREQUENCY_QTY |
DOUBLE PRECISION |
8 |
| 13 |
MARGIN_AMT |
DOUBLE PRECISION |
8 |
| 14 |
MARGIN_EXPIRY_DATE |
TIMESTAMP |
8 |
| 15 |
DERIVATION_OPERATOR_CODE |
CHARACTER VARYING(40) |
40 |
| 16 |
BENCHMARK_CODE |
CHARACTER VARYING(20) |
20 |
| 17 |
INTEREST_RATE_AMT |
DOUBLE PRECISION |
8 |
| 18 |
RULE_CODE |
CHARACTER VARYING(45) |
45 |
| 19 |
EXPRESSION_CODE |
CHARACTER VARYING(45) |
45 |
| 20 |
INDEXRETRIEVAL_DAY_CODE |
CHARACTER VARYING(5) |
5 |
| 21 |
BASEINTERESTINDEX_CODE |
CHARACTER VARYING(20) |
20 |
| 22 |
DERIVATION_FACTOR_AMT |
DOUBLE PRECISION |
8 |
| 23 |
PERIODICITY_CODE |
CHARACTER VARYING(40) |
40 |
| 24 |
BASE_INDEX_EFF_DATE |
TIMESTAMP |
8 |
| 25 |
RULE_EFFECTIVE_DATE |
TIMESTAMP |
8 |
| 26 |
APPLICABILITY_CODE |
CHARACTER VARYING(20) |
20 |
| 27 |
CREATED_BY |
CHARACTER VARYING(64) |
64 |
| 28 |
CREATION_DATE |
TIMESTAMP |
8 |
| 29 |
LAST_UPDATED_BY |
CHARACTER VARYING(64) |
64 |
| 30 |
LAST_UPDATE_DATE |
TIMESTAMP |
8 |
| 31 |
ENTITY_STATUS |
CHARACTER(1) |
1 |
| 32 |
OBJECT_VERSION_NUM |
INTEGER |
4 |
| 33 |
CDC_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(4) |
4 |
| 34 |
CDC_RECORD_TYPE |
CHARACTER VARYING(16) |
16 |
| 35 |
CDC_COMMIT_TIMESTAMP |
TIMESTAMP |
8 |
| 36 |
CDC_EXTRACT_TIMESTAMP |
TIMESTAMP |
8 |