+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, PASS Attendance in Technical; Does anyone know which table in WCBS/PASS holds the pupil attendance data? Is it stored by exception (ie everyone is ...
  1. #1

    Join Date
    Sep 2009
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    PASS Attendance

    Does anyone know which table in WCBS/PASS holds the pupil attendance data? Is it stored by exception (ie everyone is assumed to be present if not explicitly flagged as absent) or by status for all pupils? A brief look would indicate that db.events and dbo.attendance_details might contain the data but it doesnt look quite right.

  2. #2
    Iain's Avatar
    Join Date
    Oct 2006
    Location
    Warwickshire
    Posts
    195
    Thank Post
    28
    Thanked 94 Times in 54 Posts
    Rep Power
    32
    Take a look at the view XX_AC_ABSENCE_CURR_YEAR, where XX is your school code. If you look at the SQL for that view, it should give you the tables that are involved in working out attendance.

    Iain.

  3. #3

    Join Date
    Sep 2009
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Thanks

    Iain, Thanks for the help. Winding my way through this I ended up at the events table with event_type of ABSNCE and category <> PRESAM and <> PRESPM
    Richard



SHARE:
+ Post New Thread

Similar Threads

  1. Sims Attendance
    By ndavies in forum MIS Systems
    Replies: 3
    Last Post: 7th July 2008, 09:39 AM
  2. Attendance 7
    By MattGibson in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2008, 12:58 PM
  3. Attendance error sims
    By imiddleton25 in forum MIS Systems
    Replies: 4
    Last Post: 5th June 2008, 04:51 PM
  4. cmis attendance extraction
    By master in forum MIS Systems
    Replies: 5
    Last Post: 28th November 2007, 09:07 PM
  5. Importing into SIMS Attendance
    By Jonsi in forum MIS Systems
    Replies: 12
    Last Post: 7th November 2007, 11:18 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
  •