DIM_BNK_RSDL_TERM_MATURITY

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
2 RSDL_DAYS_TO_MATURITY CHARACTER VARYING(30) 30
3 EFFECTIVE_DATE TIMESTAMP 8
4 EFFECTIVE_END_DATE TIMESTAMP 8
5 RSDL_TERM_MAT_BAND_MTH CHARACTER VARYING(30) 30
6 CURRENT_RSDL_TERM_MAT_BAND_MTH CHARACTER VARYING(30) 30
7 RSDL_TERM_MAT_BAND_YR CHARACTER VARYING(30) 30
8 CURRENT_RSDL_TERM_MAT_BAND_YR CHARACTER VARYING(30) 30
9 CURRENT_FLAG CHARACTER(1) 1
10 BUSINESS_LOAD_DATE TIMESTAMP 8
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8