INT_MOTOR_CLAIMANT_SATISFACTION_CI

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_DATE DATE 4
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
3 CLAIM_ID BIGINT 8
4 FLEET_IND CHARACTER VARYING(9) 9
5 CAS_IND CHARACTER VARYING(9) 9
6 CONTACT_TYPE CHARACTER VARYING(50) 50
7 CLAIM_NUMBER CHARACTER VARYING(40) 40
8 ROLE_ID BIGINT 8
9 INCIDENT_INSURED_CCR_CC_INCIDENT_ID BIGINT 8
10 PRODUCT_ID BIGINT 8
11 LOSSCAUSE_ID BIGINT 8
12 LOSSCAUSESUBTYPE_ID BIGINT 8
13 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
14 CLAIMSTATE_ID BIGINT 8
15 CLAIMSTATE_NAME CHARACTER VARYING(256) 256
16 POLICYTYPE_ID BIGINT 8
17 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
18 LINE_OF_BUSINESS_ID BIGINT 8
19 BRAND_ID BIGINT 8
20 RISK_STATE_ID BIGINT 8
21 LODGEMENT_DATE DATE 4
22 LODGEMENT_TIME TIMESTAMP 8
23 CLOSED_DATE DATE 4
24 FINALISED_DATE TIMESTAMP 8
25 REOPENED_DATE DATE 4
26 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
27 REOPENED_FLAG INTEGER 4
28 CATASTOPHE_ID BIGINT 8
29 INSURED_CONTACT_ID BIGINT 8
30 INSURED_NAME CHARACTER VARYING(181) 181
31 BUSINESS_NAME CHARACTER VARYING(181) 181
32 INSURED_FIRST_NAME CHARACTER VARYING(90) 90
33 INSURED_LAST_NAME CHARACTER VARYING(90) 90
34 INSURED_TITLE CHARACTER VARYING(256) 256
35 INSURED_WORK_PHONE CHARACTER VARYING(24) 24
36 INSURED_HOME_PHONE CHARACTER VARYING(30) 30
37 INSURED_MOBILE_PHONE CHARACTER VARYING(30) 30
38 INSURED_EMAIL CHARACTER VARYING(60) 60
39 INSURED_ACCEPTS_SMS CHARACTER VARYING(3) 3
40 INSURED_CITY CHARACTER VARYING(60) 60
41 INSURED_POSTALCODE CHARACTER VARYING(60) 60
42 INSURED_STATE CHARACTER VARYING(256) 256
43 INSURED_STATE_ID CHARACTER VARYING(50) 50
44 INSURED_ADDRESSLINE1 CHARACTER VARYING(55) 55
45 INSURED_ADDRESSLINE2 CHARACTER VARYING(55) 55
46 INSURED_ADDRESSLINE3 CHARACTER VARYING(55) 55
47 MAIN_CONTACT_NAME CHARACTER VARYING(181) 181
48 MAIN_CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
49 MAIN_CONTACT_LAST_NAME CHARACTER VARYING(90) 90
50 MAIN_CONTACT_TITLE CHARACTER VARYING(256) 256
51 MAIN_CONTACT_WORK_PHONE CHARACTER VARYING(24) 24
52 MAIN_CONTACT_HOME_PHONE CHARACTER VARYING(30) 30
53 MAIN_CONTACT_MOBILE_PHONE CHARACTER VARYING(30) 30
54 MAIN_CONTACT_EMAIL CHARACTER VARYING(60) 60
55 MAIN_CONTACT_ACCEPTS_SMS CHARACTER VARYING(3) 3
56 MAIN_CONTACT_CITY CHARACTER VARYING(60) 60
57 MAIN_CONTACT_POSTALCODE CHARACTER VARYING(60) 60
58 MAIN_CONTACT_STATE CHARACTER VARYING(256) 256
59 MAIN_CONTACT_STATE_ID CHARACTER VARYING(50) 50
60 MAIN_CONTACT_ADDRESSLINE1 CHARACTER VARYING(55) 55
61 MAIN_CONTACT_ADDRESSLINE2 CHARACTER VARYING(55) 55
62 MAIN_CONTACT_ADDRESSLINE3 CHARACTER VARYING(55) 55
63 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
64 VEHICLE_COLLECTED_DATE TIMESTAMP 8
65 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
66 ADJUSTER_FIRSTNAME CHARACTER VARYING(90) 90
67 ADJUSTER_LASTNAME CHARACTER VARYING(90) 90
68 ADJUSTER_MIDDLENAME CHARACTER VARYING(90) 90
69 REPAIR_ACTUAL_COMPLETION_DATE_14DAYS DATE 4
70 POLICY_COVERAGE_TYPE_ID BIGINT 8
71 VEHICLE_STYLE_ID BIGINT 8
72 FINALISED_OUTCOME_ID BIGINT 8
73 CCR_CCTL_SC_CLAIMDECISION_ID BIGINT 8
74 CLAIM_DECISION_ID BIGINT 8
75 ASSESSMENTPROCESSTYPE_ID BIGINT 8
76 ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
77 ASSESSOR_ID BIGINT 8
78 VEHICLE_RETURNED_DATE TIMESTAMP 8
79 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
80 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
81 CCR_CCTL_SIUSTATUS_ID BIGINT 8
82 CCR_CCTL_SIUSTATUS_NAME CHARACTER VARYING(256) 256
83 REFER_INVESTIGATION_FLAG CHARACTER VARYING(3) 3
84 SPECIALNEED_TYPE_NAME CHARACTER VARYING(50) 50
85 SPECIALNEED_TYPE_CODE BIGINT 8
86 REPAIRER_ID BIGINT 8
87 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
88 ABLOCATION_CCR_ABTL_STATE_ID BIGINT 8
89 ASSMNT_LOCATION_TYPE_ID BIGINT 8
90 REPAIRER_STATE_ID BIGINT 8
91 ASSMNT_LOCATION_TYPE_NAME CHARACTER VARYING(256) 256
92 POLICY_INTERMEDIARY_ID BIGINT 8
93 INCIDENT_REPAIR_COST_NET_GST NUMERIC(31,2) 19
94 INVOICEDATE DATE 4
95 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE_14DAYS DATE 4
96 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(256) 256
97 INTERMEDIARY_CCR_CC_CLAIMCONTACT_CONTACTID BIGINT 8
98 VEHICLE_HIGHPERFORMANCEIND CHARACTER VARYING(3) 3
99 UNIQUEVEHICLE CHARACTER VARYING(3) 3
100 POLICY_NUMBER CHARACTER VARYING(40) 40
101 CLAIM_COUNT INTEGER 4
102 INTERMEDIARY_TYPE_CODE CHARACTER VARYING(50) 50
103 CURRENT_FLAG CHARACTER VARYING(3) 3
104 LODGMENT_DATE_BAND_ID INTEGER 4
105 LODGMENT_DATE_BAND_NAME CHARACTER VARYING(21) 21
106 CLAIM_REOPEN_FLAG CHARACTER VARYING(3) 3
107 INCIDENT_REPAIR_COST_GROSS_GST NUMERIC(31,2) 19
108 INCIDENT_REPAIR_COST_NET_GST_BAND INTEGER 4
109 INCIDENT_REPAIR_COST_NET_GST_BAND_NAME CHARACTER VARYING(18) 18
110 INCIDENT_REPAIR_COST_GROSS_GST_BAND INTEGER 4
111 INCIDENT_REPAIR_COST_GROSS_GST_BAND_NAME CHARACTER VARYING(18) 18