|
|
|
NSF GSS ENROLLMENT DETAIL
This is a fact table for the NSF Graduate Student Support Total Enrollment by Ethnicity and Gender Star. There is one record (ie. a student count) per fiscal year, school, institution, enrollment status (full time or part time), gender and ethnicity.
| 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_DEMOGRAPHIC_KEY | Use this field to join the NSF GSS DEMOGRAPHIC table to other NSF tables with this same field for demographic (ethnicity and gender) information. This field should only be used for joining tables, not for reporting | VARCHAR2 | 16 |
| 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_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