FCT_PI_CI_MOTOR_MBA_SUMMARY_INDIVIDUAL_REPAIRER_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_WK DATE 4
6 REPORT_DATE_DESCRIPTION CHARACTER VARYING(32) 32
7 REPORT_GROUP CHARACTER VARYING(256) 256
8 REPORT_GROUP2 CHARACTER VARYING(128) 128
9 REPORT_GROUP3 CHARACTER VARYING(128) 128
10 REPORT_GROUP4 CHARACTER VARYING(256) 256
11 REPORT_DATE DATE 4
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 VEHICLE_YEAR BIGINT 8
17 VEHICLE_MAKE CHARACTER VARYING(60) 60
18 VEHICLE_MODEL CHARACTER VARYING(80) 80
19 LOSS_CAUSE CHARACTER VARYING(256) 256
20 LOSS_GROUP CHARACTER VARYING(15) 15
21 REPAIRER CHARACTER VARYING(256) 256
22 HUB CHARACTER VARYING(181) 181
23 ASSESSED_STATE CHARACTER VARYING(256) 256
24 REGION CHARACTER VARYING(32) 32
25 R_SUBREGION NATIONAL CHARACTER VARYING(100) 100
26 R_MMC NATIONAL CHARACTER VARYING(250) 250
27 R_SUBREGION_STATE NATIONAL CHARACTER VARYING(100) 100
28 R_REGION NATIONAL CHARACTER VARYING(100) 100
29 ACCOUNTABILITY NATIONAL CHARACTER VARYING(100) 100
30 BRAND CHARACTER VARYING(256) 256
31 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
32 SMART_FLAG CHARACTER VARYING(20) 20
33 ASSESSOR_NAME CHARACTER VARYING(181) 181
34 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
35 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
36 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
37 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
38 AUDANET_FLAG CHARACTER VARYING(3) 3
39 AUDANET_FLAG_TYPE CHARACTER VARYING(10) 10
40 BOOKING_LOCATION CHARACTER VARYING(181) 181
41 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
42 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
43 OPERATIONAL_LOB CHARACTER VARYING(16) 16
44 FLEET_IND CHARACTER VARYING(9) 9
45 CAS_IND CHARACTER VARYING(7) 7
46 INSURED_NAME CHARACTER VARYING(181) 181
47 BROKER_NAME CHARACTER VARYING(120) 120
48 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
49 VEHICLE_STYLE CHARACTER VARYING(256) 256
50 REPAIRER_REGION CHARACTER VARYING(60) 60
51 REPAIRER_STATE CHARACTER VARYING(256) 256
52 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
53 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
54 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
55 TOTAL_COST NUMERIC(38,2) 19
56 TOTAL_DAYS NUMERIC(38,0) 19
57 TOTAL_VOLUME NUMERIC(38,0) 19
58 FIN_MEASURE1 NUMERIC(38,2) 19
59 FIN_MEASURE2 NUMERIC(38,2) 19
60 COUNT_MEASURE1 NUMERIC(38,0) 19
61 COUNT_MEASURE2 NUMERIC(38,0) 19
62 COUNT_MEASURE3 NUMERIC(38,0) 19
63 COUNT_MEASURE4 NUMERIC(38,0) 19
64 COUNT_MEASURE5 NUMERIC(38,0) 19
65 COUNT_MEASURE6 NUMERIC(38,0) 19
66 COUNT_MEASURE7 NUMERIC(38,0) 19
67 SUPPLEMENTARY_PARTS_COST NUMERIC(38,6) 19
68 SUPPLEMENTARY_LABOUR_COST NUMERIC(38,6) 19
69 SUPPLEMENTARY_PAINT_COST NUMERIC(38,6) 19
70 SUPPLEMENTARY_PARTS_VOLUME NUMERIC(38,0) 19
71 SUPPLEMENTARY_PAINT_VOLUME NUMERIC(38,0) 19
72 SUPPLEMENTARY_LABOUR_VOLUME NUMERIC(38,0) 19
73 SUPPLEMENTARY_SUBLET_COST NUMERIC(38,6) 19
74 SUPPLEMENTARY_SUBLET_VOLUME NUMERIC(38,0) 19
75 SUPPLEMENTARY_COST NUMERIC(38,6) 19
76 SUPPLEMENTARY_VOLUME NUMERIC(38,0) 19
77 PARTS_NEW_COST NUMERIC(38,6) 19
78 PARTS_NEW_VOLUME NUMERIC(38,0) 19
79 PARTS_NEW_QUANTITY NUMERIC(38,0) 19
80 PARTS_EXCH_COST NUMERIC(38,6) 19
81 PARTS_EXCH_VOLUME NUMERIC(38,0) 19
82 PARTS_EXCH_QUANTITY NUMERIC(38,0) 19
83 PARTS_RECY_COST NUMERIC(38,6) 19
84 PARTS_RECY_VOLUME NUMERIC(38,0) 19
85 PARTS_RECY_QUANTITY NUMERIC(38,0) 19
86 PARTS_ALTN_COST NUMERIC(38,6) 19
87 PARTS_ALTN_VOLUME NUMERIC(38,0) 19
88 PARTS_ALTN_QUANTITY NUMERIC(38,0) 19
89 PARTS_AFTA_COST NUMERIC(38,6) 19
90 PARTS_AFTA_VOLUME NUMERIC(38,0) 19
91 PARTS_AFTA_QUANTITY NUMERIC(38,0) 19
92 PARTS_CAFT_COST NUMERIC(38,6) 19
93 PARTS_CAFT_VOLUME NUMERIC(38,0) 19
94 PARTS_CAFT_QUANTITY NUMERIC(38,0) 19
95 PARTS_AFT_COST NUMERIC(38,6) 19
96 PARTS_AFT_VOLUME NUMERIC(38,0) 19
97 PARTS_AFT_QUANTITY NUMERIC(38,0) 19
98 PARTS_QUANTITY NUMERIC(38,0) 19
99 PARTS_COST NUMERIC(38,6) 19
100 PARTS_VOLUME NUMERIC(38,0) 19
101 SUBLET_EXTERNAL_COST NUMERIC(38,6) 19
102 SUBLET_INTERNAL_COST NUMERIC(38,6) 19
103 SUBLET_EXTERNAL_VOLUME NUMERIC(38,0) 19
104 SUBLET_INTERNAL_VOLUME NUMERIC(38,0) 19
105 LABOUR_MECHANICAL_COST NUMERIC(38,6) 19
106 LABOUR_OTHER_COST NUMERIC(38,6) 19
107 LABOUR_PLASTICS_COST NUMERIC(38,6) 19
108 LABOUR_RI_COST NUMERIC(38,6) 19
109 LABOUR_RR_COST NUMERIC(38,6) 19
110 LABOUR_REPAIRER_COST NUMERIC(38,6) 19
111 LABOUR_MECHANICAL_VOLUME NUMERIC(38,0) 19
112 LABOUR_OTHER_VOLUME NUMERIC(38,0) 19
113 LABOUR_PLASTICS_VOLUME NUMERIC(38,0) 19
114 LABOUR_RI_VOLUME NUMERIC(38,0) 19
115 LABOUR_RR_VOLUME NUMERIC(38,0) 19
116 LABOUR_REPAIRER_VOLUME NUMERIC(38,0) 19
117 LABOUR_QUANTITY NUMERIC(38,0) 19
118 LABOUR_COST NUMERIC(38,6) 19
119 LABOUR_MECHANICAL_QUANTITY NUMERIC(38,0) 19
120 LABOUR_OTHER_QUANTITY NUMERIC(38,0) 19
121 LABOUR_PLASTICS_QUANTITY NUMERIC(38,0) 19
122 LABOUR_RI_QUANTITY NUMERIC(38,0) 19
123 LABOUR_RR_QUANTITY NUMERIC(38,0) 19
124 LABOUR_REPAIRER_QUANTITY NUMERIC(38,0) 19
125 LABOUR_VOLUME NUMERIC(38,0) 19
126 PAINT_MATERIAL_COST NUMERIC(38,6) 19
127 PAINT_MATERIAL_VOLUME NUMERIC(38,0) 19
128 PAINT_OTHER_COST NUMERIC(38,6) 19
129 PAINT_OTHER_VOLUME NUMERIC(38,0) 19
130 PAINT_LABOUR_COST NUMERIC(38,6) 19
131 PAINT_LABOUR_VOLUME NUMERIC(38,0) 19
132 PAINT_COST NUMERIC(38,6) 19
133 PAINT_VOLUME NUMERIC(38,0) 19
134 REPAIR_TOTAL_COST NUMERIC(38,6) 19
135 REPAIR_TOTAL_VOLUME NUMERIC(38,6) 19