Graduate Office Data Model

Here we will design the data model to be used in our database to hold all the information related to the Grad Office.

TA Assignment

This was done earlier and is documented at TAAssignmentDataModel.

Graduate Admissions

OUAC Application Data

We plan to obtain regular (nightly?) dumps of OUAC application data from GSO. These will be parsed and inserted into these tables. See ST#57293.

-- IsaacMorland - 09 Mar 2007

Tables generated off GSO extracts.

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/gso.png" width="100%"/>

The Supplementary Information Form tables

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/suppinfo.png" width="100%"/>

The applicant's references.

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/referee.png" width="100%"/>

The workflow tables.

Some notes on handling the checklist: GradOfficeDataModelChecklist

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/workflow.png" width="100%"/>

UW Directory.

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/uwdir.png" width="100%"/>

UW primitives.

This browser cannot display inline frames. The contents of the frame follow. <img src="/twiki/pub/CF/GradOfficeDataModel/uw.png" width="100%"/>

-- JasonTestart, IsaacMorland, IlguizLatypov - 22 August 2007

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
sql	gso.sql	r1	manage	9.4 K	2007-08-22 - 13:46	IlguizLatypov	the DDL data model for tables generated off GSO extracts, by jatestart and ijmorland
sql	referee.sql	r1	manage	5.4 K	2007-08-22 - 15:08	IlguizLatypov	the faculty referee DDL, by ijmorland
conf	gso.conf	r1	manage	8.9 K	2007-08-22 - 13:45	IlguizLatypov	the scripted data model for tables generated off GSO extracts
sql	suppinfo.sql	r1	manage	2.6 K	2007-08-22 - 13:48	IlguizLatypov	the support info DDL, by ijmorland
sql	uwdir.sql	r1	manage	4.5 K	2007-08-22 - 23:35	IlguizLatypov	the UW Dir DDL, by ijmorland
sql	uw.sql	r1	manage	1.1 K	2007-08-22 - 23:34	IlguizLatypov	the UW primitives DDL, by ijmorland
sql	workflow.sql	r1	manage	6.7 K	2007-08-22 - 16:58	IlguizLatypov	the workflow DDL, by ijmorland

Topic revision: r45 - 2012-09-06 - BillInce

Information in this area is meant for use by CSCF staff and is not official documentation, but anybody who is interested is welcome to use it if they find it useful.

Other Webs

My links
- People
- CERAS
- WatForm
- Tetherless lab
- Ubuntu Main.HowTo
- eDocs
- RGG NE notes
- RGG
- CS infrastructure
- Grad images

Edit