INT_PI_MOTOR_METHODS_BASED_ASSESSING_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_REGISTRATION CHARACTER VARYING(40) 40
36 CCR_CC_VEHICLE_YEAR BIGINT 8
37 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
38 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
39 CCR_CC_VEHICLE_VIN CHARACTER VARYING(40) 40
40 VEHICLE_STYLE CHARACTER VARYING(256) 256
41 COMBINED_COST_TYPE CHARACTER VARYING(10) 10
42 TOTAL_LOSS_SUBMITTED_DATE TIMESTAMP 8
43 TOTAL_LOSS_SUBMITTED_COST NUMERIC(18,2) 19
44 REPAIR_AUTHORISED_DATE DATE 4
45 REPAIR_AUTHORISED_DATETIME TIMESTAMP 8
46 SUPP_AUTHORISED_DATE TIMESTAMP 8
47 SUBLET_AUTHORISED_DATE DATE 4
48 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
49 BOOKING_DATE TIMESTAMP 8
50 NO_SHOW INTEGER 4
51 BOOKING_LOCATION_ABCONTACTID BIGINT 8
52 BOOKING_LOCATION CHARACTER VARYING(181) 181
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 ASSESSOR_PRIMARY_TEAM_CURRENT CHARACTER VARYING(100) 100
58 ASSESSOR_PRIMARY_TEAM_CURRENT_STATE CHARACTER VARYING(100) 100
59 ASSESSOR_PRIMARY_TEAM_CURRENT_REGION CHARACTER VARYING(100) 100
60 EXTERNAL_ASSESSOR_INDICATOR INTEGER 4
61 LOCATION_TYPE CHARACTER VARYING(256) 256
62 HUB CHARACTER VARYING(181) 181
63 ASSESSED_STATE CHARACTER VARYING(256) 256
64 REGION CHARACTER VARYING(8) 8
65 REPAIRER_NAME CHARACTER VARYING(181) 181
66 SUBLET_REPAIRER_NAME CHARACTER VARYING(60) 60
67 SUBLET_REPAIRER_STATE CHARACTER VARYING(60) 60
68 SUBLET_REPAIRER_REGION CHARACTER VARYING(60) 60
69 REPAIRER_ABCONTACT_ID BIGINT 8
70 PREFERRED_REPAIRER_INDICATOR SMALLINT 2
71 AUDANET_REPAIRER_FLAG CHARACTER VARYING(3) 3
72 AUDANET_QUOTE_FLAG CHARACTER VARYING(3) 3
73 AUDANET_CHECK_FLAG CHARACTER VARYING(10) 10
74 AUDANET_TRIGGERED_DATE DATE 4
75 CCR_CCX_SC_PNETQUOTE_QUOTSOFTWARE CHARACTER VARYING(20) 20
76 PNET_QUOTE_OUTCOME CHARACTER VARYING(256) 256
77 QUOTE_REQUEST_NUMBER CHARACTER VARYING(13) 13
78 QUOTE_TYPE CHARACTER VARYING(256) 256
79 QUOTE_METHOD CHARACTER VARYING(11) 11
80 QUOTE_AUTHORISED_FLAG CHARACTER VARYING(3) 3
81 QUOTELINE_CHECK_FLAG INTEGER 4
82 QUOTELINE_CHANGEIND CHARACTER VARYING(1) 1
83 QUOTELINE_ADJUSTMENT_FLAG CHARACTER VARYING(3) 3
84 QUOTELINE_ADJUSTMENT_AMOUNT NUMERIC(18,2) 19
85 ASSESSED_REPAIR_COST NUMERIC(18,2) 19
86 ORIGINAL_QUOTE_AMOUNT NUMERIC(18,2) 19
87 REPAIR_COMPONENT_TYPE CHARACTER VARYING(6) 6
88 QUOTELINE_NUMBER BIGINT 8
89 QUOTE_LINE_SEQUENCE BIGINT 8
90 QUOTELINE_QUANTITY INTEGER 4
91 PART_TYPE_NAME CHARACTER VARYING(256) 256
92 PART_TYPE_CODE CHARACTER VARYING(50) 50
93 PART_NUMBER CHARACTER VARYING(20) 20
94 PAINT_WORK_TYPE_NAME CHARACTER VARYING(256) 256
95 PAINT_WORK_TYPE_CODE CHARACTER VARYING(50) 50
96 LABOUR_TYPE_NAME CHARACTER VARYING(256) 256
97 LABOUR_TYPE_CODE CHARACTER VARYING(50) 50
98 SUBLET_MANAGEMENT_TYPE_NAME CHARACTER VARYING(256) 256
99 SUBLET_MANAGEMENT_TYPE_CODE CHARACTER VARYING(50) 50
100 SUBLET_TYPE CHARACTER VARYING(256) 256
101 SUB_TYPE_CATEGORY CHARACTER VARYING(10) 10
102 LINE_ITEM_DESCRIPTION CHARACTER VARYING(255) 255
103 NSP_OPINION_FLAG CHARACTER VARYING(3) 3
104 REPAIRS_COMPLETED_FLAG CHARACTER VARYING(3) 3
105 VEHICLE_ARRIVAL_EXCEPTION_FLAG CHARACTER VARYING(3) 3
106 REPAIR_COMPLETED_EXCEPTION_FLAG CHARACTER VARYING(3) 3
107 REPAIRS_COMPLETED_DATE TIMESTAMP 8
108 ORIGINAL_ECD TIMESTAMP 8
109 CURRENT_ECD TIMESTAMP 8
110 ECD_CHANGES INTEGER 4
111 INVOICE_DATE DATE 4
112 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE DATE 4
113 CCR_CCX_SC_PNETINVOICEITEM_AMOUNT NUMERIC(38,6) 19
114 INVOICE_COUNT BIGINT 8
115 CASH_SETTLEMENT_COST NUMERIC(38,2) 19
116 CASH_SETTLEMENT_VOLUME NUMERIC(38,0) 19
117 CASH_SETTLEMENT_ASSESSMENT_COMPLETION_DATE TIMESTAMP 8
118 VEHICLE_RETURNED_DATE TIMESTAMP 8
119 QUALITY_ISSUE_FLAG CHARACTER VARYING(3) 3
120 QUOTE_ASSESS_ARCHIVED_FLAG CHARACTER VARYING(3) 3
121 PNETQUOTE_SUBMITTED_TIME TIMESTAMP 8
122 PRIMARY_BOOKING_DATE DATE 4
123 PRIMARY_BOOKING CHARACTER VARYING(3) 3
124 TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
125 REPAIR_CUSTOMER_LIFE_END_DATE DATE 4
126 TOTAL_LOSS_CUSTOMER_LIFE_END_DATE DATE 4
127 SALVAGE_DATE_OF_SALE DATE 4
128 SALVAGE_RECEIVED_DATE DATE 4
129 SALVAGE_ACTUAL_AMOUNT NUMERIC(38,2) 19
130 SALVAGE_ACTUAL_NET NUMERIC(38,2) 19
131 SALVAGE_PROVIDER_NAME CHARACTER VARYING(256) 256
132 SALVAGE_ESTIMATED_AMOUNT NUMERIC(18,2) 19
133 CUSTOMER_LIFE INTEGER 4
134 REPAIRER_REGION CHARACTER VARYING(8) 8
135 REPAIRER_STATE CHARACTER VARYING(256) 256
136 REPAIRER_POSTALCODE CHARACTER VARYING(60) 60
137 REPAIRS_END_DATE DATE 4
138 ORIGINAL_ECD_DATE DATE 4
139 MAX_COMMIT_TIMESTAMP TIMESTAMP 8
140 LOCATION_REPAIR_TYPE_EXT_NAME CHARACTER VARYING(256) 256
141 REPAIRER_RELATIONSHIP_EXT_NAME CHARACTER VARYING(256) 256
142 TOTAL_LOSS_ARRIVAL_DATE TIMESTAMP 8
143 SUBROCLOSE_REASON CHARACTER VARYING(25) 25
144 SUBROCLOSEDATE DATE 4
145 SALVAGE_PERCENTAGE NUMERIC(33,0) 19
146 ACCOUNTABILITY CHARACTER VARYING(100) 100