FCT_PI_HOME_JOB_FINANCIALS_DETAIL_INSIGHT
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CCR_CC_TRANSACTION_ID | BIGINT | 8 |
| 2 | JOB_ID | BIGINT | 8 |
| 3 | CLAIM_ID | BIGINT | 8 |
| 4 | TRANSACTION_MONTH | TIMESTAMP | 8 |
| 5 | CLOSE_DATE | DATE | 4 |
| 6 | MAX_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 7 | LOSS_GROUP | CHARACTER VARYING(15) | 15 |
| 8 | SUBLOSS_GROUP | CHARACTER VARYING(18) | 18 |
| 9 | GROUPED_LOSS_CAUSE | CHARACTER VARYING(40) | 40 |
| 10 | LOSS_CAUSE | CHARACTER VARYING(256) | 256 |
| 11 | BRAND | CHARACTER VARYING(256) | 256 |
| 12 | LOB | CHARACTER VARYING(16) | 16 |
| 13 | RISK_STATE | CHARACTER VARYING(256) | 256 |
| 14 | GIC_BANDING | CHARACTER VARYING(12) | 12 |
| 15 | EXPOSURE_BANDING | CHARACTER VARYING(15) | 15 |
| 16 | JOB_CATEGORY | CHARACTER VARYING(256) | 256 |
| 17 | CCR_CCTL_COSTCATEGORY_NAME | CHARACTER VARYING(256) | 256 |
| 18 | CCR_CCTL_TRANSACTION_NAME | CHARACTER VARYING(256) | 256 |
| 19 | FIRST_PAYMENT_MONTH | TIMESTAMP | 8 |
| 20 | TOTAL_PAYMENTS_EX_GST | NUMERIC(38,2) | 19 |
| 21 | TOTAL_RESERVES_EX_GST | NUMERIC(38,6) | 19 |
| 22 | GROSS_INCURRED_EX_GST | NUMERIC(38,6) | 19 |