OBP24_FLX_INS_INSURANCE_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_INS_INSURANCE_B

Columns
# Name Data Type Length
1 INS_ID CHARACTER VARYING(20) 20
2 PROVIDER_ID CHARACTER VARYING(50) 50
3 POLICY_NUMBER CHARACTER VARYING(20) 20
4 CURRENCY CHARACTER VARYING(3) 3
5 INSURED_AMOUNT DOUBLE PRECISION 8
6 REVIEW_PERIOD DOUBLE PRECISION 8
7 REVISION_DATE TIMESTAMP 8
8 NOTICE_DAYS DOUBLE PRECISION 8
9 POLICY_VERSION DOUBLE PRECISION 8
10 INSURANCE_TYPE CHARACTER VARYING(20) 20
11 BENEFICIARY_TYPE CHARACTER VARYING(20) 20
12 COVERED_RISK CHARACTER VARYING(200) 200
13 COOL_EXPIRY_DATE TIMESTAMP 8
14 PLCY_CANCEL_DATE TIMESTAMP 8
15 PLCY_STATUS_TYPE CHARACTER VARYING(20) 20
16 ANNUAL_CONFRM_REQ CHARACTER VARYING(3) 3
17 PARTY_ID CHARACTER VARYING(10) 10
18 PARTY_NAME CHARACTER VARYING(250) 250
19 POLICY_CODE CHARACTER VARYING(20) 20
20 RISK_COVER_DETAILS CHARACTER VARYING(250) 250
21 ASSIGNED CHARACTER VARYING(1) 1
22 INS_UNDERTAKING CHARACTER VARYING(1) 1
23 REMARKS CHARACTER VARYING(40) 40
24 START_DATE TIMESTAMP 8
25 CREATED_BY CHARACTER VARYING(254) 254
26 CREATION_DATE TIMESTAMP 8
27 LAST_UPDATED_BY CHARACTER VARYING(254) 254
28 LAST_UPDATE_DATE TIMESTAMP 8
29 OBJECT_STATUS CHARACTER VARYING(1) 1
30 OBJECT_VERSIO_NUM SMALLINT 2
31 EXPIRY_DATE TIMESTAMP 8
32 PLCY_CREATION_DATE TIMESTAMP 8
33 END_DATE TIMESTAMP 8
34 LMI_SUBMISSION_TYPE CHARACTER VARYING(40) 40
35 DUA_APPLICABLE CHARACTER VARYING(1) 1
36 EXT_REF_NO CHARACTER VARYING(50) 50
37 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
38 FACILITY_ID CHARACTER VARYING(20) 20
39 SYSTEM_STATUS CHARACTER VARYING(20) 20
40 PREMIUM_TYPE CHARACTER VARYING(20) 20
41 REVIEW_START_DATE TIMESTAMP 8
42 REVIEW_END_DATE TIMESTAMP 8
43 SUSPEND_PRIMARY_REASON CHARACTER VARYING(250) 250
44 SUSPEND_SECONDARY_REASON CHARACTER VARYING(250) 250
45 SUSPENSION_REMARKS CHARACTER VARYING(250) 250
46 SUSPENSION_DATE TIMESTAMP 8
47 BORROWING_ENTITY CHARACTER VARYING(50) 50
48 CANCELLATION_PRIMARY_REASON CHARACTER VARYING(100) 100
49 CANCELLATION_SECONDARY_REASON CHARACTER VARYING(100) 100
50 NOMINATED_ACCOUNT CHARACTER VARYING(50) 50
51 PLAN_CODE CHARACTER VARYING(50) 50
52 REPAYMENT_TERM CHARACTER VARYING(4) 4
53 REPAYMENT_TERM_MONTHS CHARACTER VARYING(2) 2
54 REPAYMENT_TYPE CHARACTER VARYING(20) 20
55 TOTAL_PREMIUM_PAID DOUBLE PRECISION 8
56 QUOTE_ID CHARACTER VARYING(50) 50
57 PREMIUM_AMOUNT DOUBLE PRECISION 8
58 RISK_CATEGORY CHARACTER VARYING(200) 200
59 FUNDING_TYPE CHARACTER VARYING(20) 20
60 ACCOUNT_TYPE CHARACTER VARYING(10) 10
61 PREMIUM_PERIODICITY CHARACTER VARYING(20) 20
62 SETTLEMENT_PREFERENCE_ID CHARACTER VARYING(50) 50
63 CANCELLATION_REMARKS CHARACTER VARYING(250) 250
64 FUNDING_EFFECTIVE_DATE TIMESTAMP 8
65 NOMINATION_EFFECTIVE_DATE TIMESTAMP 8
66 SOURCE_TYPE CHARACTER VARYING(20) 20
67 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
68 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
69 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
70 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8