Which Major Minor View Do I Use?
Scenario | SAH-MajorMinor-View | SAH-MajorMinorDetails-View | SAH-MajorMinorNarrow-View SAH-MajorMinorNarrowCensus-View |
|---|---|---|---|
Record Type | Current primary major/minor for a student per term | All majors/minors and change details for a student per term | One row per major/minor program for a student per term (primary + non-primary) |
Includes all students | Yes | No | Yes |
Which students are excluded | None | Exclude students with one primary major that has never changed. | None |
Includes students who have changed their primary major | Yes shows only current major, not history | Yes shows current + change history | Yes shows current + change history |
Includes students who have changed their non-primary minor | Yes includes all student, even those who have not changed their major or minor | Yes includes 2nd/3rd/4th majors + history | Yes |
Includes students who have changed their minor | Yes only current state; no historical tracking | Yes includes change history | Yes |
Includes 3rd/4th Major fields | No | Yes Folder = Majors Minors Detail Information | Yes Folder = Per Term Demographic In formation |
Includes data of major/minor change | No History | Yes with begin/end term fields and sequences | Yes |
Includes all major/minors in a single field | No | No | Yes Folder = Major Minors Narrow Information |
Grain | Student Level Code, Term ID, Student PID | Term ID, To Program Code, Student PID, Program Change Request Transaction ID, Program Change Request Date, Program Priority Level, Program Change Date, Student Level Code | Student Level Code, Term ID, Student PID |