tbl1_TransferRequests

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: <upload_path>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=""