FCT_PI_HOME_PROPERTY_SERVICES_SUMMARY_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REPORT_DATE | TIMESTAMP | 8 |
| 2 | REPORT_DATE_FYQTR | CHARACTER VARYING(10) | 10 |
| 3 | REPORT_GROUP | CHARACTER VARYING(60) | 60 |
| 4 | CLAIM_ID | BIGINT | 8 |
| 5 | CLAIM_NUMBER | CHARACTER VARYING(40) | 40 |
| 6 | JOB_ID | BIGINT | 8 |
| 7 | QUOTE_NUMBER | CHARACTER VARYING(20) | 20 |
| 8 | VENDOR_NAME | CHARACTER VARYING(255) | 255 |
| 9 | BRAND | CHARACTER VARYING(256) | 256 |
| 10 | LOSS_GROUP | CHARACTER VARYING(15) | 15 |
| 11 | EVENT_NAME | CHARACTER VARYING(256) | 256 |
| 12 | SUBLOSS_GROUP | CHARACTER VARYING(18) | 18 |
| 13 | OPERATIONAL_LOB | CHARACTER VARYING(16) | 16 |
| 14 | RISK_STATE | CHARACTER VARYING(256) | 256 |
| 15 | RISK_POSTCODE | CHARACTER VARYING(60) | 60 |
| 16 | RISK_ZONE_NAME | CHARACTER VARYING(255) | 255 |
| 17 | JOB_FULFILLMENT_PATH | CHARACTER VARYING(256) | 256 |
| 18 | LOSS_CAUSE | CHARACTER VARYING(256) | 256 |
| 19 | CLAIM_TYPE | CHARACTER VARYING(256) | 256 |
| 20 | JOB_MAKESAFE_FLAG | CHARACTER VARYING(3) | 3 |
| 21 | PANEL_FLAG | CHARACTER VARYING(3) | 3 |
| 22 | ASBESTOS_FLAG | CHARACTER VARYING(256) | 256 |
| 23 | MOULD_FLAG | CHARACTER VARYING(256) | 256 |
| 24 | TEMP_ACCOMMODATION_FLAG | CHARACTER VARYING(256) | 256 |
| 25 | JOB_RECTIFICATION_FLAG | CHARACTER VARYING(3) | 3 |
| 26 | JOB_SIZE | CHARACTER VARYING(40) | 40 |
| 27 | JOB_EXPOSURE_TYPE | CHARACTER VARYING(256) | 256 |
| 28 | VENDOR_CATEGORY | CHARACTER VARYING(10) | 10 |
| 29 | ASSESSMENT_TYPE | CHARACTER VARYING(256) | 256 |
| 30 | STATUS_GROUP | CHARACTER VARYING(256) | 256 |
| 31 | JOB_STATUS | CHARACTER VARYING(256) | 256 |
| 32 | JOB_TYPE | CHARACTER VARYING(256) | 256 |
| 33 | JOB_COST_BANDING_1 | CHARACTER VARYING(40) | 40 |
| 34 | JOB_COST_BANDING_2 | CHARACTER VARYING(40) | 40 |
| 35 | JOB_COST_BANDING_3 | CHARACTER VARYING(40) | 40 |
| 36 | JOB_LIFE_BANDING | CHARACTER VARYING(20) | 20 |
| 37 | MAX_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 38 | ORIGINAL_VENDOR_NAME | CHARACTER VARYING(181) | 181 |
| 39 | REPAIR_COST | NUMERIC(18,2) | 19 |
| 40 | REPAIR_COST_VOLUME | NUMERIC(18,2) | 19 |
| 41 | REPAIR_LIFE | NUMERIC(18,2) | 19 |
| 42 | REPAIR_LIFE_VOLUME | NUMERIC(18,2) | 19 |
| 43 | ASSESS_REPORT_LIFE | NUMERIC(18,2) | 19 |
| 44 | ASSESS_REPORT_LIFE_VOLUME | NUMERIC(18,2) | 19 |
| 45 | QUOTE_LIFE | NUMERIC(18,2) | 19 |
| 46 | QUOTE_LIFE_VOLUME | NUMERIC(18,2) | 19 |
| 47 | RECOVERY_REPAIR_COST | NUMERIC(18,2) | 19 |
| 48 | RECOVERY_COST_VOLUME | SMALLINT | 2 |
| 49 | MANAGEMENT_COST | NUMERIC(18,2) | 19 |
| 50 | MANAGEMENT_COST_VOLUME | SMALLINT | 2 |
| 51 | JOB_PAYMENT_APPLICATION | CHARACTER VARYING(256) | 256 |