INT_CIBSECCS_D010_CHDR_STG03

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 EXPOSUREINCIDENTID BIGINT 8
6 EXPOSURETYPE CHARACTER VARYING(50) 50
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 REPORT_ONLY_CLAIM BIGINT 8
17 LOSSDATE DATE 4
18 LOSSTIME TIME 8
19 CLOSED_OUTCOME BIGINT 8
20 LOSSCAUSE BIGINT 8
21 EXCESS_CLAIM NUMERIC(19,2) 19
22 CATASTROPHECODE BIGINT 8
23 POLICYID BIGINT 8
24 FAULTRATING BIGINT 8
25 CLAIM_DECISION BIGINT 8
26 LAST_TRANSACTIONDATE TIMESTAMP 8
27 CHDR_STATUS CHARACTER VARYING(13) 13
28 REPORTEDDATE DATE 4
29 HOW_CLAIM_REPORTED BIGINT 8
30 CLAIMSTATE BIGINT 8
31 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
32 REOPENDATE DATE 4
33 REPORTEDTIME TIMESTAMP 8
34 CLOSEDATE DATE 4
35 LINEOFBUSINESS BIGINT 8
36 MVBRAND BIGINT 8
37 POLICY_EFFDATE TIMESTAMP 8
38 POLICY_EXPDATE TIMESTAMP 8
39 ORIGINALESTIMATE NUMERIC(18,2) 19
40 ACCIDENTCLAIMTYPE_EXT BIGINT 8
41 RESPONSIBLEPARTY_IDENTIFIED CHARACTER VARYING(1) 1
42 ORIGINALESTIMATETP NUMERIC(18,2) 19
43 OTHER_VEHICLE BIGINT 8
44 LOSSSUBCAUSE BIGINT 8
45 SC_REJECTCOMMENT CHARACTER VARYING(2000) 2000
46 COVERTYPE BIGINT 8
47 RECOV_MGMT_STATUS BIGINT 8
48 THIRDPARTY_MGMT_STATUS BIGINT 8
49 LITIGATION_STATUS BIGINT 8
50 INVESTIGATION_STATUS BIGINT 8
51 SC_WITHOUTPREJUDICECOMMENT CHARACTER VARYING(2000) 2000
52 LEGACYCLAIMCATEGORY BIGINT 8
53 LEGACY_CLAIM CHARACTER VARYING(3) 3
54 ASSIGNEDGROUPID CHARACTER VARYING(100) 100
55 ASSIGNEDUSERID CHARACTER VARYING(30) 30
56 CLAIM_CREATED_USERNAME CHARACTER VARYING(30) 30
57 ASSIGNEDTOUSERID BIGINT 8
58 ASSIGNEDTOUSERID_USERNAME CHARACTER VARYING(30) 30
59 UPDATEDUSERID_USERNAME CHARACTER VARYING(30) 30
60 UPDATEUSERID BIGINT 8
61 LOSSLOCATIONID BIGINT 8
62 ADDRESSID BIGINT 8
63 VERIFIED CHARACTER VARYING(1) 1
64 SOURCESYST CHARACTER VARYING(3) 3
65 COVERAGETYPE CHARACTER VARYING(50) 50
66 POLICYNUMBER CHARACTER VARYING(40) 40
67 JURISDICTIONSTATE BIGINT 8
68 LITIGATIONSTATUS_EXT BIGINT 8
69 PRIMARYBODYFUNCTION_EXT BIGINT 8
70 SEVERITY BIGINT 8