FCT_MOTOR_QUOTE_LINE_INSIGHT_DRILLTHRU_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 RANKING BIGINT 8
3 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
4 CCR_CC_CLAIM_ID BIGINT 8
5 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
6 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
7 CCR_CCX_SC_PNETQUOTEREQUEST_QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
8 CCR_CCX_SC_PNETQUOTE_AUTHORITYNUMBER BIGINT 8
9 CCR_CCX_SC_PNETQUOTE_QUOTENUMBER CHARACTER VARYING(13) 13
10 CCR_CCX_SC_PNETQUOTE_VERSIONNUMBER BIGINT 8
11 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
12 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
13 REPAIRER_NAME CHARACTER VARYING(120) 120
14 CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
15 ASSESSOR_NAME CHARACTER VARYING(181) 181
16 CCR_CCX_SC_PNETQUOTEREQUEST_ASSESSCOMPLETEDTE DATE 4
17 AUTHORISED_DATE DATE 4
18 CCR_CCTL_SC_PNETLOSINGREASON_NAME CHARACTER VARYING(256) 256
19 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
20 QUOTE_SUBMITTED_COST_GROSS_AMOUNT NUMERIC(38,2) 19
21 QUOTE_REPAIR_COST_GROSS_AMOUNT NUMERIC(38,2) 19
22 PNETQUOTELINE_SUBMITTED_COST_NET_AMOUNT NUMERIC(38,2) 19
23 SUBMITTED_COST_LABOUR_NET NUMERIC(38,2) 19
24 SUBMITTED_COST_PAINT_NET NUMERIC(38,2) 19
25 SUBMITTED_COST_PARTS_NET NUMERIC(38,2) 19
26 SUBMITTED_COST_INTERNAL_SUBLET_NET NUMERIC(38,2) 19
27 PNETQUOTELINE_REPAIR_COST_NET_AMOUNT NUMERIC(38,2) 19
28 REPAIR_COST_LABOUR_NET NUMERIC(38,2) 19
29 REPAIR_COST_PAINT_NET NUMERIC(38,2) 19
30 REPAIR_COST_PARTS_NET NUMERIC(38,2) 19
31 REPAIR_COST_INTERNAL_SUBLET_NET NUMERIC(38,2) 19
32 CCR_CC_VEHICLE_SC_NVIC CHARACTER VARYING(15) 15
33 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
34 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
35 CCR_CC_VEHICLE_YEAR CHARACTER VARYING(20) 20
36 CCR_CCTL_VEHICLESTYLE_NAME CHARACTER VARYING(256) 256
37 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(10) 10
38 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_ID BIGINT 8
39 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_NAME CHARACTER VARYING(256) 256
40 CCR_CCTL_SC_BRAND_ID BIGINT 8
41 CCR_CCTL_VEHICLESTYLE_ID BIGINT 8
42 CCR_CCTL_SC_PNETLOSINGREASON_ID BIGINT 8
43 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_GROUP CHARACTER VARYING(13) 13
44 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_ID BIGINT 8
45 CCR_CCTL_SC_PNETSUBLETOUTCOME_ID BIGINT 8
46 CCR_CCTL_SC_PNETSUBLETOUTCOME_NAME CHARACTER VARYING(256) 256
47 CCR_CC_INCIDENT_ID BIGINT 8
48 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
49 CCR_CCTL_LOSSCAUSE_ID BIGINT 8
50 CCR_CCTL_SC_LOSSCAUSESUBTYPE_ID BIGINT 8
51 CCR_CCTL_POLICYTYPE_ID BIGINT 8
52 CCR_CCTL_SC_LINEOFBUSINESS_ID BIGINT 8
53 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
54 RISK_CITY CHARACTER VARYING(60) 60
55 RISK_CCR_CCTL_STATE_ID BIGINT 8
56 RISK_CCR_CCTL_STATE_NAME CHARACTER VARYING(256) 256
57 RISK_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
58 RISK_LONGITUDE NUMERIC(8,5) 19
59 RISK_LATITUDE NUMERIC(7,5) 19
60 CCR_CC_CATASTROPHE_ID BIGINT 8
61 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_ID BIGINT 8
62 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_NAME CHARACTER VARYING(256) 256
63 CCR_CCTL_LOSSPARTYTYPE_ID BIGINT 8
64 REPAIR_ACTUAL_COMPLETION_DATE DATE 4
65 CCR_CC_VEHICLE_ID BIGINT 8
66 ASSESSOR_CCR_CC_CONTACT_ID BIGINT 8
67 VEHICLE_RETURNED_DATE DATE 4
68 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
69 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
70 ABLOCATION_CCR_ABTL_STATE_ID BIGINT 8
71 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
72 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL_BAND INTEGER 4
73 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
74 CCR_CCTL_SC_PNETASSESSOUTCOME_NAME CHARACTER VARYING(256) 256
75 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
76 CCR_CCTL_SC_PNETQUOTE_ID BIGINT 8
77 AUTHORISED_QUOTE_FLAG CHARACTER VARYING(14) 14
78 CCR_CCX_SC_PNETQUOTEREQUEST_ID BIGINT 8
79 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS BIGINT 8
80 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
81 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
82 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
83 QUOTE_ONTIME_FLAG CHARACTER VARYING(9) 9
84 LATE_TIME NUMERIC(38,7) 19
85 EXTERNAL_SUBLET_COUNT INTEGER 4
86 ALIGNED_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
87 ALIGNED_REPAIRER_ASSESSMENT_CC_ID BIGINT 8
88 ALIGNED_REPAIRER_REGION CHARACTER VARYING(15) 15
89 ALIGNED_REPAIRER_STATE CHARACTER VARYING(256) 256
90 ALIGNED_REPAIRER_BOOKING_LOCATION_ID BIGINT 8
91 ALIGNED_REPAIRER_BOOKING_LOCATION_NAME CHARACTER VARYING(612) 612
92 PNET_REPAIRER_FLAG CHARACTER VARYING(10) 10
93 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
94 CLAIMNUMBER_BAND CHARACTER VARYING(24) 24
95 CCR_CC_COVERAGE_TYPE BIGINT 8
96 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
97 LOSS_CITY CHARACTER VARYING(60) 60
98 LOSS_CCR_CCTL_STATE_ID BIGINT 8
99 LOSS_CCR_CCTL_STATE_NAME CHARACTER VARYING(256) 256
100 LOSS_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
101 LOSS_LONGITUDE NUMERIC(8,5) 19
102 LOSS_LATITUDE NUMERIC(7,5) 19
103 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(17) 17
104 CHOICEOFREPAIRER_FLAG CHARACTER VARYING(28) 28
105 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
106 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
107 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE DATE 4
108 CCR_CC_CHECK_INVOICEPAIDDATE DATE 4
109 EXCESS_COLLECTED_AMOUNT_NET NUMERIC(38,2) 19
110 EXCESS_COLLECTED_AMOUNT_GROSS NUMERIC(38,2) 19
111 INVOICE_AMOUNT_NET NUMERIC(38,22) 19
112 INVOICE_AMOUNT_GROSS NUMERIC(38,2) 19
113 CCR_CC_INCIDENT_SC_EXTERNALASSESSOR BIGINT 8
114 CCR_CCTL_FAULTRATING_ID BIGINT 8
115 INCIDENT_ORIGINAL_REPAIR_COST_NET_GST NUMERIC(38,2) 19
116 INCIDENT_REPAIR_COST_NET_GST NUMERIC(38,2) 19
117 INCIDENT_REPAIR_COST_NET_GST_BAND INTEGER 4
118 CCR_CCX_SC_PNETQUOTEASSESS_QUOTEDUETIME TIMESTAMP 8
119 ORIGINAL_ECD TIMESTAMP 8
120 VEHICLE_COLLECTED_DATE DATE 4
121 ASSESSMENT_OUTCOME_CALL_COMPLETED_DATE TIMESTAMP 8
122 VEHICLE_ARRIVAL_DATE DATE 4
123 REPAIR_START_DATETIME TIMESTAMP 8
124 REPAIRER_ARRIVAL_TIME TIMESTAMP 8
125 REPAIRER_APPOINTMENT_TIME TIMESTAMP 8
126 FINAL_ECD_DATE TIMESTAMP 8
127 ECD_CHANGED_ON_DUE_DATE_INDICATOR CHARACTER VARYING(14) 14
128 ECD_CHANGES_ON_DUE_DATE_COUNT BIGINT 8
129 ECD_CHANGES_COUNT BIGINT 8
130 ECD_CHANGES_EXCEEDED_INDICATOR CHARACTER VARYING(14) 14
131 REPAIR_OVERDUE_INDICATOR CHARACTER VARYING(14) 14
132 PRIMARY_LATE_REPAIR_REASON_INDICATOR CHARACTER VARYING(27) 27
133 REPAIR_ONTIME_FLAG CHARACTER VARYING(14) 14
134 REPAIR_COMPLETED_INDICATOR CHARACTER VARYING(20) 20
135 REWORK_INDICATOR CHARACTER VARYING(20) 20
136 QUALITY_ISSUES_INDICATOR CHARACTER VARYING(28) 28
137 TOTAL_QUALITY_ISSUES_ITEMS BIGINT 8
138 TOTAL_QUALITY_ISSUES BIGINT 8
139 WORKING_REPAIR_DAYS NUMERIC(27,8) 19
140 ELAPSED_REPAIR_DAYS NUMERIC(23,8) 19
141 REPAIRER_APPOINTMENT_TIME_MET_INDICATOR CHARACTER VARYING(24) 24
142 ASSESSED_WITHIN_TIMEFRAME_INDICATOR CHARACTER VARYING(29) 29
143 ASSESSED_BY_1PM_INDICATOR CHARACTER VARYING(19) 19
144 CUSTOMER_CONTACTED_WITHIN_TIMEFRAME_INDICATOR CHARACTER VARYING(30) 30
145 CAR_COLLECTED_WITHIN_TIMEFRAME_INDICATOR CHARACTER VARYING(30) 30
146 REPAIRED_BY_ORIGINAL_ECD_INDICATOR CHARACTER VARYING(28) 28
147 NBR_OF_DAYS_DELAYED_FROM_ORIGINAL_ECD NUMERIC(38,8) 19
148 SMART_CATCHMENT_NAME CHARACTER VARYING(2000) 2000
149 SMART_CATCHMENT_POSTCODE CHARACTER VARYING(9) 9
150 SMART_AREA_INDICATOR CHARACTER VARYING(14) 14
151 EXT_REPAIRER_NAME_FREE_TEXT CHARACTER VARYING(30) 30
152 TOW_FLAG CHARACTER VARYING(17) 17
153 LODGEMENT_DATE DATE 4
154 EVENT_NAME CHARACTER VARYING(256) 256
155 LARGE_LOSS_FLAG CHARACTER VARYING(3) 3
156 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
157 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
158 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
159 POLICY_INTERMEDIARY_CC_CONTACT_ID NUMERIC(18,0) 19
160 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
161 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
162 CLAIM_PROCESS_TYPE_ID BIGINT 8
163 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
164 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
165 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
166 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
167 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
168 FLEET_IND CHARACTER VARYING(9) 9
169 CAS_IND CHARACTER VARYING(9) 9
170 CCR_CC_CLAIM_LOSSDATE DATE 4
171 CI_LARGE_LOSS_FLAG CHARACTER VARYING(9) 9
172 POLICYNUMBER CHARACTER VARYING(40) 40
173 CCR_CC_INCIDENT_SC_EXTERNALASSESSOR_NAME CHARACTER VARYING(120) 120
174 SMART_UNINVITED_FLAG CHARACTER VARYING(3) 3
175 CCR_CCTL_LOSSPARTYTYPE_NAME CHARACTER VARYING(256) 256
176 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
177 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
178 CCR_CCTL_FAULTRATING_NAME CHARACTER VARYING(256) 256
179 REPAIR_AGE_OVER_7DAYS_INDICATOR CHARACTER VARYING(1) 1
180 REPAIR_AGE_ELAPSED_DAYS INTEGER 4
181 XREF_TYPE_ID INTEGER 4
182 XREF_TYPE_NAME CHARACTER VARYING(4) 4
183 REPAIRER_LOCATIONTYPE_TYPECODE CHARACTER VARYING(256) 256
184 REPAIRER_LOCATIONTYPE_ID BIGINT 8
185 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
186 LEGACY_CLAIM CHARACTER VARYING(3) 3
187 LEGACY_TYPE CHARACTER VARYING(256) 256
188 INCIDENT_REPAIR_COST_NET_GST_BAND_NAME CHARACTER VARYING(18) 18
189 INCIDENT_REPAIR_COST_NET_GST_BAND_SUBNAME CHARACTER VARYING(18) 18
190 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL_BAND_NAME CHARACTER VARYING(18) 18
191 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL_BAND_SUBNAME CHARACTER VARYING(18) 18