|
|
|
FROSH ACADEMIC DETAIL
This fact table contains the freshmen profile for academic and test data. There is one record for an institution in an academic year, where each record contains information such as the total number of students in the entering class, number and percentage of which reporting SAT scores, number and percentage of which reporting ACT scores, High School GPA, SAT Verbal and Math Percentile, and ACT Composite Percentile.
| 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 |
| 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