FCT_PI_MOTOR_MBA_SUMMARY_INDIVIDUAL_ASSESSOR_REPAIRER_INSIGHT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

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