PROPOSAL Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

PROPOSAL Table

Explanation
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.

Common Uses

• 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?")

PROPOSAL_ID

CO_PI_HOME_ORG

CO_PI_HOME_SCHOOL

END_DATE

FISCAL_YR_END

FISCAL_YR_START

FISCAL_YR_STATUS

ORG_LOG_NUMBER

PI_HOME_ORG

PI_HOME_SCHOOL

PI_PRI_APPT_ORG

PI_PRI_APPT_SCHOOL

PROJECT_ID

PROJECT_SEGMENT_ID

PROPOSAL_ID

PROP_RESP_ORG

PROP_RESP_SCHOOL

START_DATE

AGENCY

AWARD

CNAC_CODES

ORA_PURPOSE

ORG_CODES

SPON_PROJ_INVESTIGATOR

SPON_PROJ_SUBCONTRACTOR

• 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, and CO_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.

PROPOSAL Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home