This table contains fields of application that are associated with a particular award. The associated data is parsed from "Field Of Application(s)" field in the NSF data.

This table contains the following fields:

  • PK: Automatically generated. Guarantees uniqueness.
  • ORIGINAL_INPUT_FIELD: The exact string as found in the "Field Of Application(s)" field.
  • EXTRACTED_NUMERIC_FIELD: Field of application can be split up into Numeric & non-numeric part. The value of this field is the extracted numeric field.
  • EXTRACTED_TEXT_FIELD: The value of this field is the extracted non-numeric field.

It's primary key is used as a foreign key in it's relationship table with Award; see AWARD_FIELD_OF_APPLICATIONS for additional information.