INT_PI_MOTOR_PATHING_SCORING_DIMENSION_INSIGHT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_NUMBER CHARACTER VARYING(40) 40
2 POLICY_NUMBER CHARACTER VARYING(40) 40
3 CLAIM_ID BIGINT 8
4 INCIDENT_ID BIGINT 8
5 RISK_POSTCODE CHARACTER VARYING(60) 60
6 QUOTEASSESS_ID BIGINT 8
7 QUOTE_ID BIGINT 8
8 QUOTELINE_ID BIGINT 8
9 OPERATIONAL_LOB CHARACTER VARYING(16) 16
10 LINE_OF_BUSINESS CHARACTER VARYING(256) 256
11 POLICY_TYPE CHARACTER VARYING(256) 256
12 BRAND CHARACTER VARYING(256) 256
13 LOSS_POSTCODE CHARACTER VARYING(60) 60
14 LOSS_STATE CHARACTER VARYING(256) 256
15 LOSS_CITY CHARACTER VARYING(60) 60
16 LOSS_ADDRESS CHARACTER VARYING(165) 165
17 LOSS_LATITUDE NUMERIC(7,5) 19
18 LOSS_LONGITUDE NUMERIC(8,5) 19
19 LOSS_LOCATION_ID BIGINT 8
20 LOSS_TYPE CHARACTER VARYING(256) 256
21 LOSS_CAUSE CHARACTER VARYING(256) 256
22 LOSS_CAUSE_SUBTYPE CHARACTER VARYING(256) 256
23 LOSS_GROUP CHARACTER VARYING(15) 15
24 LOSS_PARTY_TYPE CHARACTER VARYING(256) 256
25 FLEET_IND CHARACTER VARYING(9) 9
26 CAS_IND CHARACTER VARYING(7) 7
27 INSURED_NAME CHARACTER VARYING(181) 181
28 BROKER_NAME CHARACTER VARYING(120) 120
29 CLAIM_STATE CHARACTER VARYING(256) 256
30 LOSS_DATE TIMESTAMP 8
31 LODGEMENT_DATE TIMESTAMP 8
32 CLOSE_DATE TIMESTAMP 8
33 CLAIM_CLOSED_REASON CHARACTER VARYING(256) 256
34 CLAIM_LIFE INTEGER 4
35 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1
36 VEHICLE_REGISTRATION CHARACTER VARYING(40) 40
37 CCR_CC_VEHICLE_YEAR BIGINT 8
38 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
39 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
40 CCR_CC_VEHICLE_VIN CHARACTER VARYING(40) 40
41 VEHICLE_STYLE CHARACTER VARYING(256) 256
42 COMBINED_COST_TYPE CHARACTER VARYING(10) 10
43 TOTAL_LOSS_SUBMITTED_DATE TIMESTAMP 8
44 TOTAL_LOSS_SUBMITTED_COST NUMERIC(18,2) 19
45 REPAIR_AUTHORISED_DATE DATE 4
46 REPAIR_AUTHORISED_DATETIME TIMESTAMP 8
47 SUPP_AUTHORISED_DATE TIMESTAMP 8
48 SUBLET_AUTHORISED_DATE DATE 4
49 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
50 BOOKING_DATE TIMESTAMP 8
51 NO_SHOW INTEGER 4
52 BOOKING_LOCATION_ABCONTACTID BIGINT 8
53 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
54 ARRIVAL_DATE TIMESTAMP 8
55 ASSESSED_AS_TOTAL_LOSS CHARACTER VARYING(3) 3
56 ASSESSOR_NAME CHARACTER VARYING(181) 181
57 EXTERNAL_ASSESSOR_INDICATOR INTEGER 4
58 LOCATION_TYPE CHARACTER VARYING(256) 256
59 HUB CHARACTER VARYING(181) 181
60 ASSESSED_STATE CHARACTER VARYING(256) 256
61 REGION CHARACTER VARYING(8) 8
62 REPAIRER_NAME CHARACTER VARYING(120) 120
63 ABCONTACT_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
64 ABCONTACT_REPAIRER_REPAIRER_PROFILE CHARACTER VARYING(50) 50
65 ABCONTACT_REPAIRER_REPAIRER_PROFILE_1 CHARACTER VARYING(25) 25
66 ABCONTACT_REPAIRER_RETIRED BIGINT 8
67 ABCONTACT_REPAIRER_SC_ACTIVECONTACT CHARACTER VARYING(1) 1
68 SUBLET_REPAIRER_NAME CHARACTER VARYING(60) 60
69 SUBLET_REPAIRER_STATE CHARACTER VARYING(60) 60
70 SUBLET_REPAIRER_REGION CHARACTER VARYING(60) 60
71 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
72 AUDANET_QUOTE_FLAG CHARACTER VARYING(3) 3
73 AUDANET_TRIGGERED_DATE DATE 4
74 CCR_CCX_SC_PNETQUOTE_QUOTSOFTWARE CHARACTER VARYING(20) 20
75 PNET_QUOTE_OUTCOME CHARACTER VARYING(256) 256
76 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
77 QUOTE_TYPE CHARACTER VARYING(256) 256
78 QUOTE_METHOD CHARACTER VARYING(11) 11
79 QUOTE_AUTHORISED_FLAG CHARACTER VARYING(3) 3
80 QUOTELINE_CHECK_FLAG INTEGER 4
81 QUOTELINE_CHANGEIND CHARACTER VARYING(1) 1
82 QUOTELINE_ADJUSTMENT_FLAG CHARACTER VARYING(3) 3
83 QUOTELINE_ADJUSTMENT_AMOUNT NUMERIC(18,2) 19
84 ASSESSED_REPAIR_COST NUMERIC(18,2) 19
85 ORIGINAL_QUOTE_AMOUNT NUMERIC(18,2) 19
86 REPAIR_COMPONENT_TYPE CHARACTER VARYING(6) 6
87 QUOTELINE_NUMBER BIGINT 8
88 QUOTE_LINE_SEQUENCE BIGINT 8
89 QUOTELINE_QUANTITY INTEGER 4
90 PART_TYPE_NAME CHARACTER VARYING(256) 256
91 PART_TYPE_CODE CHARACTER VARYING(50) 50
92 PART_NUMBER CHARACTER VARYING(20) 20
93 LINE_ITEM_DESCRIPTION CHARACTER VARYING(255) 255
94 NSP_OPINION_FLAG CHARACTER VARYING(3) 3
95 REPAIRS_COMPLETED_FLAG CHARACTER VARYING(3) 3
96 VEHICLE_ARRIVAL_EXCEPTION_FLAG CHARACTER VARYING(3) 3
97 REPAIR_COMPLETED_EXCEPTION_FLAG CHARACTER VARYING(3) 3
98 REPAIRS_COMPLETED_DATE TIMESTAMP 8
99 ORIGINAL_ECD TIMESTAMP 8
100 CURRENT_ECD TIMESTAMP 8
101 ECD_CHANGES INTEGER 4
102 INVOICE_DATE DATE 4
103 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE_MAX DATE 4
104 CCR_CCX_SC_PNETQUOTEINVOICE_AMOUNTEXCLUDINGGST NUMERIC(38,2) 19
105 INVOICE_COUNT BIGINT 8
106 CASH_SETTLEMENT_COST NUMERIC(38,2) 19
107 CASH_SETTLEMENT_VOLUME NUMERIC(38,0) 19
108 CASH_SETTLEMENT_ASSESSMENT_COMPLETION_DATE TIMESTAMP 8
109 VEHICLE_RETURNED_DATE TIMESTAMP 8
110 QUALITY_ISSUE_FLAG CHARACTER VARYING(3) 3
111 QUOTE_ASSESS_ARCHIVED_FLAG CHARACTER VARYING(3) 3
112 PNETQUOTE_SUBMITTED_TIME TIMESTAMP 8
113 PRIMARY_BOOKING_DATE DATE 4
114 PRIMARY_BOOKING CHARACTER VARYING(3) 3
115 TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
116 REPAIR_CUSTOMER_LIFE_END_DATE DATE 4
117 TOTAL_LOSS_CUSTOMER_LIFE_END_DATE DATE 4
118 SALVAGE_DATE_OF_SALE DATE 4
119 SALVAGE_RECEIVED_DATE DATE 4
120 SALVAGE_ACTUAL_AMOUNT NUMERIC(38,2) 19
121 SALVAGE_ACTUAL_NET NUMERIC(38,2) 19
122 SALVAGE_PROVIDER_NAME CHARACTER VARYING(256) 256
123 SALVAGE_ESTIMATED_AMOUNT NUMERIC(18,2) 19
124 CUSTOMER_LIFE INTEGER 4
125 REPAIRER_REGION CHARACTER VARYING(8) 8
126 REPAIRER_STATE CHARACTER VARYING(256) 256
127 REPAIRER_POSTALCODE CHARACTER VARYING(60) 60
128 REPAIRS_END_DATE DATE 4
129 ORIGINAL_ECD_DATE DATE 4
130 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
131 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
132 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
133 TOTAL_LOSS_ARRIVAL_DATE TIMESTAMP 8
134 SUBROCLOSE_REASON CHARACTER VARYING(25) 25
135 SUBROCLOSEDATE DATE 4
136 SALVAGE_PERCENTAGE NUMERIC(33,0) 19