FCT_PI_MOTOR_MBA_SUMMARY_ASSESSOR_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 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 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 LOSS_CAUSE CHARACTER VARYING(256) 256
16 LOSS_GROUP CHARACTER VARYING(15) 15
17 REPAIRER CHARACTER VARYING(1) 1
18 HUB CHARACTER VARYING(1) 1
19 ASSESSED_STATE CHARACTER VARYING(256) 256
20 REGION CHARACTER VARYING(32) 32
21 BRAND CHARACTER VARYING(256) 256
22 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
23 ASSESSOR_NAME CHARACTER VARYING(181) 181
24 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
25 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
26 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
27 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
28 AUDANET_FLAG CHARACTER VARYING(3) 3
29 BOOKING_LOCATION CHARACTER VARYING(181) 181
30 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
31 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
32 OPERATIONAL_LOB CHARACTER VARYING(16) 16
33 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
34 VEHICLE_STYLE CHARACTER VARYING(256) 256
35 REPAIRER_REGION CHARACTER VARYING(60) 60
36 REPAIRER_STATE CHARACTER VARYING(256) 256
37 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
38 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(1) 1
39 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(1) 1
40 TOTAL_COST NUMERIC(18,2) 19
41 TOTAL_DAYS BIGINT 8
42 TOTAL_VOLUME INTEGER 4
43 COUNT_MEASURE1 INTEGER 4
44 COUNT_MEASURE2 INTEGER 4
45 COUNT_MEASURE3 INTEGER 4