FCT_PI_HOME_FULFILLMENT_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 JOB_ID BIGINT 8
2 CLAIM_ID BIGINT 8
3 BRAND_NAME CHARACTER VARYING(256) 256
4 CLAIM_LOSS_DATE DATE 4
5 CLAIM_NUMBER CHARACTER VARYING(40) 40
6 CLAIM_STATE CHARACTER VARYING(256) 256
7 LOSS_GROUP CHARACTER VARYING(15) 15
8 OPERATIONAL_LOB CHARACTER VARYING(16) 16
9 RISK_REGION CHARACTER VARYING(8) 8
10 RISK_POSTCODE CHARACTER VARYING(60) 60
11 RISK_ZONE_NAME CHARACTER VARYING(255) 255
12 LOSS_STATE CHARACTER VARYING(256) 256
13 SUBLOSS_GROUP CHARACTER VARYING(18) 18
14 JOB_CREATE_DATE DATE 4
15 AUTHORITY_ISSUED_DATE TIMESTAMP 8
16 FIRST_INVOICE_RECEIVED_DATE DATE 4
17 PAYMENT_SERVICE_VENDOR_ID CHARACTER VARYING(10) 10
18 CASH_SETTLE_LIABILITY CHARACTER VARYING(256) 256
19 CATEGORY_TYPE CHARACTER VARYING(256) 256
20 VENDOR_CATEGORY CHARACTER VARYING(10) 10
21 CATEGORY_TYPE_GROUP CHARACTER VARYING(40) 40
22 CATEGORY_SUB_TYPE CHARACTER VARYING(40) 40
23 CLAIM_TYPE CHARACTER VARYING(256) 256
24 EXPOSURE_TYPE CHARACTER VARYING(256) 256
25 JOB_EXPOSURE_TYPE CHARACTER VARYING(256) 256
26 JOB_FULFILLMENT_PATH CHARACTER VARYING(256) 256
27 JOB_PAYMENT_APPLICATION CHARACTER VARYING(256) 256
28 JOB_STATUS CHARACTER VARYING(256) 256
29 ASSESS_REPORT_TYPE CHARACTER VARYING(256) 256
30 JOB_STATUS_GROUP CHARACTER VARYING(11) 11
31 JOB_STATUS_EXCEPTION_CATEGORY CHARACTER VARYING(256) 256
32 STATUS_GROUP CHARACTER VARYING(11) 11
33 CHECK_ISSUED_DATE DATE 4
34 FIRST_AUTHORITY_REQUESTED_DATE DATE 4
35 FIRST_REPORT_SUBMIT_DATE DATE 4
36 FIRST_REPORT_REQUEST_DATE DATE 4
37 INVOICE_RECEIVED_DATE DATE 4
38 JOB_GROSS_AMOUNT NUMERIC(38,2) 19
39 JOB_MAKESAFE_FLAG CHARACTER VARYING(3) 3
40 JOB_RECTIFICATION_FLAG CHARACTER VARYING(3) 3
41 JOB_FULFILLMENT_TYPE CHARACTER VARYING(256) 256
42 JOB_LIFE SMALLINT 2
43 JOB_AGE SMALLINT 2
44 JOB_LIFE_FLAG SMALLINT 2
45 CHECK_ISSUED_DATE_FOR_REPAIR_COST DATE 4
46 SCORECARD_REPAIR_COST NUMERIC(18,2) 19
47 SCORECARD_REPAIR_COST_FLAG SMALLINT 2
48 EVENT_NAME CHARACTER VARYING(256) 256
49 DAMAGE_CATEGORY CHARACTER VARYING(256) 256
50 VENDOR CHARACTER VARYING(181) 181
51 VENDOR_NAME_ON_JOB CHARACTER VARYING(180) 180
52 PANEL_FLAG CHARACTER VARYING(3) 3
53 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
54 NET_INCURRED_EX_GST_PROPERTY_DAMAGE NUMERIC(38,2) 19
55 SYSTEM_COST_PROPERTY_DAMAGE NUMERIC(38,2) 19
56 NET_INCURRED_EX_GST_PROPERTY_DAMAGE_BAND CHARACTER VARYING(40) 40
57 JOB_APPROVED_DATE DATE 4
58 LOSS_CAUSE CHARACTER VARYING(256) 256
59 JOB_SIZE CHARACTER VARYING(40) 40
60 JOB_ESTIMATE_WLT NUMERIC(23,6) 19
61 JOB_SIZE_WLT CHARACTER VARYING(40) 40
62 JOB_LIFE_BANDING CHARACTER VARYING(20) 20
63 BUILDING_INDICATOR SMALLINT 2
64 ASSESS_REPORT_LIFE SMALLINT 2
65 ASSESS_REPORT_LIFE_FLAG SMALLINT 2
66 ASBESTOS_FLAG CHARACTER VARYING(256) 256
67 MOULD_FLAG CHARACTER VARYING(256) 256
68 TEMP_ACCOMMODATION_FLAG CHARACTER VARYING(256) 256
69 JOB_COST_BANDING_1 CHARACTER VARYING(20) 20
70 JOB_COST_BANDING_2 CHARACTER VARYING(20) 20
71 JOB_COST_BANDING_3 CHARACTER VARYING(20) 20
72 JOB_UPDATE_DATE DATE 4
73 ORIGINAL_VENDOR_NAME CHARACTER VARYING(181) 181
74 RECTIFICATION_REPAIR_COST_FLAG SMALLINT 2
75 RECTIFICATION_RECOVERY_COST_FLAG SMALLINT 2
76 RECTIFICATION_JOB_LIFE SMALLINT 2
77 RECTIFICATION_JOB_LIFE_FLAG SMALLINT 2
78 CHECK_ISSUED_DATE_FOR_MANAGEMENT_COST DATE 4
79 CLAIM_CHECK_COST NUMERIC(18,2) 19
80 VOLUME_OF_TRANSACTION_IDS BIGINT 8
81 MANAGEMENT_COST_FLAG SMALLINT 2
82 SPECIALIST_PANEL_FLAG CHARACTER VARYING(3) 3
83 CASH_SETTLEMENT_COST NUMERIC(18,2) 19
84 CASH_SETTLEMENT_COST_FLAG SMALLINT 2
85 CASHSETTLEMENT_EST_PROVIDER CHARACTER VARYING(181) 181
86 CASHSETTLEMENT_EST_PROVIDER_PANEL_FLAG CHARACTER VARYING(3) 3
87 CUMM_GIC NUMERIC(38,6) 19