Enrollment Numbers

 Problem Description : 

Running Enrollment Numbers for email to be sent

 

 

 Resolution : 

 

Open excel file n:\csd\Enrollment for the correct term. 

 

Only one column "Semester registered" will be populated.

 

Data for the columns registered and charges accepted are from the Admissions Summary Information in Banner web.

 

1. For Semester registered use "Total Registered" 

 

2. For Semester charges accepted use "Total Charges Accepted"

 

3. I use the query below in TOAD for the dorm students-

 

select *

from slrrasg dorm

where dorm.slrrasg_term_code = 201208

and dorm.slrrasg_ascd_code = 'AR'

 

4. The formulas are populated for all % Change columns.  

 

 

 

 

 Revision Date : 6/19/2012