Reporting data objects

Description

All certificates for employees

Usage examples

Overview of all certificates that are:

·         available

·         about to expire

Location in RailCube

Description

The wagons that are in an order (either created manually or received via ECN)

Usage examples

Overview of orders for which a specific wagon has been used

Location in RailCube

Description

All orders (either created manually or received via ECN)

Usage examples

Overview of orders carried out

·         Per client

Location in RailCube

Description

All complementary certificates that are owned by train drivers

Usage examples

Overview of complementary certificates that have been obtained in the last months

Location in RailCube

Description

Contracts belonging to leased or rented out locomotives and wagons

Usage examples

Overview of locomotives

·         leased per supplier

·         rented out

Location in RailCube

Description

Costs specified on a transport

Usage examples

Location in RailCube

Description

List of all available countries

Usage examples

Used as data source for (filter) parameters

Location in RailCube

Description

Registered DailyChecks for locomotives

Usage examples

·         Get usage information about locomotives

·         Insight in which employees are performing these checks

Location in RailCube

Description

Registered Defects for wagons and locomotives

Usage examples

·         KPI’s about problems with locomotives

·         Usability for wagons

Location in RailCube

Description

All defect codes that can be registered to wagons and locomotives

Usage examples

Use as filter to find wagons which have brake out of order

Location in RailCube

Description

Remarks that have been added to a defect

Usage examples

To see the frequently added remarks to a defect

Location in RailCube

Notes

Child table, can only be used in combination with table Defect

Description

Employee duties

Usage examples

·         Calculate the amount of hours per employee

·         Get number of hotel reservations in a period

Location in RailCube

Open

One row per duty.

For example :

·         1 duty with 3 activities will generate 1 rows

·         1 duty without activities will generate 1 rows

Description

List of all activities used in duties, both transport and custom activities

Usage examples

To calculate total amount of hours used for a project or client.

Total hours worked on a project per employee

Location in RailCube

Open

 For example :

·         1 duty with 3 activities will generate 3 rows

·         1 duty without activities will generate 0 rows

Description

Remarks that have been added to a duty

Usage examples

To see the remarks that are added to a duty by a planner

Location in RailCube

Notes

Child table, can only be used in combination with table Duty

Description

Activities that are planned on duties

Usage examples

Overview of activities planned on duties

Location in RailCube

Notes

Child table, can only be used in combination with Duty (this is the only difference with DutyActivities)

Description

Employee types / job titles used within the company

Usage examples

To filter employees based on the employee type

Location in RailCube

Description

List of all available employees

Usage examples

Used as data source for (filter) parameters

Location in RailCube

Description

Registered Fuels for locomotives

Usage examples

·         KPI’s about usage of locomotives

·         Usability for locomotives

Location in RailCube

Description

Paths that are received by the infra manager (IM)

Usage examples

To compare the received paths with the requested paths

Location in RailCube

Description

All items on invoices

Usage examples

·         Total turnover per transport

·         Total turnover per client

Location in RailCube

Open

For example:

·         1 invoice with 3 items à 3 rows

·         1 invoice with 0 items à 0 rows

Description

Send invoices

Usage examples

·         See turn-over per client / RU

Location in RailCube

Description

Accepted labour law exceedances

Usage examples

·         Create hand out for the authorities

Location in RailCube

Description

Languages master by employees and reported in ID documents

Usage examples

Overview of employees that speak a certain language

Location in RailCube

Notes

Child table, can only be used in combination with Employee

Description

Indicates the infrastructure for which the train driver is authorized on the complementary certificate

Usage examples

Overview of authorized lines per employee

Location in RailCube

Notes

Child table, can only be used in combination with Employee

Description

Locations specified on the complementary certificate of a train driver

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with Employee

Description

List of all available locomotives

Usage examples

Used as data source for (filter) parameters

Location in RailCube

Description

Knowledge required per locomotive type

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with Locomotive (type)

Description

Locomotive used on transport detail level

Usage examples

·         Kilometers/distance per country

Location in RailCube

Open

·         One locomotive covering 4 parts of a transport à 4 rows

Description

Locomotive used on transport level

Usage examples

·         Locomotive usage for a client

·         Availability of locomotives

Location in RailCube

Open

·         One locomotive covering 4 parts of a transport à 1 rows

·         Includes ‘pause’ between route parts

Description

Locomotives assigned to transports as resource

Usage examples

Overview of which locomotives have been used in transports

Location in RailCube

Description

All maintenance performed on locomotives and wagons

Usage examples

Overview of maintenance executed last month

Location in RailCube

Description

 List of all available oders (named contract in the windows application)

Usage examples

 Used as data source for (filter) parameters

Location in RailCube

Description

Additional information on the complementary certificate

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with Employee

Description

Part of a transport that has been outsourced to another Railway Undertaker

Usage examples

Overview of outsourced transports in the last month

Location in RailCube

Description

List of all available projects

Usage examples

Used as data source for (filter) parameters

Location in RailCube

Description

Recurring transports defined on contract

Usage examples

Overview of the recurring transports required for each client

Location in RailCube

Description

Locomotive type required on recurring transports as defined on a contract

Usage examples

Overview of locomotive types required for a specific client

Location in RailCube

Description

List of all available relations/companies

Usage examples

Used as data source for (filter) parameters

Location in RailCube

Description

The complementary certificate contains the rolling stock for which the driver is authorized

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with Employee

Description

List of roster day type assigned to an employee

Usage examples

• Overview of day types assigned to an employee

• Counters of the day type

Location in RailCube

Description

 Not used ?

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with Roster

Description

The route details of a part of a transport

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with transport details

Description

Route knowledge assigned to an employee

Usage examples

Location in RailCube

Description

 Route knowledge assigned to an employee

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with RouteKnowledge (this is the only difference with RouteKnowledge)

Description

The details of a route template

Usage examples

Location in RailCube

Description

Train paths (used or not used)

Usage examples

·         Check usage of train paths

·         Costs of paths

Location in RailCube

Description

All route parts of all transports

Usage examples

·         Ton/km

·         Distance and/or time per country

·         Activity of client countries

Location in RailCube

Open

For example :

·         1 transport with 4 route parts will generate 4 rows

·         1 transport without route parts will generate 0 rows

Description

All logs corresponding to a transport

Usage examples

Location in RailCube

Description

 Transport railway undertaker

Usage examples

• KPI on outsourcing

• Outsourcing per Railway Undertaker

Location in RailCube

 Todo : screenshot of the Railway undertaker tab in the transport

Description

 Last known status of each transport

Usage examples

• KPI on the operational status of the transport

Location in RailCube

Description

 List of all the activities linked to the transport

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with TransportStatus

Description

 List of all the locomotives linked to the transport

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with TransportStatus

Description

 List of all the remarks linked to the transport

Usage examples

Location in RailCube

Notes

Child table, can only be used in combination with TransportStatus

Description

All tasks defined on a transport

Usage examples

Location in RailCube

Description

Transported dangerous goods

Usage examples

·         KPI on GEVI / UN level

·         Dangerous goods per country

Location in RailCube

Description

Transported goods

Usage examples

·         KPI on NHM level

·         Goods per country / client

Location in RailCube

Description

Transports

Usage examples

·         Get number of trains per client

·         Get number of trains per RU

·         Performance reports

·         NOT used for ton/km

Location in RailCube

Open

One row per transport.

For example :

·         1 transports with 1 route parts will generate 1 rows

·         1 transports with 6 route parts will generate 1 rows

Description

All actions performed related to a user

Usage examples

Location in RailCube

Description

Technical details off all wagons

Usage examples

·          Get all wagons from a certain type

Location in RailCube

Description

Wagon lists created in RailCube

Usage examples

Location in RailCube

Description

All changes made in technical details of wagons

Usage examples

·         Get all changes made by a specific user

·         Monitor made changes without the need to open each individual wagon

Location in RailCube

Description

Wagon used on transport detail level

Usage examples

·         Kilometers/distance per country

Location in RailCube

Open

·         One wagon covering 4 parts of a transport à 4 rows

Open

Description

 Last known position of each wagon

Usage examples

• KPI on the current position of the wagons

Location in RailCube

Description

Types of wagons

Usage examples

 Filter out wagons of certain types

Location in RailCube

Description

Wagon used on transport level

Usage examples

·         Wagon usage for a client

·         Availability of wagons

Location in RailCube

Open

·         One wagon covering 4 parts of a transport à 1 rows 

Description

 Wagon kilometer and ton.km usage : done with transport, single wagon (order without transport) or manually imported

Usage examples

• Wagon ton.km sum

• Wagon km sum

Location in RailCube

Screenshot of the wagon usage tab in the wagon