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