Dispatch Time Definitions: Difference between revisions

From KeystoneIntranet
Jump to navigation Jump to search
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 13: Line 13:
  ||  || Plant Wash || Loaded || ARTPLANT.PLANT_WASH_MINLD || min/ld || PLANT_WASH_MINLD: SMALLINT<BR>||
  ||  || Plant Wash || Loaded || ARTPLANT.PLANT_WASH_MINLD || min/ld || PLANT_WASH_MINLD: SMALLINT<BR>||
|-
|-
  || Leave Plant ||  ||  ||  ||  ||  DepartDT in Loads Table
  || Leave Plant ||  ||  ||  ||  ||  ||  DepartDT in Loads Table
|-
|-
  ||  || Transit Time || To Job || ARTZONETIME.TO_ZONE_MINLD || min/ld || TO_JOB_MINLD: SMALLINT<BR>
  ||  || Travel Time || To Job || ARTZONETIME.TO_ZONE_MINLD || min/ld || TO_JOB_MINLD: SMALLINT<BR>
|-
|-
  || Arrive Job ||  ||  ||  ||  ||  ||Schedule Time is Anchor<BR>for Time Calculations
  || Arrive Job ||  ||  ||  ||  ||  ||ScheduleDT.  This is the anchor for Time Calculations
|-
|-
  ||  || Waiting Time || Arrive || ARTPLANT.JOB_SETUP_MINLD<BR>ARTTRCLS.JOB_SETUP_MINLD || min/ld || JOB_SETUP_MINLD: SMALLINT<BR>
  ||  || Waiting Time || Arrive || ARTPLANT.JOB_SETUP_MINLD<BR>ARTTRCLS.JOB_SETUP_MINLD || min/ld || JOB_SETUP_MINLD: SMALLINT<BR>
Line 47: Line 47:
*Actual
*Actual
:Actual times recorded
:Actual times recorded
== Load Time Definitions ==
:ScheduleDT:
*When load is scheduled to ARRIVE on job site.  It is assigned when order is created, Load 1 is the Orders Time, the rest based on "Spacing/ Qty - LoadRate".  (more on LoadRate when you are ready)
:TargetReturnOffsetMinutes: 
*This measures how early or late a truck was the last time they changed status.  IF a truck was to depart plant at 10:05, but actually departs at 10:13 the Offset would be +8.
:StatusDT:
*Time truck entered the current status.  Updated with each status change.
:TargetDepartDT
*Scheduled Departure from plant.  (ScheduleDT - ToJobTravelTime)
:DepartDt
*Actual Leave Plant Time
:TargetReturnDT
*When truck should ARRIVE at plant.  calculated based on ScheduleDT + JobSetupTime+ Pour time + Return Travel Time.
:ReturnDt
*Actual Arrive Plant Time

Latest revision as of 17:58, 7 September 2023

Time Status and Interval For Disptatch

Status Time Interval Dispatch Status Default Source Calc Method Order Hd Field Comment
Ticket Time
Batch Time Ticketed ARTPLANT.BATCH_SETUP_MINLD
ARTPLANT.BATCH_LOAD_SECYD
min/ld+sec/yd BATCH_SETUP_MINLD: SMALLINT
BATCH_LOAD_SECYD: SMALLINT
BATCH_SETUP_MINYD +
((BATCH_LOAD_SECYD * {Load Size}) * 60)
Loaded Time
Plant Wash Loaded ARTPLANT.PLANT_WASH_MINLD min/ld PLANT_WASH_MINLD: SMALLINT
Leave Plant DepartDT in Loads Table
Travel Time To Job ARTZONETIME.TO_ZONE_MINLD min/ld TO_JOB_MINLD: SMALLINT
Arrive Job ScheduleDT. This is the anchor for Time Calculations
Waiting Time Arrive ARTPLANT.JOB_SETUP_MINLD
ARTTRCLS.JOB_SETUP_MINLD
min/ld JOB_SETUP_MINLD: SMALLINT
Begin Pour
Pour Pour DITUSECL.UNLOAD_RATE_SECYD
ARTTRCLS.UNLOAD_RATE_SECYD
sec/yd UNLOAD_RATE_SECYD SMALLINT/
INTERVAL (spacing) MINLD
ARTORDHD.UNLOAD_RATE_SECYD should
be Greater of (DITUSECL or ARTRCLS rate)
--- All Resulting Time
Calculations based on lesser of
ARTORDHD.UNLOAD_RATE_SECYD*QTY or
ARTORDHD.INTERVAL (spacing)
End Pour
Job Wash Wash ARTPLANT.JOB_WASH_MINLD min/ld JOB_WASH_MINLD: SMALLINT
Leave Job
Travel Time Return ARTZONETIME.TO_ZONE_MINLD min/ld FROM_JOB_MINLD: SMALLINT
Arrive Plant ReturnDT in Loads Table
In Yard


Time Definitions

  • Target
Times based on the load schedule time
  • Projected
Target times adjusted for the load offest (Target Return Offset). The offset is to be adjusted at each status change in the shipping process.
  • Actual
Actual times recorded

Load Time Definitions

ScheduleDT:
  • When load is scheduled to ARRIVE on job site. It is assigned when order is created, Load 1 is the Orders Time, the rest based on "Spacing/ Qty - LoadRate". (more on LoadRate when you are ready)
TargetReturnOffsetMinutes:
  • This measures how early or late a truck was the last time they changed status. IF a truck was to depart plant at 10:05, but actually departs at 10:13 the Offset would be +8.
StatusDT:
  • Time truck entered the current status. Updated with each status change.
TargetDepartDT
  • Scheduled Departure from plant. (ScheduleDT - ToJobTravelTime)
DepartDt
  • Actual Leave Plant Time
TargetReturnDT
  • When truck should ARRIVE at plant. calculated based on ScheduleDT + JobSetupTime+ Pour time + Return Travel Time.
ReturnDt
  • Actual Arrive Plant Time