Rather than having mapping start and end date colums in the device mapping table, consider using a range type column.