INT_CIINTCCS_D300_CHEADR_NICHE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COVERAGEKEY NUMERIC(10,0) 19
2 COMPANY INTEGER 4
3 COMPANYTXT CHARACTER VARYING(8) 8
4 PRODUCT CHARACTER(3) 3
5 POLICYNUMBER CHARACTER VARYING(12) 12
6 ITEMNO INTEGER 4
7 RISK INTEGER 4
8 TERMIDENT CHARACTER(3) 3
9 CLASS CHARACTER(3) 3
10 SUBCLASS CHARACTER(3) 3
11 GLCHANNEL CHARACTER VARYING(5) 5
12 GLPRODUCT CHARACTER VARYING(6) 6
13 GLCLASS CHARACTER VARYING(2) 2
14 GLENTITY CHARACTER VARYING(6) 6
15 GLSTATE CHARACTER VARYING(1) 1
16 GLCATGORY CHARACTER VARYING(3) 3
17 GLCENTRE CHARACTER VARYING(4) 4
18 RATINGGROUP CHARACTER VARYING(28) 28
19 CISPDS1 CHARACTER VARYING(20) 20
20 CISPDS2 CHARACTER VARYING(27) 27
21 CISPDS3 CHARACTER VARYING(36) 36
22 CISPDS4 CHARACTER VARYING(32) 32
23 CISPDS5 CHARACTER VARYING(49) 49
24 CISPDS6 CHARACTER VARYING(50) 50
25 CISPDS7 CHARACTER VARYING(10) 10
26 CISPDS8 CHARACTER VARYING(11) 11
27 CISPKS1 CHARACTER VARYING(12) 12
28 CISPKS2 CHARACTER VARYING(24) 24
29 PRVPOLREF CHARACTER VARYING(14) 14
30 INSUREDNAME CHARACTER VARYING(90) 90
31 STATERISK CHARACTER(3) 3
32 POSTCODERISK INTEGER 4
33 OCCUPATN CHARACTER VARYING(5) 5
34 AGENTNUMBER CHARACTER VARYING(10) 10
35 AGENTNAME CHARACTER VARYING(50) 50
36 AGTACCTYP CHARACTER VARYING(4) 4
37 BUSNESSRC CHARACTER VARYING(4) 4
38 CLAIMNUMBER CHARACTER VARYING(40) 40
39 CLAIMORDER BIGINT 8
40 EXPOSUREID BIGINT 8
41 EXPOSURETYPE CHARACTER VARYING(50) 50
42 EXPOSURESTATUS CHARACTER VARYING(50) 50
43 EXPOSURECOVERAGE CHARACTER VARYING(256) 256
44 EXPOSURELOSSCODE BIGINT 8
45 EXPOSURELOSSDESCRIPTION CHARACTER VARYING(256) 256
46 EXPOSURENARRATIVE CHARACTER VARYING(2000) 2000
47 EXPOSUREDATECREATED DATE 4
48 EXPOSUREDATEUPDATED DATE 4
49 EXPOSUREDATEFINALISED DATE 4
50 EXPOSUREDATEREOPENED DATE 4
51 INCIDENTADDRLINE1 CHARACTER VARYING(55) 55
52 INCIDENTADDRLINE2 CHARACTER VARYING(55) 55
53 INCIDENTADDRLINE3 CHARACTER VARYING(55) 55
54 INCIDENTPOSTALCODE CHARACTER VARYING(60) 60
55 INCIDENTCITY CHARACTER VARYING(60) 60
56 INCIDENTSTATE BIGINT 8
57 INCIDENTCOUNTRY BIGINT 8
58 MVBRAND BIGINT 8
59 REPAIR_OR_TOTAL_LOSS CHARACTER VARYING(9) 9
60 VEHICLELOSSPARTY BIGINT 8
61 ASSIGNEDUSERID CHARACTER VARYING(30) 30
62 REPORTEDDATE DATE 4
63 REPORTEDTIME TIMESTAMP 8
64 REOPENDATE DATE 4
65 CREATETIME TIMESTAMP 8
66 CLOSEDATE DATE 4
67 CLAIMSTATUS CHARACTER VARYING(22) 22
68 TRANSACTIONDATE TIMESTAMP 8
69 LAST_TRANSACTIONDATE TIMESTAMP 8
70 LOSSDATE DATE 4
71 LOSSTIME TIME 8
72 LOSSPOSTCODE CHARACTER VARYING(60) 60
73 LOSSSTATE BIGINT 8
74 LOSSCITY CHARACTER VARYING(60) 60
75 LOSSADDRESSLINE1 CHARACTER VARYING(55) 55
76 LOSSADDRESSLINE2 CHARACTER VARYING(55) 55
77 LOSSADDRESSLINE3 CHARACTER VARYING(55) 55
78 CHDR_STATUS CHARACTER VARYING(13) 13
79 TP_INSURED CHARACTER VARYING(1) 1
80 FAULTRATING BIGINT 8
81 LOSSCAUSE BIGINT 8
82 LOSSSUBCAUSE BIGINT 8
83 CATASTROPHECODE BIGINT 8
84 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
85 RECOVERYSTRATEGY BIGINT 8
86 REPORT_ONLY_CLAIM BIGINT 8
87 RISKPOSTCODE CHARACTER VARYING(60) 60
88 RISKSTATE BIGINT 8
89 CLAIM_CREATED_USERNAME CHARACTER VARYING(30) 30
90 ROCOUNT NUMERIC(38,0) 19
91 POLICYMATCH INTEGER 4
92 RECOVERYUSER CHARACTER VARYING(8) 8
93 SOURCESYST CHARACTER VARYING(3) 3