planned hours view and relationships