+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, See the key field in Technical; Hey, Bit of a random question but is there anyway of running a report in SIMs that shows the key ...
  1. #1

    Join Date
    Jun 2010
    Location
    King's Lynn
    Posts
    24
    Thank Post
    8
    Thanked 2 Times in 1 Post
    Rep Power
    9

    See the key field

    Hey,

    Bit of a random question but is there anyway of running a report in SIMs that shows the key fields for students?

  2. #2
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,022
    Thank Post
    803
    Thanked 346 Times in 270 Posts
    Blog Entries
    60
    Rep Power
    278
    Do you mean primary key? Each student has a UID and these are invisible by default unless you add yourself to the permissions group for automated exports I think?

    If it has been entered, you can also use UPN at a pinch.

  3. Thanks to CAM from:

    spend_day (3rd July 2013)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    There are a number of ID's you can use in SIMS but my favourite is Person_ID - it's unique, it's short and it's numeric (unlike External_ID which is unique but very long and alphanumeric).

    To see it, you have to be in the "Third Party Reporting" group and then add it in to a report. You'll also notice that for every type of report you'll then see a "CES Third Party Fields" option, which contains ID's for all types of objects in SIMS and quite often the ID's of any directly related object (e.g. the aspect and resultset ID's when viewing a results report)

    I'm unsure if any of these match up to the primary key used in the SIMS SQL DB, I've never checked because I never read directly from the DB, always through CommandReporter
    Last edited by LosOjos; 3rd July 2013 at 01:39 PM.

  5. 2 Thanks to LosOjos:

    CAM (3rd July 2013), spend_day (3rd July 2013)

  6. #4

    Join Date
    Jun 2010
    Location
    King's Lynn
    Posts
    24
    Thank Post
    8
    Thanked 2 Times in 1 Post
    Rep Power
    9
    yeah sorry primary key.

    we had a biostore fingerprint system put in not long ago and I've been told by them that there "Person ID" number is taken from the primary key field in SIMs. I need the "Person ID" to link users to AD (by inputting into an AD field) but the Biostore database isn't populated until new students become "current" in sims. I want to input the "Person ID" when I create the new year 7 accounts but the new year 7's don't become "current" until the day before they start.

    Rather than get our SIMs manager to change the year 7's start date on SIMs I was just wondering if there was an easy way to find what I was looking for.

  7. #5

    Join Date
    Jun 2010
    Location
    King's Lynn
    Posts
    24
    Thank Post
    8
    Thanked 2 Times in 1 Post
    Rep Power
    9
    Quote Originally Posted by LosOjos View Post
    There are a number of ID's you can use in SIMS but my favourite is Person_ID - it's unique, it's short and it's numeric (unlike External_ID which is unique but very long and alphanumeric).

    To see it, you have to be in the "Third Party Reporting" group and then add it in to a report. You'll also notice that for every type of report you'll then see a "CES Third Party Fields" option, which contains ID's for all types of objects in SIMS and quite often the ID's of any directly related object (e.g. the aspect and resultset ID's when viewing a results report)

    I'm unsure if any of these match up to the primary key used in the SIMS SQL DB, I've never checked because I never read directly from the DB, always through CommandReporter
    I think you may have just cracked it.



    EDIT: Thanks LosOjos thats exactly what I needed
    Last edited by spend_day; 3rd July 2013 at 01:53 PM. Reason: Update

  8. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Happy to help

SHARE:
+ Post New Thread

Similar Threads

  1. Why are my users seeing the Windows Update icon?
    By -Jim in forum Windows Server 2000/2003
    Replies: 9
    Last Post: 2nd April 2009, 10:09 AM
  2. Did anyone see The Thirties in Colour ?
    By mattx in forum General Chat
    Replies: 6
    Last Post: 10th December 2008, 12:52 PM
  3. Replies: 12
    Last Post: 10th October 2008, 06:32 AM
  4. lost the key for rm systembase server
    By amyr in forum Hardware
    Replies: 6
    Last Post: 24th January 2007, 08:53 AM
  5. Windows NT4 won't see the internet
    By nawbus in forum Windows
    Replies: 7
    Last Post: 27th July 2006, 09:05 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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