0005 EventLibrary
- 18 Aug 2025
- 1 Minute to read
- Print
- DarkLight
- PDF
0005 EventLibrary
- Updated on 18 Aug 2025
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
0005 EventLibrary
Migration Path
- INSPEVNT -> EventLibrary (Bridge Inspection type)
- INSPEVNT -> EventLibrary (Load Posting Status type based on latest inspection)
- LOAD_RATING_EVENTS -> EventLibrary
- PON_ASSESSMENT -> EventLibrary
- PON_TUNNEL_INSP -> EventLibrary
- SIGN_INSP -> EventLibrary
- ASSET_WORK_CANDIDATE -> EventLibrary
Data Considerations
- Duplicates
- Null Data Replacement
- LOAD_RATING_EVENTS.RATING_DATE -> 2099-12-31
- PON_ASSESSMENT.ASMTDATE -> 2099-12-31
- PON_TUNNEL_INSP.INSPDATE -> 1901-01-01
Other Notes
- NULL INSPEVNT.INSPEVNT_GD fields will cause data not to migrate for bridge inspections.
- A LoadPostingEventID is created on INSPEVNT in the TRANSFORMED database to migrate EventLibrary and LoadPostingStatus records using the same event ID.
- Load rating events must have a valid BRIDGE_GD and LOAD_RATING_EVENTS_GD to migrate.
- Assessments must have a valid BRIDGE_GD to migrate.
- Tunnel and Sign inspections must have a valid BRIDGE_GD to migrate.
- Asset work candidates must have valid BRIDGE_GD to migrate.
- See sql for other filtering requirements.
- Only the latest asset work candidate records will migrate (based off of ASSET_WORK_CANDIDATE.CREATE_DATE)
Was this article helpful?
