Currently I've been working on automating the form that students use to add and/or drop courses throughout the semester. I've been successful with automating the 'drop' portion by using a stored procedure to update an already existing row with a workflow service task.

Adding has been much harder. I know that it's inserting the information into a table called 'STUDENT_CRS_HIST' but it's also pulling data from multiple other tables that I'm unsure it's coming up with the relevant information. I'm curious if anyone been successful in automating something like this? I'm still a bit new with SQL and curious if there's an easier way to do the same process.

If I was to search a student in that table, it would show all classes they've ever enrolled in along with a code to tell if the course is 'C' for current or 'D' for dropped, grades, professor, course, etc. 

Thank you for any help. I just wanted to be sure it was possible without having to have Jenzabar do the process for me.