We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
I'm working on creating a SQL query for creating a customized report card using the Open SQL QUery Tool in the plugins. I'm having trouble locating the table that shows the link between the student record and their Homeroom. I can find each faculty homeroom with no problem. I can see the field SBHomeroom - but because we are running Registrar's Office - that's null. I definitely have homerooms assigned to all students - and teachers assigned to homerooms.
I've looked in EA7Records, EA7Students - just not finding it.
Any suggestions would be greatly appreciated.
__________________ Candace Chesler
The Frances Xavier Warde School
Chicago, IL www.fxw.org
I found it! It's in the EA7PromotionSummaries table, linked by StudentID. I was looking for a table that showed Progression - but thought that PromotionSummaries related to the Promotion Schedules - not Student Progression.
The query referenced in BB136010 was helpful.
I think that's enough SQL language for a Saturday night. Time to toast my success with a martini - shaken - not stirred.
__________________ Candace Chesler
The Frances Xavier Warde School
Chicago, IL www.fxw.org
Linear Mode
