INT_PI_MOTOR_INCIDENT_EVENT_DETAILS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_INCIDENT_CLAIMID INTEGER 4
2 CCR_CC_INCIDENT_ID INTEGER 4
3 AUTH_CREATETIME TIMESTAMP 8
4 ECD_CHANGE_COUNT INTEGER 4
5 ORIGINAL_ECD TIMESTAMP 8
6 CURRENT_ECD TIMESTAMP 8
7 MAX_ARRIVAL_DATE TIMESTAMP 8
8 MAX_BOOKINGCANCELLED_DATE TIMESTAMP 8
9 ARRIVAL_DATE TIMESTAMP 8
10 MAX_TOTAL_LOSS_SUBMITTED_DATE TIMESTAMP 8
11 MAX_TOTAL_LOSS_CANCELLED_DATE TIMESTAMP 8
12 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
13 MAX_GLASSES_GUIDE_SEARCH_DATE TIMESTAMP 8
14 TOTAL_LOSS_CREATETIME TIMESTAMP 8
15 REPAIRS_COMPLETED_DATE DATE 4
16 VEHICLE_COLLECTED_DATE TIMESTAMP 8
17 VEHICLE_RETURNED_DATE TIMESTAMP 8
18 MAX_BOOKING_TARGET_TS TIMESTAMP 8
19 MAX_METRICEVENT_ID BIGINT 8
20 NO_SHOW INTEGER 4
21 MAX_QUOTE_REQUEST_TS TIMESTAMP 8
22 GLASS_ADDED_FLAG SMALLINT 2
23 MAX_TOTAL_LOSS_AUTH_CANCELLED_DATE TIMESTAMP 8
24 TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
25 REPAIRS_COMPLETED_DATETIME TIMESTAMP 8