FCT_PI_HOME_CLAIM_COST_DRIVER_INSIGHT_TWB
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REPORT_DATE | TIMESTAMP | 8 |
| 2 | REPORT_GROUP | CHARACTER VARYING(60) | 60 |
| 3 | LOSS_GROUP | CHARACTER VARYING(15) | 15 |
| 4 | SUBLOSS_GROUP | CHARACTER VARYING(18) | 18 |
| 5 | RISK_REGION | CHARACTER VARYING(256) | 256 |
| 6 | RISK_STATE_NAME | CHARACTER VARYING(256) | 256 |
| 7 | RISK_POSTCODE | CHARACTER VARYING(60) | 60 |
| 8 | MAX_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 9 | CLAIM_TYPE | CHARACTER VARYING(256) | 256 |
| 10 | ADJUSTER_TEAM | CHARACTER VARYING(256) | 256 |
| 11 | BRAND | CHARACTER VARYING(256) | 256 |
| 12 | LOSS_LIMIT_BANDING | CHARACTER VARYING(256) | 256 |
| 13 | LOSSCAUSE_NAME | CHARACTER VARYING(256) | 256 |
| 14 | CLAIM_AGE_BAND | CHARACTER VARYING(256) | 256 |
| 15 | TOTAL_FINALISED_COST | NUMERIC(38,2) | 19 |
| 16 | CLAIM_VOLUME | NUMERIC(20,2) | 19 |
| 17 | CURRENT_OUTSTANDING_ESTIMATES_EX_GST | NUMERIC(38,2) | 19 |
| 18 | PCP_OUTSTANDING_ESTIMATES_EX_GST | NUMERIC(38,2) | 19 |