This view is joined with:
- SAH-Demographics-View
Includes:
- Historical records of students (Term based information).
- Current / most recent information about students.
- First recorded activities and information about students, such as students' first college, their first enrolled term, and their first major
Note:
- Transfer students will always have a null student level for their transfer records, but once they have UCSD records those records will be populated.
Additional Notes:
- The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.
- This view shows primary / secondary major for each term all in one row but separate fields. Therefore there should only be one row per student per term:
| Data Source | Term Code | Student | Primary Major | Secondary Major | Primary Minor | Secondary Minor |
| SAH-StudentStudentsStatsPerTerm-View | FA20 | Student 1 | Primary Major 1 | Secondary Major 1 | ||
| SAH-StudentStudentsStatsPerTerm-View | FA20 | Student 2 | Primary Major 1 | Primary Minor 1 |
Fields | Folder | Note |
|---|---|---|
| Student Classification Code / Student Classification | Term Based Student | Some values include: FR, SO, JR, MA, D1, ... Freshman, Sophomore, ... |
| Registration Status / and Code | Term Based Student | Registration status per term Note: The difference between Enrolled and Registered is the payment. |
| Visa Type / Visa Type Code | Term Based Student | |
| Student Level | Term Based Student | |
| DFW Count Term | Term Based Measures | Count of student or class section where student received a grade of D, F or W value for the selected Term. Limited to Letter Grade Option only. |
| Permanent Address Home / Code / Region | Term Based Student Contact | |
| Admissions Term | Term Based Student | |
| Ethnicity EDI Broad / Narrow | Term Based Student | Top level of a two-level hierarchy for a person’s social group. Bottom and more detailed level of a two-level hierarchy for a person’s social group. |