I’m running a few simple queries on the tables stored within the DesktopService.mdb that the FIS spits out. Perhaps I cant see the wood for the trees but I cant seem to locate where the AGLH is stored against each enrolment. The “LearningDelivery” table would be the obvious location but it doesn’t appear to be there. Can anyone here point me in the right direction?
Sorry for the confusion. Perhaps a bit of background on what I’m trying to accomplish will help …..
The FIS report titled “EFA Funding Claim Report” has a section that counts how many learners we have in each of the 5 bandings. The top band is 540+ hours and the bottom band is up to 279 hours. I have been asked to identify which of our learners the FIS has identified as being in the bottom band.
Obviously the FIS is seeing the hours we have set against each enrolment (otherwise how would it know which band to place them in?). I’m trying to find where in FIS the hours are stored.
Andrew, as Martin points out, the hours are now learner based. In the FIS output MDB there is a field in the Learner table called LrnDV_RateBand_Efa which tells you which band the FIS has put your learners into.
I’ve looked at the ‘EFA 16-19 Summary of Funding by Student (Valid)’ report as suggested by Steve Bowler which lists all learners together with which band they belong to. This does not appear to tally with the numbers on the EFA funding claim report. For example, the funding claim report says we have 92 learners in the lowest band. The ‘EFA 16-19 Summary of Funding by Student (Valid)’ shows 106.
Yes, not only did the learner number match but do did the funding value too give or take a few pence. Do you have many learners crossing over two contract years? Or learners that signed up in 12/13 but were 19 years old as of 31.08.13, as these will still be EFA learners but funded on the SFA reports…
If you cross reference the two lists and highlight the discrepancies, there might be an obvious pattern. Let me know what you get and I’ll see what I can do to help…