September 4, 2008
HB 3509
This is a series of reports that get run each year for A/R over in the business office. There are four categories.
Student Tuition and Fees
TUI,FEE,TUN,DCE,IED,NRF
Auxillary Enterprises
HOU,MEA,AUX,PHO,COU,TR,BKS,ATH,PAR
Student Aid
INS
Other Revenue
ADM,APF,AR,ART,ASW,BIL,CAS,CSH,CNT,DEP,FA,GRN,INT,LIB,QCD,MUS,NON,RFA,TRN,TRV,SCI,SIN,EXM,RET,CAR
The program is tzrlate.pc
Increment the Dec 31 year in the get_trans procedure and main select statement
Run it 4 times with the appropriate tbbdetc_dcat_code statement
Posted by wendlerb at 1:51 PM | Comments (0)
August 20, 2008
ACH in SIS
Looks like you create a detail code, put it on the student account, and then let tgrfeed bring it across to finance. It's recommended that the address type in GXADIRD be left blank so it gets picked up correctly by tgrfeed. So far I've gotten it to feed across and make the journal entry but not the invoice piece. I believe it has something to do with the doc code on gurapay. Probably needs to match SQ like checks.
Posted by wendlerb at 4:36 PM | Comments (0)
April 23, 2008
Billing
To reset billing
set statement date, due date, and bill date on tbraccd records you want to redo
Posted by wendlerb at 2:34 PM | Comments (0)
January 4, 2008
fee assessment
The new version of sfkfees stopped working the same way as the current. When a student drops a class and then another class, they get two penalty records on tbraccd. The new version was reversing the first penalty charge. I made a change to the following in p_processfeeassessment
IF (sobterm_rec.sobterm_assess_swap_ind = 'Y' AND DROPS) THEN
-- WOU mod (sobterm_rec.sobterm_assess_swap_ind = 'Y' AND REVERSE_ZEROTONINE) THEN
p_process_hours_swap(pidm_in,
term_in,
phrs,
pstart,
pend );
END IF;
/* ****************************************************** */
/* 104667, if SWAPPING is OFF, and yet PENALTY REVERSAL is*/
/* still expected in an RBT, then do the following. */
/* ****************************************************** */
/* Wou Mod
IF ( NOT(PENALTY_REV_DONE)
AND NVL(sobterm_rec.sobterm_refund_ind,'N') = 'Y'
AND REVERSE_ZEROTONINE) THEN
p_rev_nonswap_RBT(pidm_in,
term_in );
END IF;
end Wou Mod */
Posted by wendlerb at 11:54 AM | Comments (0)
August 9, 2007
SZRHRAS
This job submission shows credit hours divided into part of term 1, 3, and 6 for a student in a given term. It also gives a sum of the tuition charges from tbraccd.
Posted by wendlerb at 1:23 PM | Comments (0)
July 12, 2007
Tuition Promise - rollover cont
Ok, I made a trigger off of sfrstcr instead (sfrstcr_insert_row). It is a pre-insert trigger that I hope doesn't foul things up. I tested it on myself in woudev and the trigger fired and put the BAS08 rate code in but I didn't do a fee assessment properly. Might be because BAS08 rate insn't set up in woudev. I will have to wait for a refresh before trying some more.
Posted by wendlerb at 8:22 AM | Comments (0)
July 9, 2007
Tuition Promise - rollover
I was looking at some of the endterms populated this term and saw that the closest term was 200803. Started thinking about what happens if studen takes a class in 200900. Current process, szpexpp, only picks up students past their endterm who registered for 200900. Problem is that if fee assessment is turned on for web reg, they initially get assessed at old rate (BAS07). I can't tell anysooner with a job submission program. So I started thinking I need a pre insert trigger on the tablr sgbstdn that checks to see if current term is past the endterm and if so insert the next rate.
Still need to increment a new szrchrt record as well and probably think about adding new cohort code as well.
Update: Doesn't work. Sgbstdn only gets inserted by user manually. Tried sfrstcr and that won't work either. Can insert new cohort code and endterm but not rate.
Posted by wendlerb at 1:40 PM | Comments (0)
December 15, 2006
Tuition promise (cont)
Set up 3 table tiggers (saradap and sarappd tables) into production because I found updating data on saradap and inserting a record into sgrchrt to be a big headache after the fact. So, 200701 UG residents are getting BAS07 rate and put in TP07 cohort.
Started coming up with some logic for program to deal with students when promise expires. Created a tablr prom_term to help calulate number of terms since admit decision. Transfer students are unique in that you have to figure out how many terms they're entitled to depending on the hours transfered. Once they go past the 4 year limit, they are supposed to go up 1 year at a time. 5 year students are still a question.
Posted by wendlerb at 2:01 PM | Comments (0)