How are the links between development proposals, Institute proposals, and Awards maintained in the database?
The link between Development proposals and Institute Proposals is maintained in the osp$proposal_admin_details table. An Institute proposal is created by the system at the time a development proposal is submitted to the sponsor. Generally a new Institute Proposal number will be generated for each Development proposal. However, if the proposal is a revision, a new sequence number will be created for the existing Institute proposal. The link between awards and Institute proposals is maintained in the osp$award_funding_proposals table. When a new award is created, the user will be prompted to select one pending proposal. If the user did not select a proposal at the time of creating a new award or wants to link more proposals to the award, the Funding Proposals window can be used. This window will display all the rows that exist for the award, i.e rows for all sequence numbers. Rows will be grouped by sequence number of the award. This will give the ability to see all the proposals that ev
