INT_CIINTCCS_D400_CHEADR_STEP1

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMNUMBER CHARACTER VARYING(15) 15
2 CLAIMID CHARACTER VARYING(17) 17
3 EXPOSUREID BIGINT 8
4 COVERAGEKEY NUMERIC(10,0) 19
5 CLAIMORDER BIGINT 8
6 EXPOSURENUM BIGINT 8
7 EXPOSURETYPE CHARACTER VARYING(50) 50
8 EXPOSURESTATUS CHARACTER VARYING(50) 50
9 EXPOSURECOVERAGE CHARACTER VARYING(256) 256
10 EXPOSURELOSSCODE BIGINT 8
11 EXPOSURELOSSDESCRIPTION CHARACTER VARYING(256) 256
12 EXPOSURENARRATIVE CHARACTER VARYING(2000) 2000
13 EXPOSUREDATECREATED DATE 4
14 EXPOSUREDATEUPDATED DATE 4
15 EXPOSUREDATEFINALISED DATE 4
16 EXPOSUREDATEREOPENED DATE 4
17 EXPOSUREINCIDENTADDRESS CHARACTER VARYING(256) 256
18 EXPOSUREINCIDENTADDLINE3 CHARACTER VARYING(55) 55
19 EXPOSUREINCIDENTPOSTCODE CHARACTER VARYING(60) 60
20 EXPOSUREINCIDENTCITY CHARACTER VARYING(60) 60
21 EXPOSUREINCIDENTSTATE BIGINT 8
22 EXPOSUREINCIDENTCOUNTRY BIGINT 8
23 COMPANY NUMERIC(3,0) 19
24 COMPANYTXT CHARACTER VARYING(8) 8
25 PRODUCT CHARACTER(3) 3
26 POLICYNUMBER CHARACTER VARYING(12) 12
27 ITEMNO INTEGER 4
28 RISK INTEGER 4
29 TERMIDENT CHARACTER(3) 3
30 CLASS CHARACTER(3) 3
31 SUBCLASS CHARACTER(3) 3
32 GLCHANNEL CHARACTER VARYING(5) 5
33 GLPRODUCT CHARACTER VARYING(6) 6
34 GLCLASS CHARACTER VARYING(2) 2
35 GLENTITY CHARACTER VARYING(6) 6
36 GLSTATE CHARACTER VARYING(1) 1
37 GLCATGORY CHARACTER VARYING(3) 3
38 GLCENTRE CHARACTER VARYING(4) 4
39 PRODUCTCODE CHARACTER(4) 4
40 RATINGGROUP CHARACTER VARYING(28) 28
41 CISPDS1 CHARACTER VARYING(20) 20
42 CISPDS2 CHARACTER VARYING(27) 27
43 CISPDS3 CHARACTER VARYING(36) 36
44 CISPDS4 CHARACTER VARYING(32) 32
45 CISPDS5 CHARACTER VARYING(49) 49
46 CISPDS6 CHARACTER VARYING(50) 50
47 CISPDS7 CHARACTER VARYING(10) 10
48 CISPDS8 CHARACTER VARYING(11) 11
49 CISPKS1 CHARACTER VARYING(12) 12
50 CISPKS2 CHARACTER VARYING(24) 24
51 CLAIMANTNAME CHARACTER VARYING(50) 50
52 INSUREDNUMBER CHARACTER VARYING(10) 10
53 INSUREDNAME CHARACTER VARYING(90) 90
54 STATERISK CHARACTER(3) 3
55 POSTCODERISK NUMERIC(6,0) 19
56 OCCUPATN CHARACTER VARYING(5) 5
57 AGENTNUMBER CHARACTER VARYING(10) 10
58 AGTACCTYP CHARACTER VARYING(4) 4
59 AGENTNAME CHARACTER VARYING(50) 50
60 PRVPOLREF CHARACTER VARYING(14) 14
61 POSTCODELOSS NUMERIC(4,0) 19
62 STATELOSS CHARACTER VARYING(3) 3
63 ADDRESSLOSS CHARACTER VARYING(52) 52
64 BRANCH CHARACTER VARYING(4) 4
65 BUSNESSRC CHARACTER VARYING(4) 4
66 NOTIFICATIONFLAG CHARACTER VARYING(1) 1
67 CLMSTATUS CHARACTER VARYING(1) 1
68 CLMSTATUSDESC CHARACTER VARYING(60) 60
69 CLAIMSTATUS CHARACTER VARYING(1) 1
70 CLAIMSTATUSDESC CHARACTER VARYING(30) 30
71 CLAIMSTATUSGROUP CHARACTER VARYING(1) 1
72 COMPLTIND CHARACTER VARYING(1) 1
73 COMPLTINDDESC CHARACTER VARYING(60) 60
74 INSUREDSTATUSTP CHARACTER VARYING(1) 1
75 DATEOCCURRED DATE 4
76 DATEOCCURREDOVERRIDE DATE 4
77 DATEREPORTED DATE 4
78 DATEFINALISED DATE 4
79 DATECREATED DATE 4
80 DATELASTTRANSACTION DATE 4
81 GLDATEOCCURRED DATE 4
82 GLDATEREPORTED DATE 4
83 GLDATECREATED DATE 4
84 LOSSCODE CHARACTER VARYING(5) 5
85 LOSSDESCRIPTION CHARACTER VARYING(256) 256
86 LOSSSUBCODE NUMERIC(5,0) 19
87 LOSSSUBDESCRIPTION CHARACTER VARYING(30) 30
88 BLAMEMTRCODE BIGINT 8
89 BLAMEMTR CHARACTER VARYING(32) 32
90 CATASTROPHEEVENT CHARACTER VARYING(30) 30
91 CLAIMPERIL CHARACTER VARYING(28) 28
92 CLAIMEXPOSURE CHARACTER VARYING(28) 28
93 NARRATIVE CHARACTER VARYING(2000) 2000
94 TOTALLOSS CHARACTER VARYING(1) 1
95 INCIDENT NUMERIC(5,0) 19
96 USERRESP CHARACTER VARYING(8) 8
97 GNLNAT CHARACTER VARYING(1) 1
98 CATEGORY CHARACTER VARYING(1) 1
99 CIRCUMSTANCE CHARACTER VARYING(1) 1
100 CLAIMANTTYPE CHARACTER VARYING(2) 2
101 CAUSE CHARACTER VARYING(3) 3
102 CAUSECODE CHARACTER VARYING(5) 5
103 CAUSEDESC CHARACTER VARYING(40) 40
104 RESULTCODE CHARACTER VARYING(5) 5
105 RESULTDESC CHARACTER VARYING(30) 30
106 BODYFUNCTION CHARACTER VARYING(1) 1
107 SEVERITY CHARACTER VARYING(2) 2
108 LITIGATION CHARACTER VARYING(1) 1
109 JURISDICTION CHARACTER VARYING(3) 3
110 LIABILITYTYPE CHARACTER VARYING(2) 2
111 ERATYPE CHARACTER VARYING(1) 1
112 ERADATE DATE 4
113 RECOVERYDATE DATE 4
114 RECOVERYMODE CHARACTER VARYING(1) 1
115 RECOVERYUSER CHARACTER VARYING(8) 8
116 CLMSUBTYP CHARACTER VARYING(1) 1
117 STAGECDE CHARACTER VARYING(4) 4
118 SOLICITORNUMBER CHARACTER VARYING(10) 10
119 SOLICITORNAME CHARACTER VARYING(35) 35
120 SOLAPPDTE DATE 4
121 FSTAPPDTE DATE 4
122 APPLYDATE DATE 4
123 FINALDTE DATE 4
124 LSTFINDTE DATE 4
125 OUTCOME CHARACTER VARYING(4) 4
126 SIIBAFLAG CHARACTER VARYING(1) 1
127 SYSCLAIMNUM BIGINT 8
128 SYSPOLICYNUM BIGINT 8
129 SYSPOLICYCHAR CHARACTER VARYING(12) 12
130 POLICYMATCH INTEGER 4
131 SOURCESYST CHARACTER VARYING(3) 3
132 REOPENEDNO NUMERIC(3,0) 19
133 DATEREOPENED DATE 4
134 REALDATEFINALISED DATE 4
135 GLREALDATEFINALISED DATE 4
136 EXPOSUREREALDATEFINALISED DATE 4
137 CLAIMDESC CHARACTER VARYING(2102) 2102
138 POSTCODEACCIDENT CHARACTER VARYING(4) 4
139 POSTCODE CHARACTER VARYING(6) 6
140 ADDRESSREFERENCE BIGINT 8
141 BRANCHCLAIM CHARACTER VARYING(6) 6
142 CAUSECODEFORNH CHARACTER VARYING(5) 5
143 CAUSEDESCFORNH CHARACTER VARYING(30) 30