Moving A Student From Melton to a Dorm that Requires a Guarantor

Problem Description : 

Moving A Student From Melton to a Dorm that Requires a Guarantor

 

 

 Resolution : 

 

Moving A Student From Melton to a Dorm that Requires a Guarantor

 

BEFORE FEES ARE ASSESSED:

Make Sure Meal Plan on New Term is WD and do a Record Remove on SLAMASG

Make Sure The Room Assignment is WR and do a Record Remove on SLARASG

Update Old Term on SLARMAP - to field to current term

 

 

AFTER FEES ARE ASSESSED

Be sure to WR the SLARASG Record for the New Term

Run this in TOAD

select rowid, slbrmap.* from SLBRMAP where SLBRMAP.SLBRMAP_FROM_TERM = '201508'(Enter Current term)

and slbrmap_pidm = student.spriden_pidm('929198403')

 

 

 

 

Go to to_term and double click and change to old term

SAVE   

COMMIT

 

 

 

 

 Revision Date : 11/10/2015

 

 

 

 Keywords : Housing, Melton, Guarantor, SLARASG