Wisconsin Ed-Fi Data v3.3 - Student Parent Associations

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. The guardian does NOT have to be a member of the same household as the student to report. Ed-Fi does not have relationship start or end dates, if a relationship is started anytime within a school year, the record will be added for that year. Start Date must be blank or on or before school year end date defined in the School Years editor. End Date must be blank or after school year end date defined in the School Years editor. Report the person from the related pair that does not have an enrollment for the Parent Reference and the person that has an enrollment as the student reference. A record will not send if the student they are associated with has an enrollment in a calendar or school marked as Exclude.
Put	When any field not part of the natural key is change: If the parent or student is removed from the household.
Delete	When the Guardian check box is unchecked, relationship is end dated or deleted. Ed-Fi does not have relationship start or end dates, if a relationship is ended within a school year, the record will be deleted for that year. End Date must be blank or after school year end date defined in the School Years editor. Records will delete when a student has only 1 Student School Association record for a specific School and Year that record is deleted for. (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) When the State Exclude or No Show check boxes are checked. (Note: if the boxes are unchecked the data will not re-post, a resync must be completed to resend the data)

Action

Trigger

Post

When the Guardian check box is checked on the Relationships tab.

The guardian does NOT have to be a member of the same household as the student to report.
Ed-Fi does not have relationship start or end dates, if a relationship is started anytime within a school year, the record will be added for that year.
- Start Date must be blank or on or before school year end date defined in the School Years editor.
- End Date must be blank or after school year end date defined in the School Years editor.
Report the person from the related pair that does not have an enrollment for the Parent Reference and the person that has an enrollment as the student reference.
A record will not send if the student they are associated with has an enrollment in a calendar or school marked as Exclude.

Put

When any field not part of the natural key is change:

If the parent or student is removed from the household.

Delete

When the Guardian check box is unchecked, relationship is end dated or deleted.

