FCT_PI_MOTOR_MBA_REPAIRER_COMPONENT_BREAKDOWN_ASSESSOR_SUMMARY_INSIGHT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 MEASURE CHARACTER VARYING(32) 32
2 REPORT_DATE DATE 4
3 REPORT_GROUP4 CHARACTER VARYING(256) 256
4 REPORT_GROUP CHARACTER VARYING(256) 256
5 CLAIM_NUMBER CHARACTER VARYING(40) 40
6 INCIDENT_ID BIGINT 8
7 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
8 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
9 LOSS_CAUSE CHARACTER VARYING(256) 256
10 LOSS_GROUP CHARACTER VARYING(15) 15
11 REPAIRER CHARACTER VARYING(256) 256
12 HUB CHARACTER VARYING(181) 181
13 ASSESSED_STATE CHARACTER VARYING(256) 256
14 REGION CHARACTER VARYING(32) 32
15 BRAND CHARACTER VARYING(256) 256
16 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
17 ASSESSOR_NAME CHARACTER VARYING(181) 181
18 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
19 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
20 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
21 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
22 AUDANET_FLAG CHARACTER VARYING(3) 3
23 BOOKING_LOCATION CHARACTER VARYING(181) 181
24 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
25 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
26 OPERATIONAL_LOB CHARACTER VARYING(16) 16
27 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
28 VEHICLE_STYLE CHARACTER VARYING(256) 256
29 REPAIRER_REGION CHARACTER VARYING(60) 60
30 REPAIRER_STATE CHARACTER VARYING(256) 256
31 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
32 SUPPLEMENTARY_PARTS_COST NUMERIC(38,6) 19
33 SUPPLEMENTARY_LABOUR_COST NUMERIC(38,6) 19
34 SUPPLEMENTARY_PAINT_COST NUMERIC(38,6) 19
35 SUPPLEMENTARY_PARTS_VOLUME INTEGER 4
36 SUPPLEMENTARY_PAINT_VOLUME INTEGER 4
37 SUPPLEMENTARY_LABOUR_VOLUME INTEGER 4
38 SUPPLEMENTARY_SUBLET_COST NUMERIC(38,6) 19
39 SUPPLEMENTARY_SUBLET_VOLUME INTEGER 4
40 SUPPLEMENTARY_COST NUMERIC(38,6) 19
41 SUPPLEMENTARY_VOLUME INTEGER 4
42 PARTS_NEW_COST NUMERIC(38,6) 19
43 PARTS_NEW_VOLUME INTEGER 4
44 PARTS_NEW_QUANTITY NUMERIC(38,0) 19
45 PARTS_EXCH_COST NUMERIC(38,6) 19
46 PARTS_EXCH_VOLUME INTEGER 4
47 PARTS_EXCH_QUANTITY NUMERIC(38,0) 19
48 PARTS_RECY_COST NUMERIC(38,6) 19
49 PARTS_RECY_VOLUME INTEGER 4
50 PARTS_RECY_QUANTITY NUMERIC(38,0) 19
51 PARTS_ALTN_COST NUMERIC(38,6) 19
52 PARTS_ALTN_VOLUME INTEGER 4
53 PARTS_ALTN_QUANTITY NUMERIC(38,0) 19
54 PARTS_AFTA_COST NUMERIC(38,6) 19
55 PARTS_AFTA_VOLUME INTEGER 4
56 PARTS_AFTA_QUANTITY NUMERIC(38,0) 19
57 PARTS_CAFT_COST NUMERIC(38,6) 19
58 PARTS_CAFT_VOLUME INTEGER 4
59 PARTS_CAFT_QUANTITY NUMERIC(38,0) 19
60 PARTS_AFT_COST NUMERIC(38,6) 19
61 PARTS_AFT_VOLUME INTEGER 4
62 PARTS_AFT_QUANTITY NUMERIC(38,0) 19
63 PARTS_QUANTITY NUMERIC(38,0) 19
64 PARTS_COST NUMERIC(38,6) 19
65 PARTS_VOLUME INTEGER 4
66 SUBLET_EXTERNAL_COST NUMERIC(38,6) 19
67 SUBLET_INTERNAL_COST NUMERIC(38,6) 19
68 SUBLET_EXTERNAL_VOLUME INTEGER 4
69 SUBLET_INTERNAL_VOLUME INTEGER 4
70 LABOUR_MECHANICAL_COST NUMERIC(38,6) 19
71 LABOUR_OTHER_COST NUMERIC(38,6) 19
72 LABOUR_PLASTICS_COST NUMERIC(38,6) 19
73 LABOUR_RI_COST NUMERIC(38,6) 19
74 LABOUR_RR_COST NUMERIC(38,6) 19
75 LABOUR_REPAIRER_COST NUMERIC(38,6) 19
76 LABOUR_MECHANICAL_VOLUME INTEGER 4
77 LABOUR_OTHER_VOLUME NUMERIC(38,0) 19
78 LABOUR_PLASTICS_VOLUME INTEGER 4
79 LABOUR_RI_VOLUME INTEGER 4
80 LABOUR_RR_VOLUME INTEGER 4
81 LABOUR_REPAIRER_VOLUME INTEGER 4
82 LABOUR_QUANTITY NUMERIC(38,0) 19
83 LABOUR_COST NUMERIC(38,6) 19
84 LABOUR_MECHANICAL_QUANTITY NUMERIC(38,0) 19
85 LABOUR_OTHER_QUANTITY NUMERIC(38,0) 19
86 LABOUR_PLASTICS_QUANTITY NUMERIC(38,0) 19
87 LABOUR_RI_QUANTITY NUMERIC(38,0) 19
88 LABOUR_RR_QUANTITY NUMERIC(38,0) 19
89 LABOUR_REPAIRER_QUANTITY NUMERIC(38,0) 19
90 LABOUR_VOLUME INTEGER 4
91 PAINT_MATERIAL_COST NUMERIC(38,6) 19
92 PAINT_MATERIAL_VOLUME INTEGER 4
93 PAINT_OTHER_COST NUMERIC(38,6) 19
94 PAINT_OTHER_VOLUME INTEGER 4
95 PAINT_LABOUR_COST NUMERIC(38,6) 19
96 PAINT_LABOUR_VOLUME INTEGER 4
97 PAINT_COST NUMERIC(38,6) 19
98 PAINT_VOLUME INTEGER 4
99 REPAIR_TOTAL_COST NUMERIC(38,6) 19
100 REPAIR_TOTAL_VOLUME NUMERIC(38,6) 19