FCT_FLEET_ASSESSMENT_REPAIR
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CLAIM_ID | BIGINT | 8 |
| 2 | CLAIMNUMBER | CHARACTER VARYING(40) | 40 |
| 3 | DATE_KEY | INTEGER | 4 |
| 4 | MONTH_LABEL | CHARACTER VARYING(13) | 13 |
| 5 | CALENDAR_DATE | DATE | 4 |
| 6 | FLAG | INTEGER | 4 |
| 7 | CLIENT_NAME | CHARACTER VARYING(180) | 180 |
| 8 | VEH_REG | CHARACTER VARYING(40) | 40 |
| 9 | VEH_YEAR | BIGINT | 8 |
| 10 | VEH_MAKE | CHARACTER VARYING(60) | 60 |
| 11 | VEH_MODEL | CHARACTER VARYING(80) | 80 |
| 12 | DRIVER_LASTNAME | CHARACTER VARYING(90) | 90 |
| 13 | DRIVER_FIRSTNAME | CHARACTER VARYING(90) | 90 |
| 14 | FLEET_DIVISION | CHARACTER VARYING(60) | 60 |
| 15 | LOSS_CAUSE_ID | BIGINT | 8 |
| 16 | LOSS_CAUSE | CHARACTER VARYING(256) | 256 |
| 17 | BLAME_CODES_ID | BIGINT | 8 |
| 18 | BLAME_CODES | CHARACTER VARYING(256) | 256 |
| 19 | STATUS_ID | INTEGER | 4 |
| 20 | NEW_COUNT | INTEGER | 4 |
| 21 | ACTIVE_COUNT | INTEGER | 4 |
| 22 | REOPEN_COUNT_TM | INTEGER | 4 |
| 23 | REOPEN_COUNT_EVER | INTEGER | 4 |
| 24 | FINALISED_COUNT | INTEGER | 4 |
| 25 | SMART_NEW_COUNT | INTEGER | 4 |
| 26 | SMART_ACTIVE_COUNT | INTEGER | 4 |
| 27 | SMART_FINALIZED_COUNT | INTEGER | 4 |
| 28 | NEW_TOTAL_LOSS_COUNT | INTEGER | 4 |
| 29 | ACTIVE_TOTAL_LOSS_COUNT | INTEGER | 4 |
| 30 | FINALISED_TOTAL_LOSS_COUNT | INTEGER | 4 |
| 31 | FULFILLMENT_TYPE | CHARACTER VARYING(11) | 11 |
| 32 | LOSS_DATE | DATE | 4 |
| 33 | REPORTED_DATE | DATE | 4 |
| 34 | CLOSED_DATE | DATE | 4 |
| 35 | BRAND_ID | BIGINT | 8 |
| 36 | BRAND | CHARACTER VARYING(256) | 256 |
| 37 | BROKER_NAME | CHARACTER VARYING(120) | 120 |
| 38 | ASSIGNED_TEAM_NAME | CHARACTER VARYING(100) | 100 |
| 39 | ASSIGNED_USERID | CHARACTER VARYING(255) | 255 |
| 40 | ASSIGNED_TO_USERNAME | CHARACTER VARYING(181) | 181 |
| 41 | CLOSED_BY_USERID | CHARACTER VARYING(255) | 255 |
| 42 | CLOSED_BY_USERNAME | CHARACTER VARYING(181) | 181 |
| 43 | CREATED_BY_USERID | CHARACTER VARYING(255) | 255 |
| 44 | CREATED_BY_USERNAME | CHARACTER VARYING(181) | 181 |
| 45 | POLICY_NUMBER | CHARACTER VARYING(40) | 40 |
| 46 | AGEING_DAYS | INTEGER | 4 |
| 47 | ASSESSMENT_TYPE | CHARACTER VARYING(512) | 512 |
| 48 | ASSESSMENT_PROCESS_TYPE | CHARACTER VARYING(512) | 512 |
| 49 | TOTALLOSS_FINALIZED_TIMEFRAME | INTERVAL | 12 |
| 50 | SMART_REPAIR_TIMEFRAME | INTERVAL | 12 |
| 51 | TOTALLOSS_INSURED_COST | NUMERIC(38,2) | 19 |
| 52 | INSURED_REPAIRCOST | NUMERIC(38,2) | 19 |
| 53 | THIRDPARTY_REPAIRCOST | NUMERIC(38,2) | 19 |
| 54 | UNDER_DEDUCTIBLE_FLAG | CHARACTER VARYING(7) | 7 |