« Financial Aid Category Update - Yearly Offered Amount | Main | Weekly Report: Database Consolidation, swrrmet »
March 17, 2006
Research Table
Just when I thought I had the code perfectly written to grab the correct major for the research table, a new problem arose. Some of the curriculum records are being back dated to a prior term so the logic failed on those students because it was collecting the records with the highest lcur_seqno. Now I have it grabbing the highest term code, with the highest lcur_seqno for that term, and the highest sorlfos_seqno with the same lcur_seqno and term code as above as long as it has a priority number of 1. I tested it out today and it works perfectly! Now I just need to update my f_get_major function and I'll be set.
Posted by soukupm at March 17, 2006 04:03 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)