Each agency's records stay in its own brain. You see what each agency's rules let your role see, record by record. Change who you are viewing as and watch the columns change.