.. index:: tbl1_TransferRequests ===================== tbl1_TransferRequests ===================== .. default-role:: doc :Description: Student Requests for Transfer Credit Preapprovals or Postapprovals :Relation: one-to-one with tbl1_Requests table where tbl1_Requests.RequestID = tbl1_TransferRequests.RequestID :Footnote: It is recommended that in future we consider collapsing this table and all request-specific tables into the single tbl1_Requests table Also, there has been some discussion as to whether it would be worth standardizing the external schools and courses so decisions could be recalled easily (which would mean we would need to make list of external schools and courses table-driven instead of letting user type whatever they want). Initial analysis (by Nishali) determined that it was not worth doing this for several reasons, mostly because (i) large adiminstrative effort in standardizing the external school/course list and (ii) we cannot guarantee that external school's course curriculum remains constant, so decisions could not be necessarily trusted anyway (only as a guideline to past decisions) Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **RequestID** ``int(11) DEFAULT NULL`` :Relation: relates one-to-one with RequestID in `tbl1_Requests` table :Options: ``display="true", null="true", search="false", type=""`` **request_type** ``varchar(255) DEFAULT NULL`` :Description: "Preapproval" or "Postapproval" :Footnote: would be better as a number indicating which type :Options: ``display="true", null="true", search="false", type=""`` **course_name** ``varchar(255) DEFAULT NULL`` :Description: External School's course name :Options: ``display="true", null="true", search="false", type=""`` **course_number** ``varchar(255) DEFAULT NULL`` :Description: External School's course number :Options: ``display="true", null="true", search="false", type=""`` **course_school** ``varchar(255) DEFAULT NULL`` :Description: External School Name :Options: ``display="true", null="true", search="false", type=""`` **course_credits** ``int(11) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **course_grade** ``varchar(15) DEFAULT NULL`` :Description: For postapprovals, grade student got in the course :Options: ``display="true", null="true", search="false", type=""`` **course_start_date** ``datetime DEFAULT NULL`` :Description: Start date of external course :Options: ``display="true", null="true", search="false", type=""`` **course_end_date** ``datetime DEFAULT NULL`` :Description: End date of external course :Options: ``display="true", null="true", search="false", type=""`` **file1_link** ``varchar(255) DEFAULT NULL`` :Description: File student uploads #1 (usually course syllabus) :Footnote: This will be stored something like this: 20181105143914_senior_transcript.pdf Where upload_path translates into the location Joomla! is saving the submitted files. This is represted in Solutions code as a global constant in mod_declarations :Options: ``display="true", null="true", search="false", type=""`` **file2_link** ``varchar(255) DEFAULT NULL`` :Description: File student uploads #2 :Options: ``display="true", null="true", search="false", type=""`` **file3_link** ``varchar(255) DEFAULT NULL`` :Description: File student uploads #3 :Options: ``display="true", null="true", search="false", type=""`` **ru_course_number** ``varchar(3) DEFAULT NULL`` :Description: obsolete? :Options: ``display="true", null="true", search="false", type=""`` **ru_course_name** ``varchar(255) DEFAULT NULL`` :Description: obsolete? :Options: ``display="true", null="true", search="false", type=""`` **ru_course** ``varchar(255) DEFAULT NULL`` :Description: Rutgers course student is requesting credit for in format like "135 CALCULUS I" :Options: ``display="true", null="true", search="false", type=""`` **transfer_notes** ``mediumtext DEFAULT NULL`` :Description: Transfer advisor's notes while evaluating :Options: ``display="true", null="true", search="false", type=""`` **NJSchool** ``bit(1) DEFAULT NULL`` :Description: TRUE if this is an NJ Transfer type request :Footnote: from a NJ school, see www.njtransfer.com . Also discuss with Lew H, there is an ongoing conversation as to whether we can bypass NJ Transfer type preapprovals. :Options: ``display="true", null="true", search="false", type=""`` **OnlineCourse** ``bit(1) DEFAULT NULL`` :Description: TRUE if an online course :Footnote: Historically, the math department will not approve transfer credit requests for online courses :Options: ``display="true", null="true", search="false", type=""`` **syllabus_url** ``mediumtext DEFAULT NULL`` :Description: URL for course syllabus :Footnote: we prefer that students submits this when possible instead of uploading a syllabus file since uploads can theoretically be forged. :Options: ``display="true", null="true", search="false", type=""`` **syllabus_url2** ``mediumtext DEFAULT NULL`` :Description: 2nd URL field :Options: ``display="true", null="true", search="false", type=""`` **student_comments** ``mediumtext DEFAULT NULL`` :Description: Comments student entered when they filled out form :Options: ``display="true", null="true", search="false", type=""`` **advisor_name** ``varchar(255) DEFAULT NULL`` :Description: Advisor name :Options: ``display="true", null="true", search="false", type=""`` **advisor_department** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **decision_date** ``datetime DEFAULT NULL`` :Description: Advisor's department :Options: ``display="true", null="true", search="false", type=""`` **decision_code** ``smallint(6) DEFAULT 0`` :Description: Decision code number corresponding to advisor decision made for request. see mod_declarations constant declarations for corresponding values :Footnote: future: move to tbl1_Requests table. Historically we had overlapping decision codes across the different request types. But we have since moved to using a single pool of non-overlapping decision codes, in which case this means we can move decision out of these request-specific tables and into the tbl1_Requests table :Options: ``display="true", null="true", search="false", type=""`` **ru_equivalent_course** ``varchar(255) DEFAULT NULL`` :Description: Equivalent course :Options: ``display="true", null="true", search="false", type=""`` **transfer_equivalent_code** ``varchar(255) DEFAULT NULL`` :Description: Course advisor has determined is equivalent, in equivancy code format SAS requires :Options: ``display="true", null="true", search="false", type=""`` **admin_comments** ``mediumtext DEFAULT NULL`` :Description: Administrative comments :Options: ``display="true", null="true", search="false", type=""`` **transfer_from_semester** ``varchar(50) DEFAULT NULL`` :Description: Semester course was taken :Options: ``display="true", null="true", search="false", type=""`` **transfer_from_year** ``varchar(10) DEFAULT NULL`` :Description: Year course was taken :Options: ``display="true", null="true", search="false", type=""`` **duplicate_request** ``bit(1) DEFAULT b'0'`` :Description: TRUE if request was flagged as a duplicate :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=""``