Introduction

As part of the ROCK project, a set of business rules was defined in its own workstream, together with "Agile Data Labs" team and business SMEs. The rules specify how to understand empty equipment states in the context of stock (i.e. empty at location, empty land transport, empty on vessel), and how to understand important empty equipment events (i.e. export pick-up, and import return). The business rules includes a number of move combinations that allows identifying these states and events and enables reconciliation of the numbers against the empty flow plans (i.e. OTTs). 

In addition to equipment events, the business rules also include the criteria to determine container statuses when they are part of stock (i.e. Sound/Damaged/Total Loss).

Contents


Mappings

Mapping of Equipment Types

ROCK

RKEM/RKST

Group

Type

Description

EQSIZE

EQTYPE

EQHEIGHT

EQPREFIX

20DRY*

20DRY

20'ft dry 8'6" (DC)

20

DRY

8 6

 

20HIGH

20'ft dry 9'6" (HC)

20

DRY

9 6

 

20PLWD

20'ft Palletwide

20

PLWD

8 6

 

20OPEN*

20OPEN

20'ft open top

20

OPEN

8 6

 

40DRY*

40DRY

40'ft dry 8'6" (HC)

40

DRY

8 6

 

40PLWD

40'ft Palletwide (8'6")

40

PLWD

8 6

 

40HIGH*

40HIGH

40'ft dry 9'6" (HC)

40

DRY

9 6

 

40HCPW

40'ft Palletwide (9'6")

40

PLWD

9 6

 

20FLAT*

2086FT

20'ft flat (8'6")

20

FLAT

8 6

 

20FLAT

20'ft flat (9'6")

20

FLAT

9 6

 

40FLAT*

40FLAT

40'ft flat rack (9'6")

40

FLAT

9 6

 

4086FT

40'ft flat rack (8'6")

40

FLAT

8 6

 

40OPEN*

40OPEN

40'ft open top (9'6")

40

OPEN

9 6

 

4086OT

40'ft open top (8'6")

40

OPEN

8 6

 

40TWDK*

40TWDK

CIMC rack for 53'ft

 

 

 

CICU

45HIGH*

45HIGH

45'ft dry (9'6")

45

DRY

9 6

 

45HCPW

45'ft palletwide (9'6")

45

PLWD

9 6

 

20REEF*

20REEF

20'ft reefer

20

REEF

9 6

 

20

REEF

8 6

 

40HCRF*

40HCRF

40'ft high cube reefer

40

REEF

9 6

 

40MGRF

40'ft reefer Magnum

40

REEF

9 6

MWMU

(eq. Number table)

40AFRF*

40AFRF

40'ft reefer AFAM+ (9'6")

40

REEF

9 6

(eq. Number table)

40XFRF*

40XFRF

40'ft reefer Xtend Fresh(9'6")

40

REEF

9 6

(eq. Number table)

40CASC*

40CASC

Starcare

40

REEF

9 6

MMAU

40CARF*

40CARF

Starfresh controlled Atmosphere

40

REEF

9 6

MCAU/MCHU
(eq. Number table)

40MSFU*

40SFRF

Super freezer

40

REEF

9 6

MSFU856/MSFU862

40SORT

Multiple door loader for super freezer

40

REEF

9 6

MSFU861

40STUF

1 door loader for super freezer

40

REEF

9 6

MSFU859


Additional Notes

Triangulation

ROCK calculates several different types of import/export levels. One of them is triangulation. This is a typical business scenario where Maersk makes coordination with a trucking company to ensure an empty container from an import customer is handed over directly to an export customer instead of dropping it at a Maersk depot in between; therefore avoids unnecessary repositioning and storage cost. When this happens, the container should count as 1 import return and 1 export pick up in ROCK. There is a table manually maintained in ROCK database, which lists which location to assign this case as import/export based on the pool/city code (sample file: LOCCY.zip)

This table is manually exported from RKST and imported into ROCK. ROCK uses this table to decide which site to add the import/export.

PLA

PLA stands for Positioning Leasing Agreement and means renting Maersk containers out to 3rd parties. This is similar to export/import, therefore the release of containers to 3rd parties is counted as export and reception of the container back from the 3rd parties is counted as import return in ROCK. 

Mapping of Container Condition

CONTAINER_CONDITION

SUBCONTAINER_CONDITION

DMGD

STREDEL

STSELSCR

OPR_IS_TTL

Sound

For Sale

?

N

Y

N

Total Loss

Total Loss

1

*

*

N

Sound

For Redelivery

2

Y

*

N

Damaged

Damaged

4

N

N

N

Sound

For Sale

4

N

Y

N

Sound

For Redelivery

3

Y

*

N

Sound

For Redelivery

4

Y

*

N

Sound

Sound

?

N

N

N

Total Loss

Total Loss

*

*

*

Y

Sound

For Sale

3

N

Y

N

Sound

For Redelivery

?

Y

*

N

Damaged

Damaged

3

N

N

N

Damaged

Damaged

2

N

N

N

Sound

For Sale

2

N

Y

N

? = NULL, * = anything, including NULL


Additional Notes

When ROCK displays today stock, it is the total number of containers that have condition as Sound + Damaged and excludes Total Loss. Note that the specific screen might or might not have Sound/Damaged/TTL split.

Condition

Sub-condition

Description

Sound

Sound

Containers that are not damaged and readily fit to use for export

For Redelivery

Containers that are rented from by 3rd parties, marked for redelivery in to the original owner in RKEM, but are still in the fleet. Depending on planned redelivery date and location, it could be possible to use these containers for export. The user makes this judgement.

For Sale

Containers that are marked in RKEM to be sold to 3rd parties. Depending on planned sale date and location, it could be possible to use these containers for export. The user makes this judgement.

Damaged

Damaged

Containers that are stated as damaged by RKEM

Total Loss

Total Loss

Containers that are marked in RKEM to be out-fleeted (e.g. scrapping) and cannot be used for exports anymore


Load/Discharge + Import/Export Mapping

The specific rules to deduct Load/Discharge and Import/Export events are documented in the technical manual for ROCK. The rules can be supplied on request to the development team.

Attachments:

SupplyDemand_StockOTTEntries.v3.1.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
LOCCY.zip (application/zip)
SupplyDemand_StockOTTEntries.v4.0.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
SupplyDemand_StockOTTEntries.v4.0.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
SupplyDemand_StockOTTEntries.v4.0.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
SupplyDemand_StockOTTEntries.v4.0.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
SupplyDemand_StockOTTEntries.v4.0.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)