|
|
|
FROSH ACAD RESIDENCY DETAIL
This fact table, similar to FROSH_ACADEMIC_DETAIL, contains the freshmen profile for academic and test data. In this table, the level of detail of the records are further grouped by residency status (ie. resident vs. non resident). There is one record per academic year, per institution, per residency status.
| Field Name | Description | Data Type | Length |
|---|---|---|---|
| ACADEMIC_YEAR_KEY | Use this field to join the ACADEMIC YEAR table to a fact table for time dimension information. | VARCHAR2 | 4 |
| ACT_COMPOSITE_25TH_PCNTILE | ACT Composite 25th Percentile. Twenty five percent of the students scored at or below this score. | NUMBER | 2 |
| ACT_COMPOSITE_50TH_PCNTILE | ACT Composite 50th Percentile. Fifty percent of the students scored at or below this score. | NUMBER | 2 |
| ACT_COMPOSITE_75TH_PCNTILE | ACT Composite 75th Percentile. Seventy five percent of the students scored at or below this score. | NUMBER | 2 |
| HIGH_SCHOOL_GPA | High School GPA | NUMBER | 5.3 |
| INSTITUTION_KEY | Use this field to join to another table with the same-name field (ie. INSTITUTION_KEY). | VARCHAR2 | 6 |
| NUMBER_REPORTING_ACT | Number of students in the entering freshmen class reported/submitted their ACT scores. | NUMBER | 5 |
| NUMBER_REPORTING_SAT | Number of admits who report their SAT test scores. | NUMBER | 5 |
| PERCENT_REPORTING_ACT | Percentage of the students in the entering freshmen class reported/submitted their ACT scores | NUMBER | 6.1 |
| PERCENT_REPORTING_SAT | Percentage of the students in the entering freshmen class reported/submitted their SAT scores | NUMBER | 6.1 |
| RESIDENCY | Residency status (ie., tuition billing status): Resident - legal residency used for tuition purposes, anyone whose tuition residency is in your home state. Non-resident - anyone whose tuition residency is NOT in your home state. | VARCHAR2 | 12 |
| SAT_MATH_25TH_PCNTILE | SAT Math 25th Percentile. Twenty five percent of the reporting students scored at or below this score in their SAT Math test. | NUMBER | 3 |
| SAT_MATH_50TH_PCNTILE | SAT Math 50th Percentile. Fifty percent of the reporting students scored at or below this score in their SAT Math Test. | NUMBER | 3 |
| SAT_MATH_75TH_PCNTILE | SAT Math 75th Percentile. Seventy five percent of the reporting students score at or below this score in their SAT Math test. | NUMBER | 3 |
| SAT_VERBAL_25TH_PCNTILE | SAT Verbal 25th Percentile. Twenty five percent of the reporting students scored at or below this score in their SAT Verbal Test. | NUMBER | 3 |
| SAT_VERBAL_50TH_PCNTILE | SAT Verbal 50th Percentile. Fifty percent of the reporting students scored at or below this score in their SAT Verbal Test. | NUMBER | 3 |
| SAT_VERBAL_75TH_PCNTILE | SAT Verbal 75th Percentile. Seventy five percent of the reporting students scored at or below this score in their SAT Verbal test. | NUMBER | 3 |
| TOTAL_ENTERING_CLASS | Number of freshmen in the entering class. | NUMBER | 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