.. index:: css_sections2 ============= css_sections2 ============= .. default-role:: doc :Description: This table is used in conjunction with the getcss and putcss python programs and the css_upload table. The process works as follows: (i) Data from getcss.py fills this table. (ii) Solutions Synchronize process copies this data into `css_upload` table and makes edits reflecting any changes that have happened in Solutions, most commonly instructor assignments (iii) the putcss.py program uses `css_upload` to post changes to CSS (course scheduling system) web data Columns ======= **id** ``int(11) NOT NULL AUTO_INCREMENT`` :Options: ``display="true", null="true", search="false", type=""`` **year** ``int(11) DEFAULT 0`` :Options: ``display="true", null="true", search="false", type=""`` **term** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **unit** ``varchar(2) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **subject** ``varchar(3) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **course** ``varchar(3) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **sectionNo** ``varchar(2) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **regIndexNo** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **title** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **fullTitle** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **subTopic** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **supplement** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **currentCredits** ``varchar(3) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **stopPoint** ``varchar(3) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **priorEnrollment** ``varchar(3) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **projectedEnrollment** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **courseTypeCd** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **cmsCd** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **statusCd** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **approvedIndAsString** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructors1** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructors2** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netId1** ``varchar(32) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netId2** ``varchar(32) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netId3** ``varchar(32) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netId4** ``varchar(32) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netId5** ``varchar(32) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **rcpId1** ``varchar(8) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **rcpId2** ``varchar(8) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **rcpId3** ``varchar(8) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **rcpId4** ``varchar(8) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **rcpId5** ``varchar(8) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayEabFlag1** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayEabFlag2** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayEabFlag3** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayEabFlag4** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayEabFlag5** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayFlag1** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayFlag2** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayFlag3** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayFlag4** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayFlag5** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayName1** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayName2** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayName3** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayName4** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **displayName5** ``varchar(128) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructionModeCd1** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructionModeCd2** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructionModeCd3** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructionModeCd4** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructionModeCd5** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructorRoleCd1** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructorRoleCd2** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructorRoleCd3** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructorRoleCd4** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **instructorRoleCd5** ``varchar(5) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **percentage1** ``varchar(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **percentage2** ``varchar(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **percentage3** ``varchar(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **percentage4** ``varchar(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **percentage5** ``varchar(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **assignmentNumber1** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **assignmentNumber2** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **assignmentNumber3** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **assignmentNumber4** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **assignmentNumber5** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **day1** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **day2** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **day3** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **day4** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **day5** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeStart1** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeStart2** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeStart3** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeStart4** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeStart5** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **amPmStart1** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **amPmStart2** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **amPmStart3** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **amPmStart4** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **amPmStart5** ``varchar(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeEnd1** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeEnd2** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeEnd3** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeEnd4** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **timeEnd5** ``varchar(4) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **buildingCd1** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **buildingCd2** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **buildingCd3** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **buildingCd4** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **buildingCd5** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **room1** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **room2** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **room3** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **room4** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **room5** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **campusCd1** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **campusCd2** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **campusCd3** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **campusCd4** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **campusCd5** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modeCd1** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modeCd2** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modeCd3** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modeCd4** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **modeCd5** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **capacity1** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **capacity2** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **capacity3** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **capacity4** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **capacity5** ``varchar(10) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **leadSectionNo** ``varchar(2) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()`` :Options: ``display="true", null="true", search="false", type=""``