MCFD_CLAIM_SETTLEMENT_MOTOR_PI

Database

INSNZP01_CL

Schema

CLPADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND CHARACTER VARYING(256) 256
3 LOSS_TYPE CHARACTER VARYING(50) 50
4 COVER_TYPE CHARACTER VARYING(256) 256
5 VEHICLE_STYLE CHARACTER VARYING(256) 256
6 MAIN_CONTACT_TITLE CHARACTER VARYING(256) 256
7 MAIN_CONTACT_FIRSTNAME CHARACTER VARYING(90) 90
8 MAIN_CONTACT_LASTNAME CHARACTER VARYING(90) 90
9 INSURED_TITLE CHARACTER VARYING(256) 256
10 INSURED_FIRSTNAME CHARACTER VARYING(90) 90
11 INSURED_LASTNAME CHARACTER VARYING(90) 90
12 INSURED_OTHERNAME CHARACTER VARYING(120) 120
13 ASSESSMENT_LOCATION_TYPE_NAME CHARACTER VARYING(256) 256
14 ASSESSMENT_WORK_LOCATION_ID CHARACTER VARYING(20) 20
15 ASSESSMENT_WORK_LOCATION_NAME CHARACTER VARYING(120) 120
16 ASSESSMENT_WORK_LOCATION_STATE CHARACTER VARYING(50) 50
17 INSURED_STATE CHARACTER VARYING(50) 50
18 INSURED_ADDRESS_LINE_1 CHARACTER VARYING(55) 55
19 INSURED_ADDRESS_LINE_2 CHARACTER VARYING(55) 55
20 INSURED_ADDRESS_LINE_3 CHARACTER VARYING(55) 55
21 INSURED_ADDRESS_POSTCODE CHARACTER VARYING(60) 60
22 INSURED_ADDRESS_SUBURB CHARACTER VARYING(60) 60
23 MAIN_CONTACT_PHONE_WORK CHARACTER VARYING(24) 24
24 INSURED_PHONE_WORK CHARACTER VARYING(24) 24
25 MAIN_CONTACT_PHONE_HOME CHARACTER VARYING(30) 30
26 INSURED_PHONE_HOME CHARACTER VARYING(30) 30
27 MAIN_CONTACT_PHONE_MOBILE CHARACTER VARYING(30) 30
28 INSURED_PHONE_MOBILE CHARACTER VARYING(30) 30
29 MAIN_CONTACT_EMAIL CHARACTER VARYING(60) 60
30 MAIN_CONTACT_EMAILIDENTIFIER CHARACTER VARYING(60) 60
31 INSURED_EMAIL CHARACTER VARYING(60) 60
32 MAIN_CONTACT_ACCEPT_SMS CHARACTER VARYING(3) 3
33 INSURED_ACCEPT_SMS CHARACTER VARYING(3) 3
34 RISK_STATE CHARACTER VARYING(50) 50
35 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
36 LODGEMENT_DATE CHARACTER VARYING(200) 200
37 REPAIR_ACTUAL_COMPLETION_DATE CHARACTER VARYING(200) 200
38 TOTAL_LOSS_FULFILLED_DATE DATE 4
39 EXTRACT_DUE_DATE CHARACTER VARYING(200) 200
40 INVOICE_DATE CHARACTER VARYING(200) 200
41 CLAIM_CLOSED_DATE CHARACTER VARYING(200) 200
42 CLAIM_STATUS CHARACTER VARYING(256) 256
43 REPAIRER_ID CHARACTER VARYING(20) 20
44 REPAIRER_NAME CHARACTER VARYING(120) 120
45 REPAIRER_LOCATION CHARACTER VARYING(50) 50
46 ASSESSOR_ID CHARACTER VARYING(20) 20
47 ASSESSOR_NAME CHARACTER VARYING(181) 181
48 VEHICLE_RETURNED_DATE CHARACTER VARYING(200) 200
49 CATASTROPHE_DESC CHARACTER VARYING(60) 60
50 CATASTROPHE_CODE CHARACTER VARYING(60) 60
51 LOSS_CAUSE CHARACTER VARYING(256) 256
52 LOSS_SUBCAUSE CHARACTER VARYING(256) 256
53 INTERMEDIARY_TYPE CHARACTER VARYING(256) 256
54 INTERMEDIARY_NAME CHARACTER VARYING(180) 180
55 HIGH_PERFORMANCE_INDICATOR CHARACTER VARYING(3) 3
56 UNIQUE_VEHICLE_FLAG CHARACTER VARYING(3) 3
57 POLICY_NUMBER CHARACTER VARYING(40) 40
58 REPORT_DATE CHARACTER VARYING(200) 200
59 VEHICLE_MAKE CHARACTER VARYING(60) 60
60 VEHICLE_MODEL CHARACTER VARYING(80) 80
61 VEHICLE_YEAR CHARACTER VARYING(20) 20
62 QUALITYISSUE_FLAG CHARACTER VARYING(1) 1
63 CLAIM_SELF_SERVICE_FLAG CHARACTER VARYING(1) 1
64 EXCESS_AMOUNT CHARACTER VARYING(20) 20
65 FULFILMENT_VALUE CHARACTER VARYING(20) 20
66 ASSESSOR_TYPE CHARACTER VARYING(17) 17
67 VEHICLE_FINANCED_FLAG CHARACTER VARYING(3) 3
68 POLICY_PAYMENT_MODE CHARACTER VARYING(256) 256
69 ACTIVITY_OVERDUE_FLAG CHARACTER VARYING(1) 1
70 CLAIMANT_TOTAL_PAYMENTS NUMERIC(38,2) 19
71 TOTAL_PAYMENTS NUMERIC(18,2) 19
72 TOTAL_LOSS_FLAG CHARACTER VARYING(3) 3
73 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
74 SURVEY_DATE TIMESTAMP 8
75 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
76 HOW_REPORTED CHARACTER VARYING(256) 256
77 POLICYTYPE CHARACTER VARYING(256) 256
78 REPLACEMENT_VEHICLE_FLAG CHARACTER VARYING(1) 1
79 TIMESTAMP TIMESTAMP 8