Data Model: Application Checklist
The following items need to be recorded on the application checklist:
- Immigration Card
- Transcripts (one per institution)
- Supplementary Information form
- Reference forms (one per referee)
- Application printout, signed
- Test reports (seems to be one per test—all components are reported together)
- …anything else?
We will need the following tables to support this:
- work_education: one row per educational institution listed in gso_education. Note that gso_education probably “should” really be split up as described in the documentation in gso.sql, as we actually tend to get two gpas per institution.
- work_test: one row per test.
Each of the checklist items can become a timestamp field in the appropriate table. The fields can start NULL and be updated to NOW() upon an action being taken by the admissions coordinator.
-- IsaacMorland - 21 Nov 2007