INT_CIINTCCS_D100_CHEADR_NICHE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 COMPANY SMALLINT 2
2 ITEMNO SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 POLICY INTEGER 4
5 CLAIMNUMBER CHARACTER VARYING(40) 40
6 CLAIMORDER BIGINT 8
7 EXPOSUREID BIGINT 8
8 EXPOSURETYPE CHARACTER VARYING(50) 50
9 EXPOSURESTATUS CHARACTER VARYING(50) 50
10 EXPOSURECOVERAGE CHARACTER VARYING(256) 256
11 EXPOSURELOSSCODE BIGINT 8
12 EXPOSURELOSSDESCRIPTION CHARACTER VARYING(256) 256
13 EXPOSURENARRATIVE CHARACTER VARYING(2000) 2000
14 EXPOSUREDATECREATED DATE 4
15 EXPOSUREDATEUPDATED DATE 4
16 EXPOSUREDATEFINALISED DATE 4
17 EXPOSUREDATEREOPENED DATE 4
18 INCIDENTADDRLINE1 CHARACTER VARYING(55) 55
19 INCIDENTADDRLINE2 CHARACTER VARYING(55) 55
20 INCIDENTADDRLINE3 CHARACTER VARYING(55) 55
21 INCIDENTPOSTALCODE CHARACTER VARYING(60) 60
22 INCIDENTCITY CHARACTER VARYING(60) 60
23 INCIDENTSTATE BIGINT 8
24 INCIDENTCOUNTRY BIGINT 8
25 REPORT_ONLY_CLAIM BIGINT 8
26 MVBRAND BIGINT 8
27 ASSIGNEDUSERID CHARACTER VARYING(30) 30
28 ASSIGNEDGROUPID CHARACTER VARYING(100) 100
29 LOSSDATE DATE 4
30 LOSSTIME TIME 8
31 REPORTEDDATE DATE 4
32 REOPENDATE DATE 4
33 CLOSEDATE DATE 4
34 LAST_TRANSACTIONDATE TIMESTAMP 8
35 CHDR_STATUS CHARACTER VARYING(13) 13
36 CLAIMSTATE BIGINT 8
37 CLAIM_DECISION BIGINT 8
38 CLOSED_OUTCOME BIGINT 8
39 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
40 LOSSCAUSE BIGINT 8
41 LOSSSUBCAUSE BIGINT 8
42 LOSSPOSTCODE CHARACTER VARYING(60) 60
43 RISKPOSTCODE CHARACTER VARYING(60) 60
44 CATASTROPHECODE BIGINT 8
45 FAULTRATING BIGINT 8
46 RESPONSIBLEPARTY_IDENTIFIED CHARACTER VARYING(1) 1
47 RECOV_MGMT_STATUS BIGINT 8
48 THIRDPARTY_MGMT_STATUS BIGINT 8
49 OTHER_VEHICLE BIGINT 8
50 LOSSSTATE BIGINT 8
51 RISKSTATE BIGINT 8
52 LOSSADDRESSLINE1 CHARACTER VARYING(55) 55
53 LOSSADDRESSLINE2 CHARACTER VARYING(55) 55
54 LOSSADDRESSLINE3 CHARACTER VARYING(55) 55
55 LOSSCITY CHARACTER VARYING(60) 60
56 LOSSCOUNTRY BIGINT 8
57 LITIGATION_STATUS BIGINT 8
58 INVESTIGATION_STATUS BIGINT 8
59 REPORTEDTIME TIMESTAMP 8
60 POLICY_EFFDATE TIMESTAMP 8
61 POLICY_EXPDATE TIMESTAMP 8
62 LINEOFBUSINESS BIGINT 8
63 COVERTYPE BIGINT 8
64 CLAIM_CREATED_USERNAME CHARACTER VARYING(30) 30
65 SC_WITHOUTPREJUDICECOMMENT CHARACTER VARYING(2000) 2000
66 SC_REJECTCOMMENT CHARACTER VARYING(2000) 2000
67 ROCOUNT NUMERIC(38,0) 19
68 CREATETIME TIMESTAMP 8
69 VEHICLELOSSPARTY BIGINT 8
70 TP_INSURED CHARACTER VARYING(1) 1
71 REPAIR_OR_TOTAL_LOSS CHARACTER VARYING(9) 9
72 RECOVERYSTRATEGY BIGINT 8
73 FIRST_EFFECTIVE_DT_POLICY DATE 4
74 EFFECTIVE_DT_CURRENT_TERM DATE 4
75 DATE_POLICY_EXPIRE DATE 4
76 SUMINS_MKTVAL NUMERIC(18,2) 19
77 CLAIMSTATUS CHARACTER VARYING(22) 22
78 TRANSACTIONDATE TIMESTAMP 8
79 GL_CHANNEL CHARACTER VARYING(5) 5
80 GL_PRODUCT CHARACTER VARYING(6) 6
81 GL_CLASS CHARACTER VARYING(2) 2
82 GL_ENTITY CHARACTER VARYING(6) 6
83 GL_STATE CHARACTER VARYING(1) 1
84 GL_CATEGORY CHARACTER VARYING(3) 3
85 GL_CENTRE CHARACTER VARYING(4) 4
86 RECOVERYUSER CHARACTER VARYING(8) 8
87 SOURCESYST CHARACTER VARYING(3) 3