.. index::
   DEPT_MATH_COURSE_TTL_V

======================
DEPT_MATH_COURSE_TTL_V
======================

.. default-role:: doc



Columns
=======


**MASTER_COURSE_ID** ``int(11) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**OFFERING_UNIT_CD** ``char(2) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**SUBJECT_CD** ``char(3) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**COURSE_CD** ``char(3) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**COURSE_SUPPL_CD** ``char(2) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**COURSE_TITLE** ``varchar(20) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**LAST_ACTIVE_YEAR** ``char(4) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**LAST_ACTIVE_TERM** ``char(1) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**EFFECTIVE_YEAR** ``char(4) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**EFFECTIVE_TERM** ``char(1) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**DROPPED_YEAR** ``char(4) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**CREDIT_PREFIX** ``char(2) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**CREDITS** ``char(3) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**MCL_TYPE_CD** ``char(1) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**ACTIVITY_TYPE_CD** ``char(1) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**SPECIAL_CD** ``char(1) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**EXPAND_COURSE_TITLE_DESCR** ``varchar(80) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``