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