Calculated Fields: Shipment Manager

Calculated fields are fields whose content consists of information aggregated from several other fields. They are used on the following finders and finder results: Driver Manager, Equipment Manager and Shipment Manager.

The following properties let you define your use of calculated fields:

• glog.server.derived.derivedata.calculable_fields_limit: controls the number of calculated fields on a finder. The more calculated fields on a finder, the more performance will be impacted.
• glog.server.derived.derivedata.filterable_fields_limit: limits the number of calculated fields that are filterable. The larger the number, the more performance will be impacted.
• glog.server.derived.deriveddata.filterable_pks_limit: limits the number of primary keys (PKs) that can come in as an input to be further filtered by the derived data filters.

Following are some of the calculated fields on the Shipment manager along with descriptions.

Shipment Manager Calculated Fields

• First Freight Equipment ID: This gives the first Equipment with is_freight = 'Y'. First Freight Equipment ID represents the First Equipment ID on the shipment that carries the freight on the shipment.
• First Freight Equipment Type ID: This gives the equipment type of the first equipment having is_freight =  'Y'. First Freight Equipment Type ID represents the Equipment Type ID on the shipment that carries the freight on the shipment .
• Total Distance: Shipments where the total distance is within x miles.
• Bobtail Distance: Shipments where the bobtail distance is within x miles.
• Deadhead Distance: Shipments where the deadhead distance is within x miles.
• Total Direct Distance: The sum of direct distance for all the orders on this shipment.
• Base Work Done: The sum of the weighted distance for every order in such a way where the Total Weight is multiplied by the Direct Distance traveled by the order. For each order, the Total Weight is determined by adding the order's product weight to its Tare Weight (the inherent weight of the equipment being used). The Tare Weight is specifically defined as the weight of the equipment plus the weight of the power unit if equipment is semi-trailer. 

  Note: If equipment is semi-trailer and power unit is not defined, then weight of default power unit is considered during Tare Weight calculation.

• Actual Work Done: This calculates the total weighted distance for all orders by summing the Order Running Weight multiplied by the Distance Traveled by the order where Distance Traveled by the order defines the distance from previous stop (a field on shipment stop table). The Order Running Weight (at a stop) represents the current load being moved between stops. It is determined by taking the running weight from the previous stop and adjusting it by adding the combined weight of ship units loaded at the current stop and subtracting the combined weight of ship units dropped at the current stop.

  Note: For the first stop of a shipment, the tare weight of the equipment is also added to the initial running weight.

• Multistop Improvement Percentage: It is first calculated by determining the difference between the Base Work Done and the Actual Work Done. This difference is then divided by the Base Work Done and multiplied by 100 to express the improvement as a percentage.
• Number of Pickup Stops: The count of the number of stops on a shipment that are a pickup stop.
• Number of Delivery Stops: The count of the number of stops on a shipment that are a pickup stop.
• Number of NFR Stops: The count of the number of stops on a shipment that are neither a pickup, dropoff nor both; stops for which there are no associated shipment ship units.
• Pre-Freight Empty Equipment Type Dropoff Assignment State: The options are:
  • Not Required: If 'Move-Empty' or 'Check Inventory' special service does not exist.
  • Required: If 'Move-Empty' or 'Check Inventory' special service exists, but equipment type for this move is still not assigned.
  • Assigned: 'Move-Empty' or 'Check Inventory' special service exists and required equipment type is already assigned. It is the same as having PREV_DROP_INVENTORY_PROCESSED field on the shipment set to 'Y'.
• Pre-Freight Empty Equipment Type Pickup Assignment State: The options are:
  • Not Required: If 'Move-Empty' or 'Check Inventory' special service does not exist.
  • Required: If 'Move-Empty' or 'Check Inventory' special service exists, but equipment type for this move is still not assigned.
  • Assigned: 'Move-Empty' or 'Check Inventory' special service exists and the required equipment type is already assigned. It is the same as having PICKUP_INVENTORY_PROCESSED field on the shipment set to 'Y'.
