.. index:: tbl1_Advising_Office_Contacts ============================= tbl1_Advising_Office_Contacts ============================= .. default-role:: doc :Description: This table holds the contact information for the advising office that should be contacted with student request decisions as needed. There is one contact listed per student's school (within Rutgers, for example SAS). List can be maintained via the 'Advising Office Conatacts' button on the Request Portal's transfer credit window. It is used when evaluator clicks the "Email Student's School Advising Office" button, or the "Email Other Advising Office" button Columns ======= **ru_school** ``varchar(255) NOT NULL`` :Description: Business School, Engineering, Mason Gross, Pharmacy, SAS, SEBS :Options: ``display="true", null="true", search="false", type=""`` **contact_name** ``varchar(255) DEFAULT NULL`` :Description: advising office contact name :Options: ``display="true", null="true", search="false", type=""`` **advising_office_email** ``varchar(255) DEFAULT NULL`` :Description: advising office contact email :Options: ``display="true", null="true", search="false", type=""`` **email_disclaimer** ``mediumtext DEFAULT NULL`` :Description: standard disclaimer text to be appended by default when creating new email to advising office :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=""`` **id** ``int(11) NOT NULL AUTO_INCREMENT`` :Options: ``display="true", null="true", search="false", type=""``