TMS Issue Tracking - QA and Production

New AdHocREC value for Extra

Requester: The Linehaul Team

Request story: The linehaul team needs to be able to differentiate true adhoc bookings (loads that are created out of schedule, within 60 hours of the target ship date/time) from those that are imposed by a carrier problem (driver problem, asset problem, etc).

Solution: Proposed to add a new value option of “AdHocREC” (REC stands for Recovery) to the existing line up of values on the load’s reference field of “Extra”.

New line up of values for the load level reference of “Extra” are:

  • AdHoc24 Load creation date/time is <= 24 hours form date/time of target ship early
    Added care of a dynamic ruleset in MG at the time of load creation. Not available for manual entry

  • AdHoc48 Load creation date/time is > 24 hours and <= 48 hours form date/time of target ship early Added care of a dynamic ruleset in MG at the time of load creation. Not available for manual entry

  • AdHoc60 Load creation date/time is > 48 hours and <= 60 hours form date/time of target ship early Added care of a dynamic ruleset in MG at the time of load creation. Not available for manual entry

  • AdHocREC Recovery AdHoc requested/imposed by carrier (internal or 3rd party) To be added manually by user in the appropriate circumstance


Snowflake Changes: This request imposes no change to the TMS tables in Snowflake. The only change required on other platforms/dashboards/reports which feed off Snowflake’s Load Performance table is to account for the new value in the existing “Extra” field, should their logic depend on this field’s data.

(No team expressed logic dependency prior to implementation)

  • Kayvan Shadpour
  • Jan 7 2022
  • Resolved
  • Attach files
  • Kayvan Shadpour commented
    January 07, 2022 22:12

    Informed LH and stake holders that it was implemented

    Friday, January 7, 2022 5:04 PM

  • Kayvan Shadpour commented
    January 07, 2022 22:11

    By Friday noon (deadline) following teams were OK with the changes:

    Kishore Padibandla <KISHORE.PADIBANDLA@pb.com>; Uma Alwarsamy <Uma.Alwarsamy@pb.com>; Mahaley Huddleston <MAHALEY.HUDDLESTON@pb.com>; Amit Gupta <AMIT.GUPTA@pb.com>; David Mejia <david.mejia@pb.com>; Ishan Trikha <Ishan.Trikha@pb.com>; Seth Knight <seth.knight@pb.com>; Anthony Bowers <anthony.bowers@pb.com>; Anusha Papineni <Anusha.Papineni@pb.com>; Kinjalk Mohan <kinjalk.mohan@pb.com>

    TMSCore <TMSCore@pb.com>

  • Kayvan Shadpour commented
    January 07, 2022 22:10

    Communicated with stake holders to be sure nobody's logic has dependency on the old values.