iSAMS SQL queries for exam results

[DisplayName]

Hi all, new to Edu Geek - seems like a great community!

 

I am working in a school that is asking me to produce a list of the 2025 (and 2026 when released) exam results, with student names, subject/paper, and and raw exam result (i.e. not the exam grade). The goal being to highlight students who sit close to grade boundaries.

 

I am struggling to find the table(s) where the data sits, wondering if any you may know as I am new to iSAMS - always been a SIMS user.

 

Cheers
 

[TechMonkey]

I don't know if it is a custom report but we have a report called Results Day near-miss Report, under Exams Manager, Results, right hand bar.  Apparently the boards give out CSV of Grade boundaries that we have to concatenate into one long CSV line, and then the report does its thang.  This is our first year of doing it so I can't tell you any more than that.

I'm not sure how site specific the report is but happy to pass you the RDL if it helps

[DisplayName]

Yes please! I think that would really help.

[TechMonkey]

I've messaged you

[DisplayName]

Big thanks to @TechMonkey for sending the file across, helped solve a massive issue.