FCT_CI_MOTOR_CLAIMANT_SATISFACTION

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SURVEY_DUE_DATE CHARACTER VARYING(10) 10
2 CLAIM_TYPE CHARACTER VARYING(50) 50
3 BRAND CHARACTER VARYING(256) 256
4 CLAIM_NUMBER CHARACTER VARYING(40) 40
5 TYPE CHARACTER VARYING(10) 10
6 COST_OF_CLAIM NUMERIC(18,2) 19
7 INSURED_BUSINESS_NAME CHARACTER VARYING(181) 181
8 MAIN_CONTACT CHARACTER VARYING(256) 256
9 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
10 FLEET_IND CHARACTER VARYING(9) 9
11 CAS_IND CHARACTER VARYING(9) 9
12 LOSS_TYPE CHARACTER VARYING(50) 50
13 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
14 CONTACT_TYPE CHARACTER VARYING(50) 50
15 COVER_TYPE CHARACTER VARYING(256) 256
16 VEHICLE_STYLE CHARACTER VARYING(256) 256
17 MAIN_CONTACT_TITLE CHARACTER VARYING(256) 256
18 MAIN_CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
19 MAIN_CONTACT_SURNAME CHARACTER VARYING(90) 90
20 INSURED_TITLE CHARACTER VARYING(256) 256
21 INSURED_FIRST_NAME CHARACTER VARYING(90) 90
22 INSURED_SURNAME CHARACTER VARYING(90) 90
23 INSURED_OTHER_NAME CHARACTER VARYING(181) 181
24 ASSMNT_LOCATION_TYPE CHARACTER VARYING(256) 256
25 ASSMNT_WORK_LOCN_ID BIGINT 8
26 ASSMNT_WORK_LOCN_NAME CHARACTER VARYING(120) 120
27 ASSMNT_WORK_LOCN_STATE CHARACTER VARYING(50) 50
28 INSURED_STATE CHARACTER VARYING(256) 256
29 INSURED_ADDRESS_LINE_1 CHARACTER VARYING(55) 55
30 INSURED_ADDRESS_LINE_2 CHARACTER VARYING(55) 55
31 INSURED_ADDRESS_LINE_3 CHARACTER VARYING(55) 55
32 INSURED_ADDRESS_SUBURB CHARACTER VARYING(60) 60
33 INSURED_ADDRESS_POSTCODE CHARACTER VARYING(60) 60
34 INSURED_ADDRESS_STATE CHARACTER VARYING(50) 50
35 MAIN_CONTACT_PHONE_WORK CHARACTER VARYING(24) 24
36 INSURED_PHONE_WORK CHARACTER VARYING(24) 24
37 MAIN_CONTACT_PHONE_HOME CHARACTER VARYING(30) 30
38 INSURED_PHONE_HOME CHARACTER VARYING(30) 30
39 MAIN_CONTACT_PHONE_MOBILE CHARACTER VARYING(30) 30
40 INSURED_PHONE_MOBILE CHARACTER VARYING(30) 30
41 MAIN_CONTACT_EMAIL CHARACTER VARYING(60) 60
42 INSURED_MAIL CHARACTER VARYING(60) 60
43 RISK_STATE CHARACTER VARYING(50) 50
44 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
45 LODGEMENT_DATE CHARACTER VARYING(10) 10
46 REPAIR_ACTUAL_COMPLETION_DATE CHARACTER VARYING(10) 10
47 CLAIM_CLOSED_DATE CHARACTER VARYING(10) 10
48 CLAIM_STATUS CHARACTER VARYING(256) 256
49 REPAIRER_ID BIGINT 8
50 REPAIRER_NAME CHARACTER VARYING(120) 120
51 REPAIRER_LOCATION CHARACTER VARYING(50) 50
52 ASSESSOR_ID BIGINT 8
53 ASSESSOR_NAME CHARACTER VARYING(181) 181
54 VEHICLE_RETURNED_DATE CHARACTER VARYING(10) 10
55 CATASTROPHE_CODE BIGINT 8
56 CATASTROPHE_DESC CHARACTER VARYING(120) 120
57 LOSS_CAUSE CHARACTER VARYING(256) 256
58 LOSS_SUB_CAUSE CHARACTER VARYING(256) 256
59 EXTRACT_DUE_DATE CHARACTER VARYING(10) 10
60 INVOICE_DATE CHARACTER VARYING(10) 10
61 INTERMEDIARY_TYPE CHARACTER VARYING(256) 256
62 INTERMEDIARY_NAME CHARACTER VARYING(180) 180
63 DEDUP BIGINT 8
64 HIGH_PERFORMANCE_INDICATOR CHARACTER VARYING(3) 3
65 UNIQUE_VEHICLE_FLAG CHARACTER VARYING(3) 3
66 MAIN_CONTACT_ACCEPT_SMS CHARACTER VARYING(3) 3
67 INSURED_ACCEPT_SMS CHARACTER VARYING(3) 3
68 POLICY_NUMBER CHARACTER VARYING(40) 40
69 CONTACT_PROHIBITED INTEGER 4
70 POLICYTYPE CHARACTER VARYING(256) 256
71 HOW_REPORTED CHARACTER VARYING(256) 256
72 VEHICLE_COLLECTED_DATE CHARACTER VARYING(10) 10
73 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
74 ASSESSOR_TYPE CHARACTER VARYING(17) 17
75 REPLACEMENT_VEHICLE_FLAG CHARACTER VARYING(1) 1
76 TOTAL_LOSS_FULFILLED_DATE CHARACTER VARYING(10) 10
77 PRIMARY_ADJUSTER CHARACTER VARYING(181) 181