FCT_MOTOR_STOCK_CLAIM_ACTIVITY_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 ACTIVITY_ID BIGINT 8
3 CLAIM_ID BIGINT 8
4 CLAIM_NUMBER CHARACTER VARYING(40) 40
5 LODGEMENT_DATE TIMESTAMP 8
6 UPDATETIME TIMESTAMP 8
7 EXTRACT_TIMESTAMP TIMESTAMP 8
8 RISK_STATE_ID BIGINT 8
9 RISK_STATE_NAME CHARACTER VARYING(256) 256
10 RISK_REGION_NAME CHARACTER VARYING(15) 15
11 RISK_POSTCODE CHARACTER VARYING(60) 60
12 LOSS_STATE_ID BIGINT 8
13 LOSS_STATE_NAME CHARACTER VARYING(256) 256
14 LOSS_REGION_NAME CHARACTER VARYING(15) 15
15 LOSS_POSTCODE CHARACTER VARYING(60) 60
16 LINE_OF_BUSINESS_ID BIGINT 8
17 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
18 VEHICLE_STYLE_ID BIGINT 8
19 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
20 INCIDENT_ID BIGINT 8
21 BRAND_ID BIGINT 8
22 BRAND_NAME CHARACTER VARYING(256) 256
23 LOSS_TYPE_ID BIGINT 8
24 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
25 CREATE_DATE TIMESTAMP 8
26 REOPEN_DATE TIMESTAMP 8
27 FINALISED_DATE TIMESTAMP 8
28 REPORT_ONLY_FLAG CHARACTER VARYING(9) 9
29 CLAIM_STATE_ID INTEGER 4
30 CLAIM_STATE_NAME CHARACTER VARYING(11) 11
31 REJECT_REASON_ID BIGINT 8
32 REJECT_REASON_NAME CHARACTER VARYING(256) 256
33 REOPEN_REASON_ID BIGINT 8
34 REOPEN_REASON_NAME CHARACTER VARYING(256) 256
35 CLOSED_OUTCOME_ID BIGINT 8
36 FINALISED_OUTCOME_DESCRIPTION CHARACTER VARYING(512) 512
37 LOSSCAUSE_ID BIGINT 8
38 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
39 LOSSCAUSESUBTYPE_ID BIGINT 8
40 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
41 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
42 CATASTOPHE_ID BIGINT 8
43 CATASTROPHE_CODE CHARACTER VARYING(120) 120
44 PREMIUM_STATUS_ID BIGINT 8
45 PREMIUM_STATUS_NAME CHARACTER VARYING(256) 256
46 PREMIUM_STATUS_GROUP CHARACTER VARYING(14) 14
47 POLICY_PAYMENT_MODE_ID BIGINT 8
48 POLICY_PAYMENT_MODE_NAME CHARACTER VARYING(256) 256
49 POLICY_RENEWAL_MODE_ID BIGINT 8
50 POLICY_RENEWAL_MODE_NAME CHARACTER VARYING(256) 256
51 POLICY_STATUS_ID BIGINT 8
52 POLICY_STATUS_DESC CHARACTER VARYING(512) 512
53 POLICY_COVERAGE_TYPE_ID BIGINT 8
54 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
55 ADJUSTER_USER_ID BIGINT 8
56 ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
57 ADJUSTER_TEAM_ID BIGINT 8
58 ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
59 CREATE_USER_ID BIGINT 8
60 CREATE_USER_NAME CHARACTER VARYING(181) 181
61 CREATE_TEAM_ID BIGINT 8
62 CREATE_TEAM_NAME CHARACTER VARYING(100) 100
63 LODGEMENT_USER_ID BIGINT 8
64 LODGEMENT_USER_NAME CHARACTER VARYING(181) 181
65 LODGEMENT_TEAM_ID BIGINT 8
66 LODGEMENT_TEAM_NAME CHARACTER VARYING(100) 100
67 ACTIVITY_CREATE_DATE TIMESTAMP 8
68 ACTIVITY_STATUS_ID BIGINT 8
69 ACTIVITY_STATUS_NAME CHARACTER VARYING(256) 256
70 ACTIVITY_TYPE_ID BIGINT 8
71 ACTIVITY_TYPE_NAME CHARACTER VARYING(256) 256
72 ACTIVITY_ASSIGNED_TO_USER_ID BIGINT 8
73 ACTIVITY_ASSIGNED_TO_USER_NAME CHARACTER VARYING(181) 181
74 ACTIVITY_ASSIGNED_TO_TEAM_ID BIGINT 8
75 ACTIVITY_ASSIGNED_TO_TEAM_NAME CHARACTER VARYING(100) 100
76 ACTIVITY_ASSIGNED_TO_GROUP_ID BIGINT 8
77 ACTIVITY_ASSIGNED_TO_GROUP_NAME CHARACTER VARYING(100) 100
78 ACTIVITY_ASSIGNED_BY_USER_ID BIGINT 8
79 ACTIVITY_ASSIGNED_BY_USER_NAME CHARACTER VARYING(181) 181
80 ACTIVITY_ASSIGNED_BY_TEAM_ID BIGINT 8
81 ACTIVITY_ASSIGNED_BY_TEAM_NAME CHARACTER VARYING(100) 100
82 ACTIVITY_CLOSED_BY_USER_ID BIGINT 8
83 ACTIVITY_CLOSED_DATE TIMESTAMP 8
84 ACTIVITY_TARGET_DATE TIMESTAMP 8
85 ACTIVITY_COMPLETED_WITH_TARGET_INDICATOR INTEGER 4
86 ACTIVITY_PRIORITY_ID BIGINT 8
87 ACTIVITY_BANDING_LOSS_TYPE_ID BIGINT 8
88 ACTIVITY_BANDING_LOSS_TYPE_NAME CHARACTER VARYING(256) 256
89 ACTIVITY_BANDING_CATEGORY_ID BIGINT 8
90 ACTIVITY_BANDING_CATEGORY_NAME CHARACTER VARYING(256) 256
91 ACTIVITY_BANDING_SUBJECT CHARACTER VARYING(255) 255
92 ACTIVITY_OVERDUE_FLAG CHARACTER VARYING(9) 9
93 ACTIVITY_AGE INTEGER 4
94 ACTIVITY_AGE_NAME CHARACTER VARYING(10) 10
95 ACTIVITY_AGE_BAND_ID INTEGER 4
96 ACTIVITY_CREATE_USER_ID BIGINT 8
97 ACTIVITY_CREATE_USER_NAME CHARACTER VARYING(181) 181
98 ACTIVITY_CREATE_TEAM_ID BIGINT 8
99 ACTIVITY_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
100 ACTIVITY_CLOSE_USER_ID BIGINT 8
101 ACTIVITY_CLOSE_USER_NAME CHARACTER VARYING(181) 181
102 ACTIVITY_CLOSE_TEAM_ID BIGINT 8
103 ACTIVITY_CLOSE_TEAM_NAME CHARACTER VARYING(100) 100
104 ACTIVITY_CLOSE_TEAM_ID_HIST BIGINT 8
105 ACTIVITY_CLOSE_TEAM_NAME_HIST CHARACTER VARYING(100) 100
106 DAYS_OVERDUE INTEGER 4
107 ACTIVITY_COUNT INTEGER 4
108 EVENT_NAME CHARACTER VARYING(256) 256
109 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
110 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS_NAME CHARACTER VARYING(256) 256
111 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
112 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
113 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
114 CLAIM_PROCESS_TYPE_ID BIGINT 8
115 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
116 LOSSDATE TIMESTAMP 8
117 LOSS_CCR_CC_ADDRESS_COUNTRY BIGINT 8
118 COUNTRY_NAME CHARACTER VARYING(256) 256
119 CCR_CC_POLICY_POLICYTYPE BIGINT 8
120 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
121 FLEET_IND CHARACTER VARYING(9) 9
122 CAS_IND CHARACTER VARYING(7) 7
123 POLICY_NUMBER CHARACTER VARYING(40) 40
124 CLAIM_CREATE_DATE_YEAR INTEGER 4
125 CLAIM_CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
126 CLAIM_CREATE_DATE_QUARTER INTEGER 4
127 CLAIM_CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
128 CLAIM_CREATE_DATE_MONTH INTEGER 4
129 CLAIM_CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
130 CLAIM_CREATE_DATE_DAY INTEGER 4
131 CLAIM_CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
132 CLAIM_CREATE_DATE_FIN_YEAR INTEGER 4
133 CLAIM_CREATE_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
134 CLAIM_CREATE_DATE_FIN_QUARTER INTEGER 4
135 CLAIM_CREATE_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
136 CLAIM_CREATE_DATE_FIN_MONTH INTEGER 4
137 CLAIM_CREATE_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
138 CLAIM_CREATE_DATE_FIN_DAY INTEGER 4
139 CLAIM_CREATE_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
140 CLAIM_CREATE_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
141 CLAIM_CREATE_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
142 CLAIM_CREATE_DATE_DAY_OF_WEEK BIGINT 8
143 CLAIM_CREATE_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
144 CLAIM_CREATE_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
145 ACTIVITY_CREATE_DATE_YEAR INTEGER 4
146 ACTIVITY_CREATE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
147 ACTIVITY_CREATE_DATE_QUARTER INTEGER 4
148 ACTIVITY_CREATE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
149 ACTIVITY_CREATE_DATE_MONTH INTEGER 4
150 ACTIVITY_CREATE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
151 ACTIVITY_CREATE_DATE_DAY INTEGER 4
152 ACTIVITY_CREATE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
153 ACTIVITY_CREATE_DATE_FIN_YEAR INTEGER 4
154 ACTIVITY_CREATE_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
155 ACTIVITY_CREATE_DATE_FIN_QUARTER INTEGER 4
156 ACTIVITY_CREATE_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
157 ACTIVITY_CREATE_DATE_FIN_MONTH INTEGER 4
158 ACTIVITY_CREATE_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
159 ACTIVITY_CREATE_DATE_FIN_DAY INTEGER 4
160 ACTIVITY_CREATE_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
161 ACTIVITY_CREATE_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
162 ACTIVITY_CREATE_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
163 ACTIVITY_CREATE_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
164 ACTIVITY_CREATE_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
165 ACTIVITY_CREATE_DATE_DAY_OF_WEEK BIGINT 8
166 ACTIVITY_CREATE_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
167 ACTIVITY_CREATE_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
168 ACTIVITY_CLOSE_DATE_YEAR INTEGER 4
169 ACTIVITY_CLOSE_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
170 ACTIVITY_CLOSE_DATE_QUARTER INTEGER 4
171 ACTIVITY_CLOSE_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
172 ACTIVITY_CLOSE_DATE_MONTH INTEGER 4
173 ACTIVITY_CLOSE_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
174 ACTIVITY_CLOSE_DATE_DATE_DAY INTEGER 4
175 ACTIVITY_CLOSE_DATE_DAY_LABEL CHARACTER VARYING(13) 13
176 ACTIVITY_CLOSE_DATE_FIN_YEAR INTEGER 4
177 ACTIVITY_CLOSE_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
178 ACTIVITY_CLOSE_DATE_FIN_QUARTER INTEGER 4
179 ACTIVITY_CLOSE_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
180 ACTIVITY_CLOSE_DATE_FIN_MONTH INTEGER 4
181 ACTIVITY_CLOSE_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
182 ACTIVITY_CLOSE_DATE_FIN_DAY INTEGER 4
183 ACTIVITY_CLOSE_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
184 ACTIVITY_CLOSE_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
185 ACTIVITY_CLOSE_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
186 ACTIVITY_CLOSE_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
187 ACTIVITY_CLOSE_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
188 ACTIVITY_CLOSE_DATE_DAY_OF_WEEK BIGINT 8
189 ACTIVITY_CLOSE_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
190 ACTIVITY_CLOSE_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
191 ACTIVITY_TARGET_DATE_YEAR INTEGER 4
192 ACTIVITY_TARGET_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
193 ACTIVITY_TARGET_DATE_QUARTER INTEGER 4
194 ACTIVITY_TARGET_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
195 ACTIVITY_TARGET_DATE_MONTH INTEGER 4
196 ACTIVITY_TARGET_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
197 ACTIVITY_TARGET_DATE_DAY INTEGER 4
198 ACTIVITY_TARGET_DATE_DAY_LABEL CHARACTER VARYING(13) 13
199 ACTIVITY_TARGET_DATE_FIN_YEAR INTEGER 4
200 ACTIVITY_TARGET_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
201 ACTIVITY_TARGET_DATE_FIN_QUARTER INTEGER 4
202 ACTIVITY_TARGET_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
203 ACTIVITY_TARGET_DATE_FIN_MONTH INTEGER 4
204 ACTIVITY_TARGET_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
205 ACTIVITY_TARGET_DATE_FIN_DAY INTEGER 4
206 ACTIVITY_TARGET_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
207 ACTIVITY_TARGET_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
208 ACTIVITY_TARGET_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
209 ACTIVITY_TARGET_DAY_OF_WEEK BIGINT 8
210 ACTIVITY_TARGET_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
211 ACTIVITY_TARGET_HOLIDAY_FLAG CHARACTER VARYING(13) 13
212 FINALISED_DATE_YEAR INTEGER 4
213 FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
214 FINALISED_DATE_QUARTER INTEGER 4
215 FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
216 FINALISED_DATE_MONTH INTEGER 4
217 FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
218 FINALISED_DATE_DAY INTEGER 4
219 FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
220 FINALISED_DATE_FIN_YEAR INTEGER 4
221 FINALISED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
222 FINALISED_DATE_FIN_QUARTER INTEGER 4
223 FINALISED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
224 FINALISED_DATE_FIN_MONTH INTEGER 4
225 FINALISED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
226 FINALISED_DATE_FIN_DAY INTEGER 4
227 FINALISED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
228 FINALISED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
229 FINALISED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
230 FINALISED_DATE_DAY_OF_WEEK BIGINT 8
231 FINALISED_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
232 FINALISED_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
233 REOPEN_DATE_YEAR INTEGER 4
234 REOPEN_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
235 REOPEN_DATE_QUARTER INTEGER 4
236 REOPEN_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
237 REOPEN_DATE_MONTH INTEGER 4
238 REOPEN_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
239 REOPEN_DATE_DAY INTEGER 4
240 REOPEN_DATE_DAY_LABEL CHARACTER VARYING(13) 13
241 REOPEN_DATE_FIN_YEAR INTEGER 4
242 REOPEN_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
243 REOPEN_DATE_FIN_QUARTER INTEGER 4
244 REOPEN_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
245 REOPEN_DATE_FIN_MONTH INTEGER 4
246 REOPEN_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
247 REOPEN_DATE_FIN_DAY INTEGER 4
248 REOPEN_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
249 REOPEN_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
250 REOPEN_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
251 REOPEN_DATE_DAY_OF_WEEK BIGINT 8
252 REOPEN_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
253 REOPEN_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
254 LOSS_DATE_YEAR INTEGER 4
255 LOSS_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
256 LOSS_DATE_QUARTER INTEGER 4
257 LOSS_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
258 LOSS_DATE_MONTH INTEGER 4
259 LOSS_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
260 LOSS_DATE_DAY INTEGER 4
261 LOSS_DATE_DAY_LABEL CHARACTER VARYING(13) 13
262 LOSS_DATE_FIN_YEAR INTEGER 4
263 LOSS_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
264 LOSS_DATE_FIN_QUARTER INTEGER 4
265 LOSS_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
266 LOSS_DATE_FIN_MONTH INTEGER 4
267 LOSS_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
268 LOSS_DATE_FIN_DAY INTEGER 4
269 LOSS_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
270 LOSS_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
271 LOSS_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
272 LOSS_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
273 LOSS_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
274 LOSS_DATE_DAY_OF_WEEK BIGINT 8
275 LOSS_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
276 LOSS_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
277 LODGEMENT_DATE_YEAR INTEGER 4
278 LODGEMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
279 LODGEMENT_DATE_QUARTER INTEGER 4
280 LODGEMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
281 LODGEMENT_DATE_MONTH INTEGER 4
282 LODGEMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
283 LODGEMENT_DATE_DAY INTEGER 4
284 LODGEMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
285 LODGEMENT_DATE_FIN_YEAR INTEGER 4
286 LODGEMENT_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
287 LODGEMENT_DATE_FIN_QUARTER INTEGER 4
288 LODGEMENT_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
289 LODGEMENT_DATE_FIN_MONTH INTEGER 4
290 LODGEMENT_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
291 LODGEMENT_DATE_FIN_DAY INTEGER 4
292 LODGEMENT_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
293 LODGEMENT_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
294 LODGEMENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
295 LODGEMENT_DATE_DAY_OF_WEEK BIGINT 8
296 LODGEMENT_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
297 LODGEMENT_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
298 ACTIVITY_AGE_BAND_NAME CHARACTER VARYING(14) 14
299 ACTIVITY_PRIORITY_NAME CHARACTER VARYING(256) 256
300 ASSESSMENTBOOKING_CREATEDATE TIMESTAMP 8
301 ASSESSMENTBOOKING_CREATEDATE_YEAR INTEGER 4
302 ASSESSMENTBOOKING_CREATEDATE_YEAR_LABEL CHARACTER VARYING(13) 13
303 ASSESSMENTBOOKING_CREATEDATE_QUARTER INTEGER 4
304 ASSESSMENTBOOKING_CREATEDATE_QUARTER_LABEL CHARACTER VARYING(13) 13
305 ASSESSMENTBOOKING_CREATEDATE_MONTH INTEGER 4
306 ASSESSMENTBOOKING_CREATEDATE_MONTH_LABEL CHARACTER VARYING(13) 13
307 ASSESSMENTBOOKING_CREATEDATE_DAY INTEGER 4
308 ASSESSMENTBOOKING_CREATEDATE_DAY_LABEL CHARACTER VARYING(13) 13
309 ASSESSMENTBOOKING_CREATEDATE_FIN_YEAR INTEGER 4
310 ASSESSMENTBOOKING_CREATEDATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
311 ASSESSMENTBOOKING_CREATEDATE_FIN_QUARTER INTEGER 4
312 ASSESSMENTBOOKING_CREATEDATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
313 ASSESSMENTBOOKING_CREATEDATE_FIN_MONTH INTEGER 4
314 ASSESSMENTBOOKING_CREATEDATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
315 ASSESSMENTBOOKING_CREATEDATE_FIN_DAY INTEGER 4
316 ASSESSMENTBOOKING_CREATEDATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
317 ASSESSMENTBOOKING_CREATEDATE_CURRENT_MONTH CHARACTER VARYING(8) 8
318 ASSESSMENTBOOKING_CREATEDATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
319 ASSESSMENTBOOKING_CREATEDATE_DAY_OF_WEEK BIGINT 8
320 ASSESSMENTBOOKING_CREATEDATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
321 ASSESSMENTBOOKING_CREATEDATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
322 ACTIVITY_COMPLETED_IN_SCOPE CHARACTER VARYING(12) 12
323 ACTIVITY_COMPLETED_IN_SCOPE_WITHIN_SLA CHARACTER VARYING(23) 23
324 ACTIVITY_CONVERSION_30_DAYS CHARACTER VARYING(3) 3
325 ACTIVITY_CONVERSION_DAYS INTEGER 4
326 ACTIVITY_CONVERSION_HOURS NUMERIC(9,2) 19
327 ASSESSMENT_PROCESS_TYPE_ID BIGINT 8
328 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
329 ACTIVITY_COMPLETED_WITH_SYSTEM_TARGET_INDICATOR INTEGER 4
330 CCR_CC_ACTIVITY_PATTERN_ID BIGINT 8
331 ACTIVITY_TARGET_DAYS BIGINT 8
332 ACTIVITY_TARGET_HOURS BIGINT 8
333 ACTIVITY_TARGET_TYPE CHARACTER VARYING(24) 24
334 ACTIVITY_WORKING_HOURS_ELAPSED NUMERIC(26,6) 19
335 ACTIVITY_WORKING_DAYS_ELAPSED NUMERIC(38,0) 19
336 ACTIVITY_CALENDAR_HOURS_ELAPSED NUMERIC(25,6) 19
337 ACTIVITY_CALENDAR_DAYS_ELAPSED INTEGER 4
338 ACTIVITY_SUBJECT CHARACTER VARYING(255) 255
339 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
340 LEGACYCLAIM_FLAG CHARACTER VARYING(3) 3
341 LEGACYCLAIM_CATEGORY CHARACTER VARYING(256) 256