INT_PI_MOTOR_METHODS_BASED_ASSESSING_SUMMARY_REPAIR_LIFE_MEASURES

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MEASURE CHARACTER VARYING(32) 32
2 REPORT_DATE DATE 4
3 REPORT_GROUP CHARACTER VARYING(128) 128
4 REPORT_GROUP2 CHARACTER VARYING(128) 128
5 REPORT_GROUP3 CHARACTER VARYING(128) 128
6 REPORT_GROUP4 CHARACTER VARYING(128) 128
7 REPORT_DATE_DESCRIPTION CHARACTER VARYING(32) 32
8 CLAIM_NUMBER CHARACTER VARYING(40) 40
9 INCIDENT_ID BIGINT 8
10 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
11 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
12 LOSS_CAUSE CHARACTER VARYING(256) 256
13 LOSS_GROUP CHARACTER VARYING(15) 15
14 REPAIRER CHARACTER VARYING(181) 181
15 HUB CHARACTER VARYING(181) 181
16 ASSESSED_STATE CHARACTER VARYING(256) 256
17 REGION CHARACTER VARYING(8) 8
18 R_SUBREGION CHARACTER VARYING(100) 100
19 R_MMC CHARACTER VARYING(250) 250
20 R_SUBREGION_STATE CHARACTER VARYING(100) 100
21 R_REGION CHARACTER VARYING(100) 100
22 ACCOUNTABILITY CHARACTER VARYING(100) 100
23 BRAND CHARACTER VARYING(256) 256
24 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
25 ASSESSOR_NAME CHARACTER VARYING(181) 181
26 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
27 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
28 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
29 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
30 AUDANET_FLAG CHARACTER VARYING(3) 3
31 BOOKING_LOCATION CHARACTER VARYING(181) 181
32 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
33 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
34 OPERATIONAL_LOB CHARACTER VARYING(16) 16
35 FLEET_IND CHARACTER VARYING(9) 9
36 CAS_IND CHARACTER VARYING(7) 7
37 INSURED_NAME CHARACTER VARYING(181) 181
38 BROKER_NAME CHARACTER VARYING(120) 120
39 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
40 POLICY_TYPE CHARACTER VARYING(256) 256
41 VEHICLE_STYLE CHARACTER VARYING(256) 256
42 REPAIRER_REGION CHARACTER VARYING(8) 8
43 REPAIRER_STATE CHARACTER VARYING(256) 256
44 REPAIRER_POSTALCODE CHARACTER VARYING(60) 60
45 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
46 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
47 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
48 TOTAL_COST NUMERIC(18,2) 19
49 TOTAL_DAYS BIGINT 8
50 TOTAL_VOLUME BIGINT 8
51 FIN_MEASURE1 NUMERIC(18,2) 19
52 FIN_MEASURE2 NUMERIC(18,2) 19
53 FIN_MEASURE3 NUMERIC(18,2) 19
54 COUNT_MEASURE1 INTEGER 4
55 COUNT_MEASURE2 INTEGER 4
56 COUNT_MEASURE3 INTEGER 4
57 COUNT_MEASURE4 INTEGER 4
58 COUNT_MEASURE5 INTEGER 4