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.