.. index::
   DEPT_MATH_INSTRUCTOR_V

=================================================
DEPT_MATH_INSTRUCTOR_V --- Instructor Assignments
=================================================

.. default-role:: doc

:Description:

   Details about assignment of instructors to mathematics course
   sections.  The sections themselves are described in
   `DEPT_MATH_SECTION_V`.

:Source:

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



Columns
=======


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

   :Options:

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


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

   :Options:

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


**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=""``


**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=""``


**SECTION_NO** ``char(2) 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=""``


**REG_INDEX_NO** ``char(5) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**PERCENTAGE_RATE** ``decimal(5,1) NOT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**MODE_DESC** ``varchar(200) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**ROLE_DESCR** ``varchar(200) NOT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**NETWORK_USER_NM** ``varchar(32) NOT NULL``

   :Options:

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


**NAME_LAST** ``varchar(23) DEFAULT NULL``

   :Options:

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


**NAME_FIRST** ``varchar(23) DEFAULT NULL``

   :Options:

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


**DISPLAY_NAME** ``varchar(200) DEFAULT NULL``

   :Options:

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