|
|
|
NSF GSS BY DEGREE TOTAL
NSF Graduate Student Support. This is a fact table for the aggregation for post doctorate students (both Post Doc and Non-Faculty Research Staff) by degree type. It contains a record for a count of Post Doc or Non-Faculty Research Staff, by degree type (PhD or PhD Med), for each school in an institution for a fiscal year. The count in each record represents the "TOTAL", not a break-down by funding source.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| FISCAL_YEAR_KEY | Use this field to join to another table with the same-name field (ie. FISCAL_YEAR_KEY) for fiscal year information. It shouldn't be used for reporting. | VARCHAR2 | 4 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NSF_DISCIPLINE_KEY | Use this field to join the NSF DISCIPLINE table to other NSF tables with the same key. This field should not be used for reporting. | VARCHAR2 | 3 |
| NSF_GSS_DEGREE_KEY | Use this field to join the NSF GSS DEGREE table with other NSF tables with this same field for degree information. This field should only be used for joining tables, not for reporting | VARCHAR2 | 6 |
| NSF_GSS_SCHOOL_KEY | Use this field to join the NSF GSS SCHOOL table to other NSF tables with this same named field. This field is NOT used for reporting. | VARCHAR2 | 10 |
| STUDENT_COUNT | Number of students | NUMBER | 6 |
| 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