Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

The Degree Navigator system stores all of its course description data in a single table called COURSEDESCRIPTION_DAG.

COURSEDESCRIPTION_DAG

Column

Description

coursecode_dag

An encoded course id, the encoding is a direct concatenation of Subject Code and Course Number

description_dag

The course description, which always starts with the coursecode and a space. Course descriptions generally tun into the hundreds and thousands of characters.

startterm_dag

The first term in which this course description applies. This field is never null.

endterm_dag

The last term in which this course description applies. If this field is null the course description is considered to be the active course description.

...