maya.public

Parameters

Name	Type	Mode
_serialnumber	character varying	IN
_initdate	timestamp with time zone	IN
_enddate	timestamp with time zone	IN
serialnumber	character varying	OUT
senddate	timestamp with time zone	OUT
j1939_hiresodometer_delta	numeric	OUT
j1939_odometer_delta	numeric	OUT
j1708_odometer_delta	numeric	OUT
j1939_totalfuel_delta	numeric	OUT
j1708_totalfuel_delta	numeric	OUT
j1939_totalenginehours_delta	numeric	OUT
j1708_totalenginehours_delta	numeric	OUT
j1939_totalidlehours_delta	numeric	OUT
j1708_totalidlehours_delta	numeric	OUT
j1939_hiresodometer	double precision	OUT
j1939_odometer	double precision	OUT
j1708_odometer	double precision	OUT
j1939_totalfuel	double precision	OUT
j1708_totalfuel	double precision	OUT
j1939_totalenginehours	double precision	OUT
j1708_totalenginehours	double precision	OUT
j1939_totalidlehours	double precision	OUT
j1708_totalidlehours	double precision	OUT

Definition

/* Function to support SAC agents and technical support to get a look at the low level details regarding unit's ECM generated dat */
SELECT
        serialnumber,
        senddate,
        (max(j1939_hiresodometer) over w - min(j1939_hiresodometer) over w)::numeric(15,2) as j1939_hiresodometer_delta,
        (max(j1939_odometer) over w - min(j1939_odometer) over w)::numeric(15,2) as j1939_odometer_delta,
        (max(j1708_odometer) over w - min(j1708_odometer) over w)::numeric(15,2) as j1708_odometer_delta,
        (max(j1939_totalfuel) over w - min(j1939_totalfuel) over w)::numeric(15,2) as j1939_totalfuel_delta,
        (max(j1708_totalfuel) over w - min(j1708_totalfuel) over w)::numeric(15,2) as j1708_totalfuel_delta,
        (max(j1939_totalenginehours) over w - min(j1939_totalenginehours) over w)::numeric(15,2) as j1939_totalenginehours_delta,
        (max(j1708_totalenginehours) over w - min(j1708_totalenginehours) over w)::numeric(15,2) as j1708_totalenginehours_delta,
        (max(j1939_totalidlehours) over w - min(j1939_totalidlehours) over w)::numeric(15,2) as j1939_totalidlehours_delta,
        (max(j1708_totalidlehours) over w - min(j1708_totalidlehours) over w)::numeric(15,2) as j1708_totalidlehours_delta,
        j1939_hiresodometer,
        j1939_odometer,
        j1708_odometer,
        j1939_totalfuel,
        j1708_totalfuel,
        j1939_totalenginehours,
        j1708_totalenginehours,
        j1939_totalidlehours,
        j1708_totalidlehours
                FROM vw_dw_event_ecm
WHERE 
serialnumber = $1 AND senddate BETWEEN $2 AND $3 WINDOW w as (PARTITION BY serialnumber ORDER BY senddate);

ot_ro_ecm_rawdata(character varying, timestamp with time zone, timestamp with time zone)

Parameters

Definition