Hi all , I hope you can point me in the correct direction. Very simply I need a process to capture the number of hours a student is registered for on a daily basis. Not concerned at all about the fields or table/views needed.

I want to create a focus data set ( I believe that would be best ) that contains only 4 fields. PIDM , # of hours registered and a date stamp the file would look like this


Pidm Date Hrs _registered AR_validation_indicator
11111 07-01-2011 0
11111 07-02-2011 6 Y
11111 07-03-2011 15 Y
11111 07-04-2011 15 Y
222222 07-01-2011 12
222222 07-02-2011 12
222222 07-03-2011 12 Y
222222 07-04-2011 12 Y



The formatting is flexible. I have created focus data at the server level before with the output of fexes so I’m not looking for code but any suggestions on how to build this via report caster on a daily basis would be appreciated.

What we are trying to do is build a file that shows us if student have added additional hours after they have validated their registration. We are only trying to capture students who have added hours after they gave validated and we are not concerned about student who validate as full time. SunGard has told us that there is not a date stamp in Banner that identifies when the validation stamp was set so I need to capture that event on a student by student basis. This would then be measured against the current values in the system.


Any suggestions would be welcome as to format of the file or the process to create . Maybe I only need to capture the date they validate one time.. Just need some suggestions as to how I can capture this date. The 2 records above I have highlighted in red would be the ones I am concerned about. Apparently students once validated are not having their classes purged even if they move from par time to full time.. Billings does have a process to identify and remove the validation flag if I can identify them,

Thanks

This message has been edited. Last edited by: Kerry,

Greetings Geoff. Being at a Banner school, we used tables SFRSTCR and SFRSTCA to capture changes in hours. Mail me offline if you want to discuss more.
Paul Isherwood
Friends University