INT_CI_POLICY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICY_ID CHARACTER VARYING(20) 20
2 POLICY_NUMBER CHARACTER VARYING(40) 40
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
4 SC_SOURCE_POLICY_NUMBER CHARACTER VARYING(40) 40
5 POLICY_CREATE_TIME TIMESTAMP 8
6 POLICY_CREATE_TIME_LBL CHARACTER VARYING(30) 30
7 POLICY_CREATE_DATE_ID INTEGER 4
8 POLICY_UPDATE_TIME TIMESTAMP 8
9 POLICY_UPDATE_TIME_LBL CHARACTER VARYING(30) 30
10 POLICY_UPDATE_DATE_ID INTEGER 4
11 POLICY_EXPIRATION_DATE TIMESTAMP 8
12 POLICY_EXPIRATION_DATE_ID INTEGER 4
13 POLICY_INCEPTION_DATE TIMESTAMP 8
14 POLICY_INCEPTION_DATE_ID INTEGER 4
15 POLICY_ORIGINAL_EFFECTIVE_DATE TIMESTAMP 8
16 POLICY_ORIGINAL_EFFECTIVE_DATE_ID INTEGER 4
17 POLICY_EFFECTIVE_DATE TIMESTAMP 8
18 POLICY_EFFECTIVE_DATE_ID INTEGER 4
19 POLICY_CREATE_USER_ID BIGINT 8
20 POLICY_UPDATE_USER_ID BIGINT 8
21 POLICY_TYPE_ID BIGINT 8
22 LATEST_POLICY_FLAG CHARACTER VARYING(3) 3
23 FIRST_POLICY_FLAG CHARACTER VARYING(3) 3
24 BRAND_ID BIGINT 8
25 NOMINAL_DEFENDENT_NUMBER CHARACTER VARYING(10) 10
26 POLICY_REGION CHARACTER VARYING(9) 9
27 BRANDMARKER_LOB CHARACTER VARYING(10) 10
28 BUSINESS_SOURCE CHARACTER VARYING(9) 9
29 POLICY_CANCELLATION_DATE TIMESTAMP 8
30 POLICY_CANCELLATION_DATE_ID INTEGER 4
31 POLICY_INSTALMENT_STATUS_DATE TIMESTAMP 8
32 POLICY_INSTALMENT_STATUS_DATE_ID INTEGER 4
33 POLICY_SOURCESYSTEM_ID BIGINT 8
34 POLICY_CANCELREASON_ID BIGINT 8
35 GST_EXEMPT_FLAG INTEGER 4
36 GST_REGISTERED_FLAG INTEGER 4
37 ITC_PERCENTAGE NUMERIC(4,1) 19
38 ITC_PERCENTAGE_NAME CHARACTER VARYING(5) 5
39 LINE_OF_BUSINESS_ID BIGINT 8
40 RESPONSIBILITY_CENTRE CHARACTER VARYING(9) 9
41 SERVICE_CENTRE CHARACTER VARYING(9) 9
42 SOURCE_COMPANY CHARACTER VARYING(9) 9
43 SOURCE_COVERAGE CHARACTER VARYING(9) 9
44 SUB_CHANNEL CHARACTER VARYING(20) 20
45 CURRENT_POLICY_STATUS_ID BIGINT 8
46 TOTAL_PROPERTIES BIGINT 8
47 TOTAL_PROPERTIES_LABEL CHARACTER VARYING(50) 50
48 TOTAL_VEHICLES BIGINT 8
49 TOTAL_VEHICLES_LABEL CHARACTER VARYING(50) 50
50 VERIFIED_POLICY_FLAG INTEGER 4
51 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
52 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8