FCT_PI_CI_MOTOR_MBA_SUMMARY_REPAIRER_MANAGEMENT_OPS_INSIGHT_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_GROUP CHARACTER VARYING(256) 256
7 REPORT_GROUP2 CHARACTER VARYING(256) 256
8 REPORT_GROUP3 CHARACTER VARYING(128) 128
9 REPORT_GROUP4 CHARACTER VARYING(128) 128
10 REPORT_DATE_DESCRIPTION CHARACTER VARYING(32) 32
11 LOSS_CAUSE CHARACTER VARYING(256) 256
12 LOSS_GROUP CHARACTER VARYING(15) 15
13 REPAIRER CHARACTER VARYING(256) 256
14 HUB CHARACTER VARYING(1) 1
15 ASSESSED_STATE CHARACTER VARYING(256) 256
16 REGION CHARACTER VARYING(32) 32
17 R_SUBREGION NATIONAL CHARACTER VARYING(100) 100
18 R_MMC NATIONAL CHARACTER VARYING(250) 250
19 R_SUBREGION_STATE NATIONAL CHARACTER VARYING(100) 100
20 R_REGION NATIONAL CHARACTER VARYING(100) 100
21 ACCOUNTABILITY NATIONAL CHARACTER VARYING(100) 100
22 BRAND CHARACTER VARYING(256) 256
23 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
24 SMART_FLAG CHARACTER VARYING(20) 20
25 ASSESSOR_NAME CHARACTER VARYING(1) 1
26 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(1) 1
27 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
28 AUDANET_FLAG CHARACTER VARYING(3) 3
29 AUDANET_FLAG_TYPE CHARACTER VARYING(10) 10
30 BOOKING_LOCATION CHARACTER VARYING(181) 181
31 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
32 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
33 OPERATIONAL_LOB CHARACTER VARYING(16) 16
34 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
35 VEHICLE_STYLE CHARACTER VARYING(256) 256
36 REPAIRER_REGION CHARACTER VARYING(60) 60
37 REPAIRER_STATE CHARACTER VARYING(256) 256
38 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
39 TOTAL_COST NUMERIC(18,2) 19
40 TOTAL_DAYS BIGINT 8
41 TOTAL_VOLUME INTEGER 4
42 COUNT_MEASURE1 INTEGER 4
43 COUNT_MEASURE2 INTEGER 4
44 COUNT_MEASURE3 INTEGER 4