FCT_CUST_CLAIM_PROPERTY_CI

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EXTRACTION_RANGE_FROM DATE 4
2 EXTRACTION_RANGE_TO DATE 4
3 SURVEY_DUE_DATE DATE 4
4 BRAND CHARACTER VARYING(256) 256
5 CLAIM_NUMBER CHARACTER VARYING(40) 40
6 LINE_OF_BUSINESS CHARACTER VARYING(40) 40
7 POLICY_NUMBER CHARACTER VARYING(40) 40
8 POLICY_TYPE CHARACTER VARYING(256) 256
9 LOSS_TYPE CHARACTER VARYING(256) 256
10 LOSS_CAUSE CHARACTER VARYING(256) 256
11 LOSS_SUB_CAUSE CHARACTER VARYING(100) 100
12 LOSS_DATE DATE 4
13 PRODUCT CHARACTER VARYING(20) 20
14 COVER_TYPE CHARACTER VARYING(256) 256
15 MANAGED_STATE CHARACTER VARYING(50) 50
16 MANAGED_REGION CHARACTER VARYING(50) 50
17 MANAGED_LOCATION CHARACTER VARYING(100) 100
18 RISK_STATE CHARACTER VARYING(50) 50
19 RISK_REGION CHARACTER VARYING(20) 20
20 ITEM_ACTION CHARACTER VARYING(100) 100
21 LODGEMENT_DATE DATE 4
22 ACTUAL_COMPLETION_DATE DATE 4
23 CLAIM_CLOSED_DATE DATE 4
24 CLAIM_LIFE BIGINT 8
25 CLAIM_STATUS CHARACTER VARYING(256) 256
26 CATASTROPHE_CODE CHARACTER VARYING(60) 60
27 INSURED_TITLE CHARACTER VARYING(256) 256
28 INSURED_FIRST_NAME CHARACTER VARYING(90) 90
29 INSURED_SURNAME CHARACTER VARYING(90) 90
30 INSURED_OTHER_NAME CHARACTER VARYING(120) 120
31 INSURED_ADDRESS_LINE_1 CHARACTER VARYING(256) 256
32 INSURED_ADDRESS_LINE_2 CHARACTER VARYING(256) 256
33 INSURED_ADDRESS_LINE_3 CHARACTER VARYING(256) 256
34 INSURED_ADDRESS_SUBURB CHARACTER VARYING(60) 60
35 INSURED_ADDRESS_STATE CHARACTER VARYING(256) 256
36 INSURED_ADDRESS_POSTCODE CHARACTER VARYING(50) 50
37 INSURED_ACCEPT_SMS CHARACTER VARYING(3) 3
38 PRIMARY_PHONE CHARACTER VARYING(256) 256
39 INSURED_PHONE_HOME CHARACTER VARYING(30) 30
40 INSURED_PHONE_WORK CHARACTER VARYING(24) 24
41 INSURED_PHONE_MOBILE CHARACTER VARYING(30) 30
42 INSURED_EMAIL CHARACTER VARYING(60) 60
43 INSURED2_TITLE CHARACTER VARYING(256) 256
44 INSURED2_FIRST_NAME CHARACTER VARYING(90) 90
45 INSURED2_SURNAME CHARACTER VARYING(90) 90
46 INSURED2_OTHER_NAME CHARACTER VARYING(120) 120
47 INSURED2_ADDRESS_LINE_1 CHARACTER VARYING(256) 256
48 INSURED2_ADDRESS_LINE_2 CHARACTER VARYING(256) 256
49 INSURED2_ADDRESS_LINE_3 CHARACTER VARYING(256) 256
50 INSURED2_ADDRESS_SUBURB CHARACTER VARYING(60) 60
51 INSURED2_ADDRESS_STATE CHARACTER VARYING(256) 256
52 INSURED2_ADDRESS_POSTCODE CHARACTER VARYING(50) 50
53 INSURED2_PHONE_HOME CHARACTER VARYING(30) 30
54 INSURED2_PHONE_WORK CHARACTER VARYING(24) 24
55 INSURED2_PHONE_MOBILE CHARACTER VARYING(30) 30
56 INSURED2_EMAIL CHARACTER VARYING(60) 60
57 MAIN_CONTACT_TITLE CHARACTER VARYING(256) 256
58 MAIN_CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
59 MAIN_CONTACT_SURNAME CHARACTER VARYING(90) 90
60 MAIN_CONTACT_OTHER_NAME CHARACTER VARYING(120) 120
61 MAIN_CONTACT_ADDRESS_LINE_1 CHARACTER VARYING(256) 256
62 MAIN_CONTACT_ADDRESS_LINE_2 CHARACTER VARYING(256) 256
63 MAIN_CONTACT_ADDRESS_LINE_3 CHARACTER VARYING(256) 256
64 MAIN_CONTACT_ADDRESS_SUBURB CHARACTER VARYING(60) 60
65 MAIN_CONTACT_ADDRESS_STATE CHARACTER VARYING(256) 256
66 MAIN_CONTACT_ADDRESS_POSTCODE CHARACTER VARYING(50) 50
67 MAIN_CONTACT_PHONE_HOME CHARACTER VARYING(30) 30
68 MAIN_CONTACT_PHONE_WORK CHARACTER VARYING(24) 24
69 MAIN_CONTACT_PHONE_MOBILE CHARACTER VARYING(30) 30
70 MAIN_CONTACT_EMAIL CHARACTER VARYING(60) 60
71 MAINCONTACT_ACCEPT_SMS CHARACTER VARYING(3) 3
72 MAIN_REPAIRER_ID BIGINT 8
73 MAIN_REPAIRER CHARACTER VARYING(120) 120
74 MAIN_REPAIRER_LOCATION CHARACTER VARYING(256) 256
75 MAIN_SUPPLIER_ID BIGINT 8
76 MAIN_SUPPLIER CHARACTER VARYING(120) 120
77 MAIN_SUPPLIER_LOCATION CHARACTER VARYING(256) 256
78 ASSESSOR_ID BIGINT 8
79 ASSESSOR_NAME CHARACTER VARYING(120) 120
80 ASSESSOR_LOCATION CHARACTER VARYING(256) 256
81 GROSS_CLAIMS_COST NUMERIC(38,2) 19
82 CLIENT_MANAGER CHARACTER VARYING(200) 200
83 CLIENT_MANAGER_LOCATION CHARACTER VARYING(100) 100
84 ASSIGNED_TEAM CHARACTER VARYING(100) 100
85 SUM_INSURED NUMERIC(18,2) 19
86 REOPENED_FLAG CHARACTER VARYING(1) 1
87 HOW_REPORTED CHARACTER VARYING(256) 256