INT_MOTOR_SALVAGE_INCIDENT_CUBE

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VEHICLEINCIDENT BIGINT 8
2 TOTAL_LOSS_SUBMITTED_DATE TIMESTAMP 8
3 TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
4 LATEST_CANCEL_SUBMISSION_DATE TIMESTAMP 8
5 CASH_SETTLEMENT_AUTHORISED_DATE TIMESTAMP 8
6 TOTAL_LOSS_SUBMITTED_BY_USER_ID BIGINT 8
7 TOTAL_LOSS_FULFILLED_BY_USER_ID BIGINT 8
8 DAYS_TO_FULFILL INTEGER 4
9 OUTSIDE_OF_SLA CHARACTER VARYING(3) 3
10 NO_OF_TOTAL_LOSS_FULFILLED INTEGER 4
11 INCIDENT_ID BIGINT 8
12 CLAIM_ID BIGINT 8
13 REGISTERED_STATE_ID BIGINT 8
14 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
15 VEHICLE_YEAR BIGINT 8
16 VEHICLE_MAKE CHARACTER VARYING(60) 60
17 VEHICLE_MODEL CHARACTER VARYING(80) 80
18 SC_NVIC CHARACTER VARYING(15) 15
19 VEHICLE_STYLE_ID BIGINT 8
20 FINANCE_ON_VEHICLE_FLAG CHARACTER VARYING(3) 3
21 DAMAGE_DETAILS_TEXT CHARACTER VARYING(17) 17
22 LOSS_PARTY_TYPE_ID BIGINT 8
23 VEHICLE_ASSESSMENT_STATUS_ID BIGINT 8
24 VEHICLE_ASSESSMENT_STATUS_CODE CHARACTER VARYING(50) 50
25 EXTERNAL_ASSESSOR_FLAG CHARACTER VARYING(3) 3
26 ASSESSORS_SETTLEMENT_VALUE NUMERIC(18,2) 19
27 LARGE_LOSS_FLAG CHARACTER VARYING(3) 3
28 ASSESSORS_NET_SETTLEMENT_VALUE NUMERIC(18,2) 19
29 CUSTOMER_SETTLEMENT_VALUE NUMERIC(18,2) 19
30 ITCE_AMOUNT NUMERIC(18,2) 19
31 SALVAGE_DEDUCTION_AMOUNT NUMERIC(18,2) 19
32 DEDUCTED_EXCESS NUMERIC(21,2) 19
33 CTP_REGO_DEDUCTION_VALUE NUMERIC(18,2) 19
34 PREMIUM_DEDUCTION_VALUE NUMERIC(18,2) 19
35 ASSESSOR_BASE_PAV NUMERIC(18,2) 19
36 ASSESSOR_ESTIMATED_PAV NUMERIC(18,2) 19
37 ACCESSORIES_FLAG CHARACTER VARYING(3) 3
38 MILEAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
39 OLD_DAMAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
40 REPLACEMENT_PRICE_INC_GST NUMERIC(18,2) 19
41 GST_AMOUNT NUMERIC(18,2) 19
42 LUXURY_CAR_TAX NUMERIC(18,2) 19
43 SALVAGE_ESTIMATE_VALUE NUMERIC(18,2) 19
44 SALVAGE_DISPOSAL_TYPE_ID BIGINT 8
45 SUBMITTED_BUT_NOT_FULLFILLED_FLAG CHARACTER VARYING(3) 3
46 MILEAGE_ADJUSTMENT_TYPE CHARACTER VARYING(16) 16
47 REPLACEMENT_VEHICLE_FLAG CHARACTER VARYING(3) 3
48 FUEL_EFFICENT_FLAG CHARACTER VARYING(3) 3
49 WOVR_FLAG CHARACTER VARYING(3) 3
50 WOVR_TYPE_ID BIGINT 8
51 WOVR_VEHICLE_TYPE_ID BIGINT 8
52 ASSESSORS_SETTLEMENT_VALUE_BANDING_LEVEL_1 CHARACTER VARYING(21) 21
53 ASSESSORS_SETTLEMENT_VALUE_BANDING_LEVEL_2 CHARACTER VARYING(30) 30
54 DATE_OF_ARRIVAL TIMESTAMP 8
55 SALVAGE_SALE_DATE TIMESTAMP 8
56 AGE_FROM_ARRIVAL_DAYS INTEGER 4
57 AGE_FROM_ARRIVAL_BANDING CHARACTER VARYING(10) 10
58 SALVAGE_PROVIDER_ID BIGINT 8
59 REVS_CHECKED_DATE TIMESTAMP 8
60 NO_OF_SHARPS BIGINT 8
61 POLICY_COVERAGE_TYPE_ID BIGINT 8
62 REASON_FOR_NO_WOVR_ID BIGINT 8
63 VEHICLE_RECOVERED_DATE TIMESTAMP 8
64 VEHICLE_RECOVERED_FLAG CHARACTER VARYING(9) 9
65 SALVAGE_RIGHTS_FLAG CHARACTER VARYING(9) 9
66 AGREED_VALUE NUMERIC(38,2) 19
67 SUM_INSURED NUMERIC(38,2) 19
68 FINANCE_PAY_OUT_FIGURE_AMOUNT NUMERIC(38,2) 19
69 TOTAL_LOSS_FULFILLED_AMT_BEING_PAID NUMERIC(38,2) 19
70 TOTAL_CASH_SETTLEMENT_PAYMENT_AMOUNT NUMERIC(38,2) 19
71 LATEST_CASH_SETTLEMENT_REASON_ID BIGINT 8
72 LATEST_CASH_SETTLEMENT_TYPE_ID BIGINT 8
73 NO_OF_CASH_SETTLEMNTS_IN_LIEU_OF_REPAIR BIGINT 8
74 MULTIPLE_CASE_SETTLEMENT_FLAG CHARACTER VARYING(3) 3
75 NO_OF_JOBS INTEGER 4
76 LATEST_TOTAL_LOSS_PAID_DATE TIMESTAMP 8
77 NO_OF_PAYMENTS BIGINT 8
78 TOTAL_PAYMENT_AMOUNT NUMERIC(38,2) 19
79 TOTAL_LOSS_PAID_USER_ID BIGINT 8
80 FIRST_TOTAL_LOSS_PAID_DATE TIMESTAMP 8
81 EXTERNAL_ASSESSOR_NAME CHARACTER VARYING(120) 120
82 ASSESSMENT_PROCESS_GROUP_NAME CHARACTER VARYING(13) 13
83 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(50) 50
84 ASSESSMENTTOTALLOSS_ID BIGINT 8
85 DAMAGE_SEVERITY_ID BIGINT 8
86 NO_OF_CASH_SETTLEMENT INTEGER 4
87 FLEET_IND CHARACTER VARYING(9) 9
88 CAS_IND CHARACTER VARYING(7) 7
89 REVISED_SETTLEMENT_VALUE NUMERIC(18,2) 19
90 SC_MARKETVALUEIND CHARACTER VARYING(9) 9
91 TOTAL_LOSS_STATUS CHARACTER VARYING(9) 9
92 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3