Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.
Home Blogs Forums Photos Downloads
Forums » Technical Forums » Read Only Database Assistance » Finding Student Homeroom

Finding Student Homeroom

Last post 05-17-2008 8:48 PM by Candace Chesler. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 05-17-2008 7:36 PM

    • Candace Chesler
    • Top 500 Contributor
    • User Since: 2002
    • Posts 31
    • Organization: Frances Xavier Warde Schools
    • Products:  Online Campus Community, The Education Edge, The Financial Edge, The Raiser's Edge

    Finding Student Homeroom

    Reply Contact

    I'm having trouble locating 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 need this link so that I can create my customized report card.

    Any suggestions would be greatly appreciated.

     

    Candace Chesler
    The Frances Xavier Warde School
    Chicago, IL

  • 05-17-2008 8:48 PM In reply to

    • Candace Chesler
    • Top 500 Contributor
    • User Since: 2002
    • Posts 31
    • Organization: Frances Xavier Warde Schools
    • Products:  Online Campus Community, The Education Edge, The Financial Edge, The Raiser's Edge

    Re: Finding Student Homeroom

    Reply Contact

    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.

    On to my next quest!

    Candace Chesler
    The Frances Xavier Warde School
    Chicago, IL
Page 1 of 1 (2 items)