ID (KPI identifier)

M

To be published in “2024.012”

GRAMMAR

KPI name

M

Average Carriervisit Turnaround Time

GRAMMAR

KPI type

M

OperationalPerformance

GRAMMAR

All kinds of carriers are considered in the carrier definition

O

average time at terminal, average time at berth (for a vessel), average visit time, average service time

TIC Description

M

The average time spent by a carrier in the terminal area for picking and/or dropping a cargo.

TIC Description

O

This KPI refers to the total time a carrier (vessel, truck, train, etc.) spends during drop-off and/or picking-up activities depending on terminal operations. It represents the average time per carrier that the carrier spends within the terminal premises under the control of the terminal itself.

When this KPI is related to trucks, the starting point has been considered the completion of the gate-in (Arrival https://tic40.atlassian.net/wiki/x/14CeOw ) process at the terminal, and the endpoint for time calculation has been considered the completion of the gate-out (Departurehttps://tic40.atlassian.net/wiki/x/14CeOw ) process at the terminal.

When this KPI is related to vessels, the starting point is located at the beginning of the mooring process upon arrival (Arrival Mooring firstline), and the duration will be delimited by the end of the unmooring process during departure (Departure Mooring lastline).

When this KPI is related to rail, the starting point is located at the end of the arrival process upon arrival (Arrival ), and the duration will be delimited by the end of the start of the departure process (Departure).

The arrival process of a truck includes a part that transits inside the terminal before arriving at the transfer point. The Vessel is no longer sailing as far as one line is connected with the berth. And rail is usually considered inside the terminal when is at the transfer area.

For this KPI related to a terminal with vessels and trucks train:…

Datapoints:

For trucks:

tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual|timestamp

tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|actual|timestamp

number of truck visits = COUNT(tos|@|carriervisit|@|type=truck)

For vessels:

tos|@|carriervisit|@|arrival|@|mooring|@|firstline|time|actual|timestamp

tos|@|carriervisit|@|departure|@|mooring|@|lastline|time|actua|timestamp

number of vessels visits = COUNT(tos|@|carriervisit|@|type=vessel)

For train:

tos|@|carriervisit|@|arrival|@|end|time|actual|timestamp

tos|@|carriervisit|@|departure|@|start|time|actual|timestamp

number of train visits = COUNT(tos|@|carriervisit|@|type=vessel)

Operator:

for trucks (SUM(tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|actual|timestamp) - tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual|timestamp)) / (COUNT(tos|@|carriervisit|@|type=truck))

for vessels: (SUM(tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual|timestamp) - tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual|timestamp)) / (COUNT(tos|@|carriervisit|@|type=vessel))

for train (SUM(tos|@|carriervisit|@|arrival|@|end|time|actual|timestamp) - (tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual|timestamp)) / (COUNT(tos|@|carriervisit|@|type=truck))

Unit: minutes, hours

KPI Elements:

Timeframe: month 2024-01-01T00:00:00.000Z - 2024-01-31T23:59:00.000Z

Filter: tos|@|carriervisit|@|id|

Split: per vesseloperator, per truckoperator

Bucket: per berth, per flowtype

TIC Description

M

trucks:

tos|@|carriervisit|@|arrival|@|terminalgate|@|end|time|actual|timestamp

tos|@|carriervisit|@|departure|@|terminalgate|@|end|time|actual|timestamp

vessels:

tos|@|carriervisit|@|arrival|@|mooring|@|firstline|time|actual|timestamp

tos|@|carriervisit|@|departure|@|mooring|@|lastline|time|actual|timestamp

trains:

tos|@|carriervisit|@|arrival|@|end|time|actual

tos|@|carriervisit|@|departure|@|start|time|actual

TIC Description

terminal, Berth, carrier,

minute, hour

O

TIC Description

O

https://tic40.atlassian.net/l/cp/ZpGsxYZa, CarrierVisit, TerminalGate, Mooring , Arrival , Departure, Carrier

TIC Description

M

Determining the Average Carrier Turnaround Time of each vessel that has been operated at berth #1 in January 2024, differentiated by vessel operator.

TIC Description

M

Datapoints:

For vessel:

tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual|timestamp

tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual|timestamp

number of vessels visits = COUNT(tos|@|carriervisit|@|type=vessel)

Operator: for vessels: (SUM(tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual|timestamp) - (tos|@|carriervisit|@|arrival|@|mooring|@|lastline|time|actual|timestamp))/(SUM(tos|@|carriervisit|@|type=vessel))

Unit: Hours

Filter: tos|@|carriervisit|@|arrival|@|working|logical|qualifier=berth|qualifierid=#1

Timeframe: month 2024-01-01T00:00:00.000Z - 2024-01-31T23:59:00.000Z

Split: per vesseloperator

Bucket: per month

TIC Description

M

average turnaround, average carrier turnaround time, average vessel turnaround time, average truck turnaround time

Technical

M

20240430

Technical

M

R0.1

Technical

Created by

Edited by

Review / Approve

Published

Valenciaport Foundation Gonzalo Sandiás

Francisco Blanquer Jaraiz Gonzalo Sandiás Corbillón, Jorge Melero