Penn Computing

University of Pennsylvania
Penn Computing << go backback
SPON_PROJ_SUBCONTRACTOR Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

SPON_PROJ_SUBCONTRACTOR Table

Explanation
Data about subcontractors associated with proposals, grants, or contracts. There is one record for each unique combination of proposal/award and subcontractor.

Common Uses

  • Listing all projects for a subcontractor
  • Listing all subcontractors for a project.
  • Listing the amount for each subcontractor for a project.
Primary Key Indexed Data Elements Related Tables
PROPOSAL_ID

SUB_CONTRACTOR_CODE

PROJECT_ID

PROPOSAL_ID

SUB_CONTRACTOR_CODE
AWARD

PROPOSAL

SUB_CONTRACTOR

Cautions
  • When including subcontractor information in reports on proposals or awards, note that multiple records will be returned for a given proposal or award if there is a more than one subcontractor for the proposal or award.
  • If a subcontractor takes a new name, the subcontractor will probably be given a new code. There is no way to tell that these codes actually refer to the same subcontractor.
  • SUB_CONTRACTOR_AMOUNT is the latest known amount for the subcontractor for the proposal or award. The amount for a proposal may be 0, and the amount for an award may differ from the amount for the proposal. SUB_CONTRACTOR_AMOUNT is not populated for records dating from before November 24, 1997. The total amount for all subcontractors for a proposal (or award) is the SUB_CONTRACTOR_AMOUNT that is stored in the PROPOSAL (or AWARD) table.
SPON_PROJ_SUBCONTRACTOR Table - Data Element Index    Tables and Data Elements   Sponsored Projects Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania