| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
aisMatchFlag |
boolean |
|
Indicates AIS data are matched by port to that provided by the Lines |
|
aisPortArrivalDate |
dateTime |
|
Date of arrival at Port from matched AIS data (in UTC time zone) |
|
aisPortDepartureDate |
dateTime |
|
Date & Time of departure from Port from matched AIS data (in UTC time zone) |
|
anchorageArrival |
dateTime |
|
Date & Time of arrival at anchorage zone from matched AIS data (in UTC time zone) |
|
anchorageArrivalFlag |
boolean |
|
Indicates anchorage arrival date & time are available from AIS match |
|
anchorageDeparture |
dateTime |
|
Date & Time of departure from anchorage zone from matched AIS data (in UTC time zone) |
|
anchorageDepartureFlag |
boolean |
|
Indicates anchorage departure date & time are available from AIS match |
|
anchorageHours |
decimal{15,2} |
|
Number of hours that the vessel spent in anchorage zone |
|
anchorageName |
string(75) |
|
Anchorage zone name at which the vessel waited at before arriving at berth |
|
arrivalFlag |
boolean |
|
Indicates AIS data are matched by either port or anchorage to that provided by the Lines |
|
arrivalHours |
decimal{23,2} |
|
Derived estimated arrival hours at port using the earliest date between AIS port arrival and AIS anchorage zone arrival to berth arrival time. If the vessel call was unable to match to AIS data, an average arrival hour is calculated for the port. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
berthArrivalDate |
dateTime |
|
Date & Time of arrival at Berth in local time zone. For the measure of berth productivity, this is 'All lines fast'. |
|
berthDay |
string(3) |
|
Abbreviated day of the week on which the vessel arrived at berth. |
|
berthDayNumber |
long(1,7) |
|
Day of the week on which the vessel arrived at berth (local time zone). First day of the week is Monday |
|
berthDepartureDate |
dateTime |
|
Date & Time of departure from Berth in local time zone. For the measure of berth productivity, this is 'All lines fast'. |
|
berthHour |
long(0,24) |
|
Hour number on which the vessel arrived at berth. |
|
berthHours |
decimal{23,2} |
|
Total berth time between vessel all fast (all mooring Lines on bollards and tensioned) to last line released from the bollards |
|
callSizeRange |
string(13)* |
|
Category buckets of the quantity of container moves made per call |
|
craneHours |
decimal{15,2} |
|
The total number of crane hours for all cranes which operated on a vessel, between first and last lift per crane and without any stoppage time deductions. |
|
craneHoursFlag |
boolean |
|
Indicates gross crane operating hours are available |
|
estimatedArrivalDate |
dateTime |
|
Derived estimated arrival time at port using the earliest date between AIS port arrival and AIS anchorage zone arrival. If the vessel call was unable to match to AIS data, an estimated arrival date is calculated from the average number hours between port arrival and berth for the port. |
|
finishHours |
decimal{23,2} |
|
Total time between last container move (lift) and last line released |
|
finishHoursFlag |
boolean |
|
Indicates dates/times for the last container move for a port call are available |
|
firstLiftDate |
dateTime |
|
Date & Time of First Lift or Move in local time zone. (This is the Operation Start Date).The first move might be either a container, gear-box or hatch-cover |
|
firstLineFast |
dateTime |
|
Date and Time stamp for the first line that has been fast to the ship |
|
isActive |
boolean |
|
Indicates the record is active |
|
iso2 |
string(2) |
|
Standardized UN ISO2 country code if applicable |
|
iso3 |
string(3) |
|
Standardized UN ISO3 country code if applicable |
|
lastLiftDate |
dateTime |
|
Date & Time of Last Lift/Move in local time zone. (This is the Operation End Date). The last move might be either a container, gear-box or hatch-cover |
|
lastUpdateDate |
dateTime* |
|
Date and Time of the last update applied to any of the data contained within the record. |
|
month |
string(30) |
|
Month number, based on departure from berth |
|
onOffScheduleFlag |
string(3) |
|
On Schedule is when actual arrival day/time versus pro-forma schedule day/time is within 6 hours (agreed berth window or contractual berth window). Off Schedule is when actual arrival day/time versus pro-forma schedule day/time is greater than 6 hours. |
|
operatingHours |
decimal{23,2} |
|
Total operating time between the recorded first and last move time stamps |
|
operatingHoursFlag |
boolean |
|
Do we have the dates/times for the first and last container moves for a port call |
|
portHours |
decimal{23,2} |
|
Total port hours consumed (based on AIS arrival to the IHS mapped port limits or anchorage out where anchorage time was recorded to departure berth) |
|
quarter |
string(6)* |
|
Year and Quarter in the format 'YYYYQQ' |
|
reasonForCraneDelay |
string(20) |
|
Reason for crane delays categorized by Force Majeure, Ship Inspired, or Terminal Inspired. |
|
regionCode |
string(3) |
|
Code for the geographic region of the port |
|
regionName |
string(30) |
|
Full name of the geographic region of the port |
|
sailToDepartureHours |
decimal{23,2} |
|
Total hours for all calls within this category between last line released and departure port |
|
shipLoaRange |
string(15) |
|
Category buckets of a ship’s capacity based on length overall |
|
shipSizeRange |
string(15)* |
|
Category buckets of a ship’s capacity based on nominal TEU |
|
startHours |
decimal{23,2} |
|
Total time between all lines fast and first container move (lift) |
|
startHoursFlag |
boolean |
|
Indicates dates/times for the first container move for a port call are available |
|
territoryName |
string(50)* |
|
Full name of the territory of the port |
|
teusDischarged |
long(0,100000) |
|
The number of containers that have been loaded on the subject vessel |
|
teusDischargedAndLoaded |
long(0,100000) |
|
The number of containers that have been loaded and discharged on the subject vessel |
|
teusLoaded |
long(0,100000) |
|
The number of containers that have been discharged from the subject vessel |
|
totalMoves |
long(0,100000) |
|
Container moves (discharge+load+restow) - Ones that the carrier requested; chargeable container moves. A restow move within the same bay counts as 1 move, whereas a container being restowed via the pier/yard counts as 2 moves. Excludes hatch-covers, bins and convenience restowes. |
|
utcBerthArrivalDate |
dateTime |
|
Date & Time of arrival at Berth in UTC time zone. For the measure of berth productivity, this is 'All lines fast'. |
|
utcBerthDepartureDate |
dateTime |
|
Date & Time of departure from Berth in UTC time zone. For the measure of berth productivity, this is 'All lines fast'. |
|
utcFirstLiftDate |
dateTime |
|
Date & Time of First Lift or Move in UTC time zone. (This is the Operation Start Date).The first move might be either a container, gear-box or hatch-cover |
|
utcLastLiftDate |
dateTime |
|
Date & Time of Last Lift/Move in UTC time zone. (This is the Operation End Date). The last move might be either a container, gear-box or hatch-cover |
| filter_list |
year |
long(2015,2100) |
= |
Year number, based on departure from berth |
| filter_list |
yearMonth |
string(7)* |
= |
Year and Month numbers concatenated together in the format 'YYYY-M' |