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