+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, SIMS Database ID - have I got the right field? in Technical; Just to check : Am I right in thinking that in SIMS reporting, the "SIMS Database ID" is the first ...
  1. #1
    Quatermass's Avatar
    Join Date
    Mar 2007
    Location
    Sussex
    Posts
    82
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SIMS Database ID - have I got the right field?

    Just to check : Am I right in thinking that in SIMS reporting, the "SIMS Database ID" is the first field under the CESThirdPartyFields node, simply called "ID" - and that (here at least) it's a 5 digit number?

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,187
    Thank Post
    1,285
    Thanked 1,030 Times in 730 Posts
    Rep Power
    658
    For people (students/contacts/teachers) I tend to use Person_ID as it's consistently available across all relevant report focuses, plus it's a fairly short number (easier to do manual lookups by ID if necessary)

  3. #3
    Quatermass's Avatar
    Join Date
    Mar 2007
    Location
    Sussex
    Posts
    82
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Sorry to be dim, is Person_ID the same as the field I mentioned?

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,187
    Thank Post
    1,285
    Thanked 1,030 Times in 730 Posts
    Rep Power
    658
    Quote Originally Posted by Quatermass View Post
    Sorry to be dim, is Person_ID the same as the field I mentioned?
    Hard to say, unfortunately there doesn't seem to be much consistency as to exactly what the ID field you mentioned is, that's why I use Person_ID - it's always available and always called Person_ID so you can be sure to get a match. You have to be in Third Party Reporting group to see it, but it's not always under the CESThirdPartyFields node (helpful!), sometimes it's at the root node

    person_id.jpg

  5. #5
    Quatermass's Avatar
    Join Date
    Mar 2007
    Location
    Sussex
    Posts
    82
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Ah - your screenshot shows the student view, and ours is the same. But where do you choose it from in staff view?

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,187
    Thank Post
    1,285
    Thanked 1,030 Times in 730 Posts
    Rep Power
    658
    Quote Originally Posted by Quatermass View Post
    Ah - your screenshot shows the student view, and ours is the same. But where do you choose it from in staff view?
    Irritatingly, it seems it is now just called ID had to open up one of my reports that uses it to find it. How annoying!

    So, write off what I said - there is no consistency!

    EDIT: the more useful answer would be - try a couple of ID options and find which works best for you. I use the ID formerly known as Person_ID because it's short, simple and numeric; there is also External_ID (at least, there was! Not sure what they call it now) which is an alphanumeric string, roughly 15 characters long. Still usable but harder to lookup manually if the need arises.
    Last edited by LosOjos; 20th January 2014 at 10:21 AM.

  7. Thanks to LosOjos from:

    Quatermass (20th January 2014)

SHARE:
+ Post New Thread

Similar Threads

  1. Smoothwall Express - Have I got this right?
    By BatchFile in forum Internet Related/Filtering/Firewall
    Replies: 18
    Last Post: 6th December 2013, 09:15 AM
  2. [SIMS] Find users SIMS Database ID and make report
    By TheFopp in forum MIS Systems
    Replies: 1
    Last Post: 15th November 2013, 05:50 PM
  3. Core Switch Config - Have I got it right?
    By Mr.Ben in forum Wired Networks
    Replies: 9
    Last Post: 18th December 2012, 09:00 PM
  4. Binary have I got it right?
    By My220x in forum General Chat
    Replies: 8
    Last Post: 28th July 2008, 11:11 AM
  5. Replies: 5
    Last Post: 14th January 2008, 01:05 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
  •