Organization related information is stored in this table. Since the NSF format already provides separate fields having address information, it is easy to save this data in the table.
This table contains the following fields:
- PK: Automatically generated. Guarantees uniqueness.
- ORGANIZATION_NAME: The exact string as found in the "Organization" field.
- ORGANIZATION_PHONE: The exact string as found in the "Organization Phone" field.
- ORGANIZATION_STREET_ADDRESS: The exact string as found in the "Organization Street Address" field.
- ORGANIZATION_STATE: The exact string as found in the "Organization State" field.
- ORGANIZATION_ZIP: The exact string as found in the "Organization Zip" field.
- ORGANIZATION_CITY: The exact string as found in the "Organization City" field.
It's primary key is used as a foreign key in it's relationship table with Investigators; see INVESTIGATOR_ORGANIZATIONS for additional information.