+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Deleting Staff in SIMS.net in Technical; I need to delete a member of staff but can't seem to get it to work. The member of staff ...
  1. #1

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    501
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    22

    Question Deleting Staff in SIMS.net

    I need to delete a member of staff but can't seem to get it to work. The member of staff has a leaving date but when I go into Routines -> Delete Staff and seach against the member, it says they can't be deleted.

    Below in the Data Summary is says: This staff has Database Data (1 record). It cannot be deleted.

    Any suggestions on how to remove this member of staff?

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    I could be wrong but I dont think you can delete staff Remember reading something about DCSF guidelines and other drivel which means they can't/won't be deleted

  3. #3

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    501
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    22
    Hmmmm. Why do they have delete staff routine if that might be the case? If I could figure out what "Database Data (1 Record)" is I might be able to delete them. I though this might be connected to a user account, so I remove the staff concerned from the employee group in system manager - made no difference.

  4. #4

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    You cannot delete users, but only make them inactive. This is because users contribute centrally to data held within a database and are the authors of the data.

  5. #5
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    41
    Quote Originally Posted by Michael View Post
    You cannot delete users, but only make them inactive. This is because users contribute centrally to data held within a database and are the authors of the data.
    Another reason may be for tracking purposes. The data is held at a higher level than just your school, the LEA or indeed National Government departments may wish to track back to obtain a users history - employment for example.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    what if the staff record was created in error and actually duplicates an existing record. e.g. a parent becomes employed, or as happens sometimes, a member of staff leaves and then joins again at a later date.

    for data integrity i want to reuse the existing user but a new one was created accidentally by personnel officer number 1. this now causes an error when running the delete user routine.

    i get the database data record that says last accessed 01/01/1900 00:00:00 and 2 records under performance data that say 0 assessment results and 0 exam results. they weren't even a teacher!

    this is the second such user i have, and i've just preceded the names with the word DELETE and put in a leaving date for employment.

    could do with getting rid and cleaning up the database.

    found this on support net http://support.capitaes.co.uk/websup...72518.xmlFalse
    Last edited by vikpaw; 26th January 2009 at 11:35 AM.

  7. #7

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    Quote Originally Posted by vikpaw View Post
    what if the staff record was created in error and actually duplicates an existing record. e.g. a parent becomes employed, or as happens sometimes, a member of staff leaves and then joins again at a later date.

    for data integrity i want to reuse the existing user but a new one was created accidentally by personnel officer number 1. this now causes an error when running the delete user routine.

    i get the database data record that says last accessed 01/01/1900 00:00:00 and 2 records under performance data that say 0 assessment results and 0 exam results. they weren't even a teacher!

    this is the second such user i have, and i've just preceded the names with the word DELETE and put in a leaving date for employment.

    could do with getting rid and cleaning up the database.

    found this on support net http://support.capitaes.co.uk/websup...72518.xmlFalse
    It seems to let you delete some staff but not others.

    Where we have had staff entered in error, we just but XXX in front of their surname and forename and tick the box not to included them in Census.

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    As it's a redundant record the next time we need to add someone completely new to the system, i might reuse these DELETE / XXX prefixed users and make them active again.

    But it would have to be someone completely new, never been an agent, contact, parent, staff etc. etc.

    at least that will get rid of them.

  9. #9

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,678
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    You can delete staff using

    Routines ==> Staff ==> Delete staff.
    It checks to see that they are not connected to anything and then deletes them.

    Usefull if someone creates the staff with no start date so when I search for them, don't find them in "Current" staff and so create them and end up with dupicates.


  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    but stuart, that routine doesn't work, as it always finds some hidden records. well that is the case at 2 different schools i've seen it in at least.
    silly records to do with 0 assessment results, or default login date as described in previous post.

    these 'connections' are being checked for and found and therefore the user cannot be deleted. i don't know what it is that creates these connections but it prevents the deletion.

  11. #11

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    I've used the delete staff routine successfully where records have been accidentally duplicated but it sometimes takes a bit of detective work to track down the linked data and either delete it or add it to the correct record. Once the associated data has been removed the user can be. My biggest headache has been where the NI number has been added to the 'wrong' record. Although you can create a record without an NI number you can't delete it once it's in.

  12. #12
    robins's Avatar
    Join Date
    May 2007
    Posts
    44
    Thank Post
    15
    Thanked 5 Times in 5 Posts
    Rep Power
    15
    Seems that if there are records associated with that teacher's code in NovaT prior to the timetable being re-saved then the prospect of avoiding referential integrity problems with a delete in SIMS is nil until next academic year (NovaT6) or never (NovaT4).

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Deleting rooms in SIMS.net
    By Sylv3r in forum MIS Systems
    Replies: 5
    Last Post: 20th April 2012, 10:00 AM
  2. Replies: 23
    Last Post: 3rd October 2009, 05:44 PM
  3. Sims Reporting - Deleting Favourites
    By mtnewman in forum MIS Systems
    Replies: 2
    Last Post: 2nd September 2008, 08:55 AM
  4. Adding new staff in SIMS .NET
    By CESIL in forum MIS Systems
    Replies: 7
    Last Post: 18th March 2008, 03:23 PM
  5. Import Staff into Sims.net via a CSV
    By stephen.loader in forum MIS Systems
    Replies: 2
    Last Post: 14th January 2008, 11:32 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
  •