INT_CIINTCCS_D100_CHEADR_STAGING

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMNUMBER CHARACTER VARYING(40) 40
2 CLAIMORDER BIGINT 8
3 EXPOSUREID BIGINT 8
4 REPORT_ONLY_CLAIM BIGINT 8
5 CLAIM_FINANCIAL_STATUS CHARACTER VARYING(3) 3
6 MVBRAND 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 INCIDENTADDRLINE1 CHARACTER VARYING(55) 55
18 INCIDENTADDRLINE2 CHARACTER VARYING(55) 55
19 INCIDENTADDRLINE3 CHARACTER VARYING(55) 55
20 INCIDENTCITY CHARACTER VARYING(60) 60
21 INCIDENTPOSTALCODE CHARACTER VARYING(60) 60
22 INCIDENTSTATE BIGINT 8
23 INCIDENTCOUNTRY BIGINT 8
24 ASSIGNEDUSERID CHARACTER VARYING(30) 30
25 ASSIGNEDGROUPID CHARACTER VARYING(100) 100
26 LOSSDATE DATE 4
27 LOSSTIME TIME 8
28 REPORTEDDATE DATE 4
29 REOPENDATE DATE 4
30 CLOSEDATE DATE 4
31 LAST_TRANSACTIONDATE TIMESTAMP 8
32 CHDR_STATUS CHARACTER VARYING(13) 13
33 CLAIMSTATE BIGINT 8
34 CLAIM_DECISION BIGINT 8
35 CLOSED_OUTCOME BIGINT 8
36 HOW_CLAIM_REPORTED BIGINT 8
37 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
38 LOSSCAUSE BIGINT 8
39 LOSSSUBCAUSE BIGINT 8
40 LOSSPOSTCODE CHARACTER VARYING(60) 60
41 RISKPOSTCODE CHARACTER VARYING(60) 60
42 CATASTROPHECODE BIGINT 8
43 EXCESS_R_O CHARACTER VARYING(8) 8
44 EXCESS_CLAIM NUMERIC(19,2) 19
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 PAIDTODATE NUMERIC(38,2) 19
51 RECOVEREDTODATE NUMERIC(38,2) 19
52 ITCTODATE NUMERIC(38,2) 19
53 DAMTODATE NUMERIC(38,2) 19
54 IAMTODATE NUMERIC(38,2) 19
55 GROSSRESERVE NUMERIC(38,2) 19
56 RECOVERYRESERVE NUMERIC(38,2) 19
57 OFFSETTODATE NUMERIC(38,2) 19
58 GSTEXCESSTODATE NUMERIC(38,2) 19
59 ORIGINALESTIMATE NUMERIC(18,2) 19
60 ORIGINALESTIMATETP NUMERIC(18,2) 19
61 CLAIMID BIGINT 8
62 INCURREDTODATE NUMERIC(38,2) 19
63 LOSSSTATE BIGINT 8
64 RISKSTATE BIGINT 8
65 POLICYID BIGINT 8
66 REMAINING_RESERVES_TP NUMERIC(38,2) 19
67 REMAINING_RESERVES NUMERIC(38,2) 19
68 FUTURE_RESERVE_TP NUMERIC(38,0) 19
69 FUTURE_RESERVE NUMERIC(38,0) 19
70 TOTAL_PAID NUMERIC(38,2) 19
71 TOTAL_RECOVERIES NUMERIC(38,2) 19
72 TOTAL_PAID_TP NUMERIC(38,2) 19
73 TOTAL_RECOVERIES_TP NUMERIC(38,2) 19
74 LOSSADDRESSLINE1 CHARACTER VARYING(55) 55
75 LOSSADDRESSLINE2 CHARACTER VARYING(55) 55
76 LOSSADDRESSLINE3 CHARACTER VARYING(55) 55
77 LOSSCITY CHARACTER VARYING(60) 60
78 LOSSCOUNTRY BIGINT 8
79 LITIGATION_STATUS BIGINT 8
80 INVESTIGATION_STATUS BIGINT 8
81 REPORTEDTIME TIMESTAMP 8
82 POLICY_EFFDATE TIMESTAMP 8
83 POLICY_EXPDATE TIMESTAMP 8
84 LINEOFBUSINESS BIGINT 8
85 COVERTYPE BIGINT 8
86 CLAIM_CREATED_USERNAME CHARACTER VARYING(30) 30
87 SC_WITHOUTPREJUDICECOMMENT CHARACTER VARYING(2000) 2000
88 SC_REJECTCOMMENT CHARACTER VARYING(2000) 2000
89 CLAIMSTATUS CHARACTER VARYING(22) 22
90 TRANSACTIONDATE TIMESTAMP 8
91 ROCOUNT NUMERIC(38,0) 19
92 CREATETIME TIMESTAMP 8
93 VEHICLELOSSPARTY BIGINT 8
94 TP_INSURED CHARACTER VARYING(1) 1
95 REPAIR_OR_TOTAL_LOSS CHARACTER VARYING(9) 9
96 RECOVERYSTRATEGY BIGINT 8
97 FIRST_EFFECTIVE_DT_POLICY DATE 4
98 EFFECTIVE_DT_CURRENT_TERM DATE 4
99 DATE_POLICY_EXPIRE DATE 4
100 SUMINS_MKTVAL NUMERIC(18,2) 19
101 POLICYNUMBER CHARACTER VARYING(40) 40
102 PRODUCTTYPE BIGINT 8
103 LOSSTYPE BIGINT 8
104 POLICYCOVERAGE BIGINT 8
105 ITEMNO INTEGER 4
106 CHANNEL CHARACTER VARYING(20) 20
107 PREMIUMPAYMENT_MODE BIGINT 8
108 INS_RESPONSIBILITY_CENTRE CHARACTER VARYING(4) 4
109 SERVICE_CENTRE CHARACTER VARYING(4) 4
110 VEHICLE_NVIC CHARACTER VARYING(15) 15
111 MAKE CHARACTER VARYING(60) 60
112 MODEL CHARACTER VARYING(80) 80
113 MARKETVALUE_OR_SUM_INS CHARACTER VARYING(1) 1
114 VEHICLEYEAR BIGINT 8
115 SC_COVERAGESOURCEKEY CHARACTER VARYING(40) 40
116 SC_PREMIUMCLASS BIGINT 8
117 VEHICLECOVERAGETYPE BIGINT 8
118 GL_CHANNEL CHARACTER VARYING(5) 5
119 GL_PRODUCT CHARACTER VARYING(6) 6
120 GL_CLASS CHARACTER VARYING(2) 2
121 GL_ENTITY CHARACTER VARYING(6) 6
122 GL_STATE CHARACTER VARYING(1) 1
123 GL_CATEGORY CHARACTER VARYING(3) 3
124 GL_CENTRE CHARACTER VARYING(4) 4
125 RECOVERYUSER CHARACTER VARYING(8) 8
126 SOURCESYST CHARACTER VARYING(3) 3