DEPT_MATH_INSTRUCTOR_V — Instructor Assignments¶
- Description
Details about assignment of instructors to mathematics course sections. The sections themselves are described in DEPT_MATH_SECTION_V — Sections of Mathematics Courses.
- 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=""