OBP24_HST_FLX_INS_PREMIUM_DTLS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INSURANCE_ID CHARACTER VARYING(20) 20
2 VALUE_DATE TIMESTAMP 8
3 PREMIUM_TYPE CHARACTER VARYING(20) 20
4 CCY_CODE CHARACTER VARYING(3) 3
5 TOTAL_PREMIUM_AMT DOUBLE PRECISION 8
6 BASE_PREMIUM_AMT DOUBLE PRECISION 8
7 BANKER_PREMIUM_AMT DOUBLE PRECISION 8
8 CUST_PREMIUM_AMT DOUBLE PRECISION 8
9 DISCOUNT_AMT DOUBLE PRECISION 8
10 TOTAL_TAX_AMT DOUBLE PRECISION 8
11 STAMP_DUTY DOUBLE PRECISION 8
12 FUNDING_TYPE CHARACTER VARYING(20) 20
13 PREMIUM_FREQUENCY CHARACTER VARYING(20) 20
14 INITIAL_PREMIUM_AMT DOUBLE PRECISION 8
15 NEW_PREMIUM_AMT DOUBLE PRECISION 8
16 LAST_PREMIUM_AMT DOUBLE PRECISION 8
17 CUM_PREMIUM_AMT DOUBLE PRECISION 8
18 REFUND_AMT DOUBLE PRECISION 8
19 PREMIUM_PAY_ACCOUNT CHARACTER VARYING(40) 40
20 PREMIUM_DUE_DATE TIMESTAMP 8
21 PREMIUM_NOTICE_DAYS DOUBLE PRECISION 8
22 PREMIUM_STATUS_TYPE CHARACTER VARYING(20) 20
23 PREMIUM_INT_RATE DOUBLE PRECISION 8
24 BORROWER_GST DOUBLE PRECISION 8
25 BORROWER_ST_DUTY DOUBLE PRECISION 8
26 LENDER_GST DOUBLE PRECISION 8
27 LENDER_ST_DUTY DOUBLE PRECISION 8
28 NET_BORR_PREMIUM_AMOUNT DOUBLE PRECISION 8
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8