Tool Search: Ed-Fi
This association relates students to their parents, guardians or caretakers.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When the Guardian check box is checked on the Relationships tab.
|
| Put | When any field not part of the natural key is change:
|
| Delete | When the Guardian check box is unchecked, relationship is end dated or deleted.
|
| Delete | Records will delete when a student has only one Student School Association record for a specific School and Year that record is deleted. (Note: If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data). |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Delete/Post | Cascading Deletes: The logic for an Ed-FI ID change will update all resources impacted by this change. |
Scope Year Logic
This table describes scope year logic of this object.
| Business Rules |
|---|
A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year.
|
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.
|
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label | Mapping Needed |
|---|---|
| Relationship Descriptor | Relation Types |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| RelatedPair | personID1-personID2 (personID1 is student, personID2 is parent) |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| relatedPair | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Student Parent Parent Association resource.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
id | The unique identifier of the resource. |
| M |
| |
| parentReference | A reference to the related Parent resource. |
| M | ||
| studentReference | A reference to the related Student resource. | Report the reference from the Student record for the student being reported. | M | ||
| contactPriority | The numeric order of the preferred sequence or priority of contact. | Do not report, not collected in Campus. | O | ||
| contactRestrictions | Restrictions for student and/or teacher contact with the individual (e.g., the student may not be picked up by the individual). | Do not report, not collected in Campus. | O | ||
| emergencyContactStatus | Indicator of whether the person is a designated emergency contact for the student. |
| O | Census> People> Relationships> Emergency Priority | relatedpair.seq |
| livesWith | Indicator of whether the student lives with the associated parent. |
| O | Census> People> Households | |
| primaryContactStatus | Indicator of whether the person is a primary parental contact for the student. |
| O | Census> People> Relationships> Guardian | relatedpair.guardian |
| relationDescriptor | The nature of an individual''s relationship to a student; for example: Father Mother Step Father Step Mother Foster Father Foster Mother Guardia. |
| O | Census> People> Relationships> Relationship | relatedpair.name |
| etag | A unique system-generated value that identifies the version of the resource. | O |
