Is joined with:
- SAH-Demographics-View
- SAH-StudentStudentsStatsPerTerm-View
Includes:
- Current, Historical, and First ever recorded activities and information about students
Additional Notes:
- The fields with current suffix will carry over the most recent values of those fields if a student graduates or drops out.
All majors / Minors of students for every term is in one field (Program / Program Code) in this view. Therefore, might see multiple rows per term per student:
| Data Source | (Folder: Term Set - Student Stats Per Term) - (Field: Term Code) | Student | (Folder: Term Based Program) - (Field: Program Code) | Program Type | Student primary Major Flag |
SAH-MajorMinorNarrow-View | FA20 | Student 1 | P1 | Major | Yes |
| SAH-MajorMinorNarrow-View | FA20 | Student 1 | P2 | Minor | Yes |
| SAH-MajorMinorNarrow-View | FA20 | Student 1 | P3 | Major | No |
Folder | Fields | Note |
|---|---|---|
| Term Based Student | Basic historical information about students | |
| Current Student | The most current basic information about student | |
| Term Based Program | Program Code | Includes all majors / Minors of students for every term in one field (Program / Program Code). Therefore, might see multiple rows per term per student: |
| Term Based Program | Program Type | Major or Minor |
| Term Based Program Flags | Student primary Major Flag | Indicates if a major is primary or not |
| Term Based Program Flag Measures | Program Is Self-Supporting Count | |
| Term Based Program Flags | Program Is Self-Supporting Flag | Indicates if a program Is self-supporting or not |
| Term Based Program | Program Support Type | Indication of funding source for major programs. Self-supported major programs receive no state-funding. State-supported programs receive state-funding and have different fees for California and non-California students. All undergraduate major programs are state-supported. |