Nebraska Ed-Fi Data v3.1 - Student Parent Associations

Classic ViewSystem Administration > Ed-Fi

Search Terms: 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.

ActionTrigger
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.

  • If the student is a guardian of themselves (emancipated) then report the student as both the Parent and the Student.
  • If both people have a current enrollment, report the person with the higher age as the Parent.

    • If age cannot be determined, do not report a record.
  • 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 the relationship type is changed.

Delete

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

  • End Date must be blank or after school year end date defined in the School Years editor
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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Delete/PostCascading 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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

RelationshipRelation Descriptor


Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
RelatedPairpersonID1-personID2 (personID1 is student, personID2 is parent)


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
relatedPairPost/Put/DeleteThe 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 LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field

id

The unique identifier of the resource.


M


parentReferenceA reference to the related Parent resource.
  1. Report the reference from the Parent record for the parent being reported.


M

studentReferenceA reference to the related Student resource.
  1. Report the reference from the Student record for the student being reported.


M

contactPriorityThe numeric order of the preferred sequence or priority of contact.
  1. Do not report, not collected in Campus.
O

contactRestrictionsRestrictions for student and/or teacher contact with the individual (e.g., the student may not be picked up by the individual).
  1. Do not report, not collected in Campus.
O

emergencyContactStatus  Indicator of whether the person is a designated emergency contact for the student.
  1. Report True if there is a number entered in the Emergency Priority field for the parent being reported.
  2. Otherwise, report False.
OCensus> People> Relationships> Emergency Priority relatedpair.seq
livesWithIndicator of whether the student lives with the associated parent.
  1. Report True if student is in the same household of the parent being reported.
    • Both Student and Parent Household dates must follow Business Rule S2 in the Scope year logic for this to report.
  2. Otherwise, report False.
OCensus> People> Households
 primaryContactStatus Indicator of whether the person is a primary parental contact for the student.
  1. 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.
  2. Otherwise, report False.
OCensus> People> Relationships> Guardian relatedpair.guardian
 relationDescriptorThe nature of an individual''s relationship to a student; for example: Father Mother Step Father Step Mother Foster Father Foster Mother Guardian.
  1. Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped.
  2. If no mapping, do not report.
OCensus> People> Relationships> Relationshiprelatedpair.name
etagA unique system-generated value that identifies the version of the resource.
O


Type/Descriptor

Relationship Descriptors

Code ValueDescriptionShort Description
AuntAuntAunt
BrotherBrotherBrother
BrotherInLawBrotherInLawBrotherInLaw
CourtAppointedGuardianCourtAppointedGuardianCourtAppointedGuardian
CousinCousinCousin
DaughterDaughterDaughter
DaughterInLawDaughterInLawDaughterInLaw
EmergencyEmergencyEmergency
EmployerEmployerEmployer
FatherFatherFather
Father, stepFather, stepFather, step
FatherInLawFatherInLawFatherInLaw
FathersCivilPartnerFathersCivilPartnerFathersCivilPartner
FathersSignificantOtherFathersSignificantOtherFathersSignificantOther
FianceFianceFiance
FianceeFianceeFiancee
Foster parentFoster parentFoster parent
FriendFriendFriend
GodparentGodparentGodparent
GrandfatherGrandfatherGrandfather
GrandmotherGrandmotherGrandmother
GrandparentGrandparentGrandparent
Great auntGreat auntGreat aunt
Great GrandparentGreat GrandparentGreat Grandparent
Great uncleGreat uncleGreat uncle
GuardianGuardianGuardian
HusbandHusbandHusband
MotherMotherMother
Mother, stepMother, stepMother, step
MotherInLawMotherInLawMotherInLaw
MothersCivilPartnerMothersCivilPartnerMothersCivilPartner
MothersSignificantOtherMothersSignificantOtherMothersSignificantOther
NeighborNeighborNeighbor
NephewNephewNephew
NieceNieceNiece
OtherOtherOther
ParentParentParent
Parent, stepParent, stepParent, step
RelativeRelativeRelative
SiblingSiblingSibling
SignificantOtherSignificantOtherSignificantOther
SisterSisterSister
SisterInLawSisterInLawSisterInLaw
SonSonSon
SonInLawSonInLawSonInLaw
SpouseSpouseSpouse
UncleUncleUncle
UnknownUnknownUnknown
WardWardWard
WifeWifeWife