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

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2007-11-22 - IsaacMorland
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2025 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback