INT_CIBSECCS_D012_CLMDTLS_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 ACCESSORIES BIGINT 8
6 ACCESSORIES_IN_POLICY CHARACTER VARYING(200) 200
7 CANCELLATIONDATE TIMESTAMP 8
8 CLAIMCONTACTID BIGINT 8
9 CONTACTID BIGINT 8
10 CONTACTNAME CHARACTER VARYING(120) 120
11 DATEOFBIRTH TIMESTAMP 8
12 CONTACTSUBTYPE BIGINT 8
13 SC_DRIVERLICENCETYPE BIGINT 8
14 DRIVERWITHCONSENT CHARACTER VARYING(1) 1
15 YEARSLICENCEHELD BIGINT 8
16 ENDORSEMENT_DESC CHARACTER VARYING(255) 255
17 ENDORSEMENT_EFFDATE TIMESTAMP 8
18 ENDORSEMENT_EXPDATE TIMESTAMP 8
19 MVBRAND BIGINT 8
20 FAULTRATING BIGINT 8
21 INCIDENTID BIGINT 8
22 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
23 LOSSTYPE BIGINT 8
24 MVPOLICYTYPE BIGINT 8
25 POLICYOPTIONALCOVER CHARACTER VARYING(1) 1
26 ORIGEFFECTIVEDATE TIMESTAMP 8
27 POLICY_STATUS BIGINT 8
28 POLICYNUMBER CHARACTER VARYING(40) 40
29 POLICY_EFFDATE TIMESTAMP 8
30 POLICY_EXPDATE TIMESTAMP 8
31 SC_MARKETVALUEIND CHARACTER VARYING(1) 1
32 MAKE CHARACTER VARYING(60) 60
33 MODEL CHARACTER VARYING(80) 80
34 SC_NVIC CHARACTER VARYING(15) 15
35 STYLE BIGINT 8
36 YEAR BIGINT 8
37 SC_VEHICLECOVERAGETYPE BIGINT 8
38 LICENSEPLATE CHARACTER VARYING(40) 40
39 VIN CHARACTER VARYING(40) 40
40 SC_HIGHPERFORMANCEIND CHARACTER VARYING(1) 1
41 SC_PROTECTIONLEVEL BIGINT 8
42 SC_BODYSTYLE BIGINT 8
43 SC_VEHICLEUSE BIGINT 8
44 SC_RATINGLEVEL CHARACTER VARYING(2) 2
45 SC_MODELTYPE CHARACTER VARYING(35) 35
46 SC_MODELSERIES CHARACTER VARYING(80) 80
47 SC_BODYSTYLEDESC CHARACTER VARYING(80) 80
48 SC_ENGINECAPACITY CHARACTER VARYING(10) 10
49 SC_NUMBEROFCYLINDERS CHARACTER VARYING(20) 20
50 SC_MONTHOFMANUFACTURE BIGINT 8
51 SC_LINEOFBUSINESS BIGINT 8
52 SC_RELATIONTOINSURED BIGINT 8
53 SC_TPSETTLEMGMTSTATUS BIGINT 8
54 SUBROGATIONSTATUS BIGINT 8
55 SUBROADVERSEPARTYID BIGINT 8
56 SC_EXPECTEDRECOVERYAMT NUMERIC(18,2) 19
57 FAULT NUMERIC(4,1) 19
58 SC_RECOVERYSTATUS BIGINT 8
59 STRATEGY BIGINT 8
60 CLASSIFICATION BIGINT 8
61 SC_RECOVERYTYPECODE BIGINT 8
62 SUBROINSTALLMENTAMOUNT NUMERIC(18,2) 19
63 SC_NEGOTIATEDRECOVERYAMT NUMERIC(18,2) 19
64 SC_ARREARSAMT NUMERIC(18,2) 19
65 SC_ISCLAIMFINANCIAL CHARACTER VARYING(1) 1
66 SC_ASSIGNEDUSERID BIGINT 8
67 INCIDENT_SUBTYPE BIGINT 8
68 SC_INCIDENTRANKING BIGINT 8
69 SC_TPINSURED CHARACTER VARYING(1) 1
70 SC_DAMAGEIND CHARACTER VARYING(1) 1
71 TOTALLOSSSTATUS CHARACTER VARYING(50) 50
72 VEHICLE_MOD_CODE BIGINT 8
73 VEHICLEASSESSMENTSTATUS BIGINT 8
74 VEHICLEID BIGINT 8
75 VEHICLELOSSPARTY BIGINT 8
76 VEHICLEOPERABLE CHARACTER VARYING(1) 1
77 VEHTOWEDIND CHARACTER VARYING(2) 2