Ed-Fi does not have relationship start or end dates, if a relationship is ended within a school year, the record will be deleted for that year.
End Date must be blank or after school year end date defined in the School Years editor.
Records will delete when a student has only 1 Student School Association record for a specific School and Year that record is deleted for.
(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)
When the State Exclude or No Show check boxes are checked.
(Note: if the boxes are unchecked the data 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. The related pair start date must be null or on/before the scope year end date to report. The related pair end date must be null or on/after the scope year end date to report. Data will only send for the years that have valid configuration. A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.
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. Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Business Rules

A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

The related pair start date must be null or on/before the scope year end date to report.
The related pair end date must be null or on/after the scope year end date to report.
Data will only send for the years that have valid configuration.
A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.

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.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Relationship	Relation Descriptor

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.	Report the Ed-Fi LEA ID + '-' + personID.	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.	Report True if there is a number entered in the Emergency Priority field for the parent being reported. Else, report False.	O	Census> People> Relationships> Emergency Priority	relatedpair.seq
livesWith	Indicator of whether the student lives with the associated parent.	Report True if student is in the same household of the parent being reported Both Student and Parent Household dates must follow the Business Rules in the Scope year logic for this to report. Else, report False.	O	Census> People> Households
primaryContactStatus	Indicator of whether the person is a primary parental contact for the student.	Report True if there is only 1 guardian being reported. If more than 1 guardian report the guardian with the earliest start date. If Start dates are the same or NULL on 1 or more guardians, report the person with the lowest personID. Else, report False.	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.	Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped, if populated. Otherwise, report as Guardian based on the following (similar logic for WISEid extract and the Identity API: If Local Student Number is populated, report guardians based on the following logic: Find a person with Guardian checked (= TRUE) AND relationship is not ended as of the current date. Report first from the Primary Household Relationships, then from Secondary Household Relationships, finally from Non-Household Relationships.	O	Census > People > Relationships > Relationship	relatedpair.name
etag	A unique system-generated value that identifies the version of the resource.		O

Type/Descriptor

Relationship Descriptors

Code Value	Description	Namespace	Short Description
Aunt	Aunt	uri://ed-fi.org/RelationDescriptor	Aunt
Brother	Brother	uri://ed-fi.org/RelationDescriptor	Brother
BrotherInLaw	BrotherInLaw	uri://ed-fi.org/RelationDescriptor	BrotherInLaw
CourtAppointedGuardian	CourtAppointedGuardian	uri://ed-fi.org/RelationDescriptor	CourtAppointedGuardian
Cousin	Cousin	uri://ed-fi.org/RelationDescriptor	Cousin
Daughter	Daughter	uri://ed-fi.org/RelationDescriptor	Daughter
DaughterInLaw	DaughterInLaw	uri://ed-fi.org/RelationDescriptor	DaughterInLaw
Emergency	Emergency	uri://ed-fi.org/RelationDescriptor	Emergency
Employer	Employer	uri://ed-fi.org/RelationDescriptor	Employer
Father	Father	uri://ed-fi.org/RelationDescriptor	Father
Father, step	Father, step	uri://ed-fi.org/RelationDescriptor	Father, step
FatherInLaw	FatherInLaw	uri://ed-fi.org/RelationDescriptor	FatherInLaw
FathersCivilPartner	FathersCivilPartner	uri://ed-fi.org/RelationDescriptor	FathersCivilPartner
FathersSignificantOther	FathersSignificantOther	uri://ed-fi.org/RelationDescriptor	FathersSignificantOther
Fiance	Fiance	uri://ed-fi.org/RelationDescriptor	Fiance
Fiancee	Fiancee	uri://ed-fi.org/RelationDescriptor	Fiancee
Foster parent	Foster parent	uri://ed-fi.org/RelationDescriptor	Foster parent
Friend	Friend	uri://ed-fi.org/RelationDescriptor	Friend
Godparent	Godparent	uri://ed-fi.org/RelationDescriptor	Godparent
Grandfather	Grandfather	uri://ed-fi.org/RelationDescriptor	Grandfather
Grandmother	Grandmother	uri://ed-fi.org/RelationDescriptor	Grandmother
Grandparent	Grandparent	uri://ed-fi.org/RelationDescriptor	Grandparent
Great aunt	Great aunt	uri://ed-fi.org/RelationDescriptor	Great aunt
Great Grandparent	Great Grandparent	uri://ed-fi.org/RelationDescriptor	Great Grandparent
Great uncle	Great uncle	uri://ed-fi.org/RelationDescriptor	Great uncle
Guardian	Guardian	uri://ed-fi.org/RelationDescriptor	Guardian
Husband	Husband	uri://ed-fi.org/RelationDescriptor	Husband
Mother	Mother	uri://ed-fi.org/RelationDescriptor	Mother
Mother, step	Mother, step	uri://ed-fi.org/RelationDescriptor	Mother, step
MotherInLaw	MotherInLaw	uri://ed-fi.org/RelationDescriptor	MotherInLaw
MothersCivilPartner	MothersCivilPartner	uri://ed-fi.org/RelationDescriptor	MothersCivilPartner
MothersSignificantOther	MothersSignificantOther	uri://ed-fi.org/RelationDescriptor	MothersSignificantOther
Neighbor	Neighbor	uri://ed-fi.org/RelationDescriptor	Neighbor
Nephew	Nephew	uri://ed-fi.org/RelationDescriptor	Nephew
Niece	Niece	uri://ed-fi.org/RelationDescriptor	Niece
Other	Other	uri://ed-fi.org/RelationDescriptor	Other
Parent	Parent	uri://ed-fi.org/RelationDescriptor	Parent
Parent, step	Parent, step	uri://ed-fi.org/RelationDescriptor	Parent, step
Relative	Relative	uri://ed-fi.org/RelationDescriptor	Relative
Sibling	Sibling	uri://ed-fi.org/RelationDescriptor	Sibling
SignificantOther	SignificantOther	uri://ed-fi.org/RelationDescriptor	SignificantOther
Sister	Sister	uri://ed-fi.org/RelationDescriptor	Sister
SisterInLaw	SisterInLaw	uri://ed-fi.org/RelationDescriptor	SisterInLaw
Son	Son	uri://ed-fi.org/RelationDescriptor	Son
SonInLaw	SonInLaw	uri://ed-fi.org/RelationDescriptor	SonInLaw
Spouse	Spouse	uri://ed-fi.org/RelationDescriptor	Spouse
Uncle	Uncle	uri://ed-fi.org/RelationDescriptor	Uncle
Unknown	Unknown	uri://ed-fi.org/RelationDescriptor	Unknown
Ward	Ward	uri://ed-fi.org/RelationDescriptor	Ward
Wife	Wife	uri://ed-fi.org/RelationDescriptor	Wife