FCT_CIBSECCS_D022_CLMDTLS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIMNUMBER CHARACTER VARYING(40) 40
2 CLAIMORDER BIGINT 8
3 EXPOSUREID BIGINT 8
4 VEHICLEID BIGINT 8
5 VEHICLELOSSPARTY BIGINT 8
6 VEHICLEDRIVEABLE CHARACTER VARYING(1) 1
7 VEHICLETOWED CHARACTER VARYING(2) 2
8 DAMAGEDESCRIPTION CHARACTER VARYING(2000) 2000
9 DRIVERDOB DATE 4
10 DRIVERLICENCETYPE BIGINT 8
11 TP_TYPE BIGINT 8
12 TP_RANKING BIGINT 8
13 TP_INSURED CHARACTER VARYING(1) 1
14 VEHICLEDAMAGE CHARACTER VARYING(1) 1
15 VEHICLEPROCESSTYPE BIGINT 8
16 ASSESSMENTLOCATION CHARACTER VARYING(120) 120
17 REPAIRCOMPLETE CHARACTER VARYING(1) 1
18 DRIVER_RELN_INS BIGINT 8
19 DRIVINGCONSENT CHARACTER VARYING(1) 1
20 YEARSLICENCED BIGINT 8
21 REPAIR_OR_TOTAL_LOSS CHARACTER VARYING(9) 9
22 CROSSREFVEHICLE CHARACTER VARYING(1) 1
23 RECOVERYTYPE BIGINT 8
24 INS_STATUS_RESPONSIBLEPARTY BIGINT 8
25 RECOVERYSTRATEGY BIGINT 8
26 RECOVERYSTATUS BIGINT 8
27 LIABILITYPERCENTAGE NUMERIC(4,1) 19
28 EXPECTED_RECOVERY_AMOUNT NUMERIC(18,2) 19
29 RECOV_SCHEDULED_PAYMENTS NUMERIC(18,2) 19
30 LIABILITY_ASSESSMENT BIGINT 8
31 MARKETVALUE CHARACTER VARYING(1) 1
32 MAKE CHARACTER VARYING(60) 60
33 MODEL CHARACTER VARYING(80) 80
34 NVIC CHARACTER VARYING(15) 15
35 VECHILE_STYLE BIGINT 8
36 MANUFACTURE_YEAR BIGINT 8
37 VECHICLE_NUMBER BIGINT 8
38 REGO_NUMBER CHARACTER VARYING(40) 40
39 VIN CHARACTER VARYING(40) 40
40 HIGH_PERFORMANCE_IND CHARACTER VARYING(1) 1
41 PROTECTION BIGINT 8
42 BODYSTYLE BIGINT 8
43 VEHICLEUSE BIGINT 8
44 RATING CHARACTER VARYING(2) 2
45 MODEL_TYPE CHARACTER VARYING(35) 35
46 MODEL_SERIES CHARACTER VARYING(80) 80
47 BODY_STYLE_DESC CHARACTER VARYING(80) 80
48 ENGINE_CAPACITY CHARACTER VARYING(10) 10
49 ENGINE_CYLINDERS CHARACTER VARYING(20) 20
50 MANUFACTURE_MONTH BIGINT 8
51 MODIFICATION BIGINT 8
52 ACCESSORIES BIGINT 8
53 ACCESSORIES_IN_POLICY CHARACTER VARYING(200) 200
54 PRODUCT_CODE BIGINT 8
55 SETTLEMENT_MANAGMENT_STATUS BIGINT 8
56 CLAIM_FINANCIAL_STATUS CHARACTER VARYING(1) 1
57 RECOVERY_MANAGEMENT_STATUS BIGINT 8
58 POLICYNUMBER CHARACTER VARYING(40) 40
59 MVBRAND BIGINT 8
60 POLICY_EFFDATE TIMESTAMP 8
61 POLICY_EXPDATE TIMESTAMP 8
62 LINEOFBUSINESS BIGINT 8
63 POLICY_STATUS BIGINT 8
64 CANCELLATION_DATE TIMESTAMP 8
65 POLICY_OPTIONAL_COVER CHARACTER VARYING(1) 1
66 POLICYTYPE BIGINT 8
67 INCEPTION_DATE TIMESTAMP 8
68 ENDORSEMENT_DESC CHARACTER VARYING(255) 255
69 ENDORSEMENT_EFFDATE TIMESTAMP 8
70 ENDORSEMENT_EXPDATE TIMESTAMP 8
71 RECOVERY_AMOUNT_NEGOTIATED NUMERIC(18,2) 19
72 ARREARS_AMOUNT NUMERIC(18,2) 19
73 SC_ASSIGNEDUSERID BIGINT 8
74 FINAL_SETTLEMENT_COST NUMERIC(18,2) 19
75 FINAL_LEGAL_COST NUMERIC(18,2) 19
76 FINAL_SETTLEMENT_DATE TIMESTAMP 8
77 MATTER_STATUS CHARACTER VARYING(128) 128
78 MATTER_CLOSED_DATE TIMESTAMP 8
79 MATTER_START_DATE TIMESTAMP 8