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

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.

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