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.