While adding a new Faculty from the IntraNet Faculty UI,
Faculty – Add a new Faculty
“SQL error” was encountered.
After looking into the SQL that caused the issue, it was found that a new data field “type” was missing from the original “insert” SQL statement. Because that data field was introduced after the original SQL statement.
“type” is to assign the faculty type to a faculty which indicates one of the three available:
A – Active; H – Honorable; F – Former
After adding that data field, adding a new faculty no longer causes “SQL error”, providing that required data fields are filled that include first name, last name, and department. (See the screenshot below)
The SQL error was fixed on 5/25/2025.