|
|
|
NSF FEDSUP AGENCY GRP
This is a dimension table used in the NSF Federal Support Survey data model. Federal Support survey data is aggregated into major agency groups. This table contains the abbreviated codes and names of the agency groups.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| AGENCY_GROUP | Name of federal agencies. | VARCHAR2 | 500 |
| AGENCY_GROUP_CODE | Abbreviated code of federal agencies, eg. DOC, DOD, DOE, DOI, ED, EPA, HHS, NASA, NSF, USA, OTHER. | VARCHAR2 | 5 |
| NSF_FEDSUP_AGENCY_GRP_KEY | Use this field to join together the NSF_FEDSUP_SURVEY_DETAIL and the NSF_FEDSUP_AGENCY_GRP tables. | VARCHAR2 | 5 |
| WAREHOUSE_LOAD_DATE | The date the records were last loaded/updated in this table in the Data Warehouse | DATE | 7 |
e-mail aaude-warehouse@mit.edu | Warehouse home | AAUDE home