FCT_CIINTCCS_D400_CHEADR

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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