INT_CI_CLAIM_INCIDENT_DRILLTHRU

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 VERIFIED_POLICY_FLAG INTEGER 4
4 POLICY_NUMBER CHARACTER VARYING(40) 40
5 POLICY_SOURCESYSTEM_ID BIGINT 8
6 POLICY_SOURCE_SYSTEM_NAME CHARACTER VARYING(256) 256
7 POLICY_TYPE_ID BIGINT 8
8 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
9 CLAIM_CREATED_DATE TIMESTAMP 8
10 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
11 CLAIM_CREATED_DATE_ID INTEGER 4
12 CLAIM_CREATED_DATE_YEAR INTEGER 4
13 CLAIM_CREATED_DATE_QUARTER INTEGER 4
14 CLAIM_CREATED_DATE_MONTH INTEGER 4
15 CLAIM_CREATED_DATE_DAY INTEGER 4
16 CLAIM_CREATED_DATE_DAY_TYPE_ID INTEGER 4
17 CLAIM_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
18 CLAIM_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
19 CLAIM_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
20 CLAIM_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
21 CLAIM_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
22 CLAIM_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
23 CLAIM_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
24 CLAIM_CREATED_DATE_HALF_TYPE_ID INTEGER 4
25 CLAIM_NUMBER CHARACTER VARYING(40) 40
26 CLAIM_SEGMENT_ID BIGINT 8
27 CLAIM_SEGMENT_NAME CHARACTER VARYING(256) 256
28 CLAIM_STATE_ID BIGINT 8
29 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
30 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
31 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
32 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
33 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
34 TEAM_ID BIGINT 8
35 TEAM_NAME CHARACTER VARYING(100) 100
36 GROUP_TYPE_ID BIGINT 8
37 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
38 L1_TEAM_ID BIGINT 8
39 L1_TEAM_NAME CHARACTER VARYING(100) 100
40 L2_TEAM_ID BIGINT 8
41 L2_TEAM_NAME CHARACTER VARYING(100) 100
42 L3_TEAM_ID BIGINT 8
43 L3_TEAM_NAME CHARACTER VARYING(100) 100
44 L4_TEAM_ID BIGINT 8
45 L4_TEAM_NAME CHARACTER VARYING(100) 100
46 L5_TEAM_ID BIGINT 8
47 L5_TEAM_NAME CHARACTER VARYING(100) 100
48 L6_TEAM_ID BIGINT 8
49 L6_TEAM_NAME CHARACTER VARYING(100) 100
50 L7_TEAM_ID BIGINT 8
51 L7_TEAM_NAME CHARACTER VARYING(100) 100
52 L8_TEAM_ID BIGINT 8
53 L8_TEAM_NAME CHARACTER VARYING(100) 100
54 L9_TEAM_ID BIGINT 8
55 L9_TEAM_NAME CHARACTER VARYING(100) 100
56 L10_TEAM_ID BIGINT 8
57 L10_TEAM_NAME CHARACTER VARYING(100) 100
58 L11_TEAM_ID BIGINT 8
59 L11_TEAM_NAME CHARACTER VARYING(100) 100
60 CLAIM_SIU_REFERRAL_ID BIGINT 8
61 CLAIM_SIU_REFERRAL_NAME CHARACTER VARYING(256) 256
62 CLAIM_SIU_STATUS_ID BIGINT 8
63 CLAIM_SIU_STATUS_NAME CHARACTER VARYING(256) 256
64 CLAIM_EVENT_ID BIGINT 8
65 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
66 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
67 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
68 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
69 VERIFIED_POLICY_STATUS_ID INTEGER 4
70 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
71 INCIDENT_ID BIGINT 8
72 INCIDENT_CLAIM_ID BIGINT 8
73 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
74 INCIDENT_NATURE_OF_INJURY_ID BIGINT 8
75 INCIDENT_NATURE_OF_INJURY_NAME CHARACTER VARYING(256) 256
76 INCIDENT_DETAILED_INJURY_TYPE_ID BIGINT 8
77 INCIDENT_DETAILED_INJURY_TYPE_NAME CHARACTER VARYING(256) 256
78 INCIDENT_ESTIMATED_REPAIR_COST_AMT NUMERIC(18,2) 19
79 INCIDENT_ESTIMATED_REPAIR_TIME CHARACTER VARYING(60) 60
80 INCIDENT_LOSS_CAUSE_ID BIGINT 8
81 ONCIDENT_LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
82 INCIDENT_REPORTED_DATE TIMESTAMP 8
83 INCIDENT_REPORTED_DATE_YEAR INTEGER 4
84 INCIDENT_REPORTED_DATE_QUARTER INTEGER 4
85 INCIDENT_REPORTED_DATE_MONTH INTEGER 4
86 INCIDENT_REPORTED_DATE_DAY INTEGER 4
87 INCIDENT_REPORTED_DATE_DAY_TYPE_ID INTEGER 4
88 INCIDENT_REPORTED_DATE_WEEK_TYPE_ID INTEGER 4
89 INCIDENT_REPORTED_DATE_MONTH_TYPE_ID INTEGER 4
90 INCIDENT_REPORTED_DATE_QUARTER_TYPE_ID INTEGER 4
91 INCIDENT_REPORTED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
92 INCIDENT_REPORTED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
93 INCIDENT_REPORTED_DATE_R12_MONTH_TYPE_ID INTEGER 4
94 INCIDENT_REPORTED_DATE_R13_MONTH_TYPE_ID INTEGER 4
95 INCIDENT_REPORTED_DATE_HALF_TYPE_ID INTEGER 4
96 INCIDENT_REPORT_ONLY_ID BIGINT 8
97 INCIDENT_REPORT_ONLY_NAME CHARACTER VARYING(256) 256
98 INCIDENT_TOTAL_ESTIMATED_VALUE NUMERIC(18,2) 19
99 INCIDENT_VEHICLE_QUESTIONS_ID BIGINT 8
100 INCIDENT_SUB_TYPE_ID BIGINT 8
101 INCIDENT_SUB_TYPE_NAME CHARACTER VARYING(256) 256
102 INCIDENT_VEHICLE_ID BIGINT 8
103 EXPOSURE_LOSS_LOCATION_ID BIGINT 8
104 EXPOSURE_LOSS_LOCATION_ADDR_STATE_ID BIGINT 8
105 EXPOSURE_LOSS_LOCATION_ADDR_STATE_NAME CHARACTER VARYING(256) 256
106 EXPOSURE_LOSS_LOCATION_ADDR_POSTALCODE CHARACTER VARYING(60) 60
107 INCIDENT_CLAIMANT_TYPE_ID BIGINT 8
108 INCIDENT_CLAIMANT_TYPE_NAME CHARACTER VARYING(256) 256
109 INCIDENT_CREATE_DATE TIMESTAMP 8
110 INCIDENT_CREATE_DATE_ID INTEGER 4
111 INCIDENT_CREATED_DATE_YEAR INTEGER 4
112 INCIDENT_CREATED_DATE_QUARTER INTEGER 4
113 INCIDENT_CREATED_DATE_MONTH INTEGER 4
114 INCIDENT_CREATED_DATE_DAY INTEGER 4
115 INCIDENT_CREATED_DATE_DAY_TYPE_ID INTEGER 4
116 INCIDENT_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
117 INCIDENT_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
118 INCIDENT_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
119 INCIDENT_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
120 INCIDENT_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
121 INCIDENT_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
122 INCIDENT_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
123 INCIDENT_CREATED_DATE_HALF_TYPE_ID INTEGER 4
124 INCIDENT_CREATE_USER_ID BIGINT 8
125 INCIDENT_CREATE_USER_NAME CHARACTER VARYING(181) 181
126 INCIDENT_FAULT_RATING_ID BIGINT 8
127 INCIDENT_FAULT_RATING_NAME CHARACTER VARYING(256) 256
128 INCIDENT_REPORT_METHOD_ID BIGINT 8
129 INCIDENT_REPORT_METHOD_NAME CHARACTER VARYING(256) 256
130 INCIDENT_INSPECTION_REQUIRED_FLAG INTEGER 4
131 INCIDENT_INSPECTION_REQUIRED_NAME CHARACTER VARYING(256) 256
132 INCIDENT_MAKE_SAFE_REPAIR_REQUIRED_ID BIGINT 8
133 INCIDENT_MAKE_SAFE_REPAIR_REQUIRED_NAME CHARACTER VARYING(256) 256
134 INCIDENT_PRIMARY_BODY_FUNCTION_ID BIGINT 8
135 INCIDENT_PRIMARY_BODY_FUNCTION_NAME CHARACTER VARYING(256) 256
136 INCIDENT_RECOVERY_INDICATOR_ID BIGINT 8
137 INCIDENT_RECOVERY_INDICATOR_NAME CHARACTER VARYING(256) 256
138 INCIDENT_REPORTER_RELATIONSHIP_TO_INSURED_ID BIGINT 8
139 INCIDENT_REPORTER_RELATIONSHIP_TO_INSURED_NAME CHARACTER VARYING(256) 256
140 INCIDENT_RESULT_OF_INJURY_ID BIGINT 8
141 INCIDENT_RESULT_OF_INJURY_NAME CHARACTER VARYING(256) 256
142 INCIDENT_EXTERNAL_ASSESSOR_FLAG INTEGER 4
143 INCIDENT_EXTERNAL_ASSESSOR_NAME CHARACTER VARYING(256) 256
144 INCIDENT_SCOPE_OF_WORK_TYPE_ID BIGINT 8
145 INCIDENT_SCOPE_OF_WORK_TYPE_NAME CHARACTER VARYING(256) 256
146 INCIDENT_LOSS_SEVERITY_ID BIGINT 8
147 INCIDENT_LOSS_SEVERITY_NAME CHARACTER VARYING(256) 256
148 INCIDENT_UPDATE_DATE TIMESTAMP 8
149 INCIDENT_UPDATE_DATE_ID INTEGER 4
150 INCIDENT_UPDATED_DATE_YEAR INTEGER 4
151 INCIDENT_UPDATED_DATE_QUARTER INTEGER 4
152 INCIDENT_UPDATED_DATE_MONTH INTEGER 4
153 INCIDENT_UPDATED_DATE_DAY INTEGER 4
154 INCIDENT_UPDATED_DATE_DAY_TYPE_ID INTEGER 4
155 INCIDENT_UPDATED_DATE_WEEK_TYPE_ID INTEGER 4
156 INCIDENT_UPDATED_DATE_MONTH_TYPE_ID INTEGER 4
157 INCIDENT_UPDATED_DATE_QUARTER_TYPE_ID INTEGER 4
158 INCIDENT_UPDATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
159 INCIDENT_UPDATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
160 INCIDENT_UPDATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
161 INCIDENT_UPDATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
162 INCIDENT_UPDATED_DATE_HALF_TYPE_ID INTEGER 4
163 INCIDENT_UPDATE_USER_ID BIGINT 8
164 INCIDENT_UPDATE_USER_NAME CHARACTER VARYING(181) 181
165 INCIDENT_LOSS_PARTY_ID BIGINT 8
166 INCIDENT_LOSS_PARTY_NAME CHARACTER VARYING(256) 256
167 INCIDENT_CLAIMANT_ID BIGINT 8
168 INCIDENT_CLAIMANT_NAME CHARACTER VARYING(181) 181
169 INCIDENT_INSPECTION_PLAN_DATE TIMESTAMP 8
170 INCIDENT_INSPECTION_PLAN_DATE_ID INTEGER 4
171 INCIDENT_INSPECTION_PLAN_DATE_YEAR INTEGER 4
172 INCIDENT_INSPECTION_PLAN_DATE_QUARTER INTEGER 4
173 INCIDENT_INSPECTION_PLAN_DATE_MONTH INTEGER 4
174 INCIDENT_INSPECTION_PLAN_DATE_DAY INTEGER 4
175 INCIDENT_INSPECTION_PLAN_DATE_DAY_TYPE_ID INTEGER 4
176 INCIDENT_INSPECTION_PLAN_DATE_WEEK_TYPE_ID INTEGER 4
177 INCIDENT_INSPECTION_PLAN_DATE_MONTH_TYPE_ID INTEGER 4
178 INCIDENT_INSPECTION_PLAN_DATE_QUARTER_TYPE_ID INTEGER 4
179 INCIDENT_INSPECTION_PLAN_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
180 INCIDENT_INSPECTION_PLAN_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
181 INCIDENT_INSPECTION_PLAN_DATE_R12_MONTH_TYPE_ID INTEGER 4
182 INCIDENT_INSPECTION_PLAN_DATE_R13_MONTH_TYPE_ID INTEGER 4
183 INCIDENT_INSPECTION_PLAN_DATE_HALF_TYPE_ID INTEGER 4
184 INCIDENT_DAMAGE_DESCRIPTION CHARACTER VARYING(289) 289
185 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS BIGINT 8
186 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS_NAME CHARACTER VARYING(256) 256
187 INCIDENT_REPAIR_DONE_FLAG CHARACTER VARYING(1) 1
188 INCIDENT_ASSESSMENT_DESCRIPTION CHARACTER VARYING(128) 128
189 INCIDENT_ASSESSMENT_STATUS_ID BIGINT 8
190 INCIDENT_ASSESSMENT_STATUS_NAME CHARACTER VARYING(256) 256
191 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE TIMESTAMP 8
192 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_ID INTEGER 4
193 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_YEAR INTEGER 4
194 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER INTEGER 4
195 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH INTEGER 4
196 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY INTEGER 4
197 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
198 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
199 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
200 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
201 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
202 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
203 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
204 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
205 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
206 INCIDENT_ASSESSMENT_CLOSE_DATE TIMESTAMP 8
207 INCIDENT_ASSESSMENT_CLOSE_DATE_ID INTEGER 4
208 INCIDENT_ASSESSMENT_CLOSE_DATE_YEAR INTEGER 4
209 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER INTEGER 4
210 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH INTEGER 4
211 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY INTEGER 4
212 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
213 INCIDENT_ASSESSMENT_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
214 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
215 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
216 INCIDENT_ASSESSMENT_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
217 INCIDENT_ASSESSMENT_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
218 INCIDENT_ASSESSMENT_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
219 INCIDENT_ASSESSMENT_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
220 INCIDENT_ASSESSMENT_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
221 INCIDENT_ASSESSMENT_COMMENT CHARACTER VARYING(255) 255
222 INCIDENT_ASSESSMENT_INTERNAL_USER_ID BIGINT 8
223 INCIDENT_ASSESSMENT_INTERNAL_USER_NAME CHARACTER VARYING(181) 181
224 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG INTEGER 4
225 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG_NAME CHARACTER VARYING(256) 256
226 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG INTEGER 4
227 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG_NAME CHARACTER VARYING(256) 256
228 CLAIM_DURATION CHARACTER VARYING(17) 17
229 CLAIM_DURATION_BAND_ID INTEGER 4
230 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
231 REPORT_ONLY_FLAG_ID BIGINT 8
232 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
233 CLAIM_DECISION_ID BIGINT 8
234 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
235 LINE_OF_BUSINESS_ID BIGINT 8
236 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
237 CLAIM_LOSS_DATE TIMESTAMP 8
238 CLAIM_LOSS_DATE_ID INTEGER 4
239 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
240 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
241 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
242 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
243 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
244 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
245 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
246 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
247 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
248 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
249 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
250 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
251 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
252 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
253 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
254 POLICY_INTERMEDIARY_ID BIGINT 8
255 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
256 VERIFIED_POLICY CHARACTER VARYING(256) 256
257 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
258 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
259 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
260 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
261 INCIDENT_VEHICLE_DAMAGED_INDICATOR INTEGER 4
262 INCIDENT_VEHICLE_DAMAGED_INDICATOR_FLAG CHARACTER VARYING(256) 256
263 INCIDENT_VEHICLE_DRIVEABLE_INDICATOR INTEGER 4
264 INCIDENT_VEHICLE_DRIVEABLE_INDICATOR_FLAG CHARACTER VARYING(256) 256
265 INCIDENT_VEHICLE_TOWED_INDICATOR INTEGER 4
266 INCIDENT_VEHICLE_TOWED_INDICATOR_FLAG CHARACTER VARYING(256) 256
267 INCIDENT_VEHICLE_REGISTRATION_STATE BIGINT 8
268 INCIDENT_VEHICLE_REGISTRATION_STATE_NAME CHARACTER VARYING(256) 256