FCT_CIBSECCS_M020_CHDR

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMNUMBER CHARACTER VARYING(40) 40
2 CLAIMID BIGINT 8
3 CLAIMORDER BIGINT 8
4 EXPOSUREID BIGINT 8
5 EXPOSURETYPE CHARACTER VARYING(50) 50
6 EXPOSUREINCIDENTID BIGINT 8
7 EXPOSURECOVERAGE CHARACTER VARYING(256) 256
8 EXPOSURESTATUS CHARACTER VARYING(50) 50
9 EXPOSURELOSSCODE BIGINT 8
10 EXPOSURELOSSDESCRIPTION CHARACTER VARYING(256) 256
11 EXPOSURENARRATIVE CHARACTER VARYING(2000) 2000
12 EXPOSUREDATECREATED DATE 4
13 EXPOSUREDATEUPDATED DATE 4
14 EXPOSUREDATEFINALISED DATE 4
15 EXPOSUREDATEREOPENED DATE 4
16 INCIDENTADDRLINE1 CHARACTER VARYING(55) 55
17 INCIDENTADDRLINE2 CHARACTER VARYING(55) 55
18 INCIDENTADDRLINE3 CHARACTER VARYING(55) 55
19 INCIDENTPOSTALCODE CHARACTER VARYING(60) 60
20 INCIDENTCITY CHARACTER VARYING(60) 60
21 INCIDENTSTATE BIGINT 8
22 INCIDENTCOUNTRY BIGINT 8
23 REPORT_ONLY_CLAIM BIGINT 8
24 LOSSDATE DATE 4
25 LOSSTIME TIME 8
26 CLOSED_OUTCOME BIGINT 8
27 LOSSCAUSE BIGINT 8
28 EXCESS_CLAIM NUMERIC(19,2) 19
29 CATASTROPHECODE BIGINT 8
30 POLICYID BIGINT 8
31 FAULTRATING BIGINT 8
32 CLAIM_DECISION BIGINT 8
33 LAST_TRANSACTIONDATE TIMESTAMP 8
34 CHDR_STATUS CHARACTER VARYING(13) 13
35 REPORTEDDATE DATE 4
36 HOW_CLAIM_REPORTED BIGINT 8
37 CLAIMSTATE BIGINT 8
38 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
39 REOPENDATE DATE 4
40 REPORTEDTIME TIMESTAMP 8
41 CLOSEDATE DATE 4
42 LINEOFBUSINESS BIGINT 8
43 MVBRAND BIGINT 8
44 POLICY_EFFDATE TIMESTAMP 8
45 POLICY_EXPDATE TIMESTAMP 8
46 ORIGINALESTIMATE NUMERIC(18,2) 19
47 ACCIDENTCLAIMTYPE_EXT BIGINT 8
48 RESPONSIBLEPARTY_IDENTIFIED CHARACTER VARYING(1) 1
49 ORIGINALESTIMATETP NUMERIC(18,2) 19
50 OTHER_VEHICLE BIGINT 8
51 LOSSSUBCAUSE BIGINT 8
52 SC_REJECTCOMMENT CHARACTER VARYING(2000) 2000
53 COVERTYPE BIGINT 8
54 RECOV_MGMT_STATUS BIGINT 8
55 THIRDPARTY_MGMT_STATUS BIGINT 8
56 LITIGATION_STATUS BIGINT 8
57 INVESTIGATION_STATUS BIGINT 8
58 SC_WITHOUTPREJUDICECOMMENT CHARACTER VARYING(2000) 2000
59 LEGACYCLAIMCATEGORY BIGINT 8
60 LEGACY_CLAIM CHARACTER VARYING(3) 3
61 LOSSPOSTCODE CHARACTER VARYING(60) 60
62 LOSSSTATE BIGINT 8
63 LOSSADDRESSLINE1 CHARACTER VARYING(55) 55
64 LOSSADDRESSLINE2 CHARACTER VARYING(55) 55
65 LOSSADDRESSLINE3 CHARACTER VARYING(55) 55
66 LOSSCITY CHARACTER VARYING(60) 60
67 LOSSCOUNTRY BIGINT 8
68 RISKPOSTCODE CHARACTER VARYING(60) 60
69 RISKSTATE BIGINT 8
70 ASSIGNEDGROUPID CHARACTER VARYING(100) 100
71 ASSIGNEDUSERID CHARACTER VARYING(30) 30
72 CLAIM_CREATED_USERNAME CHARACTER VARYING(30) 30
73 ASSIGNEDTOUSERID BIGINT 8
74 ASSIGNEDTOUSERID_USERNAME CHARACTER VARYING(30) 30
75 UPDATEDUSERID_USERNAME CHARACTER VARYING(30) 30
76 UPDATEUSERID BIGINT 8
77 VERIFIED CHARACTER VARYING(1) 1
78 SOURCESYST CHARACTER VARYING(3) 3
79 CLAIM_FINANCIAL_STATUS CHARACTER VARYING(3) 3
80 PAIDTODATE NUMERIC(38,2) 19
81 RECOVEREDTODATE NUMERIC(38,2) 19
82 GROSSRESERVE NUMERIC(38,2) 19
83 GSTEXCESSTODATE NUMERIC(38,2) 19
84 IAMTODATE NUMERIC(38,2) 19
85 ITCTODATE NUMERIC(38,2) 19
86 RECOVERYRESERVE NUMERIC(38,2) 19
87 DAMTODATE NUMERIC(38,2) 19
88 OFFSETTODATE NUMERIC(38,2) 19
89 INCURREDTODATE NUMERIC(38,2) 19
90 EXCESS_R_O CHARACTER VARYING(8) 8
91 TOTAL_PAID NUMERIC(38,2) 19
92 TOTAL_PAID_TP NUMERIC(38,2) 19
93 TOTAL_RECOVERIES NUMERIC(38,2) 19
94 TOTAL_RECOVERIES_TP NUMERIC(38,2) 19
95 REMAINING_RESERVES NUMERIC(38,2) 19
96 REMAINING_RESERVES_TP NUMERIC(38,2) 19
97 FUTURE_RESERVE NUMERIC(38,0) 19
98 FUTURE_RESERVE_TP NUMERIC(38,0) 19
99 COVERAGETYPE CHARACTER VARYING(50) 50
100 POLICYNUMBER CHARACTER VARYING(40) 40
101 JURISDICTIONSTATE BIGINT 8
102 LITIGATIONSTATUS_EXT BIGINT 8
103 PRIMARYBODYFUNCTION_EXT BIGINT 8
104 SEVERITY BIGINT 8