FCT_MOTOR_CLAIMS_ASSIST_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 LOSS_TYPE_CODE CHARACTER VARYING(50) 50
5 POLICY_ID BIGINT 8
6 POLICY_NUMBER CHARACTER VARYING(40) 40
7 LODGEMENT_DATE TIMESTAMP 8
8 UPDATETIME TIMESTAMP 8
9 EXTRACT_TIMESTAMP TIMESTAMP 8
10 RISK_STATE_ID BIGINT 8
11 RISK_REGION_NAME CHARACTER VARYING(15) 15
12 RISK_POSTCODE CHARACTER VARYING(60) 60
13 LOSS_STATE_ID BIGINT 8
14 LOSS_REGION_NAME CHARACTER VARYING(15) 15
15 LOSS_POSTCODE CHARACTER VARYING(60) 60
16 LINE_OF_BUSINESS_ID BIGINT 8
17 VEHICLE_STYLE_ID BIGINT 8
18 VEHICLE_INCIDENT_ID BIGINT 8
19 BRAND_ID BIGINT 8
20 CLAIM_DECISION_ID BIGINT 8
21 LOSS_TYPE_ID BIGINT 8
22 CREATE_DATE TIMESTAMP 8
23 REOPEN_DATE TIMESTAMP 8
24 FINALISED_DATE TIMESTAMP 8
25 FIRST_REOPEN_DATE TIMESTAMP 8
26 LATEST_REOPEN_DATE TIMESTAMP 8
27 LATEST_FINALISED_DATE TIMESTAMP 8
28 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
29 CLAIM_STATE_ID INTEGER 4
30 REJECT_REASON_ID BIGINT 8
31 REOPEN_REASON_ID BIGINT 8
32 LOSS_CAUSE_ID BIGINT 8
33 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
34 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
35 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
36 LOSS_CAUSE_GROUP CHARACTER VARYING(14) 14
37 CATASTOPHE_ID BIGINT 8
38 CATASTROPHE_NUMBER CHARACTER VARYING(60) 60
39 CATASTROPHE_NAME CHARACTER VARYING(60) 60
40 PREMIUM_STATUS_ID BIGINT 8
41 POLICY_STATUS_ID BIGINT 8
42 POLICY_COVERAGE_TYPE_ID BIGINT 8
43 INVESTIGATION_STATUS_ID BIGINT 8
44 ADJUSTER_USER_ID BIGINT 8
45 CLAIM_CREATE_USER_ID BIGINT 8
46 CLAIM_CREATE_USER_CA_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
47 CLAIM_CREATE_USER_CA_NAME CHARACTER VARYING(256) 256
48 CLAIM_CREATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
49 CLAIM_CREATE_USER_CA_LEADER CHARACTER VARYING(256) 256
50 CLAIM_CREATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
51 CLAIM_UPDATE_USER_ID BIGINT 8
52 CLAIM_CREATE_USER_DATE_KEY CHARACTER VARYING(285) 285
53 LODGEMENT_USER_ID BIGINT 8
54 LODGEMENT_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
55 LODGEMENT_USER_DATE_KEY CHARACTER VARYING(455) 455
56 LODGEMENT_USER_CA_NAME CHARACTER VARYING(256) 256
57 LODGEMENT_USER_CA_MANAGER CHARACTER VARYING(256) 256
58 LODGEMENT_USER_CA_LEADER CHARACTER VARYING(256) 256
59 LODGEMENT_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
60 LIABILITY_ASSESSMENT_ID BIGINT 8
61 EXCESS_RECEIVED_FLAG CHARACTER VARYING(9) 9
62 FIRST_EXCESS_RECEIVED_DATE TIMESTAMP 8
63 LATEST_EXCESS_RECEIVED_DATE TIMESTAMP 8
64 EXCESS_AMOUNT NUMERIC(38,2) 19
65 INITIAL_EXCESS_COLLECTION_AGE INTEGER 4
66 INITIAL_EXCESS_COLLECTION_AGE_BAND_ID INTEGER 4
67 DAMAGE_INDICATOR_FLAG CHARACTER VARYING(9) 9
68 VEHICLE_TOWED_FLAG CHARACTER VARYING(9) 9
69 VEHICLE_OPERABLE_FLAG CHARACTER VARYING(9) 9
70 EXCESS_WAIVED_FLAG CHARACTER VARYING(9) 9
71 TOTAL_EXCESS_APPLICABLE NUMERIC(18,2) 19
72 ASSESSMENT_BOOKING_CREATE_DATE TIMESTAMP 8
73 ASSESSMENT_BOOKING_APPOINTMENT_DATE TIMESTAMP 8
74 ASSESSMENT_BOOKING_UDPATE_DATE TIMESTAMP 8
75 CONTACT_ID BIGINT 8
76 ASSESSMENT_PROCESS_TYPE_ID BIGINT 8
77 ASSESSMENT_BOOKING_LOCATION_ID CHARACTER VARYING(30) 30
78 ASSESSMENT_BOOKING_LOCATION_TYPE_ID BIGINT 8
79 ASSESSMENT_BOOKING_LOCATION_STATE_ID BIGINT 8
80 CHOICE_OF_REPAIRER_FLAG CHARACTER VARYING(9) 9
81 BOOKING_COMPLETED_FLAG CHARACTER VARYING(9) 9
82 BOOK_APPOINTMENT_FLAG CHARACTER VARYING(9) 9
83 ASSESSMENT_BOOKING_STATUS_ID BIGINT 8
84 ASSESSMENT_NON_BOOKING_REASON_ID BIGINT 8
85 ASSESSMENT_BOOKING_CREATE_USER_ID BIGINT 8
86 ASSESSMENT_BOOKING_CREATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
87 ASSESSMENT_BOOKING_CREATE_USER_CA_NAME CHARACTER VARYING(256) 256
88 ASSESSMENT_BOOKING_CREATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
89 ASSESSMENT_BOOKING_CREATE_USER_CA_LEADER CHARACTER VARYING(256) 256
90 ASSESSMENT_BOOKING_CREATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
91 ASSESSMENT_BOOKING_UPDATE_USER_CA_EMPLOYEE_NUMBER CHARACTER VARYING(256) 256
92 ASSESSMENT_BOOKING_UPDATE_USER_CA_NAME CHARACTER VARYING(256) 256
93 ASSESSMENT_BOOKING_UPDATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
94 ASSESSMENT_BOOKING_UPDATE_USER_CA_LEADER CHARACTER VARYING(256) 256
95 ASSESSMENT_BOOKING_UPDATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
96 ASSESSMENT_BOOKING_USER_DATE_KEY CHARACTER VARYING(285) 285
97 AGE_TO_ACTIVATE INTEGER 4
98 SMART_BOOKING_OPPORTUNITY_FLAG CHARACTER VARYING(9) 9
99 LOSS_PARTY_TYPE_ID BIGINT 8
100 BOOKING_CANCEL_REASON_ID BIGINT 8
101 ASSESSMENT_BOOKING_UPDATE_USER_ID BIGINT 8
102 ASSESSMENT_BOOKING_UPDATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
103 ASSESSMENT_BOOKING_UPDATE_USER_NAME CHARACTER VARYING(181) 181
104 LICENSE_PLATE CHARACTER VARYING(40) 40
105 REPAIRER_ID BIGINT 8
106 REPAIRER_NAME CHARACTER VARYING(181) 181
107 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
108 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
109 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
110 CLAIM_PROCESS_TYPE_ID BIGINT 8
111 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
112 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
113 LOSSDATE TIMESTAMP 8
114 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
115 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
116 CCR_CC_POLICY_POLICYTYPE BIGINT 8
117 FLEET_IND CHARACTER VARYING(9) 9
118 CAS_IND CHARACTER VARYING(7) 7
119 POLICYNUMBER CHARACTER VARYING(40) 40
120 INSURED_NAME CHARACTER VARYING(181) 181
121 ASSESSMENT_BOOKING_LOCATION_NAME CHARACTER VARYING(120) 120
122 ASSESSMENT_BOOKING_LOCATION_STATE_NAME CHARACTER VARYING(256) 256
123 ASSESSMENT_BOOKING_LOCATION_TYPE_NAME CHARACTER VARYING(256) 256
124 ASSESSMENT_BOOKING_STATUS_NAME CHARACTER VARYING(256) 256
125 ASSESSMENT_NON_BOOK_REASON_NAME CHARACTER VARYING(256) 256
126 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
127 BRAND_NAME CHARACTER VARYING(256) 256
128 CLAIM_DECISION_DESCRIPTION CHARACTER VARYING(512) 512
129 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
130 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
131 INITIAL_EXCESS_COLLECTION_AGE_BAND_NAME CHARACTER VARYING(9) 9
132 INVESTIGATION_STATUS_NAME CHARACTER VARYING(256) 256
133 LIABILITY_ASSESSMENT_DESCRIPTION CHARACTER VARYING(256) 256
134 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
135 LOSS_PARTY_TYPE_NAME CHARACTER VARYING(256) 256
136 LOSS_STATE_NAME CHARACTER VARYING(256) 256
137 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
138 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
139 POLICY_STATUS_NAME CHARACTER VARYING(256) 256
140 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
141 PREMIUM_STATUS_NAME CHARACTER VARYING(256) 256
142 PREMIUM_STATUS_GROUP CHARACTER VARYING(14) 14
143 REJECT_REASON_NAME CHARACTER VARYING(256) 256
144 REOPEN_REASON_NAME CHARACTER VARYING(256) 256
145 RISK_STATE_NAME CHARACTER VARYING(256) 256
146 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
147 LODGEMENT_DATE_YEAR INTEGER 4
148 LODGEMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
149 LODGEMENT_DATE_QUARTER INTEGER 4
150 LODGEMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
151 LODGEMENT_DATE_MONTH INTEGER 4
152 LODGEMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
153 LODGEMENT_DATE_DAY INTEGER 4
154 LODGEMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
155 LODGEMENT_DATE_FIN_YEAR INTEGER 4
156 LODGEMENT_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
157 LODGEMENT_DATE_FIN_QUARTER INTEGER 4
158 LODGEMENT_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
159 LODGEMENT_DATE_FIN_MONTH INTEGER 4
160 LODGEMENT_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
161 LODGEMENT_DATE_FIN_DAY INTEGER 4
162 LODGEMENT_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
163 LODGEMENT_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
164 LODGEMENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
165 ASSESSMENT_BOOKING_APPOINTMENT_DATE_YEAR INTEGER 4
166 ASSESSMENT_BOOKING_APPOINTMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
167 ASSESSMENT_BOOKING_APPOINTMENT_DATE_QUARTER INTEGER 4
168 ASSESSMENT_BOOKING_APPOINTMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
169 ASSESSMENT_BOOKING_APPOINTMENT_DATE_MONTH INTEGER 4
170 ASSESSMENT_BOOKING_APPOINTMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
171 ASSESSMENT_BOOKING_APPOINTMENT_DATE_DAY INTEGER 4
172 ASSESSMENT_BOOKING_APPOINTMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
173 ASSESSMENT_BOOKING_CREATE_DATE_YEAR INTEGER 4
174 ASSESSMENT_BOOKING_CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
175 ASSESSMENT_BOOKING_CREATE_DATE_QUARTER INTEGER 4
176 ASSESSMENT_BOOKING_CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
177 ASSESSMENT_BOOKING_CREATE_DATE_MONTH INTEGER 4
178 ASSESSMENT_BOOKING_CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
179 ASSESSMENT_BOOKING_CREATE_DATE_DAY INTEGER 4
180 ASSESSMENT_BOOKING_CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
181 CREATE_DATE_YEAR INTEGER 4
182 CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
183 CREATE_DATE_QUARTER INTEGER 4
184 CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
185 CREATE_DATE_MONTH INTEGER 4
186 CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
187 CREATE_DATE_DAY INTEGER 4
188 CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
189 CREATE_DATE_FIN_YEAR INTEGER 4
190 CREATE_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
191 CREATE_DATE_FIN_QUARTER INTEGER 4
192 CREATE_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
193 CREATE_DATE_FIN_MONTH INTEGER 4
194 CREATE_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
195 CREATE_DATE_FIN_DAY INTEGER 4
196 CREATE_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
197 CREATE_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
198 CREATE_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
199 FINALISED_DATE_YEAR INTEGER 4
200 FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
201 FINALISED_DATE_QUARTER INTEGER 4
202 FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
203 FINALISED_DATE_MONTH INTEGER 4
204 FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
205 FINALISED_DATE_DAY INTEGER 4
206 FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
207 REOPEN_DATE_YEAR INTEGER 4
208 REOPEN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
209 REOPEN_DATE_QUARTER INTEGER 4
210 REOPEN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
211 REOPEN_DATE_MONTH INTEGER 4
212 REOPEN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
213 REOPEN_DATE_DAY INTEGER 4
214 REOPEN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
215 LATEST_REOPEN_DATE_YEAR INTEGER 4
216 LATEST_REOPEN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
217 LATEST_REOPEN_DATE_QUARTER INTEGER 4
218 LATEST_REOPEN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
219 LATEST_REOPEN_DATE_MONTH INTEGER 4
220 LATEST_REOPEN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
221 LATEST_REOPEN_DATE_DAY INTEGER 4
222 LATEST_REOPEN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
223 LATEST_FINALISED_DATE_YEAR INTEGER 4
224 LATEST_FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
225 LATEST_FINALISED_DATE_QUARTER INTEGER 4
226 LATEST_FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
227 LATEST_FINALISED_DATE_MONTH INTEGER 4
228 LATEST_FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
229 LATEST_FINALISED_DATE_DAY INTEGER 4
230 LATEST_FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
231 FIRST_EXCESS_RECEIVED_DATE_YEAR INTEGER 4
232 FIRST_EXCESS_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
233 FIRST_EXCESS_RECEIVED_DATE_QUARTER INTEGER 4
234 FIRST_EXCESS_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
235 FIRST_EXCESS_RECEIVED_DATE_MONTH INTEGER 4
236 FIRST_EXCESS_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
237 FIRST_EXCESS_RECEIVED_DATE_DAY INTEGER 4
238 FIRST_EXCESS_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
239 LATEST_EXCESS_RECEIVED_DATE_YEAR INTEGER 4
240 LATEST_EXCESS_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
241 LATEST_EXCESS_RECEIVED_DATE_QUARTER INTEGER 4
242 LATEST_EXCESS_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
243 LATEST_EXCESS_RECEIVED_DATE_MONTH INTEGER 4
244 LATEST_EXCESS_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
245 LATEST_EXCESS_RECEIVED_DATE_DAY INTEGER 4
246 LATEST_EXCESS_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
247 LOSS_DATE_YEAR INTEGER 4
248 LOSS_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
249 LOSS_DATE_QUARTER INTEGER 4
250 LOSS_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
251 LOSS_DATE_MONTH INTEGER 4
252 LOSS_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
253 LOSS_DATE_DAY INTEGER 4
254 LOSS_DATE_DAY_LABEL CHARACTER VARYING(13) 13
255 ASSESSMENT_BOOKING_CREATE_TEAM_ID BIGINT 8
256 ASSESSMENT_BOOKING_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
257 ASSESSMENT_BOOKING_CREATE_USER_NAME CHARACTER VARYING(181) 181
258 CLAIM_CREATE_TEAM_ID BIGINT 8
259 CLAIM_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
260 CLAIM_CREATE_USER_NAME CHARACTER VARYING(181) 181
261 LODGEMENT_TEAM_ID BIGINT 8
262 LODGEMENT_TEAM_NAME CHARACTER VARYING(100) 100
263 LODGEMENT_USER_NAME CHARACTER VARYING(181) 181
264 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
265 LEGACY_CLAIM CHARACTER VARYING(3) 3
266 LEGACY_TYPE CHARACTER VARYING(256) 256