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