|
|
|
NSF GSS ENRL GENDER DETAIL
This is a fact table of NSF Graduate Student Support Total Enrollment by Gender. There is a record per fiscal year, school (Graduate School, School of Medicine), institution, enrollment status (Part-Time, Full-Time), and gender.
| 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_ENROLL_STATUS_KEY | Use this field to join the NSF GSS ENROLL STATUS table to other NSF tables with this same field for enrollment status information. This field should only be used for joining tables, not for reporting | VARCHAR2 | 2 |
| 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