INT_CI_CLAIM_EXPOSURE_DRILLTHRU

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND_ID BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CREATE_DATE TIMESTAMP 8
4 CREATE_DATE_YEAR INTEGER 4
5 CREATE_DATE_QUARTER INTEGER 4
6 CREATE_DATE_MONTH INTEGER 4
7 CREATE_DATE_DAY INTEGER 4
8 CREATE_DATE_DAY_TYPE_ID INTEGER 4
9 CREATE_DATE_WEEK_TYPE_ID INTEGER 4
10 CREATE_DATE_MONTH_TYPE_ID INTEGER 4
11 CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
12 CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
13 CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
14 CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
15 CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
16 CREATE_DATE_HALF_TYPE_ID INTEGER 4
17 CLAIM_REJECT_REASON_ID BIGINT 8
18 CLAIM_REJECT_REASON CHARACTER VARYING(256) 256
19 CLAIM_NUMBER CHARACTER VARYING(40) 40
20 EXPOSURE_REJECT_REASON_ID BIGINT 8
21 EXPOSURE_REJECT_REASON CHARACTER VARYING(256) 256
22 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
23 EXPOSURE_ASSIGNMENT_DATE TIMESTAMP 8
24 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
25 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
26 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
27 CLAIM_INITIAL_FINALISED_DATE_YEAR INTEGER 4
28 CLAIM_INITIAL_FINALISED_DATE_QUARTER INTEGER 4
29 CLAIM_INITIAL_FINALISED_DATE_MONTH INTEGER 4
30 CLAIM_INITIAL_FINALISED_DATE_DAY INTEGER 4
31 CLAIM_INITIAL_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
32 CLAIM_INITIAL_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
33 CLAIM_INITIAL_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
34 CLAIM_INITIAL_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
35 CLAIM_INITIAL_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
36 CLAIM_INITIAL_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
37 CLAIM_INITIAL_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
38 CLAIM_INITIAL_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
39 CLAIM_INITIAL_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
40 CLAIM_REOPENED_REASON_ID BIGINT 8
41 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
42 CLAIM_SEGMENT_ID BIGINT 8
43 CLAIM_SEGMENT CHARACTER VARYING(256) 256
44 EXCESS_AMOUNT NUMERIC(38,2) 19
45 CLAIM_DURATION_ID INTEGER 4
46 CLAIM_DURATION_BAND_ID INTEGER 4
47 CLAIM_DURATION_BAND CHARACTER VARYING(14) 14
48 LATEST_EXPOSURE_CLOSE_DATE TIMESTAMP 8
49 LATEST_EXPOSURE_CLOSE_DATE_YEAR INTEGER 4
50 LATEST_EXPOSURE_CLOSE_DATE_QUARTER INTEGER 4
51 LATEST_EXPOSURE_CLOSE_DATE_MONTH INTEGER 4
52 LATEST_EXPOSURE_CLOSE_DATE_DAY INTEGER 4
53 LATEST_EXPOSURE_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
54 LATEST_EXPOSURE_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
55 LATEST_EXPOSURE_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
56 LATEST_EXPOSURE_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
57 LATEST_EXPOSURE_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
58 LATEST_EXPOSURE_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
59 LATEST_EXPOSURE_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
60 LATEST_EXPOSURE_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
61 LATEST_EXPOSURE_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
62 LATEST_EXPOSURE_REOPENED_DATE TIMESTAMP 8
63 LATEST_EXPOSURE_REOPENED_DATE_YEAR INTEGER 4
64 LATEST_EXPOSURE_REOPENED_DATE_QUARTER INTEGER 4
65 LATEST_EXPOSURE_REOPENED_DATE_MONTH INTEGER 4
66 LATEST_EXPOSURE_REOPENED_DATE_DAY INTEGER 4
67 LATEST_EXPOSURE_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
68 LATEST_EXPOSURE_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
69 LATEST_EXPOSURE_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
70 LATEST_EXPOSURE_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
71 LATEST_EXPOSURE_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
72 LATEST_EXPOSURE_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
73 LATEST_EXPOSURE_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
74 LATEST_EXPOSURE_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
75 LATEST_EXPOSURE_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
76 EXPOSURE_INITAL_CLOSED_DATE TIMESTAMP 8
77 EXPOSURE_INITAL_CLOSED_DATE_YEAR INTEGER 4
78 EXPOSURE_INITAL_CLOSED_DATE_QUARTER INTEGER 4
79 EXPOSURE_INITAL_CLOSED_DATE_MONTH INTEGER 4
80 EXPOSURE_INITAL_CLOSED_DATE_DAY INTEGER 4
81 EXPOSURE_INITAL_CLOSED_DATE_DAY_TYPE_ID INTEGER 4
82 EXPOSURE_INITAL_CLOSED_DATE_WEEK_TYPE_ID INTEGER 4
83 EXPOSURE_INITAL_CLOSED_DATE_MONTH_TYPE_ID INTEGER 4
84 EXPOSURE_INITAL_CLOSED_DATE_QUARTER_TYPE_ID INTEGER 4
85 EXPOSURE_INITAL_CLOSED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
86 EXPOSURE_INITAL_CLOSED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
87 EXPOSURE_INITAL_CLOSED_DATE_R12_MONTH_TYPE_ID INTEGER 4
88 EXPOSURE_INITAL_CLOSED_DATE_R13_MONTH_TYPE_ID INTEGER 4
89 EXPOSURE_INITAL_CLOSED_DATE_HALF_TYPE_ID INTEGER 4
90 EXPOSURE_COUNT BIGINT 8
91 EXPOSURE_DURATION_ID INTERVAL 12
92 EXPOSURE_DURATION_BAND_ID INTEGER 4
93 EXPOSURE_DURATION_BAND CHARACTER VARYING(14) 14
94 CLAIM_STATE_ID BIGINT 8
95 CLAIM_STATE CHARACTER VARYING(256) 256
96 EXPOSURE_STATE_ID BIGINT 8
97 EXPOSURE_STATE CHARACTER VARYING(256) 256
98 EXPOSURE_DECISION_ID BIGINT 8
99 EXPOSURE_DECISION CHARACTER VARYING(256) 256
100 EXPOSURE_CREATE_DATE TIMESTAMP 8
101 EXPOSURE_CREATE_DATE_YEAR INTEGER 4
102 EXPOSURE_CREATE_DATE_QUARTER INTEGER 4
103 EXPOSURE_CREATE_DATE_MONTH INTEGER 4
104 EXPOSURE_CREATE_DATE_DAY INTEGER 4
105 EXPOSURE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
106 EXPOSURE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
107 EXPOSURE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
108 EXPOSURE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
109 EXPOSURE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
110 EXPOSURE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
111 EXPOSURE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
112 EXPOSURE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
113 EXPOSURE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
114 POLICY_TYPE_ID BIGINT 8
115 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
116 LINE_OF_BUSINESS_ID BIGINT 8
117 CURRENT_POLICY_STATUS_ID BIGINT 8
118 EXPOSURE_INCIDENT_LOSS_CAUSE_ID BIGINT 8
119 EXPOSURE_INCIDENT_LOSS_CAUSE CHARACTER VARYING(256) 256
120 EXPOSURE_INCIDENT_SUB_TYPE_ID BIGINT 8
121 EXPOSURE_INCIDENT_SUB_TYPE CHARACTER VARYING(256) 256
122 EXPOSURE_FIRST_CLOSURE_DURATION INTEGER 4
123 EXPOSURE_FIRST_CLOSURE_DURATION_BAND_ID INTEGER 4
124 EXPOSURE_FIRST_CLOSURE_DURATION_BAND_NAME CHARACTER VARYING(14) 14
125 EXPOSURE_ADJUSTER_ID BIGINT 8
126 EXPOSURE_ADJUSTER_LOOKUP_USER_ID BIGINT 8
127 EXPOSURE_ADJUSTER CHARACTER VARYING(181) 181
128 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
129 TEAM_ID BIGINT 8
130 TEAM_NAME CHARACTER VARYING(100) 100
131 GROUP_TYPE_ID BIGINT 8
132 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
133 L1_TEAM_ID BIGINT 8
134 L1_TEAM_NAME CHARACTER VARYING(100) 100
135 L2_TEAM_ID BIGINT 8
136 L2_TEAM_NAME CHARACTER VARYING(100) 100
137 L3_TEAM_ID BIGINT 8
138 L3_TEAM_NAME CHARACTER VARYING(100) 100
139 L4_TEAM_ID BIGINT 8
140 L4_TEAM_NAME CHARACTER VARYING(100) 100
141 L5_TEAM_ID BIGINT 8
142 L5_TEAM_NAME CHARACTER VARYING(100) 100
143 L6_TEAM_ID BIGINT 8
144 L6_TEAM_NAME CHARACTER VARYING(100) 100
145 L7_TEAM_ID BIGINT 8
146 L7_TEAM_NAME CHARACTER VARYING(100) 100
147 L8_TEAM_ID BIGINT 8
148 L8_TEAM_NAME CHARACTER VARYING(100) 100
149 L9_TEAM_ID BIGINT 8
150 L9_TEAM_NAME CHARACTER VARYING(100) 100
151 L10_TEAM_ID BIGINT 8
152 L10_TEAM_NAME CHARACTER VARYING(100) 100
153 L11_TEAM_ID BIGINT 8
154 L11_TEAM_NAME CHARACTER VARYING(100) 100
155 EXPOSURE_INCIDENT_LOSS_LOCATION_STATE_ID BIGINT 8
156 EXPOSURE_INCIDENT_LOSS_LOCATION_STATE CHARACTER VARYING(256) 256
157 POSTCODE CHARACTER VARYING(60) 60
158 EXPOSURE_INCIDENT_REPORT_ONLY_ID BIGINT 8
159 EXPOSURE_INCIDENT_REPORT_ONLY_NAME CHARACTER VARYING(256) 256
160 EXPOSURE_INCIDENT_NATURE_OF_INJURY_ID BIGINT 8
161 EXPOSURE_INCIDENT_NATURE_OF_INJURY_NAME CHARACTER VARYING(256) 256
162 EXPOSURE_INCIDENT_DETAILED_INJURY_TYPE_ID BIGINT 8
163 EXPOSURE_INCIDENT_DETAILED_INJURY_TYPE_NAME CHARACTER VARYING(256) 256
164 EXPOSURE_ASSIGNED_TEAM_ID BIGINT 8
165 EXPOSURE_ASSIGNED_TEAM CHARACTER VARYING(100) 100
166 EXPOSURE_ASSIGNED_BY_USER_ID BIGINT 8
167 EXPOSURE_ASSIGNED_BY_USER CHARACTER VARYING(181) 181
168 EXPOSURE_ASSIGNMENT_STATUS_ID BIGINT 8
169 EXPOSURE_ASSIGNMENT_STATUS CHARACTER VARYING(256) 256
170 EXPOSURE_CLAIMANT_ID BIGINT 8
171 EXPOSURE_CLAIMANT CHARACTER VARYING(181) 181
172 EXPOSURE_CLAIM_ID BIGINT 8
173 EXPOSURE_COVERAGE_ID BIGINT 8
174 EXPOSURE_COVERAGE_SUBTYPE_ID BIGINT 8
175 EXPOSURE_COVERAGE_SUBTYPE CHARACTER VARYING(256) 256
176 EXPOSURE_CREATE_USER_ID BIGINT 8
177 EXPOSURE_CREATE_USER CHARACTER VARYING(181) 181
178 EXPOSURE_TYPE_ID BIGINT 8
179 EXPOSURE_TYPE CHARACTER VARYING(256) 256
180 EXPOSURE_INCIDENT_ID BIGINT 8
181 EXPOSURE_LOSS_PARTY_ID BIGINT 8
182 EXPOSURE_LOSS_PARTY CHARACTER VARYING(256) 256
183 EXPOSURE_PRIMARY_COVERAGE_ID BIGINT 8
184 EXPOSURE_PRIMARY_COVERAGE CHARACTER VARYING(256) 256
185 EXPOSURE_REOPENED_REASON_ID BIGINT 8
186 EXPOSURE_REOPENED_REASON CHARACTER VARYING(256) 256
187 EXPOSURE_SEGMENT_ID BIGINT 8
188 EXPOSURE_SEGMENT CHARACTER VARYING(256) 256
189 EXPOSURE_CLOSED_OUTCOME_ID BIGINT 8
190 EXPOSURE_CLOSED_OUTCOME CHARACTER VARYING(256) 256
191 EXPOSURE_RISK_POLICY_LOCATION_ID BIGINT 8
192 EXPOSURE_POLICY_LOCATION_ADDRESS_ID BIGINT 8
193 EXPOSURE_RISK_LOCATION_ADDR_STATE_ID BIGINT 8
194 EXPOSURE_RISK_LOCATION_ADDR_POSTALCODE CHARACTER VARYING(60) 60
195 EXPOSURE_RISK_LOCATION_ADDR_STATE_NAME CHARACTER VARYING(256) 256
196 EXPOSURE_INCIDENT_REPORTED_DATE TIMESTAMP 8
197 EXPOSURE_INCIDENT_REPORTED_DATE_ID INTEGER 4
198 EXPOSURE_INCIDENT_REPORTED_DATE_YEAR INTEGER 4
199 EXPOSURE_INCIDENT_REPORTED_DATE_QUARTER INTEGER 4
200 EXPOSURE_INCIDENT_REPORTED_DATE_MONTH INTEGER 4
201 EXPOSURE_INCIDENT_REPORTED_DATE_DAY INTEGER 4
202 EXPOSURE_INCIDENT_REPORTED_DATE_DAY_TYPE_ID INTEGER 4
203 EXPOSURE_INCIDENT_REPORTED_DATE_WEEK_TYPE_ID INTEGER 4
204 EXPOSURE_INCIDENT_REPORTED_DATE_MONTH_TYPE_ID INTEGER 4
205 EXPOSURE_INCIDENT_REPORTED_DATE_QUARTER_TYPE_ID INTEGER 4
206 EXPOSURE_INCIDENT_REPORTED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
207 EXPOSURE_INCIDENT_REPORTED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
208 EXPOSURE_INCIDENT_REPORTED_DATE_R12_MONTH_TYPE_ID INTEGER 4
209 EXPOSURE_INCIDENT_REPORTED_DATE_R13_MONTH_TYPE_ID INTEGER 4
210 EXPOSURE_INCIDENT_REPORTED_DATE_HALF_TYPE_ID INTEGER 4
211 EXPOSURE_INCIDENT_FAULT_RATING_ID BIGINT 8
212 EXPOSURE_INCIDENT_FAULT_RATING_NAME CHARACTER VARYING(256) 256
213 CLAIM_ASSIGNMENT_DATE TIMESTAMP 8
214 CLAIM_ASSIGNMENT_DATE_ID INTEGER 4
215 CLAIM_ASSIGNED_DATE_CAL_YEAR INTEGER 4
216 CLAIM_ASSIGNED_DATE_CAL_QUARTER INTEGER 4
217 CLAIM_ASSIGNED_DATE_CAL_MONTH INTEGER 4
218 CLAIM_ASSIGNED_DATE_CAL_DAY INTEGER 4
219 CLAIM_ASSIGNED_DATE_DAY_TYPE_ID INTEGER 4
220 CLAIM_ASSIGNED_DATE_WEEK_TYPE_ID INTEGER 4
221 CLAIM_ASSIGNED_DATE_MONTH_TYPE_ID INTEGER 4
222 CLAIM_ASSIGNED_DATE_QUARTER_TYPE_ID INTEGER 4
223 CLAIM_ASSIGNED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
224 CLAIM_ASSIGNED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
225 CLAIM_ASSIGNED_DATE_R12_MONTH_TYPE_ID INTEGER 4
226 CLAIM_ASSIGNED_DATE_R13_MONTH_TYPE_ID INTEGER 4
227 CLAIM_ASSIGNED_DATE_HALF_TYPE_ID INTEGER 4
228 CLAIM_LOSS_DATE TIMESTAMP 8
229 CLAIM_LOSS_DATE_ID INTEGER 4
230 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
231 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
232 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
233 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
234 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
235 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
236 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
237 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
238 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
239 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
240 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
241 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
242 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
243 EXPOSURE_SETTLEMENT_DATE TIMESTAMP 8
244 EXPOSURE_SETTLEMENT_DATE_ID INTEGER 4
245 EXPOSURE_SETTLEMENT_DATE_CAL_YEAR INTEGER 4
246 EXPOSURE_SETTLEMENT_DATE_CAL_QUARTER INTEGER 4
247 EXPOSURE_SETTLEMENT_DATE_CAL_MONTH INTEGER 4
248 EXPOSURE_SETTLEMENT_DATE_CAL_DAY INTEGER 4
249 EXPOSURE_SETTLEMENT_DATE_DAY_TYPE_ID INTEGER 4
250 EXPOSURE_SETTLEMENT_DATE_WEEK_TYPE_ID INTEGER 4
251 EXPOSURE_SETTLEMENT_DATE_MONTH_TYPE_ID INTEGER 4
252 EXPOSURE_SETTLEMENT_DATE_QUARTER_TYPE_ID INTEGER 4
253 EXPOSURE_SETTLEMENT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
254 EXPOSURE_SETTLEMENT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
255 EXPOSURE_SETTLEMENT_DATE_R12_MONTH_TYPE_ID INTEGER 4
256 EXPOSURE_SETTLEMENT_DATE_R13_MONTH_TYPE_ID INTEGER 4
257 EXPOSURE_SETTLEMENT_DATE_HALF_TYPE_ID INTEGER 4
258 EXPOSURE_SETTLEMENT_FLAG_ID INTEGER 4
259 EXPOSURE_SETTLEMENT_FLAG_NAME CHARACTER VARYING(256) 256
260 EXPOSURE_SETTLEMENT_DURATION INTEGER 4
261 EXPOSURE_SETTLEMENT_DURATION_BAND_ID INTEGER 4
262 EXPOSURE_SETTLEMENT_DURATION_BAND_NAME CHARACTER VARYING(14) 14
263 POLICY_NUMBER CHARACTER VARYING(40) 40
264 CLAIM_EVENT_ID BIGINT 8
265 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
266 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
267 EXPOSURE_LITIGATION_FLAG_ID INTEGER 4
268 EXPOSURE_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
269 EXPOSURE_CLAIMANT_TYPE_ID BIGINT 8
270 EXPOSURE_CLAIMANT_TYPE_NAME CHARACTER VARYING(256) 256
271 EXPOSURE_UPDATE_DATE TIMESTAMP 8
272 EXPOSURE_UPDATE_DATE_YEAR INTEGER 4
273 EXPOSURE_UPDATE_DATE_QUARTER INTEGER 4
274 EXPOSURE_UPDATE_DATE_MONTH INTEGER 4
275 EXPOSURE_UPDATE_DATE_DAY INTEGER 4
276 EXPOSURE_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
277 EXPOSURE_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
278 EXPOSURE_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
279 EXPOSURE_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
280 EXPOSURE_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
281 EXPOSURE_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
282 EXPOSURE_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
283 EXPOSURE_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
284 EXPOSURE_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
285 POLICY_GST_EXEMPT_FLAG INTEGER 4
286 POLICY_GST_EXEMPT_FLAG_NAME CHARACTER VARYING(256) 256
287 POLICY_GST_REGISTERED_FLAG INTEGER 4
288 POLICY_GST_REGISTERED_FLAG_NAME CHARACTER VARYING(256) 256
289 POLICY_ITC_PERCENTAGE NUMERIC(4,1) 19
290 VERIFIED_POLICY_FLAG INTEGER 4
291 VERIFIED_POLICY CHARACTER VARYING(256) 256
292 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
293 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
294 VERIFIED_POLICY_STATUS_ID INTEGER 4
295 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
296 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
297 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
298 POLICY_INTERMEDIARY_ID BIGINT 8
299 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
300 EXPOSURE_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
301 EXPOSURE_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
302 EXPOSURE_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
303 EXPOSURE_INSURED_OCCOUPATION_CODE CHARACTER VARYING(10) 10
304 EXPOSURE_INSURED_OCCOUPATION_DESCRIPTION CHARACTER VARYING(100) 100
305 EXPOSURE_LOSS_ADJUSTER_FLAG_ID INTEGER 4
306 EXPOSURE_LOSS_ADJUSTER_FLAG_NAME CHARACTER VARYING(256) 256
307 EXPOSURE_COVERAGE_PRODUCT_CODE CHARACTER VARYING(20) 20
308 EXPOSURE_COVERAGE_PRODUCT_CLASS_CODE CHARACTER VARYING(20) 20
309 EXPOSURE_COVERAGE_PRODUCT_SUBCLASS_CODE CHARACTER VARYING(20) 20
310 EXPOSURE_COVERAGE_BRAND_MARKER_COVERAGE_CODE CHARACTER VARYING(10) 10
311 CLAIM_GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
312 CLAIM_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
313 CLAIM_GROSS_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
314 CLAIM_NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
315 CLAIM_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
316 CLAIM_NET_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
317 EXPOSURE_GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
318 EXPOSURE_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
319 EXPOSURE_GROSS_RECOVERED_NAME CHARACTER VARYING(15) 15
320 EXPOSURE_NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
321 EXPOSURE_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
322 EXPOSURE_NET_RECOVERED_NAME CHARACTER VARYING(15) 15
323 EXPOSURE_GROSS_PAID_AMOUNT NUMERIC(38,2) 19
324 EXPOSURE_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
325 EXPOSURE_GROSS_PAID_NAME CHARACTER VARYING(15) 15
326 EXPOSURE_GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
327 EXPOSURE_GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
328 EXPOSURE_GROSS_INCURRED_NAME CHARACTER VARYING(15) 15
329 EXPOSURE_NET_INCURRED_AMOUNT NUMERIC(38,2) 19
330 EXPOSURE_NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
331 EXPOSURE_NET_INCURRED_NAME CHARACTER VARYING(15) 15