OBP_REF_INTEREST_RATE_TERM

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INTEREST_RATE_TERM_HIID BIGINT 8
2 PRODUCT_TYPE CHARACTER VARYING(100) 100
3 PRODUCT_CODE CHARACTER VARYING(100) 100
4 SOURCE_INTEREST_RATE_TYPE_CODE CHARACTER VARYING(20) 20
5 INTEREST_RATE_TYPE CHARACTER VARYING(100) 100
6 INTEREST_RATE_TERM CHARACTER VARYING(100) 100
7 DELTA_TYPE CHARACTER VARYING(1) 1
8 EFFECTIVE_STRT_DT TIMESTAMP 8
9 EFFECTIVE_END_DT TIMESTAMP 8
10 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
11 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
12 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
13 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8