I inherited a application for grants tracking database last year and the grants themselves do not have a location. There are persons and institutions associated with each Application/Grant, and each of those has a location.
Interestingly, the application is designed for a very specific workflow, audit and review as part of the intake, but has no facilities for auditing after the fact. The data and relationships exist and there is a wealth of information in the database including known conflicts of interest but there's no easy way to query or browse this data from the application unless you're reviewing a specific grant or application.
For example:
The application doesn't allow you to search for persons by location and doesn't show you grants associated with persons. Rather you can only see persons associated with grants.
You can search for institution by address but again, it doesn't show you grants associated with an institution.
These interfaces were designed to just update Persons or Institutions when changes occur. They weren't intended as a way to back into a Grant or Application.
Or the person searching it ctrl+f’d a typo. Or a Chinese intern who helped compile the spreadsheet deleted that row on “accident”.
People are too quick to notice conflicts of interest. Everyone of us lives a life filled with such conflicts, yet we manage somehow to rise above, for the most part. Fauci seems like a nice guy to me.
