0009 Load Rating Event

0009 Load Rating Event

Migration Path

• LOAD_RATING_EVENTS -> LoadRatingEvent

Data Considerations

• Duplicates
  • EVENT_NAME -> EVENT_NAME_x
• Null Data Replacement - See SQL

Other Notes

• Rating.Rating will migrate from LOAD_RATINGS.LOAD_FACTOR. If this value is null, the Rating value will be null. This is due to an unexpected tonnage calculation from the FHWA instructions. Currently Rating must be manually updated to get a different result.
• LOAD_RATING_EVENT.BRIDGE_GD and LOAD_RATING_EVENT.LOAD_RATING_EVENTS_GD must not be NULL for data to migrate. BRIDGE_GD must be a valid bridge.