INT_PI_HOME_REPAIRER_JOB_METRIC

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 METRIC_GROUP SMALLINT 2
2 METRIC_GROUP_NAME CHARACTER VARYING(28) 28
3 REPORT_DATE_YYYYMM INTEGER 4
4 REPORT_DATE DATE 4
5 JOB_APPROVED_DATE DATE 4
6 JOB_AUTHISSUED_DATE DATE 4
7 JOB_AUTHORISED_AMOUNT NUMERIC(18,2) 19
8 JOB_CREATE_DATE DATE 4
9 JOB_ID BIGINT 8
10 JOB_TOTAL_ESTIMATE NUMERIC(18,2) 19
11 CASH_SETTLE_LIABILITY CHARACTER VARYING(256) 256
12 CCR_CCX_SC_JOB_EXPOSUREID BIGINT 8
13 CCR_CCX_SC_JOB_SC_QUOTETYPE BIGINT 8
14 CLAIM_ID BIGINT 8
15 JOB_FULFILMENT_PATH CHARACTER VARYING(256) 256
16 JOB_PAYMENT_APPLICATION CHARACTER VARYING(256) 256
17 JOB_STATUS CHARACTER VARYING(256) 256
18 QUOTE_AMOUNT NUMERIC(18,2) 19
19 JOB_MAKESAFE_FLAG CHARACTER VARYING(3) 3
20 JOB_RECTIFICATION_FLAG CHARACTER VARYING(3) 3
21 CHECK_ISSUED_DATE DATE 4
22 FIRST_AUTHORITY_REQUESTED_DATE DATE 4
23 FIRST_JOB_REPORT_SUBMIT_DATE DATE 4
24 FIRST_JOB_REQUEST_SUBMIT_DATE DATE 4
25 INVOICE_RECEIVED_DATE DATE 4
26 JOB_GROSS_AMOUNT NUMERIC(18,2) 19
27 JOB_SC_EXCESS NUMERIC(18,2) 19
28 JOB_SC_EXCESSGST NUMERIC(18,2) 19
29 JOB_SC_GSTAMOUNT NUMERIC(18,2) 19
30 JOB_TRANSACTIONAMOUNT NUMERIC(18,2) 19
31 JOB_SCHEDULED_SEND_DATE TIMESTAMP 8
32 CONTACT_ID BIGINT 8
33 REPAIR_LIFE_DAYS INTEGER 4
34 REPAIR_LIFE_FLAG SMALLINT 2
35 REPAIR_COST NUMERIC(18,2) 19
36 REPAIR_COST_FLAG SMALLINT 2
37 JOB_ASSESS_REPORT_REQUESTED INTEGER 4
38 JOB_ASSESS_REPORT_PENDING INTEGER 4
39 JOB_ASSESS_REPORT_AUTHORISED INTEGER 4
40 JOB_ASSESS_REPORT_CASH_SETTLE INTEGER 4
41 JOB_ASSESS_REPORT_OUTSTANDING INTEGER 4
42 JOB_ASSESS_REPORT_COMPLETE INTEGER 4
43 JOB_QUOTES_REQUESTED INTEGER 4
44 JOB_QUOTES_PENDING INTEGER 4
45 JOB_QUOTES_AUTHORISED INTEGER 4
46 JOB_QUOTES_CASH_SETTLED INTEGER 4
47 JOB_QUOTES_COMPLETE INTEGER 4
48 JOB_DO_AND_CHARGE_AUTHORISED INTEGER 4
49 JOB_DO_AND_CHARGE_OUTSTANDING INTEGER 4
50 JOB_DO_AND_CHARGE_COMPLETE INTEGER 4
51 JOB_MAKESAFE_ALLOCATIONS INTEGER 4
52 JOB_MAKESAFE_OUTSTANDING INTEGER 4
53 JOB_MAKESAFE_COMPLETE INTEGER 4
54 ASSESSMENT_LIFE_DAYS INTEGER 4
55 ASSESSMENT_LIFE_FLAG SMALLINT 2
56 CASH_SETTLEMENT_COST NUMERIC(18,2) 19
57 CASH_SETTLEMENT_COST_FLAG SMALLINT 2
58 COMBINED_COST NUMERIC(18,2) 19
59 COMBINED_COST_BANDING NUMERIC(18,2) 19
60 COMBINED_COST_FLAG SMALLINT 2