INT_CIINTCCS_D400_CHEADR

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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