« Updated null county codes in SOBSBGI | Main | New job submission: SZRMREP »
January 16, 2008
SCARF: Changed finaid category code for repay detail codes
I changed the way the scarf financial aid category query calculates the total amount for the term for students. Several new detail codes were added this last year that are repayments and the total was not calculating correctly. The old code did a sum(tbraccd_amount) and didnt take into account that these new codes are actually payments and should be subtracted from the total amount. So now it decodes whether its a charge or a payment: sum(decode(tbbdetc_type_ind,'C',tbraccd_amount,tbraccd_amount*-1))*-1 to come up with the correct results.
Posted by soukupm at January 16, 2008 5: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.)