• Complete OUAC data model [complete]
• Develop internal data model for OGSAS [complete]
• Review infrastructure requirements for OGSAS system [in progress]
• Review security and access control requirements for OGSAS system [in progress]
• Write a script to import normalized data into OGSAS database [in progress]
  • Load data with insert/update statements to maintain integrity constraints of local tables. [1 week]
• Determine scanning requirements and procedures [2-3 weeks]
• Develop an on-line supplementary information form. [2 weeks]
• Develop an on-line confidential reference form [1 week]
• Develop a pdf generator for reference form [1 week]
• Write code for automatic email generation [2 weeks]
  • Develop a custom URL generator for reference form
• Develop a web interface for paper collection and display [2 weeks]
• Develop a "checklist" interface for the Admissions Coordinator [1 week]
• Determine method for attaching scanned documents to an application [1 week]
• Develop a method to export data (of accepted students) to Grad Database (currently Filemaker) [1 week]
• Write a header sheet generation script [1 week]

-- JasonTestart - 03 Jul 2007