FCT_PI_MOTOR_MBA_SUMMARY_REPAIRER_COST_INSIGHT_DRILLTHRU_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 YEAR_NUMBER BIGINT 8
2 MONTH_NUMBER BIGINT 8
3 WEEK_NUMBER BIGINT 8
4 MEASURE CHARACTER VARYING(32) 32
5 REPORT_DATE DATE 4
6 REPORT_DATE_DESCRIPTION CHARACTER VARYING(32) 32
7 REPORT_DATE_WK DATE 4
8 REPORT_GROUP CHARACTER VARYING(256) 256
9 REPORT_GROUP3 CHARACTER VARYING(128) 128
10 REPORT_GROUP6 CHARACTER VARYING(128) 128
11 CLAIM_NUMBER CHARACTER VARYING(40) 40
12 INCIDENT_ID BIGINT 8
13 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
14 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
15 VEHICLE_YEAR BIGINT 8
16 VEHICLE_MAKE CHARACTER VARYING(60) 60
17 VEHICLE_MODEL CHARACTER VARYING(80) 80
18 LOSS_CAUSE CHARACTER VARYING(256) 256
19 LOSS_GROUP CHARACTER VARYING(15) 15
20 REPAIRER CHARACTER VARYING(256) 256
21 ASSESSED_STATE CHARACTER VARYING(256) 256
22 REGION CHARACTER VARYING(32) 32
23 BRAND CHARACTER VARYING(256) 256
24 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
25 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
26 AUDANET_FLAG CHARACTER VARYING(3) 3
27 AUDANET_FLAG_TYPE CHARACTER VARYING(10) 10
28 BOOKING_LOCATION CHARACTER VARYING(181) 181
29 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
30 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
31 OPERATIONAL_LOB CHARACTER VARYING(16) 16
32 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
33 VEHICLE_STYLE CHARACTER VARYING(256) 256
34 REPAIRER_REGION CHARACTER VARYING(60) 60
35 REPAIRER_STATE CHARACTER VARYING(256) 256
36 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
37 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
38 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
39 TOTAL_COST NUMERIC(18,2) 19
40 TOTAL_DAYS INTEGER 4
41 TOTAL_VOLUME INTEGER 4
42 FIN_MEASURE1 NUMERIC(18,2) 19
43 FIN_MEASURE2 NUMERIC(18,2) 19
44 FIN_MEASURE3 NUMERIC(18,2) 19
45 COUNT_MEASURE1 INTEGER 4
46 COUNT_MEASURE2 INTEGER 4
47 COUNT_MEASURE3 INTEGER 4
48 COUNT_MEASURE4 INTEGER 4
49 COUNT_MEASURE5 INTEGER 4
50 COUNT_MEASURE6 INTEGER 4
51 COUNT_MEASURE7 INTEGER 4