The Education/School Relationship ID (ESRImpID) is the link to the education record in The Raiser's Edge. It is unique for each education record and is required when updating existing education records through Import. Without this field, the program would not know which education record to update.To view the Education Relationship Import ID from the Relationship Record:
- Select Records>Constituents.
- Open the appropriate Constituent record.
- Select the Relationships tab.
- Double-click to open the appropriate Relationship record.
- Select File>Properties. The Relationship Import ID will be listed on the resulting window.
To export the Education Relationship Import ID for a group of records:
- Create a Constituent export.
- On the General tab, select Include>Selected record to include a query of gifts, if desired.
- Select the Output tab.
- From Available fields, select Relationships>Education>Import ID.
- Click Export now to view results.
- Create an Education/School Import File.
- Select the Fields tab.
- From Available fields, select Education Relationship Import ID.
- Click Create Now to view results.