| Table | Logical Dependencies | Primary Tool Use |
|---|
| external_course | external_department, external_division (You might think this table should precede external_student_transcript_course in a sort of master-detail relationship. But external_student_transcript_course uses a less strict definition of course and the application does not use external_course to provide additional context when rendering external_student_transcript_course records. There is a relationship between these two tables, but if anything it flows the other direction, i.e. at the app layer external_course records are checked against external_student_transcript_course to determine if a planned course has already been taken.)
| |
| external_course_program | external_course, external_program
| |
| external_course_requisite | external_course | - MAP-Available Courses, planned course validation
|
| external_course_tag | external_course
| - MAP-TAG Filter, Available Courses
|
| external_course_term | external_term, external_person | - MAP-Available Courses, planned course validation
|
| external_department | | |
| external_division | | |
| external_faculty_course | external_term, external_person | - Early Alert Portlet-Early Alert course list
|
| external_faculty_course_roster | external_term, external_person, external_faculty_course_roster | - Early Alert Portlet-Early Alert course list roster
|
| external_person | external_term, external_department, external_person | - Caseload Assignment-Add and Edit students
- Main-Dashboard and Details tabs
- Reports-Counselor Case Management Report
|
| external_person_note | external_person | |
| external_person_planning_status | external_person | - Main-Dashboard tab, MAP summary
- MAP-Plan Status indicator
- Reports-Number of Students by Plan Status
|
| external_program | | - Caseload Assignment-Student Search
- MAP-Program Filter, Template definition
|
| external_registration_status_by_term | external_term, external_person | - Main-Details tab Recent Term Activity
- Reports-Counselor Case Management Report
|
| external_student_academic_program | external_program, external_person | - Main-Dashboard and Details tabs, MAP summary
|
| external_student_financial_aid | external_person | - Main-Dashboard and Details tabs
- MAP-Financial Aid pop-up
- Reports-Counselor Case Management Report
|
| external_student_test | external_person | |
| external_student_transcript | external_person | - Main-Dashboard and Details tabs
- Reports-Counselor Case Management Report
|
| external_student_transcript_course | external_person (Note that while this table refers to the same notion of a "course" as external_faculty_course and should use the same course and section identifiers, there isn't really even a logical dependency between the two tables because external_faculty_course should only contain "early alertable" courses whereas a student transcript should list all transcripted courses for any given student.)
| - Main-Transcript and Schedule tabs
- MAP-Transcripted planned course validation
|
| external_student_transcript_term | external_term, external_person | - Main-Details tab
- Reports-Counselor Case Management Report
|
| external_term | | - Caseload Assignment-Anticipated Start Year and Term
- Student Intake-Anticipated Graduation Year and Term
- MAP-Plan and Template year and term grid
|