The Comparison Report - Events report provides a comparison of the events in the system as it was just prior to running the interface compared to the contents of the buffer tables loaded by the interface run. It is primarily used with Test Mode interface runs so that the changes that would be made by a Full Mode interface run can be evaluated. Only changed events are shown in this report.

Each changed event is displayed in its own row containing the following information:

  • Source Table Name – This is the type of event this row represents. You can sort, or filter based on this field.
  • Data Year – This field displays year data if it is available.
  • Location ID – This is the identifier for the location of this event.
  • Current: Route Name – This is the name of the route associated with this event as it was just prior to running the interface.
  • Current: From Measure – This is the beginning measure of the event as it was just prior to running the interface.
  • Current: To Measure – This is the end measure of the event as it was just prior to running the interface. For point events, this is the same as the Current LRS: From Measure field.
  • Split Count – For events that get split into multiple rows, this numbers the individual pieces.
  • Buffer: Route Name – This is the name of the route associated with this event as it exists in the buffer table that was loaded by the interface.
  • Buffer: From Measure – This is the beginning measure of the event as it exists in the buffer table that was loaded by the interface. For point events, this is the same as the LRS Buffer: From Measure field.
  • Buffer: To Measure – This is the end measure of the event as it exists in the buffer table that was loaded by the interface.
  • Delete Flag – This field indicates if an event is deleted. Otherwise it is blank.
  • Error Text – This displays any errors that were detected when locating the changed version of the event compared to the changed version of the LRS. The possible values for this field and their meanings are:
    • The start of this event (<event start>) occurs before the start of the route (<route start>) – Event measures that do not land on the route are not allowed
    • The end of this event (<event end>) occurs after the end of the route (<route end>) – Event measures that do not land on the route are not allowed
    • The event (<event start>/<event end>) overlaps a gap (<gap start>/<gap end>) – Event measures that do not land on the route are not allowed
    • The event (<event start>/<event end>) overlaps a subordinate section (<concurrency start>/<concurrency end>) – Events are not allowed on subordinate routes
    • The start measure of this event is null – Start measure is a key field that should never be null
    • The end measure of this event is null – End measure is a key field that should never be null
    • The route name of this event is null – Route name is a key field that should never be null
    • The effective date of this event is null – Effective date is a key field that should never be null
    • The begin measure is greater than the end measure – Measures should always go from lower values to higher values
    • This event is not present in SETUP_LOC_IDENT – The event that is attempting to be updated does not exist in the current AgileAssets system
    • The event (<event start>/<event end>) overlaps another event with the same loc_ident (<event start>/<event end>) – Two or more event records may have the same loc_ident value in the case of split events, but the pieces of that split should never overlap
  • No labels

Provide Feedback