FCT_PI_HOME_REPAIRER_PERFORMANCE_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 VENDOR_NAME CHARACTER VARYING(181) 181
2 QUOTE_VENDOR_NAME CHARACTER VARYING(181) 181
3 PANEL_FLAG SMALLINT 2
4 METRIC_GROUP SMALLINT 2
5 METRIC_GROUP_NAME CHARACTER VARYING(28) 28
6 REPORT_DATE_YYYYMM INTEGER 4
7 REPORT_DATE TIMESTAMP 8
8 BRAND_NAME CHARACTER VARYING(256) 256
9 CLAIM_ID BIGINT 8
10 CLAIM_NUMBER CHARACTER VARYING(40) 40
11 CLAIM_STATE CHARACTER VARYING(256) 256
12 CLAIM_TYPE CHARACTER VARYING(256) 256
13 CLAIM_LOSS_DATE DATE 4
14 JOB_APPROVED_DATE DATE 4
15 JOB_AUTHISSUED_DATE DATE 4
16 JOB_AUTHORISED_AMOUNT NUMERIC(18,2) 19
17 JOB_CREATE_DATE DATE 4
18 JOB_ID BIGINT 8
19 JOB_TOTAL_ESTIMATE NUMERIC(18,2) 19
20 LOSS_GROUP CHARACTER VARYING(15) 15
21 OPERATIONAL_LOB CHARACTER VARYING(16) 16
22 QUOTE_CREATE_DATE DATE 4
23 QUOTE_ID BIGINT 8
24 QUOTE_NUMBER CHARACTER VARYING(20) 20
25 RISK_REGION CHARACTER VARYING(8) 8
26 RISK_STATE CHARACTER VARYING(256) 256
27 SUBLOSS_GROUP CHARACTER VARYING(18) 18
28 VENDOR_ID CHARACTER VARYING(10) 10
29 CASH_SETTLE_LIABILITY CHARACTER VARYING(256) 256
30 JOB_FULFILMENT_PATH CHARACTER VARYING(256) 256
31 JOB_PAYMENT_APPLICATION CHARACTER VARYING(256) 256
32 JOB_QUOTE_TYPE CHARACTER VARYING(256) 256
33 JOB_STATUS CHARACTER VARYING(256) 256
34 QUOTE_AMOUNT NUMERIC(18,2) 19
35 QUOTE_REJECT_REASON_TYPE CHARACTER VARYING(256) 256
36 CHECK_ISSUED_DATE DATE 4
37 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(3) 3
38 FIRST_AUTHORITY_REQUESTED_DATE DATE 4
39 FIRST_JOB_REQUEST_SUBMIT_DATE DATE 4
40 FIRST_JOB_REPORT_SUBMIT_DATE DATE 4
41 FIRST_QUOTE_RECEIVED_DATE DATE 4
42 FIRST_QUOTE_REQUESTED_DATE DATE 4
43 INVOICE_RECEIVED_DATE DATE 4
44 JOB_MAKESAFE_FLAG CHARACTER VARYING(3) 3
45 JOB_RECTIFICATION_FLAG CHARACTER VARYING(3) 3
46 JOB_GROSS_AMOUNT NUMERIC(18,2) 19
47 JOB_SC_EXCESS NUMERIC(18,2) 19
48 JOB_SC_EXCESSGST NUMERIC(18,2) 19
49 JOB_SC_GSTAMOUNT NUMERIC(18,2) 19
50 JOB_TRANSACTIONAMOUNT NUMERIC(18,2) 19
51 JOB_SCHEDULED_SEND_DATE TIMESTAMP 8
52 QUOTE_STATUS CHARACTER VARYING(256) 256
53 RISK_POSTCODE CHARACTER VARYING(60) 60
54 REPAIR_LIFE_DAYS INTEGER 4
55 REPAIR_LIFE_FLAG SMALLINT 2
56 QUOTE_LIFE_DAYS INTEGER 4
57 QUOTE_LIFE_FLAG SMALLINT 2
58 REPAIR_COST NUMERIC(18,2) 19
59 REPAIR_COST_FLAG SMALLINT 2
60 WIN_CASH_SETTLE INTEGER 4
61 WIN_REPAIR INTEGER 4
62 REPAIR_LOSE_TOTAL INTEGER 4
63 WIN_LOSE_DEFINED_FLAG SMALLINT 2
64 WIN_LOSE_UNDEFINED_FLAG SMALLINT 2
65 JOB_ASSESS_REPORT_REQUESTED INTEGER 4
66 JOB_ASSESS_REPORT_PENDING INTEGER 4
67 JOB_ASSESS_REPORT_AUTHORISED INTEGER 4
68 JOB_ASSESS_REPORT_CASH_SETTLE INTEGER 4
69 JOB_ASSESS_REPORT_OUTSTANDING INTEGER 4
70 JOB_ASSESS_REPORT_COMPLETE INTEGER 4
71 JOB_QUOTES_REQUESTED INTEGER 4
72 JOB_QUOTES_PENDING INTEGER 4
73 JOB_QUOTES_AUTHORISED INTEGER 4
74 JOB_QUOTES_CASH_SETTLED INTEGER 4
75 JOB_QUOTES_COMPLETE INTEGER 4
76 JOB_DO_AND_CHARGE_AUTHORISED INTEGER 4
77 JOB_DO_AND_CHARGE_OUTSTANDING INTEGER 4
78 JOB_DO_AND_CHARGE_COMPLETE INTEGER 4
79 JOB_MAKESAFE_ALLOCATIONS INTEGER 4
80 JOB_MAKESAFE_OUTSTANDING INTEGER 4
81 JOB_MAKESAFE_COMPLETE INTEGER 4
82 ASSESSMENT_LIFE_DAYS INTEGER 4
83 ASSESSMENT_LIFE_FLAG SMALLINT 2
84 CASH_SETTLEMENT_COST NUMERIC(18,2) 19
85 CASH_SETTLEMENT_COST_FLAG SMALLINT 2
86 COMBINED_COST NUMERIC(18,2) 19
87 COMBINED_COST_BANDING NUMERIC(18,2) 19
88 COMBINED_COST_FLAG SMALLINT 2
89 CSI_REPAIR_QUALITY_MEAN NUMERIC(8,2) 19
90 CSI_REPAIR_QUALITY_SAMPLE NUMERIC(8,2) 19
91 CSI_REPAIR_QUALITY_BASE_SCORE NUMERIC(8,2) 19
92 CSI_REPAIR_SERVICE_MEAN NUMERIC(8,2) 19
93 CSI_REPAIR_SERVICE_SAMPLE NUMERIC(8,2) 19
94 CSI_REPAIR_SERVICE_BASE_SCORE NUMERIC(8,2) 19
95 CSI_TIMELINESS NUMERIC(8,2) 19
96 ADJUSTED_ITEM NUMERIC(8,2) 19
97 EVENT_NAME CHARACTER VARYING(256) 256