...
The BANNER system consists of thousands of tables, views, sequences, and pl/sql procedures. Luckily, only a handful of those objects are of interest to the Sakai project. The following diagram and table will describe each of the objects Sakai will be collecting data from.
<insert chart of banner objects and their relationships here>
Name | Object Type | Description | Example |
|---|---|---|---|
STVTERM | Table | Academic Term Infomation | Spring Quarter 2007 |
STVCOLL | Table | Academic Colleges | AE - Agricultural and Environmental Sciences |
STVDEPT | Table | Academic Departments | ENH - Environmental Horticulture |
STVSUBJ | Table | Academic Subjects | LDA - Landscape Architecture |
SCBCRSE | Table | Course Information | LDA 001 - Spring Quarter 2007 |
SSBSECT | Table | Section Information | LDA 001 - Section A01 - Spring Quarter 2007 |
SSRMEET | Table | Section Meeting Times | MWF 9:00-10:15 - LDA 001 - Section A01 - Spring Quarter 2007 |
SIRASGN | Table | Instructor Assignments | John Smith - LDA 001 - Section A01 - Spring Quarter 2007 |
SFRSTCR | Table | Student Enrollments | Jane Doe - Waitlisted - LDA 001 - Section A01 - Spring Quarter 2007 |
...