I have roads in a feature class (Oracle 10.3 geodatabase).
Roads are split into separate lines where they intersect. This is an established business rule that cannot be changed.
Each road has related work order records/points (in a separate system).
Scenario:
A new road (#200) has been built that intersects an existing road (#100).
Road #100 needs to be split into two separate roads at the intersection of road #200 (using ArcMap).
Question:
What are the options for managing the the road IDs and the related work order records?
(I'm thinking in a generic/business-rule sense; I'm not looking for technical ArcMap instructions.)