FCT_MOTOR_QUOTE_LINE_INSIGHT_OLD

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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