FCT_FLEET_CLAIMS_SUMMARY
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CLAIM_ID | BIGINT | 8 |
| 2 | CLAIMNUMBER | CHARACTER VARYING(40) | 40 |
| 3 | FLAG | INTEGER | 4 |
| 4 | CLIENT_NAME | CHARACTER VARYING(180) | 180 |
| 5 | DATE_KEY | INTEGER | 4 |
| 6 | MONTH_LABEL | CHARACTER VARYING(13) | 13 |
| 7 | CALENDAR_DATE | DATE | 4 |
| 8 | LOSS_ID | BIGINT | 8 |
| 9 | LOSS_TYPE | CHARACTER VARYING(256) | 256 |
| 10 | BLAME_CODES_ID | BIGINT | 8 |
| 11 | BLAME_CODES | CHARACTER VARYING(256) | 256 |
| 12 | FLEET_DIVISION | CHARACTER VARYING(60) | 60 |
| 13 | REPORT_ONLY | INTEGER | 4 |
| 14 | STATUS_ID | INTEGER | 4 |
| 15 | NEW_COUNT | INTEGER | 4 |
| 16 | ACTIVE_COUNT | INTEGER | 4 |
| 17 | REOPEN_COUNT_TM | INTEGER | 4 |
| 18 | REOPEN_COUNT_EVER | INTEGER | 4 |
| 19 | FINALISED_COUNT | INTEGER | 4 |
| 20 | FINALISED_COUNT_WITHIN_90DAYS | INTEGER | 4 |
| 21 | FULFILLMENT_TYPE | CHARACTER VARYING(11) | 11 |
| 22 | LOSS_DATE | DATE | 4 |
| 23 | REPORTED_DATE | DATE | 4 |
| 24 | CLOSED_DATE | DATE | 4 |
| 25 | BRAND_ID | BIGINT | 8 |
| 26 | BRAND | CHARACTER VARYING(256) | 256 |
| 27 | BROKER_NAME | CHARACTER VARYING(120) | 120 |
| 28 | ASSIGNED_TEAM_NAME | CHARACTER VARYING(100) | 100 |
| 29 | ASSIGNED_USERID | CHARACTER VARYING(255) | 255 |
| 30 | ASSIGNED_TO_USERNAME | CHARACTER VARYING(181) | 181 |
| 31 | CLOSED_BY_USERID | CHARACTER VARYING(255) | 255 |
| 32 | CLOSED_BY_USERNAME | CHARACTER VARYING(181) | 181 |
| 33 | CREATED_BY_USERID | CHARACTER VARYING(255) | 255 |
| 34 | CREATED_BY_USERNAME | CHARACTER VARYING(181) | 181 |
| 35 | POLICY_NUMBER | CHARACTER VARYING(40) | 40 |
| 36 | AGEING_DAYS | INTEGER | 4 |
| 37 | AGEING_ACTIVE_DAYS | INTEGER | 4 |
| 38 | AGEING_FINALIZED_DAYS | INTEGER | 4 |
| 39 | INCURRED_AMOUNT | NUMERIC(38,2) | 19 |
| 40 | RECOVERY_AMOUNT | NUMERIC(38,2) | 19 |
| 41 | UNDER_DEDUCTIBLE_FLAG | CHARACTER VARYING(7) | 7 |