FCT_PI_CI_MOTOR_MBA_SUMMARY_ASSESSOR_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(1) 1
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(181) 181
26 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
27 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
28 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
29 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
30 AUDANET_FLAG CHARACTER VARYING(3) 3
31 AUDANET_FLAG_TYPE CHARACTER VARYING(10) 10
32 BOOKING_LOCATION CHARACTER VARYING(181) 181
33 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
34 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
35 OPERATIONAL_LOB CHARACTER VARYING(16) 16
36 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
37 VEHICLE_STYLE CHARACTER VARYING(256) 256
38 REPAIRER_REGION CHARACTER VARYING(60) 60
39 REPAIRER_STATE CHARACTER VARYING(256) 256
40 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
41 TOTAL_COST NUMERIC(18,2) 19
42 TOTAL_DAYS BIGINT 8
43 TOTAL_VOLUME INTEGER 4
44 COUNT_MEASURE1 INTEGER 4
45 COUNT_MEASURE2 INTEGER 4
46 COUNT_MEASURE3 INTEGER 4