FCT_MOTOR_QUALITY_ISSUE_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
3 REPAIRER_NAME CHARACTER VARYING(120) 120
4 PROCESS_TYPE CHARACTER VARYING(256) 256
5 RESPONSIBLE_PARTY CHARACTER VARYING(256) 256
6 CLAIMNUMBER CHARACTER VARYING(40) 40
7 CCR_CCX_SC_ASSESSMENTQUALITYISSUE_RESOLUTIONDATE DATE 4
8 ASSESSMENT_COMPLETED_DATE DATE 4
9 RESOLUTION_STRATEGY CHARACTER VARYING(256) 256
10 ISSUE_WARRANTY CHARACTER VARYING(256) 256
11 VEHICLEREGNO CHARACTER VARYING(10) 10
12 VEHICLEDESCRIPTION CHARACTER VARYING(263) 263
13 CCR_CCX_SC_QUALITYISSUEITEM_DESCRIPTION CHARACTER VARYING(255) 255
14 REPAIR_ACTUAL_COMPLETION_DATE DATE 4
15 REWORK_INDICATOR CHARACTER VARYING(20) 20
16 RESOLUTIONSTRATEGYAPPLIED CHARACTER VARYING(3) 3
17 QUALITY_ISSUE_CREATETIME DATE 4
18 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS BIGINT 8
19 QUOTE_REQUEST_STATUS CHARACTER VARYING(256) 256
20 CCR_CCX_SC_QUALITYISSUEITEM_ID BIGINT 8
21 CCR_CCX_SC_ASSESSMENTQUALITYISSUE_ID BIGINT 8
22 QUALITY_ISSUES_INDICATOR CHARACTER VARYING(15) 15
23 ALIGNED_REPAIRER_ASSESSMENT_CC_NAME CHARACTER VARYING(612) 612
24 ALIGNED_REPAIRER_NAME CHARACTER VARYING(120) 120
25 ALIGNED_REPAIRER_STATE_NAME CHARACTER VARYING(256) 256
26 ALIGNED_REPAIRER_STATE_ID CHARACTER VARYING(50) 50
27 ALIGNED_REPAIRER_BOOKING_LOCATION_ID BIGINT 8
28 ALIGNED_REPAIRER_STATE CHARACTER VARYING(256) 256
29 ALIGNED_REPAIRER_REGION CHARACTER VARYING(15) 15
30 ALIGNED_REPAIRER_BOOKING_LOCATION_NAME CHARACTER VARYING(612) 612
31 ALIGNED_REPAIRER_ID BIGINT 8
32 CCR_ABTL_SC_LOCATIONCONTACTTYPE_NAME CHARACTER VARYING(256) 256
33 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
34 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_GROUP CHARACTER VARYING(13) 13
35 CCR_CCTL_FAULTRATING_ID BIGINT 8
36 CCR_CCTL_FAULTRATING_NAME CHARACTER VARYING(256) 256
37 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
38 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
39 RISK_CCR_CC_ADDRESS_ADDRESSLINE1 CHARACTER VARYING(55) 55
40 RISK_CCR_CC_ADDRESS_ADDRESSLINE2 CHARACTER VARYING(55) 55
41 RISK_CCR_CC_ADDRESS_ADDRESSLINE3 CHARACTER VARYING(55) 55
42 RISK_CCR_CC_ADDRESS_CITY CHARACTER VARYING(60) 60
43 RISK_CCR_CC_ADDRESS_POSTALCODE CHARACTER VARYING(60) 60
44 RISK_CCR_CC_ADDRESS_STATE_ID BIGINT 8
45 STATE_NAME CHARACTER VARYING(256) 256
46 RISK_CCR_CC_ADDRESS_LONGITUDE NUMERIC(8,5) 19
47 RISK_CCR_CC_ADDRESS_LATITUDE NUMERIC(7,5) 19
48 BRAND CHARACTER VARYING(256) 256
49 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
50 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
51 CLAIM_ID BIGINT 8
52 CCR_CC_INCIDENT_ID BIGINT 8
53 CCR_CCTL_LOSSTYPE_ID BIGINT 8
54 CCR_CCTL_LOSSCAUSE_ID BIGINT 8
55 CCR_CCTL_SC_LOSSCAUSESUBTYPE_ID BIGINT 8
56 CCR_CCTL_POLICYTYPE_ID BIGINT 8
57 CCR_CCTL_SC_BRAND_ID BIGINT 8
58 CCR_CCTL_SC_LINEOFBUSINESS_ID BIGINT 8
59 CLOSED_DATE TIMESTAMP 8
60 CCR_CC_CATASTROPHE_ID BIGINT 8
61 CATASTROPHE_CODE CHARACTER VARYING(120) 120
62 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_ID BIGINT 8
63 CCR_CCTL_LOSSPARTYTYPE_ID BIGINT 8
64 CCR_CCTL_LOSSPARTYTYPE_NAME CHARACTER VARYING(256) 256
65 INTRO_CALL_COMPLETED_DATE TIMESTAMP 8
66 VEHICLE_ARRIVAL_DATE DATE 4
67 HIRE_CAR_DATE TIMESTAMP 8
68 VEHICLE_RETURNED_DATE DATE 4
69 ORIGINAL_ECD TIMESTAMP 8
70 ASSESSMENT_OUTCOME_CALL_COMPLETED_DATE TIMESTAMP 8
71 VEHICLE_COLLECTED_DATE DATE 4
72 FINAL_ECD_DATE TIMESTAMP 8
73 REPAIR_COMPLETED_INDICATOR CHARACTER VARYING(20) 20
74 CCR_CC_VEHICLE_ID BIGINT 8
75 CCR_CCTL_VEHICLESTYLE_ID BIGINT 8
76 CCR_CCTL_VEHICLESTYLE_NAME CHARACTER VARYING(256) 256
77 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
78 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
79 CCR_CC_VEHICLE_YEAR BIGINT 8
80 CCR_CC_VEHICLE_YEAR_TEXT CHARACTER VARYING(9) 9
81 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_ID BIGINT 8
82 ASSESSOR_CCR_CC_CONTACT_ID BIGINT 8
83 ASSESSOR_NAME CHARACTER VARYING(181) 181
84 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(30) 30
85 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
86 ABLOCATION_CCR_ABTL_STATE_ID BIGINT 8
87 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
88 INCIDENT_ORIGINAL_REPAIR_COST_NET_GST NUMERIC(19,2) 19
89 INCIDENT_REPAIR_COST_NET_GST NUMERIC(19,2) 19
90 INCIDENT_REPAIR_COST_NET_GST_BAND INTEGER 4
91 CCR_CCX_SC_PNETQUOTE_ORIGINALQUOTETOTAL NUMERIC(18,2) 19
92 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL NUMERIC(18,2) 19
93 CCR_CCX_SC_PNETQUOTE_QUOTETOTAL_BAND INTEGER 4
94 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
95 CCR_CCTL_SC_PNETASSESSOUTCOME_TYPECODE CHARACTER VARYING(50) 50
96 SUPPS_CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
97 CCR_CCTL_SC_PNETQUOTE_ID BIGINT 8
98 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
99 AUTHORISED_QUOTE_FLAG CHARACTER VARYING(14) 14
100 AUTHORISED_DATE DATE 4
101 CCR_CCX_SC_PNETQUOTEREQUEST_ID BIGINT 8
102 CCR_CCX_SC_PNETQUOTEREQUEST_QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
103 QUOTEREQUESTNUMBER CHARACTER VARYING(13) 13
104 CCR_CCX_SC_PNETQUOTEASSESS_ID BIGINT 8
105 CCR_CCX_SC_PNETQUOTE_ID BIGINT 8
106 CCR_CCX_SC_PNETQUOTE_SUBMITTEDTIME TIMESTAMP 8
107 QUOTE_ONTIME_FLAG CHARACTER VARYING(7) 7
108 LATE_TIME NUMERIC(36,7) 19
109 CCR_CCX_SC_PNETQUOTE_AUTHORITYNUMBER BIGINT 8
110 ALIGNED_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
111 ALIGNED_REPAIRER_ASSESSMENT_CC_ID BIGINT 8
112 PNET_REPAIRER_FLAG CHARACTER VARYING(1) 1
113 CCR_CC_COVERAGE_TYPE BIGINT 8
114 CCR_CC_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
115 CCR_CC_VEHICLE_SC_NVIC CHARACTER VARYING(15) 15
116 CCR_CCX_SC_PNETQUOTE_VERSIONNUMBER BIGINT 8
117 CCR_CCX_SC_PNETQUOTE_QUOTENUMBER CHARACTER VARYING(13) 13
118 CCR_CCTL_SC_PNETLOSINGREASON_ID BIGINT 8
119 COMPETITIVE_QUOTE_FLAG CHARACTER VARYING(17) 17
120 CHOICEOFREPAIRER_FLAG CHARACTER VARYING(28) 28
121 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICENUMBER CHARACTER VARYING(20) 20
122 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICE_ID BIGINT 8
123 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
124 CCR_CC_CHECK_INVOICEPAIDDATE TIMESTAMP 8
125 EXCESS_COLLECTED_AMOUNT_NET NUMERIC(9,2) 19
126 EXCESS_COLLECTED_AMOUNT_GROSS NUMERIC(9,2) 19
127 INVOICE_AMOUNT_NET NUMERIC(9,2) 19
128 INVOICE_AMOUNT_GROSS NUMERIC(9,2) 19
129 CCR_CC_INCIDENT_SC_EXTERNALASSESSOR BIGINT 8
130 CCR_CCX_SC_PNETQUOTEASSESS_QUOTEDUETIME TIMESTAMP 8
131 CCR_CC_VEHICLE_LICENSEPLATE CHARACTER VARYING(10) 10
132 CCR_CCTL_SC_PNETQUOTEASSESSSTATUS_ID BIGINT 8
133 QUALITY_ISSUE_RAISED_DATE DATE 4
134 ISSUEID BIGINT 8
135 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
136 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
137 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
138 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
139 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
140 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
141 CLAIM_PROCESS_TYPE_ID BIGINT 8
142 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
143 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
144 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
145 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
146 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
147 FLEET_IND CHARACTER VARYING(9) 9
148 CAS_IND CHARACTER VARYING(7) 7
149 CCR_CC_CLAIM_LOSSDATE DATE 4
150 CI_LARGE_LOSS_FLAG CHARACTER VARYING(3) 3
151 CCR_CCTL_SC_LINEOFBUSINESS_NAME CHARACTER VARYING(256) 256
152 POLICYNUMBER CHARACTER VARYING(40) 40
153 ADDITIONAL_COST_INCURRED_IND CHARACTER VARYING(3) 3
154 RECTIFICATION_METHOD CHARACTER VARYING(512) 512
155 ALLEGED_RESPONSIBLE_PARTY CHARACTER VARYING(512) 512
156 ISSUE_ASSIGNED_TO_USER_ID BIGINT 8
157 ISSUE_ASSIGNED_TO_USER_NAME CHARACTER VARYING(181) 181
158 ISSUE_ASSIGNED_TO_TEAM_ID BIGINT 8
159 ISSUE_ASSIGNED_TO_TEAM_NAME CHARACTER VARYING(100) 100
160 ISSUE_LODGED_BY_USER_ID BIGINT 8
161 ISSUE_LODGED_BY_USER_NAME CHARACTER VARYING(181) 181
162 ISSUE_LODGED_BY_TEAM_ID BIGINT 8
163 ISSUE_LODGED_BY_TEAM_NAME CHARACTER VARYING(100) 100
164 ISSUE_TYPE_DESCRIPTION CHARACTER VARYING(512) 512
165 RECOMMENDED_REPAIRER_IND CHARACTER VARYING(3) 3
166 ISSUE_RECTIFIED_IND CHARACTER VARYING(3) 3
167 ISSUE_AGE_ELAPSED_DAYS INTEGER 4
168 ESTIMATED_RECTIFICATION_COST NUMERIC(18,2) 19
169 LODGEMENT_DATE DATE 4
170 QUALITY_ISSUE_REPAIRER_NAME CHARACTER VARYING(120) 120
171 QUALITY_ISSUE_RECOMMENDED_REPAIRER_IND CHARACTER VARYING(3) 3
172 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
173 LEGACY_CLAIM CHARACTER VARYING(3) 3
174 LEGACY_TYPE CHARACTER VARYING(256) 256