|
|
|
NSF GSS BY GENDER 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 gender. It contains a record for a count of Post Doc or Non-Faculty Research Staff by gender 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_GENDER_KEY | Use this field to join the NSF GSS GENDER table to other NSF tables with this same named field for gender information. This field is NOT used for reporting | VARCHAR2 | 1 |
| 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