OBP24_FLX_PR_INDEXES_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PR_INDEXES_B
Columns
| # | 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 |