GradOfficeDataModel < CF

CF Web>CSCFSoftwareNotes>ClientProjects>GradOfficeWebApplication>GradOfficeDataModel (2012-09-06, BillInce) (raw view)

<style>.pre { margin-left: 5em; width: 90%; height: 1000px; white-space: pre-wrap; white-space: -moz-pre-wrap; }</style>
<script type="text/javascript">
// TWiki limitations on javascript: no empty lines, no exclamation marks "!", no ampersands "&".
function resizeOnLoad(iframe) {
    var doc = iframe.contentWindow || iframe.contentDocument;
    if (doc.document) {
        doc = doc.document;
    }
    var height = 0;
    if (doc.body) { 
        height = doc.body.scrollHeight;
    }
    if (height) {
        iframe.style.height = height + 25 + "px";
    }
}
function resizeIframe(fid) {
    var iframe = document.getElementById(fid);
    /*
    var win = 0;
    if (iframe.contentDocument) {
        if (iframe.contentDocument.defaultView) {
            win = iframe.contentDocument.defaultView;
        }
    } else if (iframe.contentWindow) {
        win = iframe.contentWindow;
    }
    if (win) {
        // In case iframe is not yet loaded.
        win.onload = function() { resizeOnLoad(iframe); };
    }
    */
    // In case iframe is loaded.
    resizeOnLoad(iframe);
}
window.onload = function() {
    resizeIframe("dgso");
    resizeIframe("dsuppinfo");
    resizeIframe("dreferee");
    resizeIframe("dworkflow");
    resizeIframe("duwdir");
    resizeIframe("duw");
}
</script>
---+ 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 [[https://www.cs.uwaterloo.ca/cscf/internal/request/UpdateRequest?57293][ST#57293]].

-- Main.IsaacMorland - 09 Mar 2007


---+++ Tables generated off GSO extracts.

    <iframe id="dgso" name="dgso" src="%ATTACHURLPATH%/gso.png" width="100%" height="1000">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/gso.png" width="100%"/>
    </iframe>

---+++ The Supplementary Information Form tables

    <iframe id="dsuppinfo" name="dsuppinfo" src="%ATTACHURLPATH%/suppinfo.png" width="100%" height="400">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/suppinfo.png" width="100%"/>
    </iframe>

---+++ The applicant's references.

    <iframe id="dreferee" name="dreferee" src="%ATTACHURLPATH%/referee.png" width="100%" height="400">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/referee.png" width="100%"/>
    </iframe>

---+++ The workflow tables.

Some notes on handling the checklist: GradOfficeDataModelChecklist

    <iframe id="dworkflow" name="dworkflow" src="%ATTACHURLPATH%/workflow.png" width="100%" height="400">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/workflow.png" width="100%"/>
    </iframe>

---+++ UW Directory.

    <iframe id="duwdir" name="duwdir" src="%ATTACHURLPATH%/uwdir.png" width="100%" height="400">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/uwdir.png" width="100%"/>
    </iframe>

---+++ UW primitives.

    <iframe id="duw" name="duw" src="%ATTACHURLPATH%/uw.png" width="100%" height="400">
      This browser cannot display inline frames.  The contents of the frame follow.<br />
      <img src="%ATTACHURLPATH%/uw.png" width="100%"/>
    </iframe>

-- Main.JasonTestart, Main.IsaacMorland, Main.IlguizLatypov - 22 August 2007

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
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	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
sql	suppinfo.sql	r1	manage	2.6 K	2007-08-22 - 13:48	IlguizLatypov	the support info DDL, by ijmorland
sql	uw.sql	r1	manage	1.1 K	2007-08-22 - 23:34	IlguizLatypov	the UW primitives DDL, by ijmorland
sql	uwdir.sql	r1	manage	4.5 K	2007-08-22 - 23:35	IlguizLatypov	the UW Dir 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