This page last changed on Dec 07, 2010 by barbosaa.

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 CISHELL:AWARD and CISHELL:PROGRAM for further reference

Document generated by Confluence on May 31, 2011 15:16