FCT_MOTOR_TOTAL_LOSS_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 REPORT_DATE DATE 4
3 ACCESSORIES_MODIFICATION_VALUE NUMERIC(18,2) 19
4 AGREED_VALUE NUMERIC(38,2) 19
5 ASSESSMENT_CENTRE_NAME CHARACTER VARYING(120) 120
6 ASSESSMENT_CENTRE_REGION_NAME CHARACTER VARYING(9) 9
7 ASSESSMENT_CENTRE_STATE_NAME CHARACTER VARYING(256) 256
8 ASSESSMENT_PROCESS_GROUP_NAME CHARACTER VARYING(13) 13
9 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
10 ASSESSOR_BASE_PAV NUMERIC(18,2) 19
11 ASSESSOR_ESTIMATED_PAV NUMERIC(18,2) 19
12 ASSESSOR_NAME CHARACTER VARYING(181) 181
13 ASSESSORS_NET_SETTLEMENT_VALUE NUMERIC(18,2) 19
14 ASSESSORS_SETTLEMENT_VALUE NUMERIC(18,2) 19
15 ASSESSORS_SETTLEMENT_VALUE_BANDING CHARACTER VARYING(12) 12
16 ASSESSORS_SETTLEMENT_VALUE_SUB_BANDING CHARACTER VARYING(16) 16
17 BRAND_ID BIGINT 8
18 BRAND_NAME CHARACTER VARYING(256) 256
19 CATASTROPHE_ID BIGINT 8
20 CATASTROPHE_NAME CHARACTER VARYING(60) 60
21 CLAIM_DECISION_ID BIGINT 8
22 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
23 CLAIM_ID BIGINT 8
24 CLAIM_NUMBER CHARACTER VARYING(40) 40
25 CTP_REGO_DEDUCTION_VALUE NUMERIC(18,2) 19
26 CUSTOMER_SETTLEMENT_VALUE NUMERIC(18,2) 19
27 DAMAGE_DETAILS_TEXT CHARACTER VARYING(17) 17
28 DAMAGE_SEVERITY_ID BIGINT 8
29 DAMAGE_SEVERITY_NAME CHARACTER VARYING(256) 256
30 DAYS_TO_FULFILL INTEGER 4
31 DEDUCTED_EXCESS NUMERIC(21,2) 19
32 EXTERNAL_ASSESSOR_NAME CHARACTER VARYING(120) 120
33 FINANCE_ON_VEHICLE_FLAG CHARACTER VARYING(3) 3
34 FINANCE_PAY_OUT_FIGURE_AMOUNT NUMERIC(38,2) 19
35 FUEL_EFFICENT_FLAG CHARACTER VARYING(3) 3
36 GST_AMOUNT NUMERIC(18,2) 19
37 INCIDENT_ID BIGINT 8
38 ITCE_AMOUNT NUMERIC(18,2) 19
39 LATEST_CANCEL_SUBMISSION_DATE DATE 4
40 LATEST_TOTAL_LOSS_PAID_DATE DATE 4
41 LINE_OF_BUSINESS_ID BIGINT 8
42 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
43 LODGEMENT_DATE DATE 4
44 LOSS_CAUSE_GROUP_TEXT CHARACTER VARYING(14) 14
45 LOSS_CAUSE_ID BIGINT 8
46 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
47 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
48 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
49 LOSS_PARTY_TYPE_ID BIGINT 8
50 LOSS_PARTY_TYPE_NAME CHARACTER VARYING(256) 256
51 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
52 LOSS_CITY CHARACTER VARYING(60) 60
53 LOSS_LONGITUDE NUMERIC(8,5) 19
54 LOSS_LATITUDE NUMERIC(7,5) 19
55 LOSS_POSTCODE CHARACTER VARYING(60) 60
56 LOSS_REGION_NAME CHARACTER VARYING(15) 15
57 LOSS_STATE_ID BIGINT 8
58 LOSS_STATE_NAME CHARACTER VARYING(256) 256
59 LUXURY_CAR_TAX NUMERIC(18,2) 19
60 MILEAGE_ADJUSTMENT_TYPE CHARACTER VARYING(16) 16
61 MILEAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
62 NO_OF_JOBS INTEGER 4
63 NO_OF_PAYMENTS BIGINT 8
64 NO_OF_TOTAL_LOSS_FULFILLED INTEGER 4
65 OLD_DAMAGE_ADJUSTMENT_VALUE NUMERIC(18,2) 19
66 OUTSIDE_OF_SLA CHARACTER VARYING(9) 9
67 POLICY_COVERAGE_TYPE_ID BIGINT 8
68 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
69 PREMIUM_DEDUCTION_VALUE NUMERIC(18,2) 19
70 PRODUCT_ID BIGINT 8
71 PRODUCT_NAME CHARACTER VARYING(256) 256
72 QUOTE_REQUEST_ASSESSOR_TEAM_ID BIGINT 8
73 QUOTE_REQUEST_ASSESSOR_TEAM_NAME CHARACTER VARYING(100) 100
74 QUOTE_REQUEST_ASSESSOR_LOOKUP_USER_ID BIGINT 8
75 QUOTE_REQUEST_ASSESSOR_USER_ID BIGINT 8
76 QUOTE_REQUEST_ASSESSOR_USER_NAME CHARACTER VARYING(181) 181
77 REASON_FOR_NO_WOVR_ID BIGINT 8
78 REASON_FOR_NO_WOVR_NAME CHARACTER VARYING(256) 256
79 REGISTERED_STATE_ID BIGINT 8
80 REGISTERED_STATE_NAME CHARACTER VARYING(256) 256
81 REPLACEMENT_PRICE_INC_GST NUMERIC(18,2) 19
82 REPLACEMENT_VEHICLE_FLAG CHARACTER VARYING(3) 3
83 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
84 RISK_CITY CHARACTER VARYING(60) 60
85 RISK_LONGITUDE NUMERIC(8,5) 19
86 RISK_LATITUDE NUMERIC(7,5) 19
87 RISK_POSTCODE CHARACTER VARYING(60) 60
88 RISK_REGION_NAME CHARACTER VARYING(15) 15
89 RISK_STATE_ID BIGINT 8
90 RISK_STATE_NAME CHARACTER VARYING(256) 256
91 SALVAGE_DEDUCTION_AMOUNT NUMERIC(18,2) 19
92 SALVAGE_DISPOSAL_TYPE_ID BIGINT 8
93 SALVAGE_DISPOSAL_TYPE_NAME CHARACTER VARYING(256) 256
94 SALVAGE_ESTIMATE_VALUE NUMERIC(18,2) 19
95 SALVAGE_RIGHTS_FLAG CHARACTER VARYING(9) 9
96 SHARPS_CHECK_FLAG CHARACTER VARYING(3) 3
97 SUBMITTED_BUT_NOT_FULLFILLED_FLAG CHARACTER VARYING(13) 13
98 SUM_INSURED NUMERIC(38,2) 19
99 TOTAL_LOSS_FULFILLED_AMT_BEING_PAID NUMERIC(38,2) 19
100 TOTAL_LOSS_FULFILLED_BY_TEAM_ID BIGINT 8
101 TOTAL_LOSS_FULFILLED_BY_TEAM_NAME CHARACTER VARYING(100) 100
102 TOTAL_LOSS_FULFILLED_BY_LOOKUP_USER_ID BIGINT 8
103 TOTAL_LOSS_FULFILLED_BY_USER_ID BIGINT 8
104 TOTAL_LOSS_FULFILLED_BY_USER_NAME CHARACTER VARYING(181) 181
105 TOTAL_LOSS_FULFILLED_DATE DATE 4
106 TOTAL_LOSS_PAID_TEAM_ID BIGINT 8
107 TOTAL_LOSS_PAID_TEAM_NAME CHARACTER VARYING(100) 100
108 TOTAL_LOSS_PAID_BY_LOOKUP_USER_ID BIGINT 8
109 TOTAL_LOSS_PAID_USER_ID BIGINT 8
110 TOTAL_LOSS_PAID_USER_NAME CHARACTER VARYING(181) 181
111 TOTAL_LOSS_SUBMITTED_BY_TEAM_ID BIGINT 8
112 TOTAL_LOSS_SUBMITTED_BY_TEAM_NAME CHARACTER VARYING(100) 100
113 TOTAL_LOSS_SUBMITTED_BY_LOOKUP_USER_ID BIGINT 8
114 TOTAL_LOSS_SUBMITTED_BY_USER_ID BIGINT 8
115 TOTAL_LOSS_SUBMITTED_BY_USER_NAME CHARACTER VARYING(181) 181
116 TOTAL_LOSS_SUBMITTED_DATE DATE 4
117 TOTAL_PAYMENT_AMOUNT NUMERIC(38,2) 19
118 VEHICLE_ASSESSMENT_STATUS_ID BIGINT 8
119 VEHICLE_ASSESSMENT_STATUS_NAME CHARACTER VARYING(256) 256
120 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
121 VEHICLE_MAKE CHARACTER VARYING(60) 60
122 VEHICLE_MODEL CHARACTER VARYING(80) 80
123 VEHICLE_RECOVERED_DATE DATE 4
124 VEHICLE_RECOVERED_FLAG CHARACTER VARYING(9) 9
125 VEHICLE_STYLE_ID BIGINT 8
126 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
127 VEHICLE_YEAR CHARACTER VARYING(9) 9
128 WOVR_FLAG CHARACTER VARYING(3) 3
129 WOVR_TYPE_ID BIGINT 8
130 WOVR_TYPE_NAME CHARACTER VARYING(256) 256
131 WOVR_VEHICLE_TYPE_ID BIGINT 8
132 WOVR_VEHICLE_TYPE_NAME CHARACTER VARYING(256) 256
133 TOTAL_LOSS_STATUS CHARACTER VARYING(9) 9
134 EVENT_NAME CHARACTER VARYING(256) 256
135 LARGE_LOSS_FLAG CHARACTER VARYING(3) 3
136 CLAIM_STATE_ID BIGINT 8
137 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
138 TOTAL_LOSS_AGE_BAND CHARACTER VARYING(10) 10
139 TOTAL_LOSS_AGE_SUB_BAND CHARACTER VARYING(14) 14
140 TOTAL_LOSS_AGE_BAND_RANK INTEGER 4
141 TOTAL_LOSS_AGE_SUB_BAND_RANK INTEGER 4
142 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
143 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
144 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
145 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
146 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
147 CLAIM_PROCESS_TYPE_ID BIGINT 8
148 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
149 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
150 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
151 CCR_CC_CLAIM_LOSSDATE DATE 4
152 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
153 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
154 CCR_CC_POLICY_POLICYTYPE BIGINT 8
155 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
156 LOSS_CCR_CC_ADDRESS_COUNTRY BIGINT 8
157 LOSS_COUNTRY_NAME CHARACTER VARYING(256) 256
158 REVISED_SETTLEMENT_VALUE NUMERIC(18,2) 19
159 CI_TOTAL_LOSS_LARGE_LOSS_FLAG CHARACTER VARYING(9) 9
160 CCR_CCTL_LICENCECLASS_EXT_ID BIGINT 8
161 CCR_CCTL_LICENCECLASS_EXT_NAME CHARACTER VARYING(256) 256
162 FLEET_IND CHARACTER VARYING(9) 9
163 CAS_IND CHARACTER VARYING(9) 9
164 POLICYNUMBER CHARACTER VARYING(40) 40
165 ASSESSORS_SETTLEMENT_VALUE_SUB_BANDING_RANKING INTEGER 4
166 ASSESSORS_SETTLEMENT_VALUE_BANDING_RANKING INTEGER 4
167 NVIC CHARACTER VARYING(15) 15
168 SC_MARKETVALUEIND CHARACTER VARYING(9) 9
169 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
170 LEGACY_CLAIM CHARACTER VARYING(20) 20
171 LEGACY_TYPE CHARACTER VARYING(256) 256