FCT_CI_CLAIM_ACTIVITY_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 ACTIVITY_ID BIGINT 8
3 ACTIVITY_CLAIM_ID BIGINT 8
4 ACTIVITY_CREATE_USER_ID BIGINT 8
5 ACTIVITY_CREATE_USER_NAME CHARACTER VARYING(181) 181
6 ACTIVITY_CREATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
7 ACTIVITY_CREATE_USER_TEAM_ID BIGINT 8
8 ACTIVITY_CREATE_USER_TEAM_NAME CHARACTER VARYING(100) 100
9 ACTIVITY_CREATE_USER_GROUP_TYPE_ID BIGINT 8
10 ACTIVITY_CREATE_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
11 ACTIVITY_CREATE_USER_L1_TEAM_ID BIGINT 8
12 ACTIVITY_CREATE_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
13 ACTIVITY_CREATE_USER_L2_TEAM_ID BIGINT 8
14 ACTIVITY_CREATE_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
15 ACTIVITY_CREATE_USER_L3_TEAM_ID BIGINT 8
16 ACTIVITY_CREATE_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
17 ACTIVITY_CREATE_USER_L4_TEAM_ID BIGINT 8
18 ACTIVITY_CREATE_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
19 ACTIVITY_CREATE_USER_L5_TEAM_ID BIGINT 8
20 ACTIVITY_CREATE_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
21 ACTIVITY_CREATE_USER_L6_TEAM_ID BIGINT 8
22 ACTIVITY_CREATE_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
23 ACTIVITY_CREATE_USER_L7_TEAM_ID BIGINT 8
24 ACTIVITY_CREATE_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
25 ACTIVITY_CREATE_USER_L8_TEAM_ID BIGINT 8
26 ACTIVITY_CREATE_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
27 ACTIVITY_CREATE_USER_L9_TEAM_ID BIGINT 8
28 ACTIVITY_CREATE_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
29 ACTIVITY_CREATE_USER_L10_TEAM_ID BIGINT 8
30 ACTIVITY_CREATE_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
31 ACTIVITY_CREATE_USER_L11_TEAM_ID BIGINT 8
32 ACTIVITY_CREATE_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
33 ACTIVITY_STATUS_ID BIGINT 8
34 ACTIVITY_STATUS_NAME CHARACTER VARYING(256) 256
35 ACTIVITY_CLOSE_DATE TIMESTAMP 8
36 ACTIVITY_CLOSE_DATE_ID INTEGER 4
37 ACTIVITY_CLOSE_DATE_CAL_YEAR INTEGER 4
38 ACTIVITY_CLOSE_DATE_CAL_QUARTER INTEGER 4
39 ACTIVITY_CLOSE_DATE_CAL_MONTH INTEGER 4
40 ACTIVITY_CLOSE_DATE_CAL_DAY INTEGER 4
41 ACTIVITY_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
42 ACTIVITY_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
43 ACTIVITY_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
44 ACTIVITY_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
45 ACTIVITY_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
46 ACTIVITY_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
47 ACTIVITY_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
48 ACTIVITY_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
49 ACTIVITY_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
50 ACTIVITY_CREATE_DATE TIMESTAMP 8
51 ACTIVITY_CREATE_DATE_ID INTEGER 4
52 ACTIVITY_CREATE_DATE_CAL_YEAR INTEGER 4
53 ACTIVITY_CREATE_DATE_CAL_QUARTER INTEGER 4
54 ACTIVITY_CREATE_DATE_CAL_MONTH INTEGER 4
55 ACTIVITY_CREATE_DATE_CAL_DAY INTEGER 4
56 ACTIVITY_CREATE_DATE_DAY_TYPE_ID INTEGER 4
57 ACTIVITY_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
58 ACTIVITY_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
59 ACTIVITY_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
60 ACTIVITY_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
61 ACTIVITY_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
62 ACTIVITY_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
63 ACTIVITY_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
64 ACTIVITY_CREATE_DATE_HALF_TYPE_ID INTEGER 4
65 ACTIVITY_TARGET_DATE TIMESTAMP 8
66 ACTIVITY_TARGET_DATE_ID INTEGER 4
67 ACTIVITY_TARGET_DATE_CAL_YEAR INTEGER 4
68 ACTIVITY_TARGET_DATE_CAL_QUARTER INTEGER 4
69 ACTIVITY_TARGET_DATE_CAL_MONTH INTEGER 4
70 ACTIVITY_TARGET_DATE_CAL_DAY INTEGER 4
71 ACTIVITY_TARGET_DATE_DAY_TYPE_ID INTEGER 4
72 ACTIVITY_TARGET_DATE_WEEK_TYPE_ID INTEGER 4
73 ACTIVITY_TARGET_DATE_MONTH_TYPE_ID INTEGER 4
74 ACTIVITY_TARGET_DATE_QUARTER_TYPE_ID INTEGER 4
75 ACTIVITY_TARGET_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
76 ACTIVITY_TARGET_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
77 ACTIVITY_TARGET_DATE_R12_MONTH_TYPE_ID INTEGER 4
78 ACTIVITY_TARGET_DATE_R13_MONTH_TYPE_ID INTEGER 4
79 ACTIVITY_TARGET_DATE_HALF_TYPE_ID INTEGER 4
80 ACTIVITY_ESCALATION_DATE TIMESTAMP 8
81 ACTIVITY_ESCALATION_DATE_ID INTEGER 4
82 ACTIVITY_ESCALATION_DATE_CAL_YEAR INTEGER 4
83 ACTIVITY_ESCALATION_DATE_CAL_QUARTER INTEGER 4
84 ACTIVITY_ESCALATION_DATE_CAL_MONTH INTEGER 4
85 ACTIVITY_ESCALATION_DATE_CAL_DAY INTEGER 4
86 ACTIVITY_ESCALATION_DATE_DAY_TYPE_ID INTEGER 4
87 ACTIVITY_ESCALATION_DATE_WEEK_TYPE_ID INTEGER 4
88 ACTIVITY_ESCALATION_DATE_MONTH_TYPE_ID INTEGER 4
89 ACTIVITY_ESCALATION_DATE_QUARTER_TYPE_ID INTEGER 4
90 ACTIVITY_ESCALATION_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
91 ACTIVITY_ESCALATION_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
92 ACTIVITY_ESCALATION_DATE_R12_MONTH_TYPE_ID INTEGER 4
93 ACTIVITY_ESCALATION_DATE_R13_MONTH_TYPE_ID INTEGER 4
94 ACTIVITY_ESCALATION_DATE_HALF_TYPE_ID INTEGER 4
95 ACTIVITY_LAST_VIEWED_DATE TIMESTAMP 8
96 ACTIVITY_LAST_VIEWED_DATE_ID INTEGER 4
97 ACTIVITY_LAST_VIEWED_DATE_CAL_YEAR INTEGER 4
98 ACTIVITY_LAST_VIEWED_DATE_CAL_QUARTER INTEGER 4
99 ACTIVITY_LAST_VIEWED_DATE_CAL_MONTH INTEGER 4
100 ACTIVITY_LAST_VIEWED_DATE_CAL_DAY INTEGER 4
101 ACTIVITY_LAST_VIEWED_DATE_DAY_TYPE_ID INTEGER 4
102 ACTIVITY_LAST_VIEWED_DATE_WEEK_TYPE_ID INTEGER 4
103 ACTIVITY_LAST_VIEWED_DATE_MONTH_TYPE_ID INTEGER 4
104 ACTIVITY_LAST_VIEWED_DATE_QUARTER_TYPE_ID INTEGER 4
105 ACTIVITY_LAST_VIEWED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
106 ACTIVITY_LAST_VIEWED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
107 ACTIVITY_LAST_VIEWED_DATE_R12_MONTH_TYPE_ID INTEGER 4
108 ACTIVITY_LAST_VIEWED_DATE_R13_MONTH_TYPE_ID INTEGER 4
109 ACTIVITY_LAST_VIEWED_DATE_HALF_TYPE_ID INTEGER 4
110 ACTIVITY_UPDATE_DATE TIMESTAMP 8
111 ACTIVITY_UPDATE_DATE_ID INTEGER 4
112 ACTIVITY_UPDATE_DATE_CAL_YEAR INTEGER 4
113 ACTIVITY_UPDATE_DATE_CAL_QUARTER INTEGER 4
114 ACTIVITY_UPDATE_DATE_CAL_MONTH INTEGER 4
115 ACTIVITY_UPDATE_DATE_CAL_DAY INTEGER 4
116 ACTIVITY_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
117 ACTIVITY_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
118 ACTIVITY_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
119 ACTIVITY_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
120 ACTIVITY_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
121 ACTIVITY_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
122 ACTIVITY_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
123 ACTIVITY_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
124 ACTIVITY_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
125 ACTIVITIES_NUMBER_OF_DAYS_OVERDUE NUMERIC(31,12) 19
126 ACTIVITIES_TOTAL_NUMBER_OVERDUE INTEGER 4
127 BRAND BIGINT 8
128 BRAND_NAME CHARACTER VARYING(256) 256
129 CLAIM_CREATED_DATE TIMESTAMP 8
130 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
131 CLAIM_CREATED_DATE_ID INTEGER 4
132 CLAIM_CREATE_DATE_DATE_KEY INTEGER 4
133 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
134 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
135 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
136 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
137 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
138 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
139 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
140 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
141 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
142 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
143 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
144 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
145 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
146 CLAIM_ID BIGINT 8
147 CLAIM_NUMBER CHARACTER VARYING(40) 40
148 VERIFIED_POLICY_FLAG INTEGER 4
149 VERIFIED_POLICY CHARACTER VARYING(256) 256
150 VERIFIED_POLICY_STATUS_ID INTEGER 4
151 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
152 CLAIM_DURATION_BAND_ID INTEGER 4
153 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
154 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
155 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
156 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
157 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
158 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
159 CLAIM_SEGMENT_ID BIGINT 8
160 CLAIM_SEGMENT CHARACTER VARYING(256) 256
161 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
162 LOSS_CAUSE_ID BIGINT 8
163 CLAIM_DURATION_ID INTEGER 4
164 CLAIM_DURATION CHARACTER VARYING(17) 17
165 CLAIM_STATE_ID BIGINT 8
166 CLAIM_STATE CHARACTER VARYING(256) 256
167 REPORT_ONLY_FLAG_ID BIGINT 8
168 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
169 CLAIM_DECISION_ID BIGINT 8
170 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
171 POLICY_NUMBER CHARACTER VARYING(40) 40
172 POLICY_TYPE_ID BIGINT 8
173 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
174 LINE_OF_BUSINESS_ID BIGINT 8
175 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
176 CURRENT_POLICY_STATUS_ID BIGINT 8
177 CURRENT_POLICY_STATUS_NAME CHARACTER VARYING(256) 256
178 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
179 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
180 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
181 CLAIM_ADJUSTER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
182 CLAIM_ADJUSTER_TEAM_ID BIGINT 8
183 CLAIM_ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
184 CLAIM_ADJUSTER_GROUP_TYPE_ID BIGINT 8
185 CLAIM_ADJUSTER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
186 CLAIM_ADJUSTER_L1_TEAM_ID BIGINT 8
187 CLAIM_ADJUSTER_L1_TEAM_NAME CHARACTER VARYING(100) 100
188 CLAIM_ADJUSTER_L2_TEAM_ID BIGINT 8
189 CLAIM_ADJUSTER_L2_TEAM_NAME CHARACTER VARYING(100) 100
190 CLAIM_ADJUSTER_L3_TEAM_ID BIGINT 8
191 CLAIM_ADJUSTER_L3_TEAM_NAME CHARACTER VARYING(100) 100
192 CLAIM_ADJUSTER_L4_TEAM_ID BIGINT 8
193 CLAIM_ADJUSTER_L4_TEAM_NAME CHARACTER VARYING(100) 100
194 CLAIM_ADJUSTER_L5_TEAM_ID BIGINT 8
195 CLAIM_ADJUSTER_L5_TEAM_NAME CHARACTER VARYING(100) 100
196 CLAIM_ADJUSTER_L6_TEAM_ID BIGINT 8
197 CLAIM_ADJUSTER_L6_TEAM_NAME CHARACTER VARYING(100) 100
198 CLAIM_ADJUSTER_L7_TEAM_ID BIGINT 8
199 CLAIM_ADJUSTER_L7_TEAM_NAME CHARACTER VARYING(100) 100
200 CLAIM_ADJUSTER_L8_TEAM_ID BIGINT 8
201 CLAIM_ADJUSTER_L8_TEAM_NAME CHARACTER VARYING(100) 100
202 CLAIM_ADJUSTER_L9_TEAM_ID BIGINT 8
203 CLAIM_ADJUSTER_L9_TEAM_NAME CHARACTER VARYING(100) 100
204 CLAIM_ADJUSTER_L10_TEAM_ID BIGINT 8
205 CLAIM_ADJUSTER_L10_TEAM_NAME CHARACTER VARYING(100) 100
206 CLAIM_ADJUSTER_L11_TEAM_ID BIGINT 8
207 CLAIM_ADJUSTER_L11_TEAM_NAME CHARACTER VARYING(100) 100
208 CLAIM_SIU_REFERRAL_FLAG_ID BIGINT 8
209 CLAIM_SIU_REFERRAL_FLAG CHARACTER VARYING(256) 256
210 CLAIM_SIU_STATUS_ID BIGINT 8
211 CLAIM_SIU_STATUS CHARACTER VARYING(256) 256
212 CLAIM_LOSS_DATE TIMESTAMP 8
213 CLAIM_LOSS_DATE_ID INTEGER 4
214 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
215 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
216 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
217 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
218 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
219 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
220 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
221 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
222 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
223 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
224 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
225 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
226 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
227 CLAIM_ASSIGNMENT_DATE TIMESTAMP 8
228 CLAIM_ASSIGNMENT_DATE_ID INTEGER 4
229 CLAIM_ASSIGNED_DATE_CAL_YEAR INTEGER 4
230 CLAIM_ASSIGNED_DATE_CAL_QUARTER INTEGER 4
231 CLAIM_ASSIGNED_DATE_CAL_MONTH INTEGER 4
232 CLAIM_ASSIGNED_DATE_CAL_DAY INTEGER 4
233 CLAIM_ASSIGNED_DATE_DAY_TYPE_ID INTEGER 4
234 CLAIM_ASSIGNED_DATE_WEEK_TYPE_ID INTEGER 4
235 CLAIM_ASSIGNED_DATE_MONTH_TYPE_ID INTEGER 4
236 CLAIM_ASSIGNED_DATE_QUARTER_TYPE_ID INTEGER 4
237 CLAIM_ASSIGNED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
238 CLAIM_ASSIGNED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
239 CLAIM_ASSIGNED_DATE_R12_MONTH_TYPE_ID INTEGER 4
240 CLAIM_ASSIGNED_DATE_R13_MONTH_TYPE_ID INTEGER 4
241 CLAIM_ASSIGNED_DATE_HALF_TYPE_ID INTEGER 4
242 CLAIM_RISK_INDICATORS_FLAG_ID INTEGER 4
243 CLAIM_RISK_INDICATORS_FLAG_NAME CHARACTER VARYING(256) 256
244 CLAIM_EVENT_ID BIGINT 8
245 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
246 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
247 CLAIM_LITIGATION_FLAG_ID INTEGER 4
248 CLAIM_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
249 CLAIM_COMPLAINT_FLAG INTEGER 4
250 CLAIM_COMPLAINT_FLAG_NAME CHARACTER VARYING(256) 256
251 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
252 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
253 POLICY_INTERMEDIARY_ID BIGINT 8
254 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
255 ACTIVITY_SLA_STATUS CHARACTER VARYING(15) 15
256 ACTIVITY_INSIDE_SLA_FLAG CHARACTER VARYING(3) 3
257 ACTIVITY_ASSIGNMENT_DATE TIMESTAMP 8
258 ACTIVITY_ASSIGNMENT_DATE_ID INTEGER 4
259 ACTIVITY_ASSIGNMENT_DATE_CAL_YEAR INTEGER 4
260 ACTIVITY_ASSIGNMENT_DATE_CAL_QUARTER INTEGER 4
261 ACTIVITY_ASSIGNMENT_DATE_CAL_MONTH INTEGER 4
262 ACTIVITY_ASSIGNMENT_DATE_CAL_DAY INTEGER 4
263 ACTIVITY_ASSIGNMENT_DATE_DAY_TYPE_ID INTEGER 4
264 ACTIVITY_ASSIGNMENT_DATE_WEEK_TYPE_ID INTEGER 4
265 ACTIVITY_ASSIGNMENT_DATE_MONTH_TYPE_ID INTEGER 4
266 ACTIVITY_ASSIGNMENT_DATE_QUARTER_TYPE_ID INTEGER 4
267 ACTIVITY_ASSIGNMENT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
268 ACTIVITY_ASSIGNMENT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
269 ACTIVITY_ASSIGNMENT_DATE_R12_MONTH_TYPE_ID INTEGER 4
270 ACTIVITY_ASSIGNMENT_DATE_R13_MONTH_TYPE_ID INTEGER 4
271 ACTIVITY_ASSIGNMENT_DATE_HALF_TYPE_ID INTEGER 4
272 ACTIVITY_ASSIGNED_TO_GROUP_ID BIGINT 8
273 ACTIVITY_ASSIGNED_TO_GROUP_NAME CHARACTER VARYING(100) 100
274 ACTIVITY_ASSIGNED_TO_USER_ID BIGINT 8
275 ACTIVITY_ASSIGNED_TO_USER_NAME CHARACTER VARYING(181) 181
276 ACTIVITY_ASSIGNED_TO_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
277 ACTIVITY_ASSIGNED_TO_USER_TEAM_ID BIGINT 8
278 ACTIVITY_ASSIGNED_TO_USER_TEAM_NAME CHARACTER VARYING(100) 100
279 ACTIVITY_ASSIGNED_TO_USER_GROUP_TYPE_ID BIGINT 8
280 ACTIVITY_ASSIGNED_TO_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
281 ACTIVITY_ASSIGNED_TO_USER_L1_TEAM_ID BIGINT 8
282 ACTIVITY_ASSIGNED_TO_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
283 ACTIVITY_ASSIGNED_TO_USER_L2_TEAM_ID BIGINT 8
284 ACTIVITY_ASSIGNED_TO_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
285 ACTIVITY_ASSIGNED_TO_USER_L3_TEAM_ID BIGINT 8
286 ACTIVITY_ASSIGNED_TO_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
287 ACTIVITY_ASSIGNED_TO_USER_L4_TEAM_ID BIGINT 8
288 ACTIVITY_ASSIGNED_TO_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
289 ACTIVITY_ASSIGNED_TO_USER_L5_TEAM_ID BIGINT 8
290 ACTIVITY_ASSIGNED_TO_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
291 ACTIVITY_ASSIGNED_TO_USER_L6_TEAM_ID BIGINT 8
292 ACTIVITY_ASSIGNED_TO_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
293 ACTIVITY_ASSIGNED_TO_USER_L7_TEAM_ID BIGINT 8
294 ACTIVITY_ASSIGNED_TO_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
295 ACTIVITY_ASSIGNED_TO_USER_L8_TEAM_ID BIGINT 8
296 ACTIVITY_ASSIGNED_TO_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
297 ACTIVITY_ASSIGNED_TO_USER_L9_TEAM_ID BIGINT 8
298 ACTIVITY_ASSIGNED_TO_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
299 ACTIVITY_ASSIGNED_TO_USER_L10_TEAM_ID BIGINT 8
300 ACTIVITY_ASSIGNED_TO_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
301 ACTIVITY_ASSIGNED_TO_USER_L11_TEAM_ID BIGINT 8
302 ACTIVITY_ASSIGNED_TO_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
303 ACTIVITY_ASSIGNED_QUEUE_ID BIGINT 8
304 ACTIVITY_ASSIGN_QUEUE_NAME CHARACTER VARYING(255) 255
305 ACTIVITY_COMPLETED_BY_DEPARTMENT_USER_ID BIGINT 8
306 ACTIVITY_COMPLETED_BY_USER_DEPARTMENT_NAME CHARACTER VARYING(255) 255
307 ACTIVITY_COMPLETED_BY_USER_ID BIGINT 8
308 ACTIVITY_COMPLETED_BY_USER_NAME CHARACTER VARYING(181) 181
309 ACTIVITY_COMPLETED_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
310 ACTIVITY_COMPLETED_BY_USER_TEAM_ID BIGINT 8
311 ACTIVITY_COMPLETED_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
312 ACTIVITY_COMPLETED_BY_USER_GROUP_TYPE_ID BIGINT 8
313 ACTIVITY_COMPLETED_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
314 ACTIVITY_COMPLETED_BY_USER_L1_TEAM_ID BIGINT 8
315 ACTIVITY_COMPLETED_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
316 ACTIVITY_COMPLETED_BY_USER_L2_TEAM_ID BIGINT 8
317 ACTIVITY_COMPLETED_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
318 ACTIVITY_COMPLETED_BY_USER_L3_TEAM_ID BIGINT 8
319 ACTIVITY_COMPLETED_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
320 ACTIVITY_COMPLETED_BY_USER_L4_TEAM_ID BIGINT 8
321 ACTIVITY_COMPLETED_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
322 ACTIVITY_COMPLETED_BY_USER_L5_TEAM_ID BIGINT 8
323 ACTIVITY_COMPLETED_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
324 ACTIVITY_COMPLETED_BY_USER_L6_TEAM_ID BIGINT 8
325 ACTIVITY_COMPLETED_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
326 ACTIVITY_COMPLETED_BY_USER_L7_TEAM_ID BIGINT 8
327 ACTIVITY_COMPLETED_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
328 ACTIVITY_COMPLETED_BY_USER_L8_TEAM_ID BIGINT 8
329 ACTIVITY_COMPLETED_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
330 ACTIVITY_COMPLETED_BY_USER_L9_TEAM_ID BIGINT 8
331 ACTIVITY_COMPLETED_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
332 ACTIVITY_COMPLETED_BY_USER_L10_TEAM_ID BIGINT 8
333 ACTIVITY_COMPLETED_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
334 ACTIVITY_COMPLETED_BY_USER_L11_TEAM_ID BIGINT 8
335 ACTIVITY_COMPLETED_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
336 ACTIVITY_UPDATE_BY_USER_ID BIGINT 8
337 ACTIVITY_UPDATE_BY_USER_NAME CHARACTER VARYING(181) 181
338 ACTIVITY_UPDATE_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
339 ACTIVITY_UPDATE_BY_USER_TEAM_ID BIGINT 8
340 ACTIVITY_UPDATE_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
341 ACTIVITY_UPDATE_BY_USER_GROUP_TYPE_ID BIGINT 8
342 ACTIVITY_UPDATE_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
343 ACTIVITY_UPDATE_BY_USER_L1_TEAM_ID BIGINT 8
344 ACTIVITY_UPDATE_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
345 ACTIVITY_UPDATE_BY_USER_L2_TEAM_ID BIGINT 8
346 ACTIVITY_UPDATE_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
347 ACTIVITY_UPDATE_BY_USER_L3_TEAM_ID BIGINT 8
348 ACTIVITY_UPDATE_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
349 ACTIVITY_UPDATE_BY_USER_L4_TEAM_ID BIGINT 8
350 ACTIVITY_UPDATE_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
351 ACTIVITY_UPDATE_BY_USER_L5_TEAM_ID BIGINT 8
352 ACTIVITY_UPDATE_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
353 ACTIVITY_UPDATE_BY_USER_L6_TEAM_ID BIGINT 8
354 ACTIVITY_UPDATE_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
355 ACTIVITY_UPDATE_BY_USER_L7_TEAM_ID BIGINT 8
356 ACTIVITY_UPDATE_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
357 ACTIVITY_UPDATE_BY_USER_L8_TEAM_ID BIGINT 8
358 ACTIVITY_UPDATE_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
359 ACTIVITY_UPDATE_BY_USER_L9_TEAM_ID BIGINT 8
360 ACTIVITY_UPDATE_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
361 ACTIVITY_UPDATE_BY_USER_L10_TEAM_ID BIGINT 8
362 ACTIVITY_UPDATE_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
363 ACTIVITY_UPDATE_BY_USER_L11_TEAM_ID BIGINT 8
364 ACTIVITY_UPDATE_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
365 ACTIVITY_APPROVED_FLAG_ID INTEGER 4
366 ACTIVITY_APPROVED_FLAG_NAME CHARACTER VARYING(256) 256
367 ACTIVITY_APPROVAL_STATUS CHARACTER VARYING(21) 21
368 ACTIVITY_ESCALATED_FLAG_ID INTEGER 4
369 ACTIVITY_ESCALATED_FLAG_NAME CHARACTER VARYING(256) 256
370 ACTIVITY_TYPE_ID BIGINT 8
371 ACTIVITY_TYPE_NAME CHARACTER VARYING(256) 256
372 ACTIVITY_ASSIGNED_BY_DEPARTMENT_USER_ID BIGINT 8
373 ACTIVITY_ASSIGNED_BY_USER_DEPARTMENT_NAME CHARACTER VARYING(255) 255
374 ACTIVITY_ASSIGNED_BY_USER_ID BIGINT 8
375 ACTIVITY_ASSIGNED_BY_USER_NAME CHARACTER VARYING(181) 181
376 ACTIVITY_ASSIGNED_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
377 ACTIVITY_ASSIGNED_BY_USER_TEAM_ID BIGINT 8
378 ACTIVITY_ASSIGNED_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
379 ACTIVITY_ASSIGNED_BY_USER_GROUP_TYPE_ID BIGINT 8
380 ACTIVITY_ASSIGNED_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
381 ACTIVITY_ASSIGNED_BY_USER_L1_TEAM_ID BIGINT 8
382 ACTIVITY_ASSIGNED_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
383 ACTIVITY_ASSIGNED_BY_USER_L2_TEAM_ID BIGINT 8
384 ACTIVITY_ASSIGNED_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
385 ACTIVITY_ASSIGNED_BY_USER_L3_TEAM_ID BIGINT 8
386 ACTIVITY_ASSIGNED_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
387 ACTIVITY_ASSIGNED_BY_USER_L4_TEAM_ID BIGINT 8
388 ACTIVITY_ASSIGNED_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
389 ACTIVITY_ASSIGNED_BY_USER_L5_TEAM_ID BIGINT 8
390 ACTIVITY_ASSIGNED_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
391 ACTIVITY_ASSIGNED_BY_USER_L6_TEAM_ID BIGINT 8
392 ACTIVITY_ASSIGNED_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
393 ACTIVITY_ASSIGNED_BY_USER_L7_TEAM_ID BIGINT 8
394 ACTIVITY_ASSIGNED_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
395 ACTIVITY_ASSIGNED_BY_USER_L8_TEAM_ID BIGINT 8
396 ACTIVITY_ASSIGNED_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
397 ACTIVITY_ASSIGNED_BY_USER_L9_TEAM_ID BIGINT 8
398 ACTIVITY_ASSIGNED_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
399 ACTIVITY_ASSIGNED_BY_USER_L10_TEAM_ID BIGINT 8
400 ACTIVITY_ASSIGNED_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
401 ACTIVITY_ASSIGNED_BY_USER_L11_TEAM_ID BIGINT 8
402 ACTIVITY_ASSIGNED_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
403 ACTIVITY_PREVIOUS_ASSIGNED_USER_ID BIGINT 8
404 ACTIVITY_PREVIOUS_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
405 ACTIVITY_PREVIOUS_ASSIGNED_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
406 ACTIVITY_PREVIOUS_ASSIGNED_USER_TEAM_ID BIGINT 8
407 ACTIVITY_PREVIOUS_ASSIGNED_USER_TEAM_NAME CHARACTER VARYING(100) 100
408 ACTIVITY_PREVIOUS_ASSIGNED_USER_GROUP_TYPE_ID BIGINT 8
409 ACTIVITY_PREVIOUS_ASSIGNED_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
410 ACTIVITY_PREVIOUS_ASSIGNED_USER_L1_TEAM_ID BIGINT 8
411 ACTIVITY_PREVIOUS_ASSIGNED_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
412 ACTIVITY_PREVIOUS_ASSIGNED_USER_L2_TEAM_ID BIGINT 8
413 ACTIVITY_PREVIOUS_ASSIGNED_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
414 ACTIVITY_PREVIOUS_ASSIGNED_USER_L3_TEAM_ID BIGINT 8
415 ACTIVITY_PREVIOUS_ASSIGNED_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
416 ACTIVITY_PREVIOUS_ASSIGNED_USER_L4_TEAM_ID BIGINT 8
417 ACTIVITY_PREVIOUS_ASSIGNED_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
418 ACTIVITY_PREVIOUS_ASSIGNED_USER_L5_TEAM_ID BIGINT 8
419 ACTIVITY_PREVIOUS_ASSIGNED_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
420 ACTIVITY_PREVIOUS_ASSIGNED_USER_L6_TEAM_ID BIGINT 8
421 ACTIVITY_PREVIOUS_ASSIGNED_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
422 ACTIVITY_PREVIOUS_ASSIGNED_USER_L7_TEAM_ID BIGINT 8
423 ACTIVITY_PREVIOUS_ASSIGNED_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
424 ACTIVITY_PREVIOUS_ASSIGNED_USER_L8_TEAM_ID BIGINT 8
425 ACTIVITY_PREVIOUS_ASSIGNED_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
426 ACTIVITY_PREVIOUS_ASSIGNED_USER_L9_TEAM_ID BIGINT 8
427 ACTIVITY_PREVIOUS_ASSIGNED_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
428 ACTIVITY_PREVIOUS_ASSIGNED_USER_L10_TEAM_ID BIGINT 8
429 ACTIVITY_PREVIOUS_ASSIGNED_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
430 ACTIVITY_PREVIOUS_ASSIGNED_USER_L11_TEAM_ID BIGINT 8
431 ACTIVITY_PREVIOUS_ASSIGNED_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
432 ACTIVITY_PREVIOUS_GROUP_ID BIGINT 8
433 ACTIVITY_PREVIOUS_GROUP_NAME CHARACTER VARYING(100) 100
434 ACTIVITY_PREVIOUS_QUEUE_ID BIGINT 8
435 ACTIVITY_PREVIOUS_QUEUE_NAME CHARACTER VARYING(255) 255
436 ACTIVITY_PRIORITY_ID BIGINT 8
437 ACTIVITY_PRIORITY_NAME CHARACTER VARYING(256) 256
438 COMPLETED_STATUS_DESC CHARACTER VARYING(19) 19
439 ACTIVITY_DESCRIPTION CHARACTER VARYING(2000) 2000
440 ACTIVITY_SUBJECT_NAME CHARACTER VARYING(255) 255
441 ACTIVITY_APPROVAL_ISSUE_DESC CHARACTER VARYING(255) 255
442 ACTIVITY_APPROVAL_RATIONALE_DESC CHARACTER VARYING(255) 255
443 PATTERN_ACTIVITY_CLASS_ID BIGINT 8
444 PATTERN_ACTIVITY_CLASS_NAME CHARACTER VARYING(256) 256
445 PATTERN_CATEGORY_ID BIGINT 8
446 PATTERN_CATEGORY_NAME CHARACTER VARYING(256) 256
447 PATTERN_TYPE_ID BIGINT 8
448 PATTERN_TYPE_NAME CHARACTER VARYING(256) 256
449 PATTERN_TARGET_NUMBER_OF_DAYS BIGINT 8
450 PATTERN_SUBJECT_NAME CHARACTER VARYING(255) 255
451 PATTERN_DESCRIPTION CHARACTER VARYING(2000) 2000
452 ACTIVITY_PATTERN_PRIORITY_ID BIGINT 8
453 ACTIVITY_PATTERN_PRIORITY_NAME CHARACTER VARYING(256) 256
454 ACTIVITY_TRANSACTIONSET_ID BIGINT 8
455 ACTIVITY_EXPOSURE_ID BIGINT 8
456 ACTIVITY_PATTERN_ID BIGINT 8
457 ACTIVITY_INCIDENT_ID BIGINT 8
458 ACTIVITY_COMPLAINT_ID BIGINT 8
459 ACTIVITIES_COMPLETED_WITHIN_SLA_INDICATOR INTEGER 4
460 ACTIVITIES_COMPLETED_OUTSIDE_SLA_INDICATOR INTEGER 4
461 ACTIVITIES_TOTAL_ACTUAL_TURNAROUND_COUNT INTEGER 4
462 ACTIVITIES_TOTAL_ACTUAL_TURNAROUND_DAYS NUMERIC(31,12) 19
463 ACTIVITIES_TOTAL_TARGET_TURNAROUND_COUNT INTEGER 4
464 ACTIVITIES_TOTAL_TARGET_TURNAROUND_DAYS NUMERIC(31,12) 19
465 ACTIVITIES_TOTAL_CREATE_TURNAROUND_COUNT INTEGER 4
466 ACTIVITIES_TOTAL_CREATE_ACTUAL_TURNAROUND_DAYS NUMERIC(31,12) 19
467 GROSS_PAID_AMOUNT NUMERIC(38,2) 19
468 CLAIM_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
469 CLAIM_GROSS_PAID_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
470 GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
471 GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
472 GROSS_INCURRED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
473 NET_INCURRED_AMOUNT NUMERIC(38,2) 19
474 NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
475 NET_INCURRED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
476 GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
477 GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
478 GROSS_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
479 NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
480 NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
481 NET_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15