INT_PI_MOTOR_METRICS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 CCR_CCX_SC_AUTOMETRIC_VEHICLEINCIDENT BIGINT 8
3 INTRO_CALL_COMPLETED_DATE TIMESTAMP 8
4 VEHICLE_ARRIVAL_DATE TIMESTAMP 8
5 HIRE_CAR_DATE TIMESTAMP 8
6 VEHICLE_RETURNED_DATE TIMESTAMP 8
7 VEHICLE_REPAIR_COMPLETE TIMESTAMP 8
8 ORIGINAL_ECD TIMESTAMP 8
9 ASSESSMENT_OUTCOME_CALL_COMPLETED_DATE TIMESTAMP 8
10 VEHICLE_COLLECTED_DATE TIMESTAMP 8
11 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
12 FINAL_ECD_DATE TIMESTAMP 8
13 ECD_CHANGES_ON_DUE_DATE_COUNT BIGINT 8
14 ECD_CHANGES_COUNT BIGINT 8
15 MAX_TOTAL_LOSS_SUBMITTED_DATE TIMESTAMP 8
16 MAX_TOTAL_LOSS_CANCELLED_DATE TIMESTAMP 8
17 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
18 TOTAL_LOSS_CREATETIME TIMESTAMP 8
19 VEHICLE_COLLECTED_DATE_DERV TIMESTAMP 8