FCT_CI_EXPOSURE_TRANSACTION_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND_ID BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CLAIM_CREATE_DATE TIMESTAMP 8
4 CLAIM_CREATE_DATE_YEAR INTEGER 4
5 CLAIM_CREATE_DATE_QUARTER INTEGER 4
6 CLAIM_CREATE_DATE_MONTH INTEGER 4
7 CLAIM_CREATE_DATE_DAY INTEGER 4
8 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
9 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
10 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
11 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
12 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
13 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
14 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
15 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
16 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
17 CLAIM_ID BIGINT 8
18 CLAIM_NUMBER CHARACTER VARYING(40) 40
19 EXPOSURE_ID BIGINT 8
20 EXPOSURE_NUMBER CHARACTER VARYING(40) 40
21 CLAIM_SEGMENT_ID BIGINT 8
22 CLAIM_SEGMENT_NAME CHARACTER VARYING(256) 256
23 CLAIM_STATE_ID BIGINT 8
24 CLAIM_STATE CHARACTER VARYING(256) 256
25 EXPOSURE_STATE_ID BIGINT 8
26 EXPOSURE_STATE CHARACTER VARYING(256) 256
27 POLICY_GST_EXEMPT_FLAG INTEGER 4
28 POLICY_GST_EXEMPT_FLAG_NAME CHARACTER VARYING(256) 256
29 POLICY_GST_REGISTERED_FLAG INTEGER 4
30 POLICY_GST_REGISTERED_FLAG_NAME CHARACTER VARYING(256) 256
31 POLICY_ITC_PERCENTAGE NUMERIC(4,1) 19
32 EXPOSURE_INCIDENT_SUB_TYPE_ID BIGINT 8
33 EXPOSURE_INCIDENT_SUB_TYPE CHARACTER VARYING(256) 256
34 EXPOSURE_ADJUSTER_ID BIGINT 8
35 EXPOSURE_ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
36 EXPOSURE_ADJUSTER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
37 EXPOSURE_ADJUSTER_TEAM_ID BIGINT 8
38 EXPOSURE_ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
39 EXPOSURE_ADJUSTER_GROUP_TYPE_ID BIGINT 8
40 EXPOSURE_ADJUSTER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
41 EXPOSURE_ADJUSTER_L1_TEAM_ID BIGINT 8
42 EXPOSURE_ADJUSTER_L1_TEAM_NAME CHARACTER VARYING(100) 100
43 EXPOSURE_ADJUSTER_L2_TEAM_ID BIGINT 8
44 EXPOSURE_ADJUSTER_L2_TEAM_NAME CHARACTER VARYING(100) 100
45 EXPOSURE_ADJUSTER_L3_TEAM_ID BIGINT 8
46 EXPOSURE_ADJUSTER_L3_TEAM_NAME CHARACTER VARYING(100) 100
47 EXPOSURE_ADJUSTER_L4_TEAM_ID BIGINT 8
48 EXPOSURE_ADJUSTER_L4_TEAM_NAME CHARACTER VARYING(100) 100
49 EXPOSURE_ADJUSTER_L5_TEAM_ID BIGINT 8
50 EXPOSURE_ADJUSTER_L5_TEAM_NAME CHARACTER VARYING(100) 100
51 EXPOSURE_ADJUSTER_L6_TEAM_ID BIGINT 8
52 EXPOSURE_ADJUSTER_L6_TEAM_NAME CHARACTER VARYING(100) 100
53 EXPOSURE_ADJUSTER_L7_TEAM_ID BIGINT 8
54 EXPOSURE_ADJUSTER_L7_TEAM_NAME CHARACTER VARYING(100) 100
55 EXPOSURE_ADJUSTER_L8_TEAM_ID BIGINT 8
56 EXPOSURE_ADJUSTER_L8_TEAM_NAME CHARACTER VARYING(100) 100
57 EXPOSURE_ADJUSTER_L9_TEAM_ID BIGINT 8
58 EXPOSURE_ADJUSTER_L9_TEAM_NAME CHARACTER VARYING(100) 100
59 EXPOSURE_ADJUSTER_L10_TEAM_ID BIGINT 8
60 EXPOSURE_ADJUSTER_L10_TEAM_NAME CHARACTER VARYING(100) 100
61 EXPOSURE_ADJUSTER_L11_TEAM_ID BIGINT 8
62 EXPOSURE_ADJUSTER_L11_TEAM_NAME CHARACTER VARYING(100) 100
63 EXPOSURE_ASSIGNED_TEAM_ID BIGINT 8
64 EXPOSURE_ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
65 EXPOSURE_COVERAGE_SUBTYPE_ID BIGINT 8
66 EXPOSURE_COVERAGE_SUBTYPE_NAME CHARACTER VARYING(256) 256
67 EXPOSURE_TYPE_ID BIGINT 8
68 EXPOSURE_TYPE_NAME CHARACTER VARYING(256) 256
69 EXPOSURE_PRIMARY_COVERAGE_ID BIGINT 8
70 EXPOSURE_PRIMARY_COVERAGE_NAME CHARACTER VARYING(256) 256
71 EXPOSURE_REOPENED_REASON_ID BIGINT 8
72 EXPOSURE_REOPENED_REASON_NAME CHARACTER VARYING(256) 256
73 EXPOSURE_UPDATE_DATE TIMESTAMP 8
74 EXPOSURE_UPDATE_DATE_YEAR INTEGER 4
75 EXPOSURE_UPDATE_DATE_QUARTER INTEGER 4
76 EXPOSURE_UPDATE_DATE_MONTH INTEGER 4
77 EXPOSURE_UPDATE_DATE_DAY INTEGER 4
78 EXPOSURE_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
79 EXPOSURE_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
80 EXPOSURE_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
81 EXPOSURE_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
82 EXPOSURE_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
83 EXPOSURE_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
84 EXPOSURE_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
85 EXPOSURE_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
86 EXPOSURE_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
87 EXPOSURE_SETTLEMENT_DATE TIMESTAMP 8
88 EXPOSURE_SETTLEMENT_DATE_ID INTEGER 4
89 EXPOSURE_SETTLEMENT_DATE_CAL_YEAR INTEGER 4
90 EXPOSURE_SETTLEMENT_DATE_CAL_QUARTER INTEGER 4
91 EXPOSURE_SETTLEMENT_DATE_CAL_MONTH INTEGER 4
92 EXPOSURE_SETTLEMENT_DATE_CAL_DAY INTEGER 4
93 EXPOSURE_SETTLEMENT_DATE_DAY_TYPE_ID INTEGER 4
94 EXPOSURE_SETTLEMENT_DATE_WEEK_TYPE_ID INTEGER 4
95 EXPOSURE_SETTLEMENT_DATE_MONTH_TYPE_ID INTEGER 4
96 EXPOSURE_SETTLEMENT_DATE_QUARTER_TYPE_ID INTEGER 4
97 EXPOSURE_SETTLEMENT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
98 EXPOSURE_SETTLEMENT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
99 EXPOSURE_SETTLEMENT_DATE_R12_MONTH_TYPE_ID INTEGER 4
100 EXPOSURE_SETTLEMENT_DATE_R13_MONTH_TYPE_ID INTEGER 4
101 EXPOSURE_SETTLEMENT_DATE_HALF_TYPE_ID INTEGER 4
102 CHECK_ID BIGINT 8
103 CHEQUE_PAYEE_NAME CHARACTER VARYING(255) 255
104 CHECK_RECIPIENT_NAME CHARACTER VARYING(255) 255
105 CHECK_RECIPIENT_ADDRESS CHARACTER VARYING(255) 255
106 CHECK_ACCOUNT_NAME CHARACTER VARYING(255) 255
107 CHECK_ACCOUNT_NUMBER CHARACTER VARYING(255) 255
108 CHECK_ACCOUNT_BANK_NAME CHARACTER VARYING(255) 255
109 CHECK_ACCOUNT_BSB CHARACTER VARYING(255) 255
110 CHECK_NUMBER CHARACTER VARYING(255) 255
111 CHECK_INVOICE_NUMBER CHARACTER VARYING(255) 255
112 PAYEE_NAME_ID BIGINT 8
113 PAYEE_NAME CHARACTER VARYING(181) 181
114 RECOVERY_CATEGORY_ID BIGINT 8
115 RECOVERY_CATEGORY_NAME CHARACTER VARYING(256) 256
116 CHEQUE_STATUS_ID BIGINT 8
117 CHECK_STATUS_NAME CHARACTER VARYING(256) 256
118 TRANSACTION_PAYMENT_METHOD_ID BIGINT 8
119 TRANSACTION_PAYMENT_METHOD CHARACTER VARYING(256) 256
120 CHEQUE_CREATE_DATE TIMESTAMP 8
121 CHEQUE_CREATE_DATE_YEAR INTEGER 4
122 CHEQUE_CREATE_DATE_QUARTER INTEGER 4
123 CHEQUE_CREATE_DATE_MONTH INTEGER 4
124 CHEQUE_CREATE_DATE_DAY INTEGER 4
125 CHEQUE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
126 CHEQUE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
127 CHEQUE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
128 CHEQUE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
129 CHEQUE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
130 CHEQUE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
131 CHEQUE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
132 CHEQUE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
133 CHEQUE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
134 CHEQUE_ISSUE_DATE TIMESTAMP 8
135 CHEQUE_ISSUE_DATE_YEAR INTEGER 4
136 CHEQUE_ISSUE_DATE_QUARTER INTEGER 4
137 CHEQUE_ISSUE_DATE_MONTH INTEGER 4
138 CHEQUE_ISSUE_DATE_DAY INTEGER 4
139 CHEQUE_ISSUE_DATE_DAY_TYPE_ID INTEGER 4
140 CHEQUE_ISSUE_DATE_WEEK_TYPE_ID INTEGER 4
141 CHEQUE_ISSUE_DATE_MONTH_TYPE_ID INTEGER 4
142 CHEQUE_ISSUE_DATE_QUARTER_TYPE_ID INTEGER 4
143 CHEQUE_ISSUE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
144 CHEQUE_ISSUE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
145 CHEQUE_ISSUE_DATE_R12_MONTH_TYPE_ID INTEGER 4
146 CHEQUE_ISSUE_DATE_R13_MONTH_TYPE_ID INTEGER 4
147 CHEQUE_ISSUE_DATE_HALF_TYPE_ID INTEGER 4
148 TRANSACTION_ID BIGINT 8
149 TRANSACTION_CREATE_DATE TIMESTAMP 8
150 TRANSACTION_CREATE_DATE_YEAR INTEGER 4
151 TRANSACTION_CREATE_DATE_QUARTER INTEGER 4
152 TRANSACTION_CREATE_DATE_MONTH INTEGER 4
153 TRANSACTION_CREATE_DATE_DAY INTEGER 4
154 TRANSACTION_CREATE_DATE_DAY_TYPE_ID INTEGER 4
155 TRANSACTION_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
156 TRANSACTION_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
157 TRANSACTION_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
158 TRANSACTION_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
159 TRANSACTION_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
160 TRANSACTION_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
161 TRANSACTION_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
162 TRANSACTION_CREATE_DATE_HALF_TYPE_ID INTEGER 4
163 TRANSACTION_CREATE_BY_USER_ID BIGINT 8
164 TRANSACTION_CREATE_BY_USER_NAME CHARACTER VARYING(181) 181
165 TRANSACTION_CREATE_BY_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
166 TRANSACTION_CREATE_BY_TEAM_ID BIGINT 8
167 TRANSACTION_CREATE_BY_TEAM_NAME CHARACTER VARYING(100) 100
168 TRANSACTION_CREATE_BY_GROUP_TYPE_ID BIGINT 8
169 TRANSACTION_CREATE_BY_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
170 TRANSACTION_CREATE_BY_USER_L1_TEAM_ID BIGINT 8
171 TRANSACTION_CREATE_BY_USER_L2_TEAM_ID BIGINT 8
172 TRANSACTION_CREATE_BY_USER_L3_TEAM_ID BIGINT 8
173 TRANSACTION_CREATE_BY_USER_L4_TEAM_ID BIGINT 8
174 TRANSACTION_CREATE_BY_USER_L5_TEAM_ID BIGINT 8
175 TRANSACTION_CREATE_BY_USER_L6_TEAM_ID BIGINT 8
176 TRANSACTION_CREATE_BY_USER_L7_TEAM_ID BIGINT 8
177 TRANSACTION_CREATE_BY_USER_L8_TEAM_ID BIGINT 8
178 TRANSACTION_CREATE_BY_USER_L9_TEAM_ID BIGINT 8
179 TRANSACTION_CREATE_BY_USER_L10_TEAM_ID BIGINT 8
180 TRANSACTION_CREATE_BY_USER_L11_TEAM_ID BIGINT 8
181 TRANSACTION_UPDATE_USER_ID BIGINT 8
182 TRANSACTION_UPDATE_USER_NAME CHARACTER VARYING(181) 181
183 TRANSACTION_UPDATE_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
184 TRANSACTION_UPDATE_TEAM_ID BIGINT 8
185 TRANSACTION_UPDATE_TEAM_NAME CHARACTER VARYING(100) 100
186 TRANSACTION_UPDATE_GROUP_TYPE_ID BIGINT 8
187 TRANSACTION_UPDATE_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
188 TRANSACTION_UPDATE_USER_L1_TEAM_ID BIGINT 8
189 TRANSACTION_UPDATE_USER_L2_TEAM_ID BIGINT 8
190 TRANSACTION_UPDATE_USER_L3_TEAM_ID BIGINT 8
191 TRANSACTION_UPDATE_USER_L4_TEAM_ID BIGINT 8
192 TRANSACTION_UPDATE_USER_L5_TEAM_ID BIGINT 8
193 TRANSACTION_UPDATE_USER_L6_TEAM_ID BIGINT 8
194 TRANSACTION_UPDATE_USER_L7_TEAM_ID BIGINT 8
195 TRANSACTION_UPDATE_USER_L8_TEAM_ID BIGINT 8
196 TRANSACTION_UPDATE_USER_L9_TEAM_ID BIGINT 8
197 TRANSACTION_UPDATE_USER_L10_TEAM_ID BIGINT 8
198 TRANSACTION_UPDATE_USER_L11_TEAM_ID BIGINT 8
199 TRANSACTION_PAYMENT_APPLICATION_ID BIGINT 8
200 TRANSACTION_PAYMENT_APPLICATION_NAME CHARACTER VARYING(256) 256
201 TRANSACTION_COST_TYPE_ID BIGINT 8
202 TRANSACTION_COST_TYPE_NAME CHARACTER VARYING(256) 256
203 TRANSACTION_COST_CATEGORY_ID BIGINT 8
204 TRANSACTION_COST_CATEGORY_NAME CHARACTER VARYING(256) 256
205 TRANSACTION_STATUS_ID BIGINT 8
206 TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
207 TRANSACTION_SUB_TYPE_ID BIGINT 8
208 TRANSACTION_SUB_TYPE_NAME CHARACTER VARYING(256) 256
209 TRANSACTION_COMMENTS CHARACTER VARYING(255) 255
210 REMAINING_RESERVES NUMERIC(19,2) 19
211 FUTURE_PAYMENT NUMERIC(18,2) 19
212 PAID_AMOUNT NUMERIC(18,2) 19
213 OPEN_RECOVERY_RESERVES_AMOUNT NUMERIC(19,2) 19
214 GROSS_INCURRED_AMOUNT NUMERIC(20,2) 19
215 NET_INCURRED_AMOUNT NUMERIC(21,2) 19
216 DAM_AMOUNT NUMERIC(18,2) 19
217 DAM_SETTLEMENT_AMOUNT NUMERIC(18,2) 19
218 GST_AMOUNT NUMERIC(18,2) 19
219 ITC_AMOUNT NUMERIC(18,2) 19
220 RECOVERIES_AMOUNT NUMERIC(18,2) 19
221 RECOVERY_RESERVES_AMOUNT NUMERIC(18,2) 19
222 RESERVES_AMOUNT NUMERIC(18,2) 19
223 TRANSACTION_AMOUNT NUMERIC(18,2) 19
224 GL_NET_INCURRED_AMOUNT NUMERIC(22,2) 19
225 NET_RECOVERY_AMOUNT NUMERIC(19,2) 19
226 TRANSACTION_LINE_ITEM_ID BIGINT 8
227 EXPOSURE_INCIDENT_REPORTED_DATE TIMESTAMP 8
228 EXPOSURE_INCIDENT_REPORTED_DATE_ID INTEGER 4
229 EXPOSURE_INCIDENT_REPORTED_DATE_YEAR INTEGER 4
230 EXPOSURE_INCIDENT_REPORTED_DATE_QUARTER INTEGER 4
231 EXPOSURE_INCIDENT_REPORTED_DATE_MONTH INTEGER 4
232 EXPOSURE_INCIDENT_REPORTED_DATE_DAY INTEGER 4
233 EXPOSURE_INCIDENT_REPORTED_DATE_DAY_TYPE_ID INTEGER 4
234 EXPOSURE_INCIDENT_REPORTED_DATE_WEEK_TYPE_ID INTEGER 4
235 EXPOSURE_INCIDENT_REPORTED_DATE_MONTH_TYPE_ID INTEGER 4
236 EXPOSURE_INCIDENT_REPORTED_DATE_QUARTER_TYPE_ID INTEGER 4
237 EXPOSURE_INCIDENT_REPORTED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
238 EXPOSURE_INCIDENT_REPORTED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
239 EXPOSURE_INCIDENT_REPORTED_DATE_R12_MONTH_TYPE_ID INTEGER 4
240 EXPOSURE_INCIDENT_REPORTED_DATE_R13_MONTH_TYPE_ID INTEGER 4
241 EXPOSURE_INCIDENT_REPORTED_DATE_HALF_TYPE_ID INTEGER 4
242 TRANSACTION_APPROVAL_DATE TIMESTAMP 8
243 TRANSACTION_APPROVAL_DATE_YEAR INTEGER 4
244 TRANSACTION_APPROVAL_DATE_QUARTER INTEGER 4
245 TRANSACTION_APPROVAL_DATE_MONTH INTEGER 4
246 TRANSACTION_APPROVAL_DATE_DAY INTEGER 4
247 TRANSACTION_APPROVAL_DATE_DAY_TYPE_ID INTEGER 4
248 TRANSACTION_APPROVAL_DATE_WEEK_TYPE_ID INTEGER 4
249 TRANSACTION_APPROVAL_DATE_MONTH_TYPE_ID INTEGER 4
250 TRANSACTION_APPROVAL_DATE_QUARTER_TYPE_ID INTEGER 4
251 TRANSACTION_APPROVAL_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
252 TRANSACTION_APPROVAL_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
253 TRANSACTION_APPROVAL_DATE_R12_MONTH_TYPE_ID INTEGER 4
254 TRANSACTION_APPROVAL_DATE_R13_MONTH_TYPE_ID INTEGER 4
255 TRANSACTION_APPROVAL_DATE_HALF_TYPE_ID INTEGER 4
256 TRANSACTION_APPROVAL_STATUS_ID BIGINT 8
257 TRANSACTION_APPROVAL_STATUS_NAME CHARACTER VARYING(256) 256
258 CLAIM_LOSS_DATE TIMESTAMP 8
259 CLAIM_LOSS_DATE_ID INTEGER 4
260 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
261 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
262 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
263 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
264 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
265 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
266 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
267 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
268 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
269 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
270 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
271 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
272 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
273 CLAIM_EVENT_ID BIGINT 8
274 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
275 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
276 EXPOSURE_SETTLEMENT_FLAG_ID INTEGER 4
277 EXPOSURE_SETTLEMENT_FLAG_NAME CHARACTER VARYING(256) 256
278 EXPOSURE_SETTLEMENT_DURATION INTEGER 4
279 EXPOSURE_SETTLEMENT_DURATION_BAND_ID INTEGER 4
280 EXPOSURE_SETTLEMENT_DURATION_BAND_NAME CHARACTER VARYING(14) 14
281 TRANSACTION_RECEIPT_DATE TIMESTAMP 8
282 TRANSACTION_RECEIPT_DATE_YEAR INTEGER 4
283 TRANSACTION_RECEIPT_DATE_QUARTER INTEGER 4
284 TRANSACTION_RECEIPT_DATE_MONTH INTEGER 4
285 TRANSACTION_RECEIPT_DATE_DAY INTEGER 4
286 TRANSACTION_RECEIPT_DATE_DAY_TYPE_ID INTEGER 4
287 TRANSACTION_RECEIPT_DATE_WEEK_TYPE_ID INTEGER 4
288 TRANSACTION_RECEIPT_DATE_MONTH_TYPE_ID INTEGER 4
289 TRANSACTION_RECEIPT_DATE_QUARTER_TYPE_ID INTEGER 4
290 TRANSACTION_RECEIPT_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
291 TRANSACTION_RECEIPT_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
292 TRANSACTION_RECEIPT_DATE_R12_MONTH_TYPE_ID INTEGER 4
293 TRANSACTION_RECEIPT_DATE_R13_MONTH_TYPE_ID INTEGER 4
294 TRANSACTION_RECEIPT_DATE_HALF_TYPE_ID INTEGER 4
295 EXPOSURE_LITIGATION_FLAG_ID INTEGER 4
296 EXPOSURE_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
297 EXPOSURE_CLAIMANT_TYPE_ID BIGINT 8
298 EXPOSURE_CLAIMANT_TYPE_NAME CHARACTER VARYING(256) 256
299 EXPOSURE_INCIDENT_ID BIGINT 8
300 POLICY_NUMBER CHARACTER VARYING(40) 40
301 VERIFIED_POLICY_FLAG INTEGER 4
302 VERIFIED_POLICY CHARACTER VARYING(256) 256
303 EXPOSURE_SEGMENT_ID BIGINT 8
304 EXPOSURE_SEGMENT CHARACTER VARYING(256) 256
305 EXPOSURE_DECISION_ID BIGINT 8
306 EXPOSURE_DECISION CHARACTER VARYING(256) 256
307 EXPOSURE_INCIDENT_LOSS_CAUSE_ID BIGINT 8
308 EXPOSURE_INCIDENT_LOSS_CAUSE CHARACTER VARYING(256) 256
309 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
310 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
311 VERIFIED_POLICY_STATUS_ID INTEGER 4
312 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
313 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
314 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
315 POLICY_INTERMEDIARY_ID BIGINT 8
316 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
317 EXPOSURE_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
318 EXPOSURE_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
319 EXPOSURE_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
320 EXPOSURE_LOSS_ADJUSTER_FLAG_ID INTEGER 4
321 EXPOSURE_LOSS_ADJUSTER_FLAG_NAME CHARACTER VARYING(256) 256
322 EXPOSURE_GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
323 EXPOSURE_GROSS_RECOVERED_NAME CHARACTER VARYING(15) 15
324 EXPOSURE_NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
325 EXPOSURE_NET_RECOVERED_NAME CHARACTER VARYING(15) 15
326 EXPOSURE_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
327 EXPOSURE_GROSS_PAID_NAME CHARACTER VARYING(15) 15
328 EXPOSURE_GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
329 EXPOSURE_GROSS_INCURRED_NAME CHARACTER VARYING(15) 15
330 EXPOSURE_NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
331 EXPOSURE_NET_INCURRED_NAME CHARACTER VARYING(15) 15