Records data about each proposed grant or contract, including information about
whether funding was awarded, the school and department slated to administer
the award, whether animals or human subjects are to be used, and various proposed
funding amounts. (For proposals whose value for STATUS is "A" or "V", awarded
or advance amounts and related information are stored in the AWARD table.) One
record exists for each proposal. Note: If the proposal has been sent to the
National Institute of Health (NIH), related data elements have values; otherwise,
they are null.
- Finding proposals sent to a particular sponsor. ("Which proposals were sent
to agency 1043, the Peace Corps?")
- Listing proposals for studies in which animals are used. ("Which of our
grants involve animals?")
- Listing data about a particular proposal based on the proposal id. ("What
information is there about proposal 144590000?")
||Indexed Data Elements
- NIH fields are populated only if the agency is NIH (Agency Code 1110), and
the proposal is for a federal grant (Grant Contract Code is G). For other
records, the NIH fields will be null. Note that the NIMH became an institute
of the NIH in 1992. NIH fields are populated for NIMH grants for records dating
from 1992 and thereafter, but not for records dating from before 1992. Also,
prior to June, 2002, NIH Grant Serial Number was a 5-digit number. In June,
2002, NIH Grant Serial Number became a 6-digit number, and records for existing
NIH grants had a leading zero added to their NIH Grant Serial Numbers.
- There may be some spurious records for Medical School clinical trial proposals.
Up through fiscal year 1995, a proposal record was added every time a clinical
trial award payment was received. (As of the start of fiscal year 1996, this
was no longer done.) These spurious records can be identified by the fact
that their PROJECT_ID values are the same, but the 6th and 7th digits of their
PROPOSAL_ID's will differ.
- When working with proposals that have been awarded, note that it is possible
to have an AWARD record with a null value for PROPOSAL_ID. This means that
the original proposal for that award cannot be determined.
- NIH sub-program projects are not recorded as separate proposals (though,
once the NIH program project award is received, each sub-program project will
have its own AWARD record).
- TOTAL_COMPENSATION_AMOUNT, TUITION_AMOUNT, EQUIPMENT_AMOUNT, FOREIGN_TRAVEL_AMOUNT,
DOMESTIC_TRAVEL_AMOUNT, OTHER_EXPENSES_AMOUNT, and UNIVERSITY_EXPENSES_AMOUNT
are used only for records dating from before November 24, 1997.
- When reporting on Organizations, be sure to select the data element that
meets your needs. The PROP_RESP_ORG and PROP_RESP_SCHOOL identify the Organization
and School/Center responsible for the proposal at the time of the proposal.
The PI_PRI_APPT_SCHOOL and PI_PRI_APPT_ORG identify the School/Center and
Organization for the Principal Investigator's primary job appointment as of
the time of the proposal.. The PI_HOME_SCHOOL, PI_HOME_ORG, CO_PI_HOME_SCHOOL,
and CO_PI_HOME_ORG identify the home Schools/Centers and Organizations for
the Principal Investigator and the Co-Principal Investigator as of the time
of the proposal. The home School/Center and Organization are the ones that
own the employee's record and are responsible for its maintenance.
- Users with University-wide access may see all the data elements for every
PROPOSAL record. Users with Organization-based access may see only those records
which they are authorized to access based on PROP_RESP_ORG, PI_PRI_APPT_ORG,
PI_HOME_ORG, or CO_PI_HOME_ORG.
- To facilitate Organization-based security, null values for Organization
codes will be changed to '.' in the Warehouse. The data elements that may
contain '.' (instead of being null) are: PROP_RESP_ORG, PI_PRI_APPT_ORG, PI_HOME_ORG,
- A breakdown of SUB_CONTRACTOR_AMOUNT by subcontractor may be found in the
SPON_PROJ_SUBCONTRACTOR table for records dating from November 24, 1997 and
thereafter. The breakdown is not available for records dating from before
November 24, 1997.
- COMMITTED_YEARS is the number of years beyond the END_DATE that the sponsor
has committed to fund the project. The value will be 0 for proposal records.
- The value for a fund's F_AND_A_RATE in the Balances table may differ from
the INDIRECT_COST_RATE in the Proposal and Award tables. The INDIRECT_COST_RATE
in the Proposal table is the rate to be used to calculate the indirect cost
recovery amount, as quoted in the proposal for the project. Its value is stored
as ###.## (for example, the value 12% would be stored as 12). The INDIRECT_COST_RATE
in the Award table is the rate the sponsor awarded; its value is stored in
the same format used in the Proposal table. The F_AND_A_RATE in the Balances
table is stored in a different format (.########--for example, 12% is stored
as .12). This is the rate actually used to calculate the indirect cost recovery
amounts each week. In cases where the awarded rate actually floats based on
the federally negotiated rate, the value for the F_AND_A_RATE in the Balances
table may differ from the value for the INDIRECT_COST_RATE in the Award table.
Questions about this page? Email us at firstname.lastname@example.org