.. index::
   DEPT_MATH_CRS_MTG_ROOM_V

====================================================
DEPT_MATH_CRS_MTG_ROOM_V --- Course Room Assignments
====================================================

.. default-role:: doc

:Description:

   Information about scheduled times and rooms for mathematics section
   meetings. This table is created by Data Services by combining
   `DPT_MATH_MTG_SECTION_V` and `DEPT_MATH_CRS_ROOM_V`.

:Source:

   Automatically copied from Data Services with
   ``getdataservices.py``.

:Footnote:

       It is better to use the original tables.



Columns
=======


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

   :Options:

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


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

   :Options:

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


**SEMESTER** ``varchar(11) DEFAULT NULL``

   :Options:

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


**ACAD_YEAR** ``varchar(45) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**CLASS_HOURS** ``float DEFAULT NULL``

   :Options:

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


**CLASS_MINUTES** ``smallint(6) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**CAMPUS_NAME** ``varchar(22) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**BL_NAME** ``varchar(64) DEFAULT NULL``

   :Options:

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


**LAT_VAL** ``float DEFAULT NULL``

   :Options:

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


**LONG_VAL** ``float DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**CAPACITY** ``smallint(6) DEFAULT NULL``

   :Options:

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


**CAPACITY_GROUP** ``varchar(7) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**UNIT_CODE** ``varchar(127) DEFAULT NULL``

   :Options:

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


**UNIT_NAME** ``varchar(127) DEFAULT NULL``

   :Options:

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


**UNIT_CD_NAME** ``varchar(127) DEFAULT NULL``

   :Options:

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


**UNIT_LEVEL_CD** ``varchar(127) DEFAULT NULL``

   :Options:

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


**UNIT_LEVEL_NAME** ``varchar(127) DEFAULT NULL``

   :Options:

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


**COURSE_INFO** ``varchar(127) NOT NULL``

   :Options:

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


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

   :Options:

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


**SUM_STOP_POINT** ``smallint(6) DEFAULT NULL``

   :Options:

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


**SUM_REGD_ENROLLMENT** ``smallint(6) DEFAULT NULL``

   :Options:

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