This table contains data directly pertaining to awards. It includes all fields relevant for all possible (known) types of awards in NSF file.

All "arbitrary" fields found in the original NSF dataset are also appended to this table, as this table is somewhat central to the database schema.

In addition to "arbitrary" fields, this table contains the following fields:

The parsing of "Award" element is the first step when a new NSF row is encountered. It's primary key is used as a foreign key in other relationship tables like INVESTIGATORS, PROGRAM_MANAGERS, AWARD_FIELD_OF_APPLICATIONS, PROGRAM_NAME_AND_ELEMENT_CODES and PROGRAM_REFERENCE_CODES.