zlacker

[parent] [thread] 0 comments
1. cptski+(OP)[view] [source] 2021-06-04 16:41:10
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.

[go to top]