| Name |
Type |
Mode |
| _serialnumber |
character varying |
IN |
| _startdate |
timestamp with time zone |
IN |
| _enddate |
timestamp with time zone |
IN |
| serialnumber |
character varying |
OUT |
| trip_starttime |
timestamp with time zone |
OUT |
| trip_endtime |
timestamp with time zone |
OUT |
| trip_duration_hours |
double precision |
OUT |
| trip_startlocation |
character varying |
OUT |
| trip_endlocation |
character varying |
OUT |
| movement_hours |
double precision |
OUT |
| stopped_hours |
double precision |
OUT |
| idling_hours |
double precision |
OUT |
| distance_km |
double precision |
OUT |
| speeding_count |
integer |
OUT |
| harshbreak_count |
integer |
OUT |