FCT_PI_MOTOR_METHODS_BASED_ASSESSING_QUALITY_ISSUE_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 QUALITY_ISSUE_ID BIGINT 8
2 CLAIM_NUMBER CHARACTER VARYING(40) 40
3 CLAIM_ID BIGINT 8
4 INCIDENT_ID BIGINT 8
5 ALLEGED_RESPONSIBLE_PARTY CHARACTER VARYING(256) 256
6 ACTUAL_RESPONSIBLE_PARTY CHARACTER VARYING(256) 256
7 ESTIMATED_RECTIFICATION_COST NUMERIC(18,2) 19
8 RECTIFIED CHARACTER VARYING(3) 3
9 TYPE CHARACTER VARYING(256) 256
10 RECTIFICATION_METHOD CHARACTER VARYING(256) 256
11 QI_RESPONSIBLE_REPAIRER CHARACTER VARYING(181) 181
12 QI_RESPONSIBLE_REPAIRER_STATE CHARACTER VARYING(256) 256
13 QI_RESPONSIBLE_REPAIRER_REGION CHARACTER VARYING(8) 8
14 ORIGINAL_REPAIRER CHARACTER VARYING(181) 181
15 ORIGINAL_REPAIRER_STATE CHARACTER VARYING(256) 256
16 ORIGINAL_REPAIRER_REGION CHARACTER VARYING(8) 8
17 RESOLUTION_STRATEGY CHARACTER VARYING(256) 256
18 RESOLUTIONSTRATEGY_APPLIED_FLAG CHARACTER VARYING(1) 1
19 WARRANTY_APPLIED CHARACTER VARYING(256) 256
20 AGE BIGINT 8
21 STATUS CHARACTER VARYING(6) 6
22 ISSUE_RAISED_DATE DATE 4
23 ISSUE_COMPLETED_DATE DATE 4
24 ISSUE_RESOLVED_DATE DATE 4
25 CLAIM_CLOSE_DATE TIMESTAMP 8
26 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
27 BOOKING_LOCATION CHARACTER VARYING(181) 181
28 ASSESSED_STATE CHARACTER VARYING(256) 256
29 ASSESSED_REGION CHARACTER VARYING(8) 8
30 BRAND CHARACTER VARYING(256) 256
31 LOSS_GROUP CHARACTER VARYING(15) 15
32 LOSS_CAUSE CHARACTER VARYING(256) 256
33 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
34 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
35 ASSESSOR_NAME CHARACTER VARYING(181) 181
36 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
37 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
38 OPERATIONAL_LOB CHARACTER VARYING(16) 16
39 FLEET_IND CHARACTER VARYING(9) 9
40 CAS_IND CHARACTER VARYING(7) 7
41 INSURED_NAME CHARACTER VARYING(181) 181
42 BROKER_NAME CHARACTER VARYING(120) 120
43 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
44 POLICY_TYPE CHARACTER VARYING(256) 256
45 VEHICLE_STYLE CHARACTER VARYING(256) 256
46 LEGACY_CLAIM_FLAG CHARACTER VARYING(3) 3
47 AUDANET_QUOTE_FLAG CHARACTER VARYING(3) 3
48 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
49 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
50 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
51 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
52 R_MMC CHARACTER VARYING(250) 250
53 R_REGION CHARACTER VARYING(100) 100
54 R_SUBREGION CHARACTER VARYING(100) 100
55 R_SUBREGION_STATE CHARACTER VARYING(100) 100
56 ACCOUNTABILITY CHARACTER VARYING(100) 100