• Freight Equipment Type Assignment State: The options are:
  • Not Required: IS_FREIGHT move does not exist (S_EQUIPMENT.IS_FREIGHT set to N).
  • Required: If IS_FREIGHT move exists, it can be identified by S_EQUIPMENT.IS_FREIGHT set to Y, but equipment type for this move is still not assigned.
  • Assigned: Equipment Type assigned to FREIGHT MOVE, it can be identified by S_EQUIPMENT.IS_FREIGHT set to Y and S_EQUIPMENT.EQUIPMENT_TYPE_GID is not null.
• Post-Freight Empty Equipment Type Dropoff Assignment State: The options are:
  • Not Required: If 'Move-Empty' or 'Check Inventory' special service does not exist.
  • Required: If 'Move-Empty' or 'Check Inventory' special service exists, but equipment type for this move is still not assigned.
  • Assigned: 'Move-Empty' or 'Check Inventory' special service exists and the required equipment type is already assigned. It is the same as having DROPOFF_INVENTORY_PROCESSED field on the shipment set to 'Y'.
• Target Location ID and Destination Distance to Target Location enable you to filter search results for all shipments that have a destination located within x miles of the target location. For example, if you were looking for ship to addresses within 10 miles of King of Prussia, you would enter the ID for King of Prussia in the Target Destination ID field and 0 in the first Destination Distance to Target Location field and 10 in the second. You can choose miles or kilometers. The results would then be limited to all shipments with destinations located within 10 miles of the target location.
• Driver's Next Assignment Location ID: This filters drivers by their next available assignment location.

  Note: This field must be specified to use any of the following calculated filtering criteria fields.

• Proximity to Drivers Next Assignment Location ID: Filters shipments with drivers who's next assignment location is within a certain radius of a specific location, for example, between 10 and 20 miles from Philadelphia meaning, not less than 10 but no more than 20 miles from Philadelphia.
• Date at Drivers Next Assignment Location ID: Filters shipments with drivers who's next assignment is within a certain date range. All the assignments of a driver must fall within the specified date range.
• Pickup Duration to Drivers Next Assignment Location ID: This is the time spent at the location determined by the Drivers Next Assignment Location ID (see above) and the shipment start time of the next assignment.
• Category Cost: For the Primary Category Cost, the Secondary Category Cost and the Tertiary Category Cost, the parameter defined in parameter sets, and/or specified as input into certain planning actions is used to determine costs sets, or groups of user defined costs used to rate the shipment in question, either Regular or Weighted costs, that are grouped and totaled into one of three buckets: primary, secondary and tertiary. Secondary and tertiary costs are informational only in that there is no business logic tied to them. They are meant to represent additional qualitative cost information, such as deadhead vs bobtail miles, as an example that you can leverage to make qualitative driver assignment decisions. In this case, shipments can be searched for based on these three values/ranges.
• Total Wait Time: The sum of wait times across all stops for all orders aggregated onto the shipment.
• Total Rest Time: The sum of rest times across all stops for all orders aggregated onto the shipment.
• Total Activity Time: The sum of all activity times across all stops for all orders aggregated onto the shipment.
• Stem Distance: The distance traveled between first delivery stop and the pickup stop right before it on a multi-stop shipment.
• Empty Distance: The distance traveled by the equipment without carrying any items
• Empty Distance Percentage: Calculated by dividing the Empty Distance (the sum of Bobtail and Deadhead miles) by the Total Distance traveled by the shipment (empty distance plus loaded distance), and then multiplying the result by 100.
• Maximum Distance Between Stops: The maximum distance traveled between a pair of consecutive stops in a multi-stop shipment.
• Maximum Distance Between Pickups: The maximum distance traveled between a pair of consecutive pickup stops in a multi-stop shipment.
• Maximum Distance Between Deliveries: The maximum distance traveled between a pair of consecutive dropoff stops in a multi-stop shipment.
• Weight Utilization Percentage: Calculated by dividing the Actual Load Weight of the shipment by the Maximum Allowable Weight Capacity of the equipment, and then multiplying the result by 100.
• Volume Utilization Percentage: Calculated by dividing Total Volume of the freight loaded onto the equipment by the Maximum Available Volume Capacity of that equipment, and then multiplying the result by 100.
• Equipment Reference Unit Utilization Percentage: Calculated by dividing the total number of Equipment Reference Units (ERU) required by the shipment by the maximum number of ERUs that the equipment can physically accommodate, and then multiplying the result by 100.