+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Unique identifier in Technical; I have to perform an extraction for a web based piece of software our group of school uses, we need ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    Unique identifier

    I have to perform an extraction for a web based piece of software our group of school uses, we need each extraction to have a unique identifier which comes straight from the database.

    The schools run both Sims.net and CMIS, the unique identifiers dont have to match each school each school is independant.

    I have to extarct first name, surname, classes, year and tutro group along with a unique number/set of charecters for each teacher, can anyone think of anything or suggest anything. We tried DFES numbers and Payroll number but schools donw always have a complete set of this information.

    Dan

  2. #2

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    Re: Unique identifier

    like pupils have a UPN surely staff must have a UTN

  3. #3
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    26

    Re: Unique identifier

    When I had to do something similar I gave each school a three letter code and added it to the beginning of the userID - making it unique

    Alternatively, if you need them to be traceable if they move from one school to another then can you pull out something constant like their name plus their DOB together as a string?

  4. #4

    Join Date
    Jan 2007
    Posts
    425
    Thank Post
    7
    Thanked 32 Times in 27 Posts
    Rep Power
    22

    Re: Unique identifier

    danit: a UTN would be the DfES Number. A unique person number (country wide) would be the NI number.

    Although name + dob is a one option, im not sure thats a good idea either - you *could* in theory have two people with the same DOB.

    The 3 letter coding would work - if you cant get hold of the NI Number or something.

    Kyle



SHARE:
+ Post New Thread

Similar Threads

  1. Unique ICT Opportunities within Harris Federation...
    By Harris in forum Educational IT Jobs
    Replies: 9
    Last Post: 18th October 2007, 04:07 PM
  2. Replies: 0
    Last Post: 8th February 2007, 04:58 PM
  3. Sims.net (unique user defined reports missing)
    By edie209 in forum MIS Systems
    Replies: 3
    Last Post: 15th June 2006, 01:17 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
  •