Hour Records can be inconsistent (have no hourable relation)
On staging, there is records, that do not have their neccesary hourable (Assignment || GroupOffer) Relation. This should be prevented. Probably the best solution is to enforce it by validating its presence.