OBP24_HST_FLX_INS_BORROWER_DETAIL_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INSURANCE_ID CHARACTER VARYING(20) 20
2 BORROWER_ID CHARACTER VARYING(50) 50
3 POLICY_CODE CHARACTER VARYING(50) 50
4 COVER_TYPE CHARACTER VARYING(100) 100
5 DEATH_COVER_AMOUNT DOUBLE PRECISION 8
6 CCY_CODE CHARACTER VARYING(3) 3
7 COVER_START_DATE TIMESTAMP 8
8 COVER_END_DATE TIMESTAMP 8
9 POLICY_START_DAYS_NUM BIGINT 8
10 POLICY_START_MONTHS_NUM BIGINT 8
11 POLICY_START_YEARS_NUM BIGINT 8
12 PREMIUM_AMOUNT DOUBLE PRECISION 8
13 PARTY_NAME CHARACTER VARYING(50) 50
14 BORROWER_NAME CHARACTER VARYING(250) 250
15 COOLING_EXPIRY_DATE TIMESTAMP 8
16 PLCY_AMEND_DATE TIMESTAMP 8
17 IS_EXISTING_BORROWER CHARACTER(1) 1
18 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
19 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
20 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
21 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8