FCT_MOTOR_SALVAGE_INSIGHT_HIST_20210801035824

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_ID_NAME CHARACTER VARYING(10) 10
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 REPORT_DATE DATE 4
5 ACCESSORIES_FLAG CHARACTER VARYING(3) 3
6 AGE_FROM_ARRIVAL_BANDING CHARACTER VARYING(10) 10
7 AGE_FROM_ARRIVAL_DAYS INTEGER 4
8 AGE_SINCE_RECEIVED_DAYS INTEGER 4
9 AGE_SINCE_RELEASED_BANDING CHARACTER VARYING(10) 10
10 AGE_SINCE_RELEASED_DAYS INTEGER 4
11 AGREED_VALUE NUMERIC(38,2) 19
12 ASSESSOR_BASE_PAV NUMERIC(18,2) 19
13 ASSESSOR_ESTIMATED_PAV NUMERIC(18,2) 19
14 ASSESSORS_SETTLEMENT_VALUE NUMERIC(18,2) 19
15 BRAND_ID BIGINT 8
16 BRAND_NAME CHARACTER VARYING(256) 256
17 CATASTROPHE_CODE_ID BIGINT 8
18 CATASTROPHE_CODE_NAME CHARACTER VARYING(60) 60
19 CLAIM_CREATE_DATE_TEXT CHARACTER VARYING(10) 10
20 CLAIM_DECISION_ID BIGINT 8
21 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
22 COMMISSION_AMOUNT NUMERIC(38,6) 19
23 DAMAGE_SEVERITY_ID BIGINT 8
24 DAMAGE_SEVERITY_NAME CHARACTER VARYING(256) 256
25 DATE_OF_ARRIVAL DATE 4
26 EXTERNAL_ASSESSOR_FLAG CHARACTER VARYING(3) 3
27 FIRST_TOTAL_LOSS_PAID_DATE DATE 4
28 FINANCE_ON_VEHICLE_FLAG CHARACTER VARYING(3) 3
29 INCIDENT_ID BIGINT 8
30 LINE_OF_BUSINESS_ID BIGINT 8
31 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
32 LODGEMENT_DATE DATE 4
33 LOSS_CAUSE_ID BIGINT 8
34 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
35 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
36 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
37 LOSS_PARTY_TYPE_ID BIGINT 8
38 LOSS_PARTY_TYPE_NAME CHARACTER VARYING(256) 256
39 LOSS_POSTCODE CHARACTER VARYING(60) 60
40 LOSS_REGION_NAME CHARACTER VARYING(15) 15
41 LOSS_STATE_ID BIGINT 8
42 LOSS_STATE_NAME CHARACTER VARYING(256) 256
43 MILEAGE_ADJUSTMENT_TYPE CHARACTER VARYING(16) 16
44 MILEAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
45 NO_OF_ARRIVAL INTEGER 4
46 NO_OF_JOBS INTEGER 4
47 NO_OF_PAYMENTS BIGINT 8
48 NO_OF_RELEASED_FOR_SALE INTEGER 4
49 NO_OF_SALVAGE_RECEIVED INTEGER 4
50 OLD_DAMAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
51 POLICY_COVERAGE_TYPE_ID BIGINT 8
52 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
53 PRODUCT_ID BIGINT 8
54 PRODUCT_NAME CHARACTER VARYING(256) 256
55 REASON_FOR_NO_WOVR_ID BIGINT 8
56 REASON_FOR_NO_WOVR_NAME CHARACTER VARYING(256) 256
57 RELEASED_FOR_SALE_FLAG CHARACTER VARYING(3) 3
58 RELEASED_DATE DATE 4
59 REGISTERED_STATE_ID BIGINT 8
60 REGISTERED_STATE_NAME CHARACTER VARYING(256) 256
61 REVS_CHECKED_DATE DATE 4
62 RISK_POSTCODE CHARACTER VARYING(60) 60
63 RISK_REGION_NAME CHARACTER VARYING(15) 15
64 RISK_STATE_ID BIGINT 8
65 RISK_STATE_NAME CHARACTER VARYING(256) 256
66 SALVAGE_DATE_OF_SALE DATE 4
67 SALVAGE_DEDUCTION_AMOUNT NUMERIC(18,2) 19
68 SALVAGE_DISPOSAL_TYPE_ID BIGINT 8
69 SALVAGE_DISPOSAL_TYPE_NAME CHARACTER VARYING(256) 256
70 SALVAGE_ESTIMATE_VALUE NUMERIC(18,2) 19
71 SALVAGE_PROVIDER_ID BIGINT 8
72 SALVAGE_PROVIDER_NAME CHARACTER VARYING(256) 256
73 SALVAGE_RECEIVED_FLAG CHARACTER VARYING(3) 3
74 SALVAGE_RECEIVED_DATE DATE 4
75 SALVAGE_RIGHTS_FLAG CHARACTER VARYING(9) 9
76 SALVAGE_SALE_AMOUNT NUMERIC(38,2) 19
77 SUM_INSURED NUMERIC(38,2) 19
78 THEFT_CLAIM_FLAG CHARACTER VARYING(3) 3
79 TOTAL_LOSS_SUBMITTED_DATE DATE 4
80 TOTAL_LOSS_FULFILLED_AMT_BEING_PAID NUMERIC(38,2) 19
81 TOTAL_LOSS_FULFILLED_DATE DATE 4
82 TOTAL_PAYMENT_AMOUNT NUMERIC(38,2) 19
83 UNRECOVERED_THEFT_FLAG CHARACTER VARYING(3) 3
84 VEHICLE_ASSESSMENT_STATUS_ID BIGINT 8
85 VEHICLE_ASSESSMENT_STATUS_NAME CHARACTER VARYING(256) 256
86 VEHICLE_MAKE CHARACTER VARYING(60) 60
87 VEHICLE_MODEL CHARACTER VARYING(80) 80
88 SC_NVIC CHARACTER VARYING(15) 15
89 VEHICLE_RECOVERED_DATE DATE 4
90 VEHICLE_RECOVERED_FLAG CHARACTER VARYING(9) 9
91 VEHICLE_STYLE_ID BIGINT 8
92 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
93 VEHICLE_YEAR BIGINT 8
94 VEHICLE_YEAR_NAME CHARACTER VARYING(9) 9
95 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
96 WOVR_FLAG CHARACTER VARYING(3) 3
97 WOVR_TYPE_ID BIGINT 8
98 WOVR_TYPE_NAME CHARACTER VARYING(256) 256
99 WOVR_VEHICLE_TYPE_ID BIGINT 8
100 WOVR_VEHICLE_TYPE_NAME CHARACTER VARYING(256) 256
101 EVENT_NAME CHARACTER VARYING(256) 256
102 LARGE_LOSS_FLAG CHARACTER VARYING(3) 3
103 TOTAL_LOSS_STATUS CHARACTER VARYING(9) 9
104 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
105 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
106 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
107 CLAIM_PROCESS_TYPE_ID BIGINT 8
108 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
109 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
110 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
111 CCR_CC_CLAIM_LOSSDATE DATE 4
112 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
113 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
114 CCR_CC_POLICY_POLICYTYPE BIGINT 8
115 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
116 FLEET_IND CHARACTER VARYING(9) 9
117 CAS_IND CHARACTER VARYING(9) 9
118 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
119 SC_MARKETVALUEIND CHARACTER VARYING(9) 9
120 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
121 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
122 RISK_CITY CHARACTER VARYING(60) 60
123 RISK_LONGITUDE NUMERIC(8,5) 19
124 RISK_LATITUDE NUMERIC(7,5) 19
125 LOSS_CITY CHARACTER VARYING(60) 60
126 LOSS_LONGITUDE NUMERIC(8,5) 19
127 LOSS_LATITUDE NUMERIC(7,5) 19
128 TOW_SERVICE_USED_FLAG CHARACTER VARYING(1) 1
129 TOW_SERVICE_COUNT NUMERIC(38,0) 19
130 TOW_FULLFILLED_AMOUNT NUMERIC(38,2) 19
131 TOW_MIN_CREATE_DATE TIMESTAMP 8
132 GLASS_SERVICE_USED_FLAG CHARACTER VARYING(1) 1
133 GLASS_SERVICE_COUNT NUMERIC(38,0) 19
134 GLASS_FULLFILLED_AMOUNT NUMERIC(38,2) 19
135 GLASS_MIN_CREATE_DATE TIMESTAMP 8
136 INVESTIGATION_STATUS_ID BIGINT 8
137 INVESTIGATION_STATUS_NAME CHARACTER VARYING(256) 256
138 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
139 LEGACY_CLAIM CHARACTER VARYING(3) 3
140 LEGACY_TYPE CHARACTER VARYING(256) 256