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