Post

2 followers Follow
1
Avatar

Add Family ID to Enrollment Report

Hello,

Each term after we roll over our enrolments, we need to work through merging them by family. To identify families with multiple enrolments, we run the Enrollment report and group it by Last Name. This is obviously imperfect because same family and same last name aren't identical. If the Family ID was listed in that report, we could group it by that instead, and be certain of finding all the invoices that need merging.

Thanks,
Paul

Paul Spencer

Please sign in to leave a comment.

2 comments

1
Avatar

I am writing from the development department of a community music school and I am surprised that this is a request that appears not to have been addressed yet because it crosses so many aspects of ANY work within relational databases. My organization, for instance, relies on a unique identifier to pair donor family records in the fundraising database with student enrollment data in the student family database in order to perform imports and to create mailings - we are a newer ASAP customer and are just learning that it appears that we can no longer sync our databases using the one unique family-identifying ID. This impacts our organizational fundraising efforts in a profound way, down to and including effective fundraising mailings, donor trend analysis, and being able to recognize which donors are student families and alumni families. Please consider this a second strong and urgent request to add Family Account ID to the enrollment report and the student report. Because Family Account ID is the internal relational key in ASAP between all family member records (if I'm understanding this field correctly), it is beyond imperative that this be a functional field for reporting and, honestly, I would love to know why this is a field that we cannot access across the majority of the reports or see in the family profile page given how central and basic it is to the functioning of the database and how it ties all records together.

Thanks,

Emily

Emily Hogan 1 vote
0
Avatar

Emily again - editing to add that I JUST saw the check box for Family Account ID on the student report - hooray! For enrollment report and all other places where IDs are used to identify a family record, though, my request still holds.

Emily Hogan 0 votes