INT_CIBSECCS_D010_CHDR_STG02

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMID BIGINT 8
2 CLAIMNUMBER CHARACTER VARYING(40) 40
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 LOSSDATE TIMESTAMP 8
17 SC_CLOSEDOUTCOME BIGINT 8
18 LOSSCAUSE BIGINT 8
19 SC_EXCESS NUMERIC(18,2) 19
20 CATASTROPHEID BIGINT 8
21 POLICYID BIGINT 8
22 FAULTRATING BIGINT 8
23 SC_CLAIMDECISION BIGINT 8
24 UPDATETIME TIMESTAMP 8
25 SC_REJECTOVERRIDE BIGINT 8
26 REPORTEDDATE TIMESTAMP 8
27 HOWREPORTED BIGINT 8
28 CLAIMSTATE BIGINT 8
29 DESCRIPTION CHARACTER VARYING(2000) 2000
30 REOPENDATE TIMESTAMP 8
31 CLOSEDATE TIMESTAMP 8
32 LOSSTYPE BIGINT 8
33 ACCIDENTTYPE BIGINT 8
34 ASSIGNEDBYUSERID BIGINT 8
35 ASSIGNEDGROUPID BIGINT 8
36 FAULT NUMERIC(4,1) 19
37 INCIDENTREPORT CHARACTER VARYING(1) 1
38 LOBCODE BIGINT 8
39 LOCATIONCODEID BIGINT 8
40 LOSSLOCATIONCODE CHARACTER VARYING(5) 5
41 LOSSLOCATIONID BIGINT 8
42 SC_INCIDENTREPORT BIGINT 8
43 SC_LOSSCAUSE BIGINT 8
44 SC_ORIGINALTOTALESTIMATEVALUE NUMERIC(18,2) 19
45 SC_POLICYLOCATIONFK BIGINT 8
46 SC_PREMIUMCLASS BIGINT 8
47 SC_TPSETTLEMGMTSTATUS BIGINT 8
48 SUBROGATIONSTATUS BIGINT 8
49 CREATETIME TIMESTAMP 8
50 LITIGATION_STATUS BIGINT 8
51 INVESTIGATION_STATUS BIGINT 8
52 REPORTEDTIME TIMESTAMP 8
53 CLAIM_CREATEUSERID BIGINT 8
54 ASSIGNEDUSERID BIGINT 8
55 CLAIM_UPDATEUSERID BIGINT 8
56 POLICYNUMBER CHARACTER VARYING(40) 40
57 LINEOFBUSINESS BIGINT 8
58 MVBRAND BIGINT 8
59 SC_LINEOFBUSINESS BIGINT 8
60 POLICY_EFFDATE TIMESTAMP 8
61 POLICY_EXPDATE TIMESTAMP 8
62 POLICY_STATUS BIGINT 8
63 SC_PREMIUMSTATUS BIGINT 8
64 ORIGEFFECTIVEDATE TIMESTAMP 8
65 SC_CHANNEL CHARACTER VARYING(20) 20
66 SC_PAYMENTMODE BIGINT 8
67 SC_RESPONSIBILITYCENTER CHARACTER VARYING(4) 4
68 SC_SERVICECENTER CHARACTER VARYING(4) 4
69 CANCELLATIONDATE TIMESTAMP 8
70 ADDRESSID BIGINT 8
71 VEHICLEID BIGINT 8
72 SC_INSUREDVEHICLE BIGINT 8
73 SC_COVERAGE BIGINT 8
74 INCIDENTSUBTYPE CHARACTER VARYING(50) 50
75 OTHER_VEHICLE BIGINT 8
76 LOSSCAUSESUBTYPE BIGINT 8
77 SC_REJECTCOMMENT CHARACTER VARYING(2000) 2000
78 INITIALAVERAGECLAIMCOST NUMERIC(18,2) 19
79 INITIALTPAVERAGECLAIMCOST NUMERIC(18,2) 19
80 SC_WITHOUTPREJUDICECOMMENT CHARACTER VARYING(2000) 2000
81 SC_RESPONSIBLEPARTYIDENTIFIED CHARACTER VARYING(1) 1
82 ACCIDENTCLAIMTYPE_EXT BIGINT 8
83 POLICYOPTIONALCOVER CHARACTER VARYING(1) 1
84 COVERTYPE BIGINT 8
85 SC_COVERAGESOURCEKEY CHARACTER VARYING(40) 40
86 VERIFIED CHARACTER VARYING(1) 1
87 SOURCESYST CHARACTER VARYING(3) 3
88 COVERAGETYPE CHARACTER VARYING(50) 50
89 JURISDICTIONSTATE BIGINT 8
90 LITIGATIONSTATUS_EXT BIGINT 8
91 PRIMARYBODYFUNCTION_EXT BIGINT 8
92 SEVERITY BIGINT 8