FCT_PI_MOTOR_MBA_SUMMARY_INDIVIDUAL_REPAIRER_OPS_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 REPORT_DATE_WK DATE 4
5 MEASURE CHARACTER VARYING(32) 32
6 REPORT_DATE DATE 4
7 REPORT_GROUP CHARACTER VARYING(256) 256
8 REPORT_GROUP2 CHARACTER VARYING(256) 256
9 REPORT_GROUP3 CHARACTER VARYING(128) 128
10 REPORT_GROUP4 CHARACTER VARYING(128) 128
11 REPORT_DATE_DESCRIPTION CHARACTER VARYING(32) 32
12 CLAIM_NUMBER CHARACTER VARYING(40) 40
13 INCIDENT_ID BIGINT 8
14 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
15 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
16 LOSS_CAUSE CHARACTER VARYING(256) 256
17 LOSS_GROUP CHARACTER VARYING(15) 15
18 REPAIRER CHARACTER VARYING(256) 256
19 HUB CHARACTER VARYING(1) 1
20 ASSESSED_STATE CHARACTER VARYING(256) 256
21 REGION CHARACTER VARYING(32) 32
22 BRAND CHARACTER VARYING(256) 256
23 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
24 ASSESSOR_NAME CHARACTER VARYING(1) 1
25 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(1) 1
26 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
27 AUDANET_FLAG CHARACTER VARYING(3) 3
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 BIGINT 8
41 TOTAL_VOLUME INTEGER 4
42 COUNT_MEASURE1 INTEGER 4
43 COUNT_MEASURE2 INTEGER 4
44 COUNT_MEASURE3 INTEGER 4