+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, Retention Period for old database? in Technical; We have a school who converted to academy and had a brand new SIMS database instead of applying the patch ...
  1. #1
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31

    Retention Period for old database?

    We have a school who converted to academy and had a brand new SIMS database instead of applying the patch to their existing one.

    They CTF'd a lot of details in for kids and have spent the last year or so getting SIMS back where it was as far as the rest of the data is concerned.

    They are now asking what sort of retention period they should be looking at for the old database.

    Any ideas?

  2. #2

    Join Date
    Jan 2012
    Posts
    669
    Thank Post
    262
    Thanked 95 Times in 80 Posts
    Rep Power
    26
    I'd have thought a min of 6 years but that's just a guess

  3. #3


    Join Date
    May 2009
    Posts
    2,923
    Thank Post
    259
    Thanked 773 Times in 588 Posts
    Rep Power
    284
    There is a Data Retention Toolkit for Schools that may help. I think the minimum for a secondary is 7 years but if it is the whole MIS DB, then there may be information you want to retain for longer.

  4. 3 Thanks to pcstru:

    GREED (2nd April 2014), superfletch (25th March 2014), vikpaw (25th March 2014)

  5. #4

    Join Date
    Jan 2012
    Posts
    669
    Thank Post
    262
    Thanked 95 Times in 80 Posts
    Rep Power
    26
    TBH if it were me i'd stick it somewhere safe and forget about it, it's unlikely to take up much space in the grand scheme of things

  6. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Interesting document.
    I'd have said something like 6/7 years after the student leaves, which is similar to the DOB + 25 years mentioned in the secondary guidelines.

    So you could go in and selectively purge data out each year but it seems such a painful system.
    However, i hate the thought of data being stuffed away somewhere and forgotten about, and worse still lying around in old backup tapes. Making it part of the annual process like doing rollover / promotion might not be a bad thing to do.

    We were recently asked for data for someone that graduated in the 80s looking for a transcript of grades. It must have been their first foray into employment
    We had to go and ask and 'old' teacher what sort of paper records we kept back then.

    This raises an interesting question : what's the longest any school has kept a single computerised MIS?

  7. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    If you really really want to get to field level data retention there are rules and guidance from dfe about how long to keep each item!

    You are likely safe with 7 years for school data I think it is also 7 years for financial stuff too?

    If you get into in care data you have to keep it for 25 years if not life in some cases... eeek

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Citation?

  9. #8

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Me? Oh I don't know. I think ironically that is the point that it isn't easy to find. Info I had was from old procurement sessions with LAs and more recently conversations with DFE folk during my secondment. Some might even have been on their intranet (which would have been even more ironic)

  10. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    Old pupils have a right to expect their old school to be able to give references. Indy schools still get requests after 20 years!

  11. #10

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Quote Originally Posted by PhilNeal View Post
    Old pupils have a right to expect their old school to be able to give references. Indy schools still get requests after 20 years!
    Expected, definitely. Not sure it is in statute though, more of benefit to both sides. I know we had reference requests for ladies who had left 15 years ago when I worked in the independent school. SIMS didn't go back that far but we had records still.

  12. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by PhilNeal View Post
    Old pupils have a right to expect their old school to be able to give references. Indy schools still get requests after 20 years!
    We had a request for someone that left in the 80s.
    But, will the DPA let you keep data that long - just because it's useful? Do they really have a right to expect that?

  13. #12

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    ... I will see if I can find the data retention docs... tisk. .. more work!

  14. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Your overworked mate, if you scroll up, @pcstru has already posted a link to the 'Data Retention Toolkit for Schools' which is chapter and verse.

  15. Thanks to matt40k from:

    GREED (2nd April 2014)

  16. #14


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,629
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    Electronically, we go back to September 1993 (based on sorting all pupils ever by admission number).

    Paper-based? I suspect much longer, though it would involve digging through archives.

  17. #15

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,976
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    Quote Originally Posted by matt40k View Post
    Your overworked mate, if you scroll up, @pcstru has already posted a link to the 'Data Retention Toolkit for Schools' which is chapter and verse.
    That is the document I have seen and used, so big thumbs up for that! I love how the breakdown for each data type has different retention periods. Would love to see an MIS with a built in tool to remove aspects of a pupil record at certain times!!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Facebook For Old People!
    By Netman in forum Jokes/Interweb Things
    Replies: 8
    Last Post: 14th December 2007, 03:42 PM
  2. Replies: 37
    Last Post: 7th March 2007, 01:17 AM
  3. Is there much of a market for old reference material??
    By sidewinder in forum General Chat
    Replies: 4
    Last Post: 28th February 2007, 10:58 AM
  4. Replies: 0
    Last Post: 17th February 2007, 04:43 PM
  5. Backing up MSDE (WMSDE for WSS) database with BackupExec
    By meastaugh1 in forum How do you do....it?
    Replies: 13
    Last Post: 23rd July 2006, 01:56 PM

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
  •