How to Pull the Nelnet Count Sql

 Problem Description : 

Count of Nelnet Students with in or out of state tuition - ernolled and charged

 Resolution : 

run this sql

SELECT DISTINCT 

 student.id(a.TBRACCD_pidm),

 STUDENT.NAME(a.TBRACCD_pidm),

 FG_TERM_CHARGES_BY_DETAIL_CODE(a.TBRACCD_PIDM,'201405','TUIT'),

 FG_TERM_CHARGES_BY_DETAIL_CODE(a.TBRACCD_PIDM,'201405','NRES'),

 ve.class_hrs

 FROM TBRACCD a , v_enrollment ve

WHERE A.TBRACCD_TERM_CODE = '201405' AND A.TBRACCD_DETAIL_CODE = 'NLNT'

 and ve.pidm = a.tbraccd_pidm 

 and ve.term_code = '201405'

 and ve.class_hrs > 0

 SELECT DISTINCT 

 student.id(a.TBRACCD_pidm),

 STUDENT.NAME(a.TBRACCD_pidm),

 FG_TERM_CHARGES_BY_DETAIL_CODE(a.TBRACCD_PIDM,'201405','TUIT'),

 FG_TERM_CHARGES_BY_DETAIL_CODE(a.TBRACCD_PIDM,'201405','NRES'),

 ve.class_hrs

 FROM TBRACCD a , v_enrollment ve

WHERE A.TBRACCD_TERM_CODE = '201405' AND A.TBRACCD_DETAIL_CODE = 'NLNX'

 and ve.pidm = a.tbraccd_pidm 

 and ve.term_code = '201405'

 and ve.class_hrs > 0 

 and NOT exists( SELECT 'X' from tbraccd b where b.tbraccd_pidm = a.tbraccd_pidm

 and b.tbraccd_term_code = '201405'

 and b.tbraccd_detail_code = 'NLNT') 

This sql is located in the N:\csd\tracy\sqls\csd folder

 Revision Date : 6/3/2015