CCR_CC_CLAIM_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SC_PETSHOW CHARACTER VARYING(1) 1
2 SC_ANIMALDESC CHARACTER VARYING(255) 255
3 INSUREDDENORMID BIGINT 8
4 LOBCODE BIGINT 8
5 EMPLOYMENTINJURY CHARACTER VARYING(1) 1
6 SHOWMEDICALFIRSTINFO BIGINT 8
7 ACCIDENTTYPE BIGINT 8
8 SC_IMPACTOBJECT BIGINT 8
9 SC_FIRE_CIGARETTES CHARACTER VARYING(1) 1
10 COVERAGEINQUESTION CHARACTER VARYING(1) 1
11 SAFETYEQUIPPROV CHARACTER VARYING(1) 1
12 SC_ANIMALOWNEDBYYOU CHARACTER VARYING(1) 1
13 CLOSEDOUTCOME BIGINT 8
14 SC_CONTRACTDATE TIMESTAMP 8
15 SC_ACCDAMAGECAUSE BIGINT 8
16 SC_RENTTENANTAGREETYPE BIGINT 8
17 EXPOSUREBEGAN TIMESTAMP 8
18 WEATHER BIGINT 8
19 ASSIGNEDBYUSERID BIGINT 8
20 SC_BURNOUT_LSCONF BIGINT 8
21 SIULIFECYCLESTATE BIGINT 8
22 SC_WATERDAMAGE CHARACTER VARYING(1) 1
23 SC_IMPACTREPORTED CHARACTER VARYING(1) 1
24 SC_LOSSCAUSE BIGINT 8
25 SC_BURNOUTAPPWARRANTY CHARACTER VARYING(1) 1
26 STORAGEVOLUMES CHARACTER VARYING(10) 10
27 COMPUTERSECURITY CHARACTER VARYING(1) 1
28 SC_REOPENREASON BIGINT 8
29 SC_ENTRYVIAOPENAREA CHARACTER VARYING(1) 1
30 SC_RENTLOSS_ACCESSDIST BIGINT 8
31 PREVIOUSQUEUEID BIGINT 8
32 SC_LOSSPOSTCODEASNUMBER BIGINT 8
33 INSUREDPREMISES CHARACTER VARYING(1) 1
34 LOSSDATE TIMESTAMP 8
35 JURISDICTIONSTATE BIGINT 8
36 SC_RENTLOSS_REPLACETENANTSDESC CHARACTER VARYING(255) 255
37 SC_RENTLOSS_DEFAULTREASON BIGINT 8
38 INSURERSENTMPNNOTICE TIMESTAMP 8
39 SC_CONSOLPROJECTID BIGINT 8
40 SC_FORCEDENTRYDETAILS CHARACTER VARYING(255) 255
41 STORAGEBOXNUM CHARACTER VARYING(10) 10
42 DATEFORMRETBYEMP TIMESTAMP 8
43 SC_ORIGINALTOTALESTIMATEVALUE NUMERIC(18,2) 19
44 REOPENEDREASON BIGINT 8
45 SC_SPECEFFOTHERLOSSCAUSE CHARACTER VARYING(1) 1
46 HAZARDOUSWASTE CHARACTER VARYING(1) 1
47 HOSPITALDAYS BIGINT 8
48 SC_INCIDENTREPORT BIGINT 8
49 POLICEDEPTINFO CHARACTER VARYING(255) 255
50 REPORTEDDATE TIMESTAMP 8
51 SC_MALDMGTENANTSOCCUPY CHARACTER VARYING(1) 1
52 SC_WATERLEAKCAUSE BIGINT 8
53 SC_BURNOUT_IMPPOWER_VISIBLE CHARACTER VARYING(1) 1
54 REPORTEDBYTYPE BIGINT 8
55 SC_ANIMALOWNERINS CHARACTER VARYING(255) 255
56 PTPINMPN CHARACTER VARYING(1) 1
57 SC_BURNOUT_IMPPROPN_CAUSE BIGINT 8
58 SISCORE BIGINT 8
59 SC_FIRESOURCE BIGINT 8
60 FIRSTNOTICESUIT CHARACTER VARYING(1) 1
61 SC_IMPACTPOWERPOLEVIS CHARACTER VARYING(1) 1
62 SC_LOSSATRISKADDRESS CHARACTER VARYING(1) 1
63 ASSIGNEDUSERID BIGINT 8
64 SAFETYEQUIPUSED CHARACTER VARYING(1) 1
65 SC_RENTLOSS_RENTAGREE CHARACTER VARYING(1) 1
66 HOWREPORTED BIGINT 8
67 DATECOMPDCSNMADE TIMESTAMP 8
68 SC_ITCEGSTONBAS BIGINT 8
69 EXAMINATIONDATE TIMESTAMP 8
70 STORAGETYPE BIGINT 8
71 MAINCONTACTTYPE BIGINT 8
72 BEANVERSION BIGINT 8
73 SC_FIRE_NAKEDFLAME CHARACTER VARYING(1) 1
74 MODIFIEDDUTYAVAIL CHARACTER VARYING(1) 1
75 SC_RIOT_DAMAGEPOLLUTANTS CHARACTER VARYING(1) 1
76 PREVIOUSGROUPID BIGINT 8
77 PREEXDISBLTY CHARACTER VARYING(1) 1
78 SC_SPECEFFDATEDEPARTEDAU TIMESTAMP 8
79 SC_MINSECURITY CHARACTER VARYING(1) 1
80 SC_ITCEPREMIUM_CONFIRMED CHARACTER VARYING(1) 1
81 SC_FOODSPOILAGECAUSE BIGINT 8
82 SC_STORM_FLOODSOURCE BIGINT 8
83 ASSIGNEDGROUPID BIGINT 8
84 CONCURRENTEMP BIGINT 8
85 SC_RENTLOSSREASON BIGINT 8
86 PROGRESS BIGINT 8
87 SC_IMPACTPOWERSURGE CHARACTER VARYING(1) 1
88 SC_IMPACTTREELOPPING CHARACTER VARYING(1) 1
89 SC_STORM_FLASHFLOODSOURCE BIGINT 8
90 SC_RIOT_DAMAGELEGALAUTHORITY CHARACTER VARYING(1) 1
91 SC_CASEMGRDETAILS CHARACTER VARYING(255) 255
92 DATERPTDTOAGENT TIMESTAMP 8
93 SC_EXCESS NUMERIC(18,2) 19
94 SC_POLSRTREASON BIGINT 8
95 STORAGEDATE TIMESTAMP 8
96 SC_DAYSPROPERTYVACANT BIGINT 8
97 ID BIGINT 8
98 SC_POLICYLOCATIONFK BIGINT 8
99 SC_ANIMALTRAPPED CHARACTER VARYING(1) 1
100 SC_CLOSEDOUTCOME BIGINT 8
101 SC_MALDMGTENANTSCAUSE BIGINT 8
102 CLAIMANTRPRTDDATE TIMESTAMP 8
103 SC_STORM_FLOODSOURCETXT CHARACTER VARYING(255) 255
104 SALVAGESTATUS BIGINT 8
105 SIESCALATESIUDATE TIMESTAMP 8
106 LOADCOMMANDID BIGINT 8
107 SC_BURNOUT_PROPTREE CHARACTER VARYING(1) 1
108 CREATEUSERID BIGINT 8
109 SC_BURNOUT_LDAMAGEHOME CHARACTER VARYING(1) 1
110 SUBROGATIONSTATUS BIGINT 8
111 SC_MALDMGTENANTSCOSTS CHARACTER VARYING(1) 1
112 STATUTEDATE TIMESTAMP 8
113 EMPQUSVALIDITY BIGINT 8
114 ASSIGNMENTSTATUS BIGINT 8
115 SC_WATERLEAKSOURCE BIGINT 8
116 SC_FIRE_FLAMEORIGIN CHARACTER VARYING(1) 1
117 STATEACKNUMBER CHARACTER VARYING(20) 20
118 SC_ANIMALOWNERKNOWN CHARACTER VARYING(1) 1
119 LOCKINGCOLUMN BIGINT 8
120 STORAGEBARCODENUM CHARACTER VARYING(10) 10
121 SC_UNFINISHEDDMG CHARACTER VARYING(1) 1
122 SC_STORM_IMPACTHOMECONTENTS CHARACTER VARYING(1) 1
123 MOLD CHARACTER VARYING(1) 1
124 EMPLOYMENTDATAID BIGINT 8
125 SC_ANIMALDAMAGEDESC CHARACTER VARYING(255) 255
126 INJUREDONPREMISES CHARACTER VARYING(1) 1
127 DATERPTDTOINSURED TIMESTAMP 8
128 CURRENTCONDITIONS CHARACTER VARYING(1) 1
129 CREATETIME TIMESTAMP 8
130 SC_REJECTREASONTXT CHARACTER VARYING(2000) 2000
131 SC_WATERLEAKHOWLONG CHARACTER VARYING(255) 255
132 DRUGSINVOLVED BIGINT 8
133 SC_ACCDAMAGECAUSEPERSON BIGINT 8
134 SEGMENT BIGINT 8
135 SC_PETBUSINESS CHARACTER VARYING(1) 1
136 LOSSCAUSE BIGINT 8
137 SIUSTATUS BIGINT 8
138 SC_RIOT_DAMAGENUCLEAR CHARACTER VARYING(1) 1
139 SC_CASETEMPACCOMDETAILS CHARACTER VARYING(255) 255
140 SC_CLAIMDECISIONCOMMENTS CHARACTER VARYING(255) 255
141 LOCATIONCODEID BIGINT 8
142 SC_ANIMALTYPE BIGINT 8
143 FLAGGEDREASON CHARACTER VARYING(2000) 2000
144 FLAGGED BIGINT 8
145 STATE BIGINT 8
146 FLAGGEDDATE TIMESTAMP 8
147 SC_RENTLOSS_CONSECPERIOD BIGINT 8
148 SC_IMPACTTREEORIGIN CHARACTER VARYING(1) 1
149 MANIFESTATIONDATE TIMESTAMP 8
150 ASSIGNMENTDATE TIMESTAMP 8
151 SC_PETCOVER CHARACTER VARYING(1) 1
152 STRATEGY BIGINT 8
153 SC_PETREASON BIGINT 8
154 DIAGNOSTICCNSISTNT CHARACTER VARYING(1) 1
155 SC_STORM_IMPACTITEMHEALTH CHARACTER VARYING(1) 1
156 CATASTROPHEID BIGINT 8
157 SC_NONCOMMONAREADETAILS CHARACTER VARYING(255) 255
158 EXPOSUREENDED TIMESTAMP 8
159 FAULT NUMERIC(4,1) 19
160 SC_BURNOUT_IMPPOWER_OTHERPROP CHARACTER VARYING(1) 1
161 UPDATEUSERID BIGINT 8
162 SC_EXPLOSION_ITEM BIGINT 8
163 SC_IMPACTATINSADDRESS CHARACTER VARYING(1) 1
164 SC_ITCE_ABN CHARACTER VARYING(1) 1
165 ASSIGNEDQUEUEID BIGINT 8
166 SC_FRAUDREFERRAL BIGINT 8
167 DATERPTDTOEMPLOYER TIMESTAMP 8
168 BENEFITSSTATUSDCSN CHARACTER VARYING(1) 1
169 SC_PREMIUMCLASS BIGINT 8
170 SC_IMPACTTREESTUMP CHARACTER VARYING(1) 1
171 DESCRIPTION CHARACTER VARYING(2000) 2000
172 SC_IMPACTTREEDANGEROUS CHARACTER VARYING(1) 1
173 SC_CASEMGR CHARACTER VARYING(1) 1
174 SC_CLAIMDECISION BIGINT 8
175 SC_IMPACTOTHERPROPS CHARACTER VARYING(1) 1
176 DATEFORMGIVENTOEMP TIMESTAMP 8
177 SC_RENOVATIONSOCCURING CHARACTER VARYING(1) 1
178 SC_IDRSTATUS BIGINT 8
179 SC_STORM_LIGHTSTRIKECONF BIGINT 8
180 SC_BURNOUT BIGINT 8
181 LOSSLOCATIONCODE CHARACTER VARYING(5) 5
182 POLICYID BIGINT 8
183 DATECOMPDCSNDUE TIMESTAMP 8
184 TREATEDPATIENTBFR CHARACTER VARYING(1) 1
185 LOSSLOCATIONID BIGINT 8
186 SC_SPECEFFEVENTIDENTIFIED CHARACTER VARYING(1) 1
187 ISOENABLED CHARACTER VARYING(1) 1
188 LITIGATIONSTATUS BIGINT 8
189 CLOSEDATE TIMESTAMP 8
190 SC_IMPACTCAUSE BIGINT 8
191 EMPLOYERVALIDITYREASON CHARACTER VARYING(255) 255
192 SC_BURNOUT_IMPTREE_HEALTH CHARACTER VARYING(1) 1
193 INJWKRINMPN TIMESTAMP 8
194 RETIRED BIGINT 8
195 FURTHERTREATMENT CHARACTER VARYING(1) 1
196 FAULTRATING BIGINT 8
197 STORAGECATEGORY BIGINT 8
198 PUBLICID CHARACTER VARYING(64) 64
199 SC_EXPLOSION_OTHERDAMAGE CHARACTER VARYING(1) 1
200 SC_RENOVATIONSROOFWALLSDAMAGE CHARACTER VARYING(1) 1
201 STATEFILENUMBER CHARACTER VARYING(20) 20
202 SC_WATERLEAKDESC CHARACTER VARYING(255) 255
203 SC_SUSPECTS CHARACTER VARYING(1) 1
204 SC_UNOCCUPANCYAPPROVED CHARACTER VARYING(1) 1
205 SC_TEMPACCOMMODATION BIGINT 8
206 SC_RECOVERYPOTENTIAL CHARACTER VARYING(1) 1
207 OTHERRECOVSTATUS BIGINT 8
208 SC_ACCDAMAGEDELIBERATE CHARACTER VARYING(1) 1
209 SC_REJECTOVERRIDE BIGINT 8
210 SC_WATERLEAKCONTAINED CHARACTER VARYING(1) 1
211 HOSPITALDATE TIMESTAMP 8
212 SC_DUPLICATE CHARACTER VARYING(255) 255
213 SC_THEFTAREA BIGINT 8
214 SC_TEMPACCOMDETAILS CHARACTER VARYING(255) 255
215 PERMISSIONREQUIRED BIGINT 8
216 SC_ITCEPREMIUM BIGINT 8
217 CLAIMNUMBER CHARACTER VARYING(40) 40
218 SC_ANIMALDAMAGETYPE BIGINT 8
219 CLAIMANTDENORMID BIGINT 8
220 EMPSENTMPNNOTICE TIMESTAMP 8
221 SC_FOODSPOILAGECLAIMABLE CHARACTER VARYING(1) 1
222 MMIDATE TIMESTAMP 8
223 SC_BURNOUT_LSTRIKE BIGINT 8
224 SC_FIREDAMAGE BIGINT 8
225 SC_BURNOUT_IMPPOWER_RESPONSE CHARACTER VARYING(1) 1
226 SC_CASEMGRREASON BIGINT 8
227 SC_FIRE_OTHERDESCRIPTION CHARACTER VARYING(255) 255
228 SC_IMPACTPARTYKNOWN CHARACTER VARYING(1) 1
229 SC_RENTLOSS_CONSECWEEKS CHARACTER VARYING(1) 1
230 SC_BURNOUT_IMPVEH_RESPORTED CHARACTER VARYING(1) 1
231 PREVIOUSUSERID BIGINT 8
232 SC_STORM_IMPACTOBJECT BIGINT 8
233 SC_STORM_LIGHTNINGSTRIKE BIGINT 8
234 REOPENDATE TIMESTAMP 8
235 LOSSTYPE BIGINT 8
236 DEATHDATE TIMESTAMP 8
237 SC_ORIGINALTOTALESTIMATEITEMS BIGINT 8
238 FIREDEPTINFO CHARACTER VARYING(255) 255
239 SC_ITCE_GSTREGISTERED BIGINT 8
240 SC_RENTLOSS_RECATTEMPT CHARACTER VARYING(1) 1
241 SC_STORM_LIGHTDAMAGEHOME CHARACTER VARYING(1) 1
242 VALIDATIONLEVEL BIGINT 8
243 SC_RENTLOSS_DEFAULTWEEKS BIGINT 8
244 INCIDENTREPORT CHARACTER VARYING(1) 1
245 SC_ITCE_GSTONBAS CHARACTER VARYING(1) 1
246 SC_PERMANENTOCCUPANCY CHARACTER VARYING(1) 1
247 SC_BURNOUT_PROPERTY CHARACTER VARYING(1) 1
248 SC_RENTLOSS_REPLACETENANTS CHARACTER VARYING(1) 1
249 SC_IMPACTTREEREMOVAL CHARACTER VARYING(1) 1
250 SC_RENTLOSS_AGREETYPE BIGINT 8
251 SC_EMERGENCY CHARACTER VARYING(1) 1
252 SC_BURNOUT_IMPPROPY_CAUSE BIGINT 8
253 SC_FIRE_INTENT CHARACTER VARYING(1) 1
254 SC_STORM_IMPACTITEMONPROPERTY CHARACTER VARYING(1) 1
255 STORAGELOCATIONSTATE BIGINT 8
256 SC_SYSTEMDECISION BIGINT 8
257 SC_BURNOUT_APPLIANCEAGE BIGINT 8
258 INJUREDREGULARJOB CHARACTER VARYING(1) 1
259 SC_RIOT_DAMAGEWAR CHARACTER VARYING(1) 1
260 SC_FORCEDENTRY CHARACTER VARYING(1) 1
261 SIESCALATESIU BIGINT 8
262 SC_IMPACTTREEHEALTH CHARACTER VARYING(1) 1
263 SC_IMPACTREMOTEUSE CHARACTER VARYING(1) 1
264 SC_EMBTHEFTBYEMPLOYEE CHARACTER VARYING(1) 1
265 SC_BURNOUT_MOTORSIZE BIGINT 8
266 SC_FLOODOPENWALLS CHARACTER VARYING(1) 1
267 SC_TENANT CHARACTER VARYING(1) 1
268 SC_MANUALEXCESS NUMERIC(18,2) 19
269 SC_EMBACCOUNTRECORDS CHARACTER VARYING(1) 1
270 SC_EMBFUNDSWITHAGENT CHARACTER VARYING(1) 1
271 SC_NODAMAGEDUNITS BIGINT 8
272 SC_EMBDATEAWARE TIMESTAMP 8
273 SC_EXPLOSIONDESC CHARACTER VARYING(255) 255
274 SC_INCIDENTDESCRIPTION BIGINT 8
275 SC_CHIPPEDORSCRATCHED CHARACTER VARYING(1) 1
276 SC_CONTENTSREMOVAL CHARACTER VARYING(1) 1
277 SC_EARTHQUAKEDATE TIMESTAMP 8
278 SC_DAMDELIBERATEDAMAGE CHARACTER VARYING(1) 1
279 SC_FIRECAUSE BIGINT 8
280 SC_AGENTID CHARACTER VARYING(40) 40
281 SC_EMERGENCYACTIONCOMMENTS CHARACTER VARYING(255) 255
282 SC_PROPSAFE CHARACTER VARYING(1) 1
283 SC_COMMENTFORINJURY CHARACTER VARYING(255) 255
284 SC_OCCSPECNEED CHARACTER VARYING(1) 1
285 SC_INJURY CHARACTER VARYING(1) 1
286 SC_EMERGENCYPAYMENT CHARACTER VARYING(1) 1
287 SC_USERCLAIMPRIORITYOVERRIDE CHARACTER VARYING(255) 255
288 SC_EMERGACTTAKENBYYOU CHARACTER VARYING(1) 1
289 SC_FRAUDREFERRALTEAM BIGINT 8
290 SC_COMMENTFOROCC CHARACTER VARYING(255) 255
291 SC_EMERGACTTAKENBYEMERGSERV CHARACTER VARYING(1) 1
292 SC_CLAIMPRIORITY BIGINT 8
293 SC_CLAIMPROCTYPE BIGINT 8
294 SC_USERCLAIMPRIORITY BIGINT 8
295 SC_PREEXISTINGILLNESS CHARACTER VARYING(1) 1
296 SC_BURNOUTISBUSINESSRELATED CHARACTER VARYING(1) 1
297 SC_CRIMHIST CHARACTER VARYING(1) 1
298 SC_PARTIESFOUND CHARACTER VARYING(1) 1
299 SC_PETANOTHERVET CHARACTER VARYING(1) 1
300 SC_STORM_WINDRAINDAMAGEHOME BIGINT 8
301 SC_LL_ISCORESIDENT CHARACTER VARYING(1) 1
302 SC_BURNOUTITEM BIGINT 8
303 SC_ITEMFROMSPECIFICLIST CHARACTER VARYING(1) 1
304 SC_PETPREEXCLAIM CHARACTER VARYING(1) 1
305 SC_ANIMALBIRDBREAKGLASS CHARACTER VARYING(1) 1
306 SC_PETANOTHERVETDETAILS CHARACTER VARYING(255) 255
307 SC_VETPRACTICENAME CHARACTER VARYING(255) 255
308 SC_LL_DATELODRECEIVED TIMESTAMP 8
309 SC_VETPRACTICEADDRESS CHARACTER VARYING(70) 70
310 SC_CRIMHISTDISC CHARACTER VARYING(1) 1
311 SC_VETPRACTICEREFNO CHARACTER VARYING(255) 255
312 SC_BURNOUTITEMOTHER CHARACTER VARYING(255) 255
313 SC_DECCONFIRMED CHARACTER VARYING(1) 1
314 SC_PETLISTED CHARACTER VARYING(1) 1
315 SC_BURNOUTANYFOODSPOILAGE CHARACTER VARYING(1) 1
316 SC_MALICIOUSLYDAMAGED CHARACTER VARYING(1) 1
317 SC_SUBLOSSCONTSINTRANSITS BIGINT 8
318 SC_LL_LOCATION BIGINT 8
319 SC_ACCDAMAGEBYINSUREDEVENT CHARACTER VARYING(1) 1
320 SC_LL_CLAIMTYPE BIGINT 8
321 SC_LL_CLAIMANTSSOLICITOR BIGINT 8
322 SC_VETPRACTICEPHONE CHARACTER VARYING(255) 255
323 SC_LL_RECEIVEDLODORSTATEMENT CHARACTER VARYING(1) 1
324 SC_BURNOUTOLDERTHAN10YEARS CHARACTER VARYING(1) 1
325 SC_PETLOSTORDEAD CHARACTER VARYING(1) 1
326 SC_GLASSBREAKAGEOPTION BIGINT 8
327 SC_PETPERMANENTOCCUPANCY CHARACTER VARYING(1) 1
328 SC_LL_OCCUPANCYTYPE BIGINT 8
329 SC_LL_ISRENTEDHOME CHARACTER VARYING(1) 1
330 SC_DECACCEPTED CHARACTER VARYING(1) 1
331 SC_BURNOUTSPOILAGECAUSE BIGINT 8
332 SC_ITEMLOSTORDAMAGED BIGINT 8
333 SC_LL_ISOTHEREVENT CHARACTER VARYING(1) 1
334 SC_EXPLOSION_OTHERDESCRIPTION CHARACTER VARYING(255) 255
335 SC_THEFT_OTHERDESCRIPTION CHARACTER VARYING(255) 255
336 SC_INCIDENTREPORTED CHARACTER VARYING(1) 1
337 SC_NCDALLOWED CHARACTER VARYING(1) 1
338 SC_FULFILMENTSYSTEMSTATUS BIGINT 8
339 SC_OVERRIDEREASONDETAILS CHARACTER VARYING(2000) 2000
340 SC_VANDDAMAGECAUSE BIGINT 8
341 SC_LL_CAUSE CHARACTER VARYING(2000) 2000
342 SC_BURNOUTISFRIDGEORFREEZER CHARACTER VARYING(1) 1
343 SC_PETROUTINE CHARACTER VARYING(1) 1
344 SC_LL_ISILLEGALDAMAGE CHARACTER VARYING(1) 1
345 SC_LL_CLAIMANT BIGINT 8
346 SC_LL_ISEXCLUDEDCAUSE CHARACTER VARYING(1) 1
347 SC_BURNOUTCLAIMTYPE BIGINT 8
348 SC_PETCONGENITAL CHARACTER VARYING(1) 1
349 SC_BURNOUTISINSUREDEVENT CHARACTER VARYING(1) 1
350 SC_LL_ISCLAIMANTREPRESENTED CHARACTER VARYING(1) 1
351 SC_LL_ISOWNEDBYINSURED CHARACTER VARYING(1) 1
352 SC_DECDECLINEREASON CHARACTER VARYING(2000) 2000
353 SC_LL_WITNESSESAVAILABLE CHARACTER VARYING(1) 1
354 SC_THEFT_CARPARKPERSONALUSE CHARACTER VARYING(1) 1
355 SC_LL_ISLEGALLYCONTROLLED CHARACTER VARYING(1) 1
356 SC_CLAIMEVENTQUESTIONS BIGINT 8
357 CLAIMSOURCE BIGINT 8
358 SC_CLAIMAUTO BIGINT 8
359 CLAIMWORKCOMPID BIGINT 8
360 ARCHIVEPARTITION BIGINT 8
361 SC_CLAIMRECONCILEREPORT BIGINT 8
362 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
363 SC_WCCN CHARACTER VARYING(20) 20
364 SC_LIABILITYCHANGEDATE TIMESTAMP 8
365 SC_SHAREDCLAIMCODE BIGINT 8
366 SC_MOSTSERIOUSINJURY CHARACTER VARYING(200) 200
367 SC_UNAPPROVEDLIABILITYEFFDATE TIMESTAMP 8
368 SC_DUTYSTATUS BIGINT 8
369 SC_AGENCYBREAKDOWN CHARACTER VARYING(50) 50
370 SC_NATUREOFINJURY CHARACTER VARYING(50) 50
371 SC_WORKPLACEACTIVITY CHARACTER VARYING(50) 50
372 SC_INSURERNUMBER CHARACTER VARYING(10) 10
373 SC_PRIMARYDOCTORFKID BIGINT 8
374 SC_BODYLOCATION CHARACTER VARYING(50) 50
375 SC_INJURYBODYLOCATION CHARACTER VARYING(50) 50
376 SC_OCCURRENCESUBURB CHARACTER VARYING(50) 50
377 SC_PRN CHARACTER VARYING(12) 12
378 SC_WORKERDUTIES CHARACTER VARYING(50) 50
379 SC_VERIFICATIONSTATUS BIGINT 8
380 SC_LIABILITYREASON CHARACTER VARYING(2000) 2000
381 SC_AGENCYOFINJURY CHARACTER VARYING(50) 50
382 SC_TPSETTLEMGMTSTATUS BIGINT 8
383 SC_OCCURRENCEMACHINE CHARACTER VARYING(600) 600
384 SC_RECURRENCEINJURYDATE TIMESTAMP 8
385 SC_LIABILITYSTATUS BIGINT 8
386 SC_OCCURRENCEACTION CHARACTER VARYING(600) 600
387 SC_LIABILITYEFFECTIVEDATE TIMESTAMP 8
388 SC_DOICHANGEREASON CHARACTER VARYING(255) 255
389 SC_MECHANISMOFINJURY CHARACTER VARYING(50) 50
390 SC_POLICYPORTFOLIO CHARACTER VARYING(5) 5
391 SC_TPSETTLEINSUREDOBLIG CHARACTER VARYING(1) 1
392 SC_CATCOVERAGEBUILDING BIGINT 8
393 SC_WCREGUPDATETIME TIMESTAMP 8
394 SC_UTPCLAIM CHARACTER VARYING(1) 1
395 SC_SPECIALNEEDSCOMMENT BIGINT 8
396 SC_CATCOVERAGECONTENTS BIGINT 8
397 SC_CATDAMAGETYPE BIGINT 8
398 SC_CATCOVERAGEBOTH BIGINT 8
399 VARCHAREXT CHARACTER VARYING(30) 30
400 TYPEKEYEXT BIGINT 8
401 SC_REFERRALREASON CHARACTER VARYING(2000) 2000
402 INTEGEREXT BIGINT 8
403 SC_SEGMENTREASON CHARACTER VARYING(2000) 2000
404 SC_WORKPLACEINDUSTRYASIC CHARACTER VARYING(50) 50
405 SC_SIGNIFICANTINJURYDATE TIMESTAMP 8
406 SC_CASNOTIFICATIONID CHARACTER VARYING(20) 20
407 SC_ALTERNATECLAIMNUMBER1 CHARACTER VARYING(40) 40
408 SC_CLAIMTRANSFER BIGINT 8
409 SC_ALTERNATECLAIMNUMBER2 CHARACTER VARYING(40) 40
410 SC_INSUREDNOTIFIEDDATE TIMESTAMP 8
411 SC_WORKERCOMMUNICATONDATE TIMESTAMP 8
412 SC_ACCIDENTLOCATIONCOUNTRY BIGINT 8
413 SC_PREVIOUSREOPENDATE TIMESTAMP 8
414 SC_EXCESSWAIVED CHARACTER VARYING(1) 1
415 SC_ACCIDENTLOCATIONPOSTCODE CHARACTER VARYING(60) 60
416 SC_INHIBITPAYMENT BIGINT 8
417 SC_DEPENDENTSEQUENCENUMBER BIGINT 8
418 SC_ALTERNATECLAIMNUMBERTYPE2 CHARACTER VARYING(40) 40
419 SC_TXNSEQUENCENUMBER BIGINT 8
420 SC_CLAIMANTSUBURB CHARACTER VARYING(60) 60
421 SC_EXCESSWAIVEDREASON BIGINT 8
422 SC_REASONABLEEXCUSE BIGINT 8
423 SC_IMPORTSTATUS BIGINT 8
424 SC_ACCIDENTLOCATIONDESC CHARACTER VARYING(50) 50
425 SC_WORKCOVERCLAIMSTATEDATE TIMESTAMP 8
426 SC_CLAIMREVIEWNEXTDATE TIMESTAMP 8
427 SC_WORKCOVERCLAIMSTATE BIGINT 8
428 SC_AGENCYNOTIFIEDDATE TIMESTAMP 8
429 SC_CTPFLAG CHARACTER VARYING(1) 1
430 SC_WORKPLACEINDUSTRYANZSIC CHARACTER VARYING(50) 50
431 SC_PREVIOUSPOLICYNUMBER CHARACTER VARYING(40) 40
432 SC_HEALTHOCCUPATION BIGINT 8
433 SC_INCIDENTNUMBER CHARACTER VARYING(20) 20
434 SC_REPORTTYPE BIGINT 8
435 SC_TYPEOFDISPUTE BIGINT 8
436 SC_CLAIMANTDATEOFBIRTH TIMESTAMP 8
437 SC_ALTERNATECLAIMNUMBERTYPE1 CHARACTER VARYING(40) 40
438 SC_ACCIDENTLOCATIONSTREET CHARACTER VARYING(120) 120
439 SC_SECONDINJURYCLAIMFLAG CHARACTER VARYING(1) 1
440 SC_CLAIMCOHORT BIGINT 8
441 SC_ACCIDENTLOCATION BIGINT 8
442 SC_REVISEDCLAIMNUMBER CHARACTER VARYING(40) 40
443 SC_MEDICALEXCESSPAID BIGINT 8
444 SC_PREVIOUSCLOSEDATE TIMESTAMP 8
445 SC_SHARINGDETAILSID BIGINT 8
446 SC_ITCEUPDATETIME TIMESTAMP 8
447 SC_ACCIDENTCLAIMNUMBER CHARACTER VARYING(40) 40
448 SC_ITCETYPE BIGINT 8
449 SC_ISACCIDENTCLAIM CHARACTER VARYING(1) 1
450 SC_POLICYBRAND BIGINT 8
451 SC_CLAIMALLOCATIONCODE BIGINT 8
452 SC_TYPEOFCLAIM BIGINT 8
453 SC_ROADCONDITION BIGINT 8
454 SC_CLAIMTYPE BIGINT 8
455 SC_RECOVERIESDATA BIGINT 8
456 SC_COMMERCIALCLAIM BIGINT 8
457 SC_CLAIMREJECTREASON BIGINT 8
458 SC_LOSSCAUSESUBTYPE BIGINT 8
459 SC_TEMPACCOMENDDATE TIMESTAMP 8
460 SC_NIGHTLYCOST NUMERIC(18,2) 19
461 SC_INFORMEDDATE TIMESTAMP 8
462 SC_TEMPACCOMSTARTDATE TIMESTAMP 8
463 SC_CLAIMHOME BIGINT 8
464 SC_WPREASONCODE BIGINT 8
465 SC_TEMPACCOMPHONE CHARACTER VARYING(24) 24
466 SC_TEMPACCOMLOCATION CHARACTER VARYING(255) 255
467 PURGEDATE TIMESTAMP 8
468 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
469 TRANSITIONSTATUSDATE_EXT TIMESTAMP 8
470 TRANSITIONSTATUS_EXT BIGINT 8
471 SERIOUSINJURYFLAG_EXT CHARACTER VARYING(1) 1
472 REPORTONLYREASON_EXT BIGINT 8
473 AGENCYID CHARACTER VARYING(9) 9
474 CLAIMTIER BIGINT 8
475 CURRENCY BIGINT 8
476 DATEELIGIBLEFORARCHIVE TIMESTAMP 8
477 ISOKNOWN CHARACTER VARYING(1) 1
478 ISORECEIVEDATE TIMESTAMP 8
479 ISOSENDDATE TIMESTAMP 8
480 ISOSTATUS BIGINT 8
481 LARGELOSSNOTIFICATIONSTATUS BIGINT 8
482 LOCATIONOFTHEFT BIGINT 8
483 REINSURANCEFLAGGEDSTATUS BIGINT 8
484 REINSURANCEREPORTABLE CHARACTER VARYING(1) 1
485 WEATHERRELATED CHARACTER VARYING(1) 1
486 PRCATEGORISATIONCLAIMTYPE BIGINT 8
487 PRCATEGORISATIONPRIORITY BIGINT 8
488 SC_NOTTRIGGERASSESSOVERRIDE CHARACTER VARYING(255) 255
489 SC_TRIGGERASSESSFLAG CHARACTER VARYING(1) 1
490 LOSSCOVER_EXT BIGINT 8
491 DATERPTDTOINSURER_EXT TIMESTAMP 8