INT_PI_EXPOSURE_FINANCIALS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CLAIM_ID | BIGINT | 8 |
| 2 | EXPOSURE_ID | BIGINT | 8 |
| 3 | ACTIVATION_DATE | TIMESTAMP | 8 |
| 4 | FIRST_DAY_NET_INCURRED | NUMERIC(18,2) | 19 |
| 5 | GROSS_INCURRED | NUMERIC(18,2) | 19 |
| 6 | GROSS_INCURRED_EX_GST | NUMERIC(18,2) | 19 |
| 7 | NET_INCURRED_EX_GST | NUMERIC(18,2) | 19 |
| 8 | OPEN_RECOVERY_RESERVES | NUMERIC(18,2) | 19 |
| 9 | OPEN_RECOVERY_RESERVES_EX_GST | NUMERIC(18,2) | 19 |
| 10 | OPEN_RESERVES | NUMERIC(18,2) | 19 |
| 11 | OPEN_RESERVES_EX_GST | NUMERIC(18,2) | 19 |
| 12 | PAYMENT_GST | NUMERIC(18,2) | 19 |
| 13 | RECOVERY_GST | NUMERIC(18,2) | 19 |
| 14 | SYSTEM_COST | NUMERIC(18,2) | 19 |
| 15 | TOTAL_NON_ERODING_PAYMENTS | NUMERIC(18,2) | 19 |
| 16 | TOTAL_PAYMENTS | NUMERIC(18,2) | 19 |
| 17 | TOTAL_PAYMENTS_EX_GST | NUMERIC(18,2) | 19 |
| 18 | TOTAL_RECOVERIES_EX_GST | NUMERIC(18,2) | 19 |
| 19 | TOTAL_RECOVERY_RESERVES | NUMERIC(18,2) | 19 |
| 20 | TOTAL_RESERVES | NUMERIC(18,2) | 19 |