NSO Charges

Problem Description : 

This is the script to run for Sharon Ellis to list the students that were charges the NSO fees. 

 

 

 Resolution : 

 

SELECT student.id (TBRACCD_PIDM, 'ND') ID, student.name (TBRACCD.TBRACCD_PIDM) Name 

 FROM TBRACCD

 WHERE TRIM (TBRACCD_ENTRY_DATE) = '25-JUL-11'

 AND TBRACCD_DETAIL_CODE ='NSOF' 

 

 

 

 

 Revision Date : 7/25/2011