+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Serco CMIS - Attendance tables? in Technical; Hi all, Would anyone know which tables in Cerco CMIS contain the following data sets... Personal Details Attendance Info Timetable ...
  1. #1
    Butters's Avatar
    Join Date
    Jun 2008
    Location
    London
    Posts
    534
    Thank Post
    15
    Thanked 51 Times in 45 Posts
    Rep Power
    60

    Serco CMIS - Attendance tables?

    Hi all,

    Would anyone know which tables in Cerco CMIS contain the following data sets...

    Personal Details
    Attendance Info
    Timetable
    Assessment Results

    Having a bit of trouble finding the correct tables for this info, any help would be appreciated!

  2. #2

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,619
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    304
    The infamous NSTUResults is Results, NSTUPERSONAL is Personal Details as for the other ones they escape my mind as I haven't needed to poke them but its probably something similar. Anything NSTU is related to the student and they are actually, despite what people say, fairly logically labelled if you just look in SQL Manager at the actual tables.

  3. #3
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    88
    Thank Post
    1
    Thanked 18 Times in 17 Posts
    Rep Power
    48
    As John pointed out, NSTURESULTS holds assessments data, but you might also need to make reference to ASSESSCRITERIA to see if it's a comment type, and if it is you'll need to cross refer to STURESCOMM to get the actual comment data out rather than the numeric CommentId.

    Timetable data is kind of spread out across several tables, it really depends on what you need to get at the SQL of this data for. The main bulk of it is in TIMETABLE, but you'll find that much of this is encoded as object Ids (like SlotId, WeekId etc.), and you'll need to find the related tables to bring out the human-readable version of this info.

    Attendance is split across two tables, ATTDETAIL and NSTUATTDATA. The data in each should be identical, it's horses for courses as to which you prefer, personally I find the data format in ATTDETAIL to be easier to work with.

    Personal data is stored mainly in STUDENTS, NSTUPERSONAL and UKSTUSTATS. Still depends on exactly what you're after, however.

  4. #4
    Butters's Avatar
    Join Date
    Jun 2008
    Location
    London
    Posts
    534
    Thank Post
    15
    Thanked 51 Times in 45 Posts
    Rep Power
    60
    Excellent, thanks alot guys, should help out with what I'm planning.

  5. #5

    Join Date
    Apr 2007
    Location
    Peterborough
    Posts
    55
    Thank Post
    2
    Thanked 9 Times in 5 Posts
    Rep Power
    17
    Thank you Skyw0rca for the comments below.

    I'd like to pick your brains a little more if I can. Looking at these tables reveals AM and PM Roll CAll attendance data for a student in two different formats as you have said, but it appears only to show the exceptions where a student is late, absent or other. Am I misreading the table data of is there another table for LessonByLesson attendance for every occurance of an attendance submission through ePortal?

    Thanks Martin

    Quote Originally Posted by SkywOrca View Post
    As John pointed out, NSTURESULTS holds assessments data, but you might also need to make reference to ASSESSCRITERIA to see if it's a comment type, and if it is you'll need to cross refer to STURESCOMM to get the actual comment data out rather than the numeric CommentId.

    Timetable data is kind of spread out across several tables, it really depends on what you need to get at the SQL of this data for. The main bulk of it is in TIMETABLE, but you'll find that much of this is encoded as object Ids (like SlotId, WeekId etc.), and you'll need to find the related tables to bring out the human-readable version of this info.

    Attendance is split across two tables, ATTDETAIL and NSTUATTDATA. The data in each should be identical, it's horses for courses as to which you prefer, personally I find the data format in ATTDETAIL to be easier to work with.

    Personal data is stored mainly in STUDENTS, NSTUPERSONAL and UKSTUSTATS. Still depends on exactly what you're after, however.

  6. #6
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    88
    Thank Post
    1
    Thanked 18 Times in 17 Posts
    Rep Power
    48
    Sorry, I didn't point out that these tables only relate to Roll Call attendance (the AM and PM attendances). Lesson-by-lesson is indeed in another table, the perhaps even more incomprehensible TTATTSTUDENTS table.

    This one lists the SlotId (from TIMETABLE, which you'll probably need to link to several other tables to make sense of) relating to the lesson, the student id and a collection of Attr1, Attr2, ..., Attr40 columns which then map to the week number for the actual lesson on a particular day. You'd need to map these week numbers via CCALMAPS and the WeekDay of the slot to identify the actual date that these attributes map back to. It's possible I've skipped a step in all this since I'm pretty sure you also need to map this data via the WeekId to finally link to the specific date required...

    Did I mention how difficult this table is?

SHARE:
+ Post New Thread

Similar Threads

  1. cmis attendance extraction
    By master in forum MIS Systems
    Replies: 5
    Last Post: 28th November 2007, 08:07 PM
  2. Serco CMIS Facility
    By bursar in forum MIS Systems
    Replies: 11
    Last Post: 22nd May 2007, 04:36 PM
  3. Refreshing MS Access linked tables to CMIS MS SQL
    By dickyfinn02 in forum MIS Systems
    Replies: 0
    Last Post: 23rd April 2007, 04:33 PM
  4. Serco CMIS Facility and Groupcall
    By nigelp in forum MIS Systems
    Replies: 3
    Last Post: 27th February 2007, 12:25 PM
  5. Serco's Facility Attendance
    By danIT in forum MIS Systems
    Replies: 0
    Last Post: 7th September 2006, 01:23 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
  •