Child pages
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This table does not contain "program" information. It is a relationship table between PROGRAM and AWARD. Each record in this table describes a "Program belongs to an Award" relationship.

This table contains the following fields:

  • PRC_PROGRAM_FK: The foreign key into the PROGRAM table.
  • PRC_AWARD_FK: The foreign key into the AWARD table.

The "Program" information is captured from "Program Reference Code(s)" field in the NSF Data. Since the originating field only has "funding code" information first we try to check if any of the existing "Program" have the same funding code. If yes, then we will just get the reference to that object and save it in an appropriate relationship table. On another note if it is not present then we create a new "program" record without the "name" field.

See AWARD and PROGRAM for further reference

  • No labels