.. index:: Teaching_Availability_and_Preferences_Data_Template =================================================== Teaching_Availability_and_Preferences_Data_Template =================================================== .. default-role:: doc :Description: obsolete? Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **first_name** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **last_name** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **netid** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **email** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Role** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **load** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **GradCourse** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Assignment** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NumCourses** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Maple** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **OwnCourse** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **HeadTA** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMH1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTF1** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMH2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTF2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppW2F5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMH3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTF3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppW3F4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppMW9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ppTH9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **PPCampus** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **PPOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perM9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perT9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perW9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perH9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF1** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF3** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF7** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perF9** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **perCampus** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **PerOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS023** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS025** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS026** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS111** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS112** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BS115** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X103** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X104** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X106** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X107** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X108** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X109** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **10X110** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc135** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc136** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc138** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc151** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc152** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc244** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc250** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc250C** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc251** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc252** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_135_5** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_151_Small** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_151_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_152_Small** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_152_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_191** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_192** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_196** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Cal2_251_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc311** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc351** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc354** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc421** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc477** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Calc481** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL285** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL291** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL292** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL300** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL300_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL311** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL311_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL312** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL321** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL336** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL338** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL348** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL350** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL350_Honors** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL351** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL354** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL355** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL356** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL357** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL361** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL373** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL403** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL411** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL412** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL421** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL423** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL424** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL428** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL432** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL435** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL436** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL441** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL451** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL452** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL453** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL454** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL461** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL468** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL477** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL478** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL481** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL485** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL486** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL492** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **UL495** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **ULOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummerTch** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_B** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_C** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_E** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_F** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_H** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Summer_T** ``bit(1) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF8** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF10** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF12** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF2** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF4** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesM6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesT6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesW6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesH6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummTimesF6** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummOther** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SumHowMany** ``smallint(6) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummOther2** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **SummCampus** ``varchar(255) 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=""``