* means the field can be changed using web change forms o means the field appears on the web pages but is not part of the database (these fields are derived from the other fields) + means the fields is written to the templates ============================================================================== DEPARTMENT department department code *+ deptname department name *+ dhomepage URL of department home page INSTRUCTOR instructor person ID * instname instructor name * insthomepage URL of instructor home page * instemail email address * instofftim office hours * instoffloc office location COURSE + coursekey course key *+ ctitle course title *+ cdescription course description *+ chomepage URL of course home page *+ chompagtarg 0 or 1 *+ csyllabus URL of course syllabus *+ csyllabtarg 0 or 1 *+ cboard URL of course CUBBoard *+ cboardtarg 0 or 1 o+ subject course subject derived from course key o+ termname one of {Spring,Summer,Fall} o+ year year SECTION + sectionkey section key + callnum call number o+ sectionnum section number * stitle section title *+ sdescription section description * shomepage URL of section home page * shompagtarg 0 or 1 *+ sintroduc URL of section introduction *+ sintrotarg 0 or 1 * ssyllabus URL of section syllabus * ssyllabtarg 0 or 1 *+ sbibliography URL of section bibliography *+ sbibliotarg 0 or 1 *+ sassignments URL of section assignments *+ sassigntarg 0 or 1 *+ srequirements URL of section requirements *+ srequirtarg 0 or 1 *+ swebresources URL of section web resources *+ swebrestarg 0 or 1 + sreserves URL of section library reserves + sreservtarg 0 or 1 *+ sboard URL of section CUBBoard *+ sboardtarg 0 or 1 *+ sassistants URL of section teaching assistant info *+ coursetype one of {lecture,lab,seminar,...} *+ notes notes *+ prereq prerequisites + approval one of {none,instructor,department,both} * sapproval one of {0,1,2,3} *+ points number of points * minpoints minimum points * maxpoints maximum points daycod1 days this section meets, e.g. MWF mtimes1 start time and end time, e.g. 10:00-10:55 o+ daytime1 combination of daycod1 and mtimes1 + location1 room and building daycod2 days this section meets, e.g. MWF mtimes2 start time and end time, e.g. 10:00-10:55 o+ daytime2 combination of daycod2 and mtimes2 + location2 room and building findaycod day of the final exam, e.g. F fintimes start/end time of final exam, e.g. 10:00-10:55 o+ findaytime day and time of final exam + finlocation room and building of final exam + subfield o+ subterm which sub term + open_to open to *+ searchurl URL of the directory to search for this section instructors teaching this section: + inst1name instructor 1 name + inst1mail instructor 1 email address + inst1url instructor 1 home page URL + inst2name instructor 2 name + inst2mail instructor 2 email address + inst2url instructor 2 home page URL + inst3name instructor 3 name + inst3mail instructor 3 email address + inst3url instructor 3 home page URL + inst4name instructor 4 name + inst4mail instructor 4 email address + inst4url instructor 4 home page URL OTHER + sis_update date and time of SIS feed upload + web_update date and time web pages were written o+ phomepage URL of course or section home page o+ psyllabus URL of course or section syllabus o+ pnewsgroup URL of course or section CUBBoard o+ defaultdoc URL of document that should appear initially + secinfo_url URL of section information (index.html) Notes: Target Variables ---------------- Field names that end with "targ" can be set to 0 or 1. The default is 0, which means the corresponding web page will open in the lower right frame of the existing window. 1 means the page will be displayed by itself in a new window. Set this value to 1 if the web page has it's own frame with navigation buttons, etc. For example, shomepage contains the URL of section home page while shompagtarg controls whether the section home page appears in a separate window.