INT_PI_MOTOR_PATHING_SCORING_DIMENSION_RANGE_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPAIRER_NAME CHARACTER VARYING(120) 120
2 ABCONTACT_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
3 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1
4 ABCONTACT_REPAIRER_REPAIRER_PROFILE_1 CHARACTER VARYING(25) 25
5 INCIDENT_ID BIGINT 8
6 CLAIM_NUMBER CHARACTER VARYING(40) 40
7 REPAIRER_STATE CHARACTER VARYING(256) 256
8 MAX_INVOICE_DATE_COST DATE 4
9 MAX_REPAIR_AUTHORISED_DATE_CUSTOMER_SERVICE DATE 4
10 MAX_REPAIR_AUTHORISED_DATE DATE 4
11 MAX_INVOICE_DATE DATE 4
12 MAX_BOOKING_DATE TIMESTAMP 8
13 MAX_PNETQUOTE_SUBMITTED_TIME TIMESTAMP 8
14 MAX_REPAIR_AUTHORISED_DATE_AS_DATE DATE 4
15 MAX_INVOICE_DATE_AS_DATE DATE 4
16 MAX_BOOKING_DATE_AS_DATE DATE 4
17 MAX_PNETQUOTE_SUBMITTED_TIME_AS_DATE DATE 4
18 SUM_ASSESSED_REPAIR_COST NUMERIC(38,2) 19
19 SUM_PNETQUOTEINVOICE_AMOUNTEXCLUDINGGST NUMERIC(38,2) 19
20 MAX_ECD_CHANGES INTEGER 4
21 SUM_ALTERNATE_ASSESSED_PARTS_COST NUMERIC(38,2) 19
22 SUM_ASSESSED_PARTS_COST NUMERIC(38,2) 19