+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Free School Meals for Leavers Report?? in Technical; Hi guys Trying to find out which leavers had a free school meal eligibility. Is all this data wiped for ...
  1. #1
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14

    Lightbulb Free School Meals for Leavers Report??

    Hi guys

    Trying to find out which leavers had a free school meal eligibility. Is all this data wiped for reporting purposes when a pupil leaves? I can clearly see the data in a pupil's record, but a report cannot pick it up.

    Can anyone explain / confim / riddicule


  2. #2
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,007
    Thank Post
    124
    Thanked 286 Times in 263 Posts
    Rep Power
    109
    I just tried it quickly by replacing replacing the student filter with just year of leaving but got no data.

  3. Thanks to ChrisH from:

    SteveB (12th October 2009)

  4. #3
    dsm
    dsm is offline

    Join Date
    Nov 2008
    Location
    Kent
    Posts
    82
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    It should all still be in the system.

    Have you tried creating a report with 'use effective date' and using the day before they left as the day?

  5. Thanks to dsm from:

    SteveB (12th October 2009)

  6. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,007
    Thank Post
    124
    Thanked 286 Times in 263 Posts
    Rep Power
    109
    Quote Originally Posted by dsm View Post
    It should all still be in the system.

    Have you tried creating a report with 'use effective date' and using the day before they left as the day?
    That works .... Oops should have thought of that one :P

  7. #5
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Well i've tried that, and the pupil is still showing as F for eligiable for school meals and the FSM eligiblity dates are still blank, even though if i browse to record i can see them.

    pic attached
    Attached Images Attached Images

  8. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    Your "effective on" date (right hand side in your JPG) reads as 12/10/2009 where the childs record part of the JPG reads that the eligibility ceased sometime in September.

    The effective date doesn't seem to be set properly.

  9. Thanks to superfletch from:

    SteveB (12th October 2009)

  10. #7
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Quote Originally Posted by superfletch View Post
    Your "effective on" date (right hand side in your JPG) reads as 12/10/2009 where the childs record part of the JPG reads that the eligibility ceased sometime in September.

    The effective date doesn't seem to be set properly.
    ohh bl**dy hell . . . .


    I'll get me coat . . . . . .




    Thanks

  11. #8
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    ahah! BUT! this will only work if i manage to pick a date within the elgibility range. This report is supposed to look back and show leavers with a listing of when they WERE eligable...

    If i run the report for 31/08/09 (1 day before eligibility) then i get no dates

  12. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    Try this one (import it into SIMS and run it) - not sure if it is exactly what you need but worth a go...

    It should be a .rptdef file type but instead I had to rename it to .txt as rptdef is not a valid extension on the forum.
    Attached Files Attached Files

  13. Thanks to superfletch from:

    SteveB (13th October 2009)

  14. #10
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Quote Originally Posted by superfletch View Post
    Try this one (import it into SIMS and run it) - not sure if it is exactly what you need but worth a go...

    It should be a .rptdef file type but instead I had to rename it to .txt as rptdef is not a valid extension on the forum.
    Thanks for this, but this is my point! Your design is almost the same as mine and both do not work correctly. If you are looking at when the pupil was eligible for FSM, you have to date the report to fall within the eligibility range, otherwise the pupil comes back as "F" no eligable. Plus the FSM dates do not get populated. So if you were looking at all Leavers who had different eligibility dates, you cannot get an overall list!

    It is not working correctly i am sure

  15. #11
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    445
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    That is pretty annoying actually - it seems that the eligibility dates don't pull through unless the effective on date is within that period.

    As far as meal eligibility True/False is concerned the effective on date will provide you with the T or F for that date only.

    I suppose this bit makes sense as the child could be eligible for FSM and then not eligible and then change back to being eligible so what it is reporting is true.

    As for the eligibility date ranges not pulling through that is rather annoying.

    Can I ask why you need it?

  16. #12
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Quote Originally Posted by superfletch View Post
    That is pretty annoying actually - it seems that the eligibility dates don't pull through unless the effective on date is within that period.

    As far as meal eligibility True/False is concerned the effective on date will provide you with the T or F for that date only.

    I suppose this bit makes sense as the child could be eligible for FSM and then not eligible and then change back to being eligible so what it is reporting is true.

    As for the eligibility date ranges not pulling through that is rather annoying.

    Can I ask why you need it?
    Sure, We need to look back a schools data for leavers to see if at any point they were eligible for FSM. I think there is a funding issue in a school and they need corrobative evidence.

    short of trawling all 200 pupils i cannot see a way to do it.

  17. #13
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    131
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    Just to update a kind chap on Supportnet posted a report that works. Using the History Groups.



SHARE:
+ Post New Thread

Similar Threads

  1. school meals
    By stu in forum General Chat
    Replies: 35
    Last Post: 15th May 2009, 10:35 AM
  2. BBC News School Report
    By BJG in forum General Chat
    Replies: 1
    Last Post: 11th February 2009, 11:07 AM
  3. Starters & Leavers
    By Kaz in forum How do you do....it?
    Replies: 3
    Last Post: 10th December 2008, 11:51 AM
  4. Year 13 leavers
    By ascott2 in forum General Chat
    Replies: 18
    Last Post: 28th May 2008, 01:26 PM
  5. School leavers use of IT.
    By laserblazer in forum General Chat
    Replies: 8
    Last Post: 3rd March 2008, 11:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •