FCT_MOTOR_CLAIMS_EVENT_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 LOSS_TYPE_CODE CHARACTER VARYING(50) 50
5 POLICY_ID BIGINT 8
6 POLICY_NUMBER CHARACTER VARYING(40) 40
7 LODGEMENT_DATE TIMESTAMP 8
8 UPDATETIME TIMESTAMP 8
9 EXTRACT_TIMESTAMP TIMESTAMP 8
10 RISK_STATE_ID BIGINT 8
11 RISK_REGION_NAME CHARACTER VARYING(15) 15
12 RISK_POSTCODE CHARACTER VARYING(60) 60
13 LOSS_STATE_ID BIGINT 8
14 LOSS_REGION_NAME CHARACTER VARYING(15) 15
15 LOSS_POSTCODE CHARACTER VARYING(60) 60
16 LINE_OF_BUSINESS_ID BIGINT 8
17 VEHICLE_STYLE_ID BIGINT 8
18 VEHICLE_INCIDENT_ID BIGINT 8
19 BRAND_ID BIGINT 8
20 CLAIM_DECISION_ID BIGINT 8
21 LOSS_TYPE_ID BIGINT 8
22 CREATE_DATE TIMESTAMP 8
23 CREATE_DATE_TEXT CHARACTER VARYING(30) 30
24 REOPEN_DATE TIMESTAMP 8
25 FINALISED_DATE TIMESTAMP 8
26 FIRST_REOPEN_DATE TIMESTAMP 8
27 LATEST_REOPEN_DATE TIMESTAMP 8
28 LATEST_FINALISED_DATE TIMESTAMP 8
29 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
30 CLAIM_STATE_ID INTEGER 4
31 REJECT_REASON_ID BIGINT 8
32 REOPEN_REASON_ID BIGINT 8
33 LOSS_CAUSE_ID BIGINT 8
34 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
35 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
36 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
37 LOSS_CAUSE_GROUP CHARACTER VARYING(14) 14
38 CATASTOPHE_ID BIGINT 8
39 CATASTROPHE_NUMBER CHARACTER VARYING(60) 60
40 CATASTROPHE_NAME CHARACTER VARYING(60) 60
41 PREMIUM_STATUS_ID BIGINT 8
42 POLICY_STATUS_ID BIGINT 8
43 POLICY_COVERAGE_TYPE_ID BIGINT 8
44 INVESTIGATION_STATUS_ID BIGINT 8
45 ADJUSTER_USER_ID BIGINT 8
46 CLAIM_CREATE_USER_ID BIGINT 8
47 CLAIM_UPDATE_USER_ID BIGINT 8
48 LODGEMENT_USER_ID BIGINT 8
49 LODGEMENT_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
50 LODGEMENT_USER_DATE_KEY CHARACTER VARYING(285) 285
51 LIABILITY_ASSESSMENT_ID BIGINT 8
52 EXCESS_RECEIVED_FLAG CHARACTER VARYING(9) 9
53 FIRST_EXCESS_RECEIVED_DATE TIMESTAMP 8
54 LATEST_EXCESS_RECEIVED_DATE TIMESTAMP 8
55 EXCESS_AMOUNT NUMERIC(38,2) 19
56 INITIAL_EXCESS_COLLECTION_AGE INTEGER 4
57 INITIAL_EXCESS_COLLECTION_AGE_BAND_ID INTEGER 4
58 DAMAGE_INDICATOR_FLAG CHARACTER VARYING(9) 9
59 VEHICLE_TOWED_FLAG CHARACTER VARYING(9) 9
60 VEHICLE_OPERABLE_FLAG CHARACTER VARYING(9) 9
61 EXCESS_WAIVED_FLAG CHARACTER VARYING(9) 9
62 TOTAL_EXCESS_APPLICABLE NUMERIC(18,2) 19
63 ASSESSMENT_BOOKING_CREATE_DATE TIMESTAMP 8
64 ASSESSMENT_BOOKING_APPOINTMENT_DATE TIMESTAMP 8
65 ASSESSMENT_BOOKING_UDPATE_DATE TIMESTAMP 8
66 CONTACT_ID BIGINT 8
67 ASSESSMENT_PROCESS_TYPE_ID BIGINT 8
68 ASSESSMENT_BOOKING_LOCATION_ID CHARACTER VARYING(30) 30
69 ASSESSMENT_BOOKING_LOCATION_TYPE_ID BIGINT 8
70 ASSESSMENT_BOOKING_LOCATION_STATE_ID BIGINT 8
71 CHOICE_OF_REPAIRER_FLAG CHARACTER VARYING(9) 9
72 BOOKING_COMPLETED_FLAG CHARACTER VARYING(9) 9
73 BOOK_APPOINTMENT_FLAG CHARACTER VARYING(9) 9
74 ASSESSMENT_BOOKING_STATUS_ID BIGINT 8
75 ASSESSMENT_NON_BOOKING_REASON_ID BIGINT 8
76 ASSESSMENT_BOOKING_CREATE_USER_ID BIGINT 8
77 ASSESSMENT_BOOKING_CREATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
78 ASSESSMENT_BOOKING_USER_DATE_KEY CHARACTER VARYING(285) 285
79 AGE_TO_ACTIVATE INTEGER 4
80 SMART_BOOKING_OPPORTUNITY_FLAG CHARACTER VARYING(1) 1
81 LOSS_PARTY_TYPE_ID BIGINT 8
82 BOOKING_CANCEL_REASON_ID BIGINT 8
83 ASSESSMENT_BOOKING_UPDATE_USER_ID BIGINT 8
84 ASSESSMENT_BOOKING_UPDATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
85 ASSESSMENT_BOOKING_UPDATE_USER_NAME CHARACTER VARYING(181) 181
86 ASSESSMENT_BOOKING_UPDATE_TEAM_ID BIGINT 8
87 ASSESSMENT_BOOKING_UPDATE_TEAM_NAME CHARACTER VARYING(100) 100
88 LICENSE_PLATE CHARACTER VARYING(40) 40
89 REPAIRER_ID BIGINT 8
90 REPAIRER_NAME CHARACTER VARYING(181) 181
91 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
92 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
93 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
94 CLAIM_PROCESS_TYPE_ID BIGINT 8
95 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
96 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
97 LOSSDATE TIMESTAMP 8
98 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
99 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
100 CCR_CC_POLICY_POLICYTYPE BIGINT 8
101 FLEET_IND CHARACTER VARYING(9) 9
102 CAS_IND CHARACTER VARYING(7) 7
103 POLICYNUMBER CHARACTER VARYING(40) 40
104 INSURED_NAME CHARACTER VARYING(181) 181
105 CLAIM_AGE_BAND_ID INTEGER 4
106 CLAIM_AGE_BAND_NAME CHARACTER VARYING(14) 14
107 CLAIM_SECONDARY_AGE_BAND_ID INTEGER 4
108 CLAIM_SECONDARY_AGE_BAND_NAME CHARACTER VARYING(14) 14
109 CLAIM_AGE INTEGER 4
110 ASSESSMENT_BOOKING_LOCATION_NAME CHARACTER VARYING(120) 120
111 ASSESSMENT_BOOKING_LOCATION_STATE_NAME CHARACTER VARYING(256) 256
112 ASSESSMENT_BOOKING_LOCATION_TYPE_NAME CHARACTER VARYING(256) 256
113 ASSESSMENT_BOOKING_STATUS_NAME CHARACTER VARYING(256) 256
114 ASSESSMENT_NON_BOOK_REASON_NAME CHARACTER VARYING(256) 256
115 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
116 BRAND_NAME CHARACTER VARYING(256) 256
117 CLAIM_DECISION_DESCRIPTION CHARACTER VARYING(512) 512
118 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
119 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
120 INITIAL_EXCESS_COLLECTION_AGE_BAND_NAME CHARACTER VARYING(9) 9
121 INVESTIGATION_STATUS_NAME CHARACTER VARYING(256) 256
122 LIABILITY_ASSESSMENT_DESCRIPTION CHARACTER VARYING(256) 256
123 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
124 LOSS_PARTY_TYPE_NAME CHARACTER VARYING(256) 256
125 LOSS_STATE_NAME CHARACTER VARYING(256) 256
126 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
127 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
128 POLICY_STATUS_NAME CHARACTER VARYING(256) 256
129 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
130 PREMIUM_STATUS_NAME CHARACTER VARYING(256) 256
131 PREMIUM_STATUS_GROUP CHARACTER VARYING(14) 14
132 REJECT_REASON_NAME CHARACTER VARYING(256) 256
133 REOPEN_REASON_NAME CHARACTER VARYING(256) 256
134 RISK_STATE_NAME CHARACTER VARYING(256) 256
135 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
136 ASSESSMENT_BOOKING_CREATE_TEAM_ID BIGINT 8
137 ASSESSMENT_BOOKING_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
138 ASSESSMENT_BOOKING_CREATE_USER_NAME CHARACTER VARYING(181) 181
139 CLAIM_CREATE_TEAM_ID BIGINT 8
140 CLAIM_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
141 CLAIM_CREATE_USER_NAME CHARACTER VARYING(181) 181
142 LODGEMENT_TEAM_ID BIGINT 8
143 LODGEMENT_TEAM_NAME CHARACTER VARYING(100) 100
144 LODGEMENT_USER_NAME CHARACTER VARYING(181) 181
145 ADJUSTER_TEAM_ID BIGINT 8
146 ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
147 ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
148 LODGEMENT_DATE_YEAR INTEGER 4
149 LODGEMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
150 LODGEMENT_DATE_QUARTER INTEGER 4
151 LODGEMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
152 LODGEMENT_DATE_MONTH INTEGER 4
153 LODGEMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
154 LODGEMENT_DATE_DAY INTEGER 4
155 LODGEMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
156 LODGEMENT_DATE_FIN_YEAR INTEGER 4
157 LODGEMENT_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
158 LODGEMENT_DATE_FIN_QUARTER INTEGER 4
159 LODGEMENT_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
160 LODGEMENT_DATE_FIN_MONTH INTEGER 4
161 LODGEMENT_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
162 LODGEMENT_DATE_FIN_DAY INTEGER 4
163 LODGEMENT_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
164 LODGEMENT_DATE_CURRENT_MONTH CHARACTER VARYING(18) 18
165 LODGEMENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(18) 18
166 ASSESSMENT_BOOKING_APPOINTMENT_DATE_YEAR INTEGER 4
167 ASSESSMENT_BOOKING_APPOINTMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
168 ASSESSMENT_BOOKING_APPOINTMENT_DATE_QUARTER INTEGER 4
169 ASSESSMENT_BOOKING_APPOINTMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
170 ASSESSMENT_BOOKING_APPOINTMENT_DATE_MONTH INTEGER 4
171 ASSESSMENT_BOOKING_APPOINTMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
172 ASSESSMENT_BOOKING_APPOINTMENT_DATE_DAY INTEGER 4
173 ASSESSMENT_BOOKING_APPOINTMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
174 ASSESSMENT_BOOKING_CREATE_DATE_YEAR INTEGER 4
175 ASSESSMENT_BOOKING_CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
176 ASSESSMENT_BOOKING_CREATE_DATE_QUARTER INTEGER 4
177 ASSESSMENT_BOOKING_CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
178 ASSESSMENT_BOOKING_CREATE_DATE_MONTH INTEGER 4
179 ASSESSMENT_BOOKING_CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
180 ASSESSMENT_BOOKING_CREATE_DATE_DAY INTEGER 4
181 ASSESSMENT_BOOKING_CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
182 CREATE_DATE_YEAR INTEGER 4
183 CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
184 CREATE_DATE_QUARTER INTEGER 4
185 CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
186 CREATE_DATE_MONTH INTEGER 4
187 CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
188 CREATE_DATE_DAY INTEGER 4
189 CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
190 CREATE_DATE_FIN_YEAR INTEGER 4
191 CREATE_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
192 CREATE_DATE_FIN_QUARTER INTEGER 4
193 CREATE_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
194 CREATE_DATE_FIN_MONTH INTEGER 4
195 CREATE_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
196 CREATE_DATE_FIN_DAY INTEGER 4
197 CREATE_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
198 CREATE_DATE_CURRENT_MONTH CHARACTER VARYING(18) 18
199 CREATE_DATE_PREVIOUS_MONTH CHARACTER VARYING(18) 18
200 FINALISED_DATE_YEAR INTEGER 4
201 FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
202 FINALISED_DATE_QUARTER INTEGER 4
203 FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
204 FINALISED_DATE_MONTH INTEGER 4
205 FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
206 FINALISED_DATE_DAY INTEGER 4
207 FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
208 REOPEN_DATE_YEAR INTEGER 4
209 REOPEN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
210 REOPEN_DATE_QUARTER INTEGER 4
211 REOPEN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
212 REOPEN_DATE_MONTH INTEGER 4
213 REOPEN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
214 REOPEN_DATE_DAY INTEGER 4
215 REOPEN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
216 LATEST_REOPEN_DATE_YEAR INTEGER 4
217 LATEST_REOPEN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
218 LATEST_REOPEN_DATE_QUARTER INTEGER 4
219 LATEST_REOPEN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
220 LATEST_REOPEN_DATE_MONTH INTEGER 4
221 LATEST_REOPEN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
222 LATEST_REOPEN_DATE_DAY INTEGER 4
223 LATEST_REOPEN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
224 LATEST_FINALISED_DATE_YEAR INTEGER 4
225 LATEST_FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
226 LATEST_FINALISED_DATE_QUARTER INTEGER 4
227 LATEST_FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
228 LATEST_FINALISED_DATE_MONTH INTEGER 4
229 LATEST_FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
230 LATEST_FINALISED_DATE_DAY INTEGER 4
231 LATEST_FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
232 FIRST_EXCESS_RECEIVED_DATE_YEAR INTEGER 4
233 FIRST_EXCESS_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
234 FIRST_EXCESS_RECEIVED_DATE_QUARTER INTEGER 4
235 FIRST_EXCESS_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
236 FIRST_EXCESS_RECEIVED_DATE_MONTH INTEGER 4
237 FIRST_EXCESS_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
238 FIRST_EXCESS_RECEIVED_DATE_DAY INTEGER 4
239 FIRST_EXCESS_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
240 LATEST_EXCESS_RECEIVED_DATE_YEAR INTEGER 4
241 LATEST_EXCESS_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
242 LATEST_EXCESS_RECEIVED_DATE_QUARTER INTEGER 4
243 LATEST_EXCESS_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
244 LATEST_EXCESS_RECEIVED_DATE_MONTH INTEGER 4
245 LATEST_EXCESS_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
246 LATEST_EXCESS_RECEIVED_DATE_DAY INTEGER 4
247 LATEST_EXCESS_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
248 LOSS_DATE_YEAR INTEGER 4
249 LOSS_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
250 LOSS_DATE_QUARTER INTEGER 4
251 LOSS_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
252 LOSS_DATE_MONTH INTEGER 4
253 LOSS_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
254 LOSS_DATE_DAY INTEGER 4
255 LOSS_DATE_DAY_LABEL CHARACTER VARYING(13) 13