(Start Date <= OTT Load Date <= End Date ) OR (Start Date <= OTT Discharge Date <= End Date) OR (Start Date >= OTT Load Date AND OTT Discharge Date >= End Date)

Mode

GSIS-sourced value for GSIS OTTs and corridor mode for corridor OTTs. For inland OTTs created automatically by ROCK (See RKEM Processing (CDS) for details), the system sets it to Auto, as the transport mode is normally not discernible in RKEM moves.

Operator

Same as in OTT schedules list. See Create/Edit an OTT

Same as in OTT schedules list. See Create/Edit an OTT

Vessel Name

Same as in OTT schedules list. See Create/Edit an OTT

Voyage

Same as in OTT schedules list. See Create/Edit an OTT

SRVC

Same as in OTT schedules list. See Create/Edit an OTT

Load Date

The Origin Arrival date/time (Origin ETA) as per the schedule selected for the OTT. Origin ETA is considered as the Load Date since this is the date/time where the empty equipment can be assumed out of stock, before Load operations have started, as the vehicle (vessel, truck, rail, etc.) has arrived the origin site. As soon as the system receives Actual Arrival from GSIS, it updates Load Date field with Actual. The field reads "OMIT" if the vessel is omitting the Origin Site.

Discharge Date

The Destination Departure date/time (Destination ETD) as per the schedule selected for the OTT. Destination ETD is considered as the Discharge Date since this is the date/time where the empty equipment can be safely assumed in stock, after Discharge operations have completed and the vehicle (vessel, truck, rail, etc.) has left the destination site. As soon as the system receives Actual Departure from GSIS, it updates Discharge Date field with Actual. The field has the value "OMIT" if the vessel is omitting the Destination Site.

Whether an OTT is displayed on the grid or filtered out is related to the equ figures on the OTT. If an OTT has any of S, A, L or D figures positive values on the equ nodes matching the user's equ filter selection on the Global Filter, the system shows that OTT on the grid.

The equ figures displayed on the grid, on the other hand, are closely related to OTT status:

1. If the OTT is in Suggested status, the equ figure cell displays S figure
2. If the OTT is in Approved status, the equ figure cell displays A figure
3. If the OTT is in Loaded status, the equ figure cell displays L figure
4. If the OTT is in Cancelled status;
   
   • If the OTT was in Suggested status before it was cancelled, the equ figure cell displays S figure
   • If the OTT was in Approved status before it was cancelled, the equ figure cell displays A figure
     

If the user has selected TEU groups on the Global Filter on the equ selected, the system displays equ figures on the TEU group(s) the user has selected instead of equ type/subtype columns

To the right hand side of the equ figure/TEU group columns, the system displays two columns displaying the total units and TEU volume on each OTT. Equipment types that start with 20 (e.g. 20DRY) are considered 1 TEU and the ones starting with 40 or 45 (e.g. 40DRY) are considered 2 TEU.

OTT Summary grid features a column which displays the value of Intermodal Status on corridor OTT. As the feeds to send OTTs to intermodal systems are not set up, the field reads "No" for all inland OTTs as of writing this.

OTT Summary grid features a column which displays the value of Load Order status on the OTT. See OTT States for details on this flag.

When the system displays the OTT summary grid, it features History expandable column which includes the date/time of the last update on the OTT when collapsed. When the user expands this column, the system displays six columns: Inserted By, Inserted On, Approved By, Approved On, Updated By, Updated On. For Update By and Updated On columns, note that the system always displays the latest human update, even if the last update on the OTT might have been done by the system.

When the user presses the button the system displays a pop up window suggesting the excel file download, using the browser's standard method. The excel export includes all the records matching the query on the grid (disregarding pagination) and all the columns currently visible on the grid. Example file below:

Rock_OTTSummaryExportToExcel_7d098bcf-8005-4a26-902f-9d2eb958d57d.xlsx

When the user presses the button the system displays a pop up window suggesting the excel file download, using the browser's standard method. The excel export includes all the OTTs matching the query on the grid (disregarding pagination) with the schedule columns, equ type, equ subtype, and columns for S, A, L, D figures for each OTT. Example file below:

Rock_OTTSummary_6364d617-b6df-4677-9d0b-a84e6c20438a.xlsx

If there is a GSIS OTT with vessel OMIT case, the system displays the OTT row with red Background color. See Reconciliation to read more on OMIT

If there is a GSIS OTT with vessel mismatch case, the system displays the OTT row with red Background color. See Reconciliation to read more on Mismatch