INT_CIBSECCS_D010_CHDR_STG01

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 POLICYID BIGINT 8
10 EXPOSUREDATECREATED DATE 4
11 EXPOSUREDATEUPDATED DATE 4
12 EXPOSUREDATEFINALISED DATE 4
13 EXPOSUREDATEREOPENED DATE 4
14 EXPOSURECOVERAGEID BIGINT 8
15 FAULTRATING BIGINT 8
16 SC_EXCESS NUMERIC(18,2) 19
17 CATASTROPHEID BIGINT 8
18 SC_CLAIMDECISION BIGINT 8
19 SC_CLOSEDOUTCOME BIGINT 8
20 UPDATETIME TIMESTAMP 8
21 SC_REJECTOVERRIDE BIGINT 8
22 REPORTEDDATE TIMESTAMP 8
23 HOWREPORTED BIGINT 8
24 CLAIMSTATE BIGINT 8
25 DESCRIPTION CHARACTER VARYING(2000) 2000
26 REOPENDATE TIMESTAMP 8
27 CLOSEDATE TIMESTAMP 8
28 LOSSDATE TIMESTAMP 8
29 LOSSCAUSE BIGINT 8
30 LOSSTYPE BIGINT 8
31 ACCIDENTTYPE BIGINT 8
32 ASSIGNEDBYUSERID BIGINT 8
33 ASSIGNEDGROUPID BIGINT 8
34 FAULT NUMERIC(4,1) 19
35 INCIDENTREPORT CHARACTER VARYING(1) 1
36 LOBCODE BIGINT 8
37 LOCATIONCODEID BIGINT 8
38 LOSSLOCATIONCODE CHARACTER VARYING(5) 5
39 LOSSLOCATIONID BIGINT 8
40 SC_INCIDENTREPORT BIGINT 8
41 SC_LOSSCAUSE BIGINT 8
42 SC_ORIGINALTOTALESTIMATEVALUE NUMERIC(18,2) 19
43 SC_POLICYLOCATIONFK BIGINT 8
44 SC_PREMIUMCLASS BIGINT 8
45 SC_TPSETTLEMGMTSTATUS BIGINT 8
46 SUBROGATIONSTATUS BIGINT 8
47 CREATETIME TIMESTAMP 8
48 LITIGATION_STATUS BIGINT 8
49 INVESTIGATION_STATUS BIGINT 8
50 REPORTEDTIME TIMESTAMP 8
51 CLAIM_CREATEUSERID BIGINT 8
52 ASSIGNEDUSERID BIGINT 8
53 CLAIM_UPDATEUSERID BIGINT 8
54 SC_CLAIMAUTO BIGINT 8
55 COVERAGETYPE CHARACTER VARYING(50) 50
56 JURISDICTIONSTATE BIGINT 8
57 LITIGATIONSTATUS_EXT BIGINT 8
58 POLICYNUMBER CHARACTER VARYING(40) 40
59 LINEOFBUSINESS BIGINT 8
60 MVBRAND BIGINT 8
61 SC_LINEOFBUSINESS BIGINT 8
62 POLICY_EFFDATE TIMESTAMP 8
63 POLICY_EXPDATE TIMESTAMP 8
64 POLICY_STATUS BIGINT 8
65 SC_PREMIUMSTATUS BIGINT 8
66 ORIGEFFECTIVEDATE TIMESTAMP 8
67 SC_CHANNEL CHARACTER VARYING(20) 20
68 SC_PAYMENTMODE BIGINT 8
69 SC_RESPONSIBILITYCENTER CHARACTER VARYING(4) 4
70 SC_SERVICECENTER CHARACTER VARYING(4) 4
71 CANCELLATIONDATE TIMESTAMP 8
72 VERIFIED CHARACTER VARYING(1) 1
73 SOURCESYST CHARACTER VARYING(3) 3