FCT_POLICY_JCI

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 QUOTE_NUMBER CHARACTER VARYING(13) 13
2 COVERNOTE_NUMBER CHARACTER VARYING(13) 13
3 POLICY_NUMBER CHARACTER VARYING(13) 13
4 CLIENT_NUMBER CHARACTER VARYING(13) 13
5 COMPANY SMALLINT 2
6 JCI_CLIENT_NUMBER INTEGER 4
7 CLIENT_TYPE CHARACTER(2) 2
8 CLIENT_STATUS CHARACTER(1) 1
9 GST_REG CHARACTER(1) 1
10 CTP_FLEET CHARACTER(1) 1
11 ABN NUMERIC(11,0) 19
12 SURNAME_1 CHARACTER(40) 40
13 TITLE_1 CHARACTER(10) 10
14 GIVEN_NAMES_1 CHARACTER(40) 40
15 INITIALS_1 CHARACTER(5) 5
16 SEX_1 CHARACTER(1) 1
17 BIRTHDTE_1_DAY CHARACTER VARYING(2) 2
18 BIRTHDTE_1_MONTH CHARACTER VARYING(2) 2
19 BIRTHDTE_1_YEAR CHARACTER VARYING(4) 4
20 OCCUPATN_1 CHARACTER(4) 4
21 SURNAME_2 CHARACTER(40) 40
22 TITLE_2 CHARACTER(10) 10
23 GIVEN_NAMES_2 CHARACTER(40) 40
24 INITIALS_2 CHARACTER(5) 5
25 SEX_2 CHARACTER(1) 1
26 BIRTHDTE_2_DAY CHARACTER VARYING(2) 2
27 BIRTHDTE_2_MONTH CHARACTER VARYING(2) 2
28 BIRTHDTE_2_YEAR CHARACTER VARYING(4) 4
29 TELE_FAX_AREACDE CHARACTER(4) 4
30 CONTACT_NAMES CHARACTER(80) 80
31 MOBILE CHARACTER(10) 10
32 TELE_PRIV_AREACDE CHARACTER(10) 10
33 TELE_PRIV CHARACTER(10) 10
34 TELE_BUS_AREACDE CHARACTER(10) 10
35 TELE_BUS CHARACTER(10) 10
36 FAX CHARACTER(10) 10
37 BUILDING_OR_PROPERTY_NAME CHARACTER VARYING(30) 30
38 IND1 CHARACTER(2) 2
39 ADDRN01 CHARACTER(8) 8
40 IND2 CHARACTER(2) 2
41 ADDRN02 CHARACTER(8) 8
42 STREET_NO_IND CHARACTER(9) 9
43 STREET CHARACTER VARYING(40) 40
44 STREETYPE CHARACTER(4) 4
45 CITY CHARACTER VARYING(40) 40
46 STATE CHARACTER VARYING(3) 3
47 POSTCODE CHARACTER(9) 9
48 COUNTRY CHARACTER(3) 3
49 DIRECT_MARKETING CHARACTER(1) 1
50 NUMBER_OF_CLAIMS INTEGER 4
51 NUMBER_OF_POLICIES SMALLINT 2
52 AGENT CHARACTER VARYING(9) 9
53 BRANCH SMALLINT 2
54 POLICY_STATUS CHARACTER(1) 1
55 REASON SMALLINT 2
56 EFFECTIVE_DATE CHARACTER VARYING(10) 10
57 DUE_DATE CHARACTER VARYING(10) 10
58 INCEPTION CHARACTER VARYING(10) 10
59 NOTICE_TYPE CHARACTER(1) 1
60 NOTICE_TO CHARACTER(1) 1
61 REVIEW CHARACTER(1) 1
62 POLICY_TERM SMALLINT 2
63 ENDORSE CHARACTER(1) 1
64 SPECIAL_ENDORSE CHARACTER(1) 1
65 INSTAL_FRQ CHARACTER(1) 1
66 PREV_POLICY CHARACTER VARYING(15) 15
67 TRADING_AS CHARACTER(40) 40
68 CLASS CHARACTER(3) 3
69 SUBCLASS CHARACTER(3) 3
70 INPUT_SUBCLASS_AAMI CHARACTER VARYING(1) 1
71 INPUT_SUBCLASS_SHANNONS CHARACTER VARYING(1) 1
72 OPTBOUGHT CHARACTER(2) 2
73 OPTPRM2 NUMERIC(11,2) 19
74 MVSIDLGDE NUMERIC(7,0) 19
75 MVMAKE CHARACTER(4) 4
76 MVMODEL CHARACTER(6) 6
77 MVSTAMAKE CHARACTER(6) 6
78 MVBODTYPE CHARACTER(2) 2
79 MVMANUFYR SMALLINT 2
80 MVGEARS NUMERIC(1,0) 19
81 MVENGCAP SMALLINT 2
82 MVTRANS CHARACTER(1) 1
83 MVNOCYL CHARACTER(3) 3
84 VIN_ENGINE_NUMBER CHARACTER(20) 20
85 RISKDESC1 CHARACTER(50) 50
86 MOD_1_CODE CHARACTER VARYING(2) 2
87 MOD_1_DESC CHARACTER VARYING(41) 41
88 MOD_2_CODE CHARACTER VARYING(2) 2
89 MOD_2_DESC CHARACTER VARYING(41) 41
90 MOD_3_CODE CHARACTER VARYING(2) 2
91 MOD_3_DESC CHARACTER VARYING(41) 41
92 MOD_4_CODE CHARACTER VARYING(2) 2
93 MOD_4_DESC CHARACTER VARYING(41) 41
94 MOD_5_CODE CHARACTER VARYING(2) 2
95 MOD_5_DESC CHARACTER VARYING(41) 41
96 MOD_6_CODE CHARACTER VARYING(2) 2
97 MOD_6_DESC CHARACTER VARYING(41) 41
98 MOD_7_CODE CHARACTER VARYING(2) 2
99 MOD_7_DESC CHARACTER VARYING(41) 41
100 MOD_8_CODE CHARACTER VARYING(2) 2
101 MOD_8_DESC CHARACTER VARYING(41) 41
102 RISK_IND1 CHARACTER(2) 2
103 RISK_ADDRN01 CHARACTER(8) 8
104 STREETNUM CHARACTER(9) 9
105 RISK_STREET CHARACTER VARYING(40) 40
106 RISK_STREETTYP CHARACTER(4) 4
107 RISK_CITY CHARACTER VARYING(40) 40
108 ADDRREF INTEGER 4
109 RISK_POSTCODE CHARACTER(9) 9
110 MVFINANCE CHARACTER(1) 1
111 INPUT_MVFINANCE_AAMI CHARACTER VARYING(1) 1
112 INPUT_MVFINANCE_SHANNONS CHARACTER VARYING(1) 1
113 SUMINS INTEGER 4
114 EXCESS INTEGER 4
115 EXCESS_AAMI_STANDARD INTEGER 4
116 EXCESS_AAMI_VOLX INTEGER 4
117 EXCESS_SHANNONS_JCITOTAL INTEGER 4
118 EXCESS_AAMI_SHANNONS INTEGER 4
119 UNREPAIRED_DAMAGE CHARACTER(1) 1
120 MVRATING CHARACTER(2) 2
121 MVRATING_SHANNONS CHARACTER VARYING(1) 1
122 REGISTRATION_NUMBER CHARACTER VARYING(8) 8
123 MVEXCESS1 INTEGER 4
124 MVEXSTYP1 CHARACTER(1) 1
125 MVEXCESS2 INTEGER 4
126 MVEXSTYP2 CHARACTER(1) 1
127 VEH_EXCESS_STD INTEGER 4
128 VEH_EXCESS_HP INTEGER 4
129 VEH_EXCESS_MOD INTEGER 4
130 VEH_EXCESS_TOT INTEGER 4
131 THEFT_EXCESS_VEH INTEGER 4
132 THEFT_EXCESS_HIST INTEGER 4
133 THEFT_EXCESS_TOT INTEGER 4
134 VEH_EXCESS_CAT CHARACTER(2) 2
135 THEFT_EXCESS_CAT CHARACTER(2) 2
136 BUSINESS_USAGE_EXCESS INTEGER 4
137 ACCESSORY_EXCESS INTEGER 4
138 NAMED_DRIVER_EXCESS INTEGER 4
139 BUSINESS_USE CHARACTER(2) 2
140 BUSINESS_USE_AAMI CHARACTER VARYING(1) 1
141 BUSINESS_USE_SHANNONS CHARACTER VARYING(1) 1
142 MAIN_DRIVER_DOB CHARACTER VARYING(10) 10
143 ACCESS_1_CODE_JCI CHARACTER(2) 2
144 ACCESS_1_CODE_DESC CHARACTER(60) 60
145 ACCESS_1_CODE_SHANNONS CHARACTER VARYING(2) 2
146 ACCESS_2_CODE_JCI CHARACTER(2) 2
147 ACCESS_2_CODE_DESC CHARACTER(60) 60
148 ACCESS_2_CODE_SHANNONS CHARACTER VARYING(2) 2
149 ACCESS_3_CODE_JCI CHARACTER(2) 2
150 ACCESS_3_CODE_DESC CHARACTER(60) 60
151 ACCESS_3_CODE_SHANNONS CHARACTER VARYING(2) 2
152 ACCESS_4_CODE_JCI CHARACTER(2) 2
153 ACCESS_4_CODE_DESC CHARACTER(60) 60
154 ACCESS_4_CODE_SHANNONS CHARACTER VARYING(2) 2
155 ACCESS_5_CODE_JCI CHARACTER(2) 2
156 ACCESS_5_CODE_DESC CHARACTER(60) 60
157 ACCESS_5_CODE_SHANNONS CHARACTER VARYING(2) 2
158 ACCESS_6_CODE_JCI CHARACTER(2) 2
159 ACCESS_6_CODE_DESC CHARACTER(60) 60
160 ACCESS_6_CODE_SHANNONS CHARACTER VARYING(2) 2
161 ACCESS_7_CODE_JCI CHARACTER(2) 2
162 ACCESS_7_CODE_DESC CHARACTER(60) 60
163 ACCESS_7_CODE_SHANNONS CHARACTER VARYING(2) 2
164 ACCESS_8_CODE_JCI CHARACTER(2) 2
165 ACCESS_8_CODE_DESC CHARACTER(60) 60
166 ACCESS_8_CODE_SHANNONS CHARACTER VARYING(2) 2
167 MAKE_AAMI CHARACTER(22) 22
168 MODEL_DESC CHARACTER VARYING(66) 66
169 YEAR_OF_MANU_AAMI SMALLINT 2
170 TRANS_AAMI CHARACTER(20) 20
171 BODY_TYPE_AAMI CHARACTER(10) 10
172 SERIES_AAMI CHARACTER(10) 10
173 MVMAKE_SHANNONS NATIONAL CHARACTER VARYING(100) 100
174 MVMANUYR_SHANNONS NUMERIC(31,0) 19
175 DESC_SHANNONS NATIONAL CHARACTER VARYING(200) 200
176 MVAUTO_SHANNONS CHARACTER(1) 1
177 MVTYPE_SHANNONS CHARACTER(2) 2
178 SERIES_SHANNONS CHARACTER(2) 2
179 OTHER_PARTIES CHARACTER VARYING(1) 1
180 OTHER_PARTY_TYPE CHARACTER(1) 1
181 OTHER_PARTY_NAME CHARACTER(40) 40
182 OTHER_PARTY_IND1 CHARACTER(2) 2
183 OTHER_PARTY_ADDRN01 CHARACTER(8) 8
184 OTHER_PARTY_IND2 CHARACTER(2) 2
185 OTHER_PARTY_ADDRN02 CHARACTER(8) 8
186 OTHER_PARTY_STREET_NO_IND CHARACTER(9) 9
187 OTHER_PARTY_STREET CHARACTER VARYING(40) 40
188 OTHER_PARTY_CITY CHARACTER VARYING(40) 40
189 OTHER_PARTY_STATE CHARACTER VARYING(3) 3
190 OTHER_PARTY_POSTCODE CHARACTER(9) 9
191 OTHER_PARTY_COUNTRY CHARACTER(3) 3
192 OTHER_PARTY_CLIENT_NUMBER INTEGER 4
193 CAPPING_PERCENTAGE CHARACTER VARYING(1) 1
194 CAPPING_RSNCDE CHARACTER VARYING(1) 1
195 CUPPING_PERCENTAGE CHARACTER VARYING(1) 1
196 CUPPING_RSNCDE CHARACTER VARYING(1) 1
197 DRIVER1_AGE BIGINT 8
198 DRIVER2_AGE BIGINT 8
199 DRIVER3_AGE BIGINT 8
200 DRIVER4_AGE BIGINT 8
201 DRIVER5_AGE BIGINT 8
202 DRIVER6_AGE BIGINT 8
203 MAKE_AAMI_CODE CHARACTER VARYING(3) 3
204 MVDRIVTYP CHARACTER(3) 3
205 MVACCIND CHARACTER(1) 1
206 MVCONIND CHARACTER(1) 1
207 NO_OF_DRIVER BIGINT 8
208 DRIVER1_MVDRIVNO NUMERIC(2,0) 19
209 DRIVER1_TITLE CHARACTER(10) 10
210 DRIVER1_INITIALS CHARACTER(5) 5
211 DRIVER1_FIRSTNAME CHARACTER(40) 40
212 DRIVER1_SURNAME CHARACTER(40) 40
213 DRIVER1_GENDER CHARACTER(1) 1
214 DRIVER1_BTHDTE_DAY CHARACTER VARYING(2) 2
215 DRIVER1_BTHDTE_MONTH CHARACTER VARYING(2) 2
216 DRIVER1_BTHDTE_YEAR CHARACTER VARYING(4) 4
217 DRIVER1_LICCAN CHARACTER VARYING(1) 1
218 DRV1_NUM_CLAIMS BIGINT 8
219 DRV1CLM1_MONTH CHARACTER VARYING(200) 200
220 DRV1CLM1_YEAR CHARACTER VARYING(200) 200
221 DRV1CLM1_CODE CHARACTER VARYING(4) 4
222 DRV1CLM2_MONTH CHARACTER VARYING(200) 200
223 DRV1CLM2_YEAR CHARACTER VARYING(200) 200
224 DRV1CLM2_CODE CHARACTER VARYING(4) 4
225 DRV1CLM3_MONTH CHARACTER VARYING(200) 200
226 DRV1CLM3_YEAR CHARACTER VARYING(200) 200
227 DRV1CLM3_CODE CHARACTER VARYING(4) 4
228 DRV1CLM4_MONTH CHARACTER VARYING(200) 200
229 DRV1CLM4_YEAR CHARACTER VARYING(200) 200
230 DRV1CLM4_CODE CHARACTER VARYING(4) 4
231 DRV1CLM5_MONTH CHARACTER VARYING(200) 200
232 DRV1CLM5_YEAR CHARACTER VARYING(200) 200
233 DRV1CLM5_CODE CHARACTER VARYING(4) 4
234 DRV1_MVCONCDE1 CHARACTER(4) 4
235 DRV1_MVCONDTE1 CHARACTER VARYING(10) 10
236 DRV1_MVCONCDE2 CHARACTER VARYING(1) 1
237 DRV1_MVCONDTE2 CHARACTER VARYING(1) 1
238 DRV1_MVCONCDE3 CHARACTER VARYING(1) 1
239 DRV1_MVCONDTE3 CHARACTER VARYING(1) 1
240 DRV1_MVCONCDE4 CHARACTER VARYING(1) 1
241 DRV1_MVCONDTE4 CHARACTER VARYING(1) 1
242 DRV1_MVCONCDE5 CHARACTER VARYING(1) 1
243 DRV1_MVCONDTE5 CHARACTER VARYING(1) 1
244 DRV1_MVLICOBT SMALLINT 2
245 DRIVER2_MVDRIVNO NUMERIC(2,0) 19
246 DRIVER2_TITLE CHARACTER(10) 10
247 DRIVER2_INITIALS CHARACTER(5) 5
248 DRIVER2_FIRSTNAME CHARACTER(40) 40
249 DRIVER2_SURNAME CHARACTER(40) 40
250 DRIVER2_GENDER CHARACTER(1) 1
251 DRIVER2_BTHDTE_DAY CHARACTER VARYING(2) 2
252 DRIVER2_BTHDTE_MONTH CHARACTER VARYING(2) 2
253 DRIVER2_BTHDTE_YEAR CHARACTER VARYING(4) 4
254 DRIVER2_LICCAN CHARACTER VARYING(1) 1
255 DRV2_NUM_CLAIMS BIGINT 8
256 DRV2CLM1_MONTH CHARACTER VARYING(200) 200
257 DRV2CLM1_YEAR CHARACTER VARYING(200) 200
258 DRV2CLM1_CODE CHARACTER VARYING(4) 4
259 DRV2CLM2_MONTH CHARACTER VARYING(200) 200
260 DRV2CLM2_YEAR CHARACTER VARYING(200) 200
261 DRV2CLM2_CODE CHARACTER VARYING(4) 4
262 DRV2CLM3_MONTH CHARACTER VARYING(200) 200
263 DRV2CLM3_YEAR CHARACTER VARYING(200) 200
264 DRV2CLM3_CODE CHARACTER VARYING(4) 4
265 DRV2CLM4_MONTH CHARACTER VARYING(200) 200
266 DRV2CLM4_YEAR CHARACTER VARYING(200) 200
267 DRV2CLM4_CODE CHARACTER VARYING(4) 4
268 DRV2CLM5_MONTH CHARACTER VARYING(200) 200
269 DRV2CLM5_YEAR CHARACTER VARYING(200) 200
270 DRV2CLM5_CODE CHARACTER VARYING(4) 4
271 DRV2_MVCONCDE1 CHARACTER(4) 4
272 DRV2_MVCONDTE1 CHARACTER VARYING(10) 10
273 DRV2_MVCONCDE2 CHARACTER VARYING(1) 1
274 DRV2_MVCONDTE2 CHARACTER VARYING(1) 1
275 DRV2_MVCONCDE3 CHARACTER VARYING(1) 1
276 DRV2_MVCONDTE3 CHARACTER VARYING(1) 1
277 DRV2_MVCONCDE4 CHARACTER VARYING(1) 1
278 DRV2_MVCONDTE4 CHARACTER VARYING(1) 1
279 DRV2_MVCONCDE5 CHARACTER VARYING(1) 1
280 DRV2_MVCONDTE5 CHARACTER VARYING(1) 1
281 DRV2_MVLICOBT SMALLINT 2
282 DRIVER3_MVDRIVNO NUMERIC(2,0) 19
283 DRIVER3_TITLE CHARACTER(10) 10
284 DRIVER3_INITIALS CHARACTER(5) 5
285 DRIVER3_FIRSTNAME CHARACTER(40) 40
286 DRIVER3_SURNAME CHARACTER(40) 40
287 DRIVER3_GENDER CHARACTER(1) 1
288 DRIVER3_BTHDTE_DAY CHARACTER VARYING(2) 2
289 DRIVER3_BTHDTE_MONTH CHARACTER VARYING(2) 2
290 DRIVER3_BTHDTE_YEAR CHARACTER VARYING(4) 4
291 DRIVER3_LICCAN CHARACTER VARYING(1) 1
292 DRV3_NUM_CLAIMS BIGINT 8
293 DRV3CLM1_MONTH CHARACTER VARYING(200) 200
294 DRV3CLM1_YEAR CHARACTER VARYING(200) 200
295 DRV3CLM1_CODE CHARACTER VARYING(4) 4
296 DRV3CLM2_MONTH CHARACTER VARYING(200) 200
297 DRV3CLM2_YEAR CHARACTER VARYING(200) 200
298 DRV3CLM2_CODE CHARACTER VARYING(4) 4
299 DRV3CLM3_MONTH CHARACTER VARYING(200) 200
300 DRV3CLM3_YEAR CHARACTER VARYING(200) 200
301 DRV3CLM3_CODE CHARACTER VARYING(4) 4
302 DRV3CLM4_MONTH CHARACTER VARYING(200) 200
303 DRV3CLM4_YEAR CHARACTER VARYING(200) 200
304 DRV3CLM4_CODE CHARACTER VARYING(4) 4
305 DRV3CLM5_MONTH CHARACTER VARYING(200) 200
306 DRV3CLM5_YEAR CHARACTER VARYING(200) 200
307 DRV3CLM5_CODE CHARACTER VARYING(4) 4
308 DRV3_MVCONCDE1 CHARACTER(4) 4
309 DRV3_MVCONDTE1 CHARACTER VARYING(10) 10
310 DRV3_MVCONCDE2 CHARACTER VARYING(1) 1
311 DRV3_MVCONDTE2 CHARACTER VARYING(1) 1
312 DRV3_MVCONCDE3 CHARACTER VARYING(1) 1
313 DRV3_MVCONDTE3 CHARACTER VARYING(1) 1
314 DRV3_MVCONCDE4 CHARACTER VARYING(1) 1
315 DRV3_MVCONDTE4 CHARACTER VARYING(1) 1
316 DRV3_MVCONCDE5 CHARACTER VARYING(1) 1
317 DRV3_MVCONDTE5 CHARACTER VARYING(1) 1
318 DRV3_MVLICOBT SMALLINT 2
319 DRIVER4_MVDRIVNO NUMERIC(2,0) 19
320 DRIVER4_TITLE CHARACTER(10) 10
321 DRIVER4_INITIALS CHARACTER(5) 5
322 DRIVER4_FIRSTNAME CHARACTER(40) 40
323 DRIVER4_SURNAME CHARACTER(40) 40
324 DRIVER4_GENDER CHARACTER(1) 1
325 DRIVER4_BTHDTE_DAY CHARACTER VARYING(2) 2
326 DRIVER4_BTHDTE_MONTH CHARACTER VARYING(2) 2
327 DRIVER4_BTHDTE_YEAR CHARACTER VARYING(4) 4
328 DRIVER4_LICCAN CHARACTER VARYING(1) 1
329 DRV4_NUM_CLAIMS BIGINT 8
330 DRV4CLM1_MONTH CHARACTER VARYING(200) 200
331 DRV4CLM1_YEAR CHARACTER VARYING(200) 200
332 DRV4CLM1_CODE CHARACTER VARYING(4) 4
333 DRV4CLM2_MONTH CHARACTER VARYING(200) 200
334 DRV4CLM2_YEAR CHARACTER VARYING(200) 200
335 DRV4CLM2_CODE CHARACTER VARYING(4) 4
336 DRV4CLM3_MONTH CHARACTER VARYING(200) 200
337 DRV4CLM3_YEAR CHARACTER VARYING(200) 200
338 DRV4CLM3_CODE CHARACTER VARYING(4) 4
339 DRV4CLM4_MONTH CHARACTER VARYING(200) 200
340 DRV4CLM4_YEAR CHARACTER VARYING(200) 200
341 DRV4CLM4_CODE CHARACTER VARYING(4) 4
342 DRV4CLM5_MONTH CHARACTER VARYING(200) 200
343 DRV4CLM5_YEAR CHARACTER VARYING(200) 200
344 DRV4CLM5_CODE CHARACTER VARYING(4) 4
345 DRV4_MVCONCDE1 CHARACTER(4) 4
346 DRV4_MVCONDTE1 CHARACTER VARYING(10) 10
347 DRV4_MVCONCDE2 CHARACTER VARYING(1) 1
348 DRV4_MVCONDTE2 CHARACTER VARYING(1) 1
349 DRV4_MVCONCDE3 CHARACTER VARYING(1) 1
350 DRV4_MVCONDTE3 CHARACTER VARYING(1) 1
351 DRV4_MVCONCDE4 CHARACTER VARYING(1) 1
352 DRV4_MVCONDTE4 CHARACTER VARYING(1) 1
353 DRV4_MVCONCDE5 CHARACTER VARYING(1) 1
354 DRV4_MVCONDTE5 CHARACTER VARYING(1) 1
355 DRV4_MVLICOBT SMALLINT 2
356 DRIVER5_MVDRIVNO NUMERIC(2,0) 19
357 DRIVER5_TITLE CHARACTER(10) 10
358 DRIVER5_INITIALS CHARACTER(5) 5
359 DRIVER5_FIRSTNAME CHARACTER(40) 40
360 DRIVER5_SURNAME CHARACTER(40) 40
361 DRIVER5_GENDER CHARACTER(1) 1
362 DRIVER5_BTHDTE_DAY CHARACTER VARYING(2) 2
363 DRIVER5_BTHDTE_MONTH CHARACTER VARYING(2) 2
364 DRIVER5_BTHDTE_YEAR CHARACTER VARYING(4) 4
365 DRIVER5_LICCAN CHARACTER VARYING(1) 1
366 DRV5_NUM_CLAIMS BIGINT 8
367 DRV5CLM1_MONTH CHARACTER VARYING(200) 200
368 DRV5CLM1_YEAR CHARACTER VARYING(200) 200
369 DRV5CLM1_CODE CHARACTER VARYING(4) 4
370 DRV5CLM2_MONTH CHARACTER VARYING(200) 200
371 DRV5CLM2_YEAR CHARACTER VARYING(200) 200
372 DRV5CLM2_CODE CHARACTER VARYING(4) 4
373 DRV5CLM3_MONTH CHARACTER VARYING(200) 200
374 DRV5CLM3_YEAR CHARACTER VARYING(200) 200
375 DRV5CLM3_CODE CHARACTER VARYING(4) 4
376 DRV5CLM4_MONTH CHARACTER VARYING(200) 200
377 DRV5CLM4_YEAR CHARACTER VARYING(200) 200
378 DRV5CLM4_CODE CHARACTER VARYING(4) 4
379 DRV5CLM5_MONTH CHARACTER VARYING(200) 200
380 DRV5CLM5_YEAR CHARACTER VARYING(200) 200
381 DRV5CLM5_CODE CHARACTER VARYING(4) 4
382 DRV5_MVCONCDE1 CHARACTER(4) 4
383 DRV5_MVCONDTE1 CHARACTER VARYING(10) 10
384 DRV5_MVCONCDE2 CHARACTER VARYING(1) 1
385 DRV5_MVCONDTE2 CHARACTER VARYING(1) 1
386 DRV5_MVCONCDE3 CHARACTER VARYING(1) 1
387 DRV5_MVCONDTE3 CHARACTER VARYING(1) 1
388 DRV5_MVCONCDE4 CHARACTER VARYING(1) 1
389 DRV5_MVCONDTE4 CHARACTER VARYING(1) 1
390 DRV5_MVCONCDE5 CHARACTER VARYING(1) 1
391 DRV5_MVCONDTE5 CHARACTER VARYING(1) 1
392 DRV5_MVLICOBT SMALLINT 2
393 DRIVER6_MVDRIVNO NUMERIC(2,0) 19
394 DRIVER6_TITLE CHARACTER(10) 10
395 DRIVER6_INITIALS CHARACTER(5) 5
396 DRIVER6_FIRSTNAME CHARACTER(40) 40
397 DRIVER6_SURNAME CHARACTER(40) 40
398 DRIVER6_GENDER CHARACTER(1) 1
399 DRIVER6_BTHDTE_DAY CHARACTER VARYING(2) 2
400 DRIVER6_BTHDTE_MONTH CHARACTER VARYING(2) 2
401 DRIVER6_BTHDTE_YEAR CHARACTER VARYING(4) 4
402 DRIVER6_LICCAN CHARACTER VARYING(1) 1
403 DRV6_NUM_CLAIMS BIGINT 8
404 DRV6CLM1_MONTH CHARACTER VARYING(200) 200
405 DRV6CLM1_YEAR CHARACTER VARYING(200) 200
406 DRV6CLM1_CODE CHARACTER VARYING(4) 4
407 DRV6CLM2_MONTH CHARACTER VARYING(200) 200
408 DRV6CLM2_YEAR CHARACTER VARYING(200) 200
409 DRV6CLM2_CODE CHARACTER VARYING(4) 4
410 DRV6CLM3_MONTH CHARACTER VARYING(200) 200
411 DRV6CLM3_YEAR CHARACTER VARYING(200) 200
412 DRV6CLM3_CODE CHARACTER VARYING(4) 4
413 DRV6CLM4_MONTH CHARACTER VARYING(200) 200
414 DRV6CLM4_YEAR CHARACTER VARYING(200) 200
415 DRV6CLM4_CODE CHARACTER VARYING(4) 4
416 DRV6CLM5_MONTH CHARACTER VARYING(200) 200
417 DRV6CLM5_YEAR CHARACTER VARYING(200) 200
418 DRV6CLM5_CODE CHARACTER VARYING(4) 4
419 DRV6_MVCONCDE1 CHARACTER(4) 4
420 DRV6_MVCONDTE1 CHARACTER VARYING(10) 10
421 DRV6_MVCONCDE2 CHARACTER VARYING(1) 1
422 DRV6_MVCONDTE2 CHARACTER VARYING(1) 1
423 DRV6_MVCONCDE3 CHARACTER VARYING(1) 1
424 DRV6_MVCONDTE3 CHARACTER VARYING(1) 1
425 DRV6_MVCONCDE4 CHARACTER VARYING(1) 1
426 DRV6_MVCONDTE4 CHARACTER VARYING(1) 1
427 DRV6_MVCONCDE5 CHARACTER VARYING(1) 1
428 DRV6_MVCONDTE5 CHARACTER VARYING(1) 1
429 DRV6_MVLICOBT SMALLINT 2
430 RCHARGES NUMERIC(11,2) 19
431 RGST NUMERIC(11,2) 19
432 RSTMPDUTY NUMERIC(11,2) 19
433 COVRENEWEDDATE CHARACTER VARYING(10) 10
434 POLICYINCEPTDATE CHARACTER VARYING(10) 10
435 RISKSTATE CHARACTER VARYING(3) 3
436 RBASICPRM NUMERIC(11,2) 19
437 SHANNONS_CLIENT_NUM CHARACTER VARYING(1) 1
438 AAMI_CLIENT_NUM CHARACTER VARYING(1) 1
439 INPUT_PREM_PREV_CAP_CUP CHARACTER VARYING(1) 1
440 MESSAGES CHARACTER(1) 1
441 EMPLDISC CHARACTER VARYING(1) 1
442 DISCOUNT_GROUP_AAMI CHARACTER VARYING(1) 1
443 DISCOUNT_GROUP_SHANNONS CHARACTER VARYING(1) 1
444 CALC_NVIC_MATCHES CHARACTER VARYING(1) 1
445 CALC_CTDRIVER CHARACTER VARYING(1) 1
446 CALC_VDRIVER CHARACTER VARYING(1) 1
447 INPUT_CLASS_SHANNONS CHARACTER VARYING(1) 1
448 INPUT_SELECTION NUMERIC(31,0) 19
449 INPUT_NVIC_RETRIEVED CHARACTER VARYING(1) 1
450 INPUT_YEARLY_KM CHARACTER VARYING(1) 1
451 INPUT_TFT_SUMINS CHARACTER VARYING(1) 1
452 INPUT_INVALID_EXCESS CHARACTER VARYING(1) 1
453 INPUT_PAYMENT_FREQ CHARACTER VARYING(1) 1
454 INPUT_QUOTE_BASIC_PREMIUM CHARACTER VARYING(1) 1
455 INPUT_QUOTE_FSL_PREMIUM CHARACTER VARYING(1) 1
456 INPUT_QUOTE_SD_PREMIUM CHARACTER VARYING(1) 1
457 INPUT_QUOTE_GST_PREMIUM CHARACTER VARYING(1) 1
458 INPUT_GROSS_PREMIUM CHARACTER VARYING(1) 1
459 INPUT_QUOTE_COMMISSION CHARACTER VARYING(1) 1
460 INPUT_QUOTE_COMMISSION_GST CHARACTER VARYING(1) 1
461 INPUT_QUOTE_NET CHARACTER VARYING(1) 1
462 INPUT_POLICY_MESSAGE_LINE1 CHARACTER VARYING(1) 1
463 INPUT_POLICY_MESSAGE_LINE2 CHARACTER VARYING(1) 1
464 INPUT_POLICY_MESSAGE_LINE3 CHARACTER VARYING(1) 1
465 INPUT_POLICY_MESSAGE_LINE4 CHARACTER VARYING(1) 1
466 INPUT_LURN_SCALE CHARACTER VARYING(1) 1
467 INPUT_LURN CHARACTER VARYING(1) 1
468 INPUT_COMPLETE CHARACTER VARYING(1) 1
469 INPUT_CONTACT_NAME CHARACTER VARYING(1) 1
470 HOME_ONLY_POLICY CHARACTER VARYING(1) 1
471 HOP_NUMBER CHARACTER VARYING(1) 1
472 HOPN_MPD CHARACTER VARYING(1) 1
473 CLIENT_EMAIL_ADDRESS CHARACTER VARYING(256) 256
474 INPUT_SHANNONS_DESC2 CHARACTER VARYING(1) 1
475 INPUT_SHANNONS_DESC3 CHARACTER VARYING(1) 1
476 INPUT_ERROR_REPORTING CHARACTER VARYING(1) 1