INT_PI_MOTOR_MILESTONES

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPAIR_AUTH_MONTH DATE 4
2 REPAIR_AUTH_YEAR BIGINT 8
3 PERIOD_DIMENSION CHARACTER VARYING(10) 10
4 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
5 CCR_CC_INCIDENT_ID BIGINT 8
6 CCR_CCTL_LOSSPARTYTYPE_NAME CHARACTER VARYING(256) 256
7 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
8 OP_LOB CHARACTER VARYING(16) 16
9 POLICY_TYPE CHARACTER VARYING(256) 256
10 LOSS_GROUP CHARACTER VARYING(15) 15
11 CCR_CCTL_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
12 CCR_CCTL_SC_LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
13 VEHICLE_STYLE CHARACTER VARYING(256) 256
14 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1
15 BOOKING_STATE CHARACTER VARYING(256) 256
16 CCR_CCX_SC_ASSESSMENTTOTALLOSS_REPLACEMENTVEHICLE INTEGER 4
17 REPORT_ONLY_FLAG CHARACTER VARYING(256) 256
18 CCR_CCTL_CLAIMSTATE_NAME CHARACTER VARYING(256) 256
19 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_NAME CHARACTER VARYING(256) 256
20 VEHICLE_PATH CHARACTER VARYING(24) 24
21 REPAIRER_LOCATION_TYPE CHARACTER VARYING(256) 256
22 VEHICLE_STYLE_GROUP CHARACTER VARYING(15) 15
23 ACCOUNTABILITY NATIONAL CHARACTER VARYING(100) 100
24 REPORT_DATE DATE 4
25 ASSESSMENT_PROCESS_TYPE CHARACTER VARYING(256) 256
26 CCR_CCTL_FAULTRATING_NAME CHARACTER VARYING(256) 256
27 CCR_CC_INCIDENT_SC_DAMAGEIND CHARACTER VARYING(1) 1
28 BOOKING_LOCATION CHARACTER VARYING(181) 181
29 BOOKING_LOCATION_TYPE CHARACTER VARYING(256) 256
30 CCR_CCTL_SC_VEHICLECOVERAGETYPE_NAME CHARACTER VARYING(256) 256
31 CAS_IND CHARACTER VARYING(7) 7
32 FLEET_IND CHARACTER VARYING(9) 9
33 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
34 LODGEMENT_DATE TIMESTAMP 8
35 REPAIR_AUTHORISED_DATE TIMESTAMP 8
36 REPAIRS_COMPLETED_DATE TIMESTAMP 8
37 VEHICLE_RETURNED_DATE TIMESTAMP 8
38 SUBROCLOSEDATE DATE 4
39 CLAIM_CLOSE_DATE TIMESTAMP 8
40 FIRST_VEHICLE_ARRIVED_TIME TIMESTAMP 8
41 LAST_VEHICLE_ARRIVED_TIME TIMESTAMP 8
42 VEHICLE_ARRIVED_FREQ NUMERIC(38,0) 19
43 FIRST_VEHICLE_COLLECTED_TIME TIMESTAMP 8
44 LAST_VEHICLE_COLLECTED_TIME TIMESTAMP 8
45 VEHICLE_COLLECTED_FREQ NUMERIC(38,0) 19
46 FIRST_REPAIR_COMPLETED TIMESTAMP 8
47 LAST_REPAIR_COMPLETED TIMESTAMP 8
48 FIRST_CASH_SETTLEMENT_SUBMITTED TIMESTAMP 8
49 LAST_CASH_SETTLEMENT_SUBMITTED TIMESTAMP 8
50 FIRST_CASH_SETTLEMENT_AUTHORISED TIMESTAMP 8
51 LAST_CASH_SETTLEMENT_AUTHORISED TIMESTAMP 8
52 FIRST_CASH_SETTLEMENT_FULFILLED TIMESTAMP 8
53 LAST_CASH_SETTLEMENT_FULFILLED TIMESTAMP 8
54 FIRST_ISSUERAISEDDATE TIMESTAMP 8
55 LAST_COMPLETIONDATE TIMESTAMP 8
56 ISSUE_FREQ BIGINT 8
57 FIRST_COMPLAINT_DATE TIMESTAMP 8
58 LAST_RESOLUTION_DATE TIMESTAMP 8
59 COMPLAINT_FREQ BIGINT 8
60 READY_ASSESSMENT_CREATEDATE TIMESTAMP 8
61 READY_ASSESSMENT_CLOSEDATE TIMESTAMP 8
62 READY_ASSESSMENT_FREQ BIGINT 8
63 FIRST_BOOKING_CREATED_TIME TIMESTAMP 8
64 FIRST_APPOINTMENT_TIME TIMESTAMP 8
65 LAST_BOOKING_CREATED_TIME_EXCPT_REINSP TIMESTAMP 8
66 LAST_APPOINTMENT_TIME_EXCPT_REINSP TIMESTAMP 8
67 LAST_REINSP_APPOINTMENT_TIME TIMESTAMP 8
68 BOOKING_FREQ BIGINT 8
69 ORIGINAL_ECD TIMESTAMP 8
70 CURRENT_ECD TIMESTAMP 8
71 FIRST_SUPP_AUTHORISED TIMESTAMP 8
72 LAST_SUPP_AUTHORISED TIMESTAMP 8
73 FIRST_SUBLET_AUTHORISED TIMESTAMP 8
74 LAST_SUBLET_AUTHORISED TIMESTAMP 8
75 FIRST_EXCESS_PAYMENT_TIME TIMESTAMP 8
76 LAST_EXCESS_PAYMENT_TIME TIMESTAMP 8
77 EXCESS_FREQ BIGINT 8
78 TOTAL_EXCESS_RECEIVED NUMERIC(38,2) 19
79 FIRST_TL_SUBMITTED TIMESTAMP 8
80 LAST_TL_SUBMITTED TIMESTAMP 8
81 FIRST_TL_APPROVED TIMESTAMP 8
82 LAST_TL_APPROVED TIMESTAMP 8
83 FIRST_TL_FULFILLED TIMESTAMP 8
84 LAST_TL_FULFILLED TIMESTAMP 8
85 FIRST_RENTALBEGINDATE TIMESTAMP 8
86 LAST_RENTALENDDATE TIMESTAMP 8
87 FIRST_QUOTE_SUBMITTED TIMESTAMP 8
88 LAST_QUOTE_SUBMITTED TIMESTAMP 8
89 FIRST_QUOTE_AUTHORISED TIMESTAMP 8
90 LAST_QUOTE_AUTHORISED TIMESTAMP 8
91 INVOICEDATE TIMESTAMP 8
92 INVOICE_TOTALAMOUNT NUMERIC(38,2) 19
93 FIRST_INVESTIGATION_DATE TIMESTAMP 8
94 LAST_INVESTIGATION_DATE TIMESTAMP 8
95 INVESTIGATION_FREQ NUMERIC(38,0) 19
96 FIRST_TOWING_CREATETIME TIMESTAMP 8
97 LAST_TOWING_UPDATETIME TIMESTAMP 8
98 LAST_TOW_COMPANY CHARACTER VARYING(120) 120
99 TOWING_FREQ BIGINT 8