Nebraska Ed-Fi Data v3.1 - Student School Association

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student.  A record will report for each distinct enrollment in a School and Enrollment Start Date.

  • When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order:
    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled.
  • Do not send records if the School Exclude check box is checked in the calendar the student is enrolled.
  • Do not send a record if the No Show check box is checked.
  • When the Secondary School field is populated, report information from this new school as an override to the current school.
Post

When the start date for an enrollment is changed.

  • When an enrollment with a lower priority is changed, data will not send.
Put

When an enrollment is updated for a student.

  • When a change is made to the Graduation > NCLB Cohort End Year field.
  • When a student is assigned to a Graduation or CTE Program or the start and/or end dates are modified.
  • When a student's start status is changed.
  • When a student's end status is changed.
  • When a student's grade level is changed.
  • When a student's End Action is changed.
  • When a student's School Choice checkbox is checked or unchecked.

  • When a student's Resident District or Service District fields are changed.
  • When a students Service Type is changed.

  • When the Calendar reference is changed due to a Natural Key update on the Calendars resource.
Delete

When an enrollment is deleted.

  • When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
Delete

When the start date of an enrollment is changed.

DeleteWhen the No Show check box is checked.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action

Business Rule

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.
PutIf the natural key of the Calendar Reference is changed, a put will be done to update the Calendar Reference even if the Student School Association resource is turned 'OFF'
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.

Action

Business Rule

Post/Delete

Natural Key changes:  

  • If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number.  The delete tool would need to be used to remove all data from the old School ID.   If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
  • If the enrollment start date changes, all dependent resources will be deleted and reposted.   If a dependent resource is turned off, all dependent resources will be deleted and not reposted.
Delete

Cascading Deletes:  If the Student School Association is deleted, all dependent resources will be deleted.

  • Student Parent Associations, Student Education Organization Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the enrollment is associated with.
Data will only send for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Entry Type DescriptorsEnrollment Start Status
Exit Withdraw Type DescriptorsEnrollment End Status
Residency Status DescriptorsEnrollment Resident Status

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

EnrollmentenrollmentID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

enrollment

Post/Put/Delete

The primary table used for sending data for this resource

personPost/DeleteStudent ID in Student Reference
graduationPutClass of School Year Type Reference
programsPutGraduation Plan Reference
programparticipationPutGraduation Plan Reference

Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field

   id   

 The unique identifier of the resource. 


M


  entryDate   The month, day, and year on which an individual enters and begins to receive instructional services in a campus.   
  1. Report the enrollment start date.
MStudent Information> General> Enrollments> Start Dateenrollment.startdate
calendarReferenceA reference related to the Calendar resource.
  1. Report the Calendar reference for the calendar in which the student is enrolled that is being reported.
O

classOfSchoolYear
TypeReference  
 The year the student is expected to graduate. 
  1. Report the year selected in Student Info > General > Graduation. > NCLB Cohort End Year.
    • If NCLB Cohort End Year = Null, do not report.
C

graduationPlan
Reference
A reference to the related GraduationPlan resource.
  1. Report the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi.
    • The Program Participation record must overlap the enrollment(s) that are aligned to the Student School Association record(s) being reported.
  2. Report the Graduation Plan School year that is aligned to the student's NCLB Cohort End Year.
    • If the student does not have a NCLB Cohort End Year, do not report a record.
  3. If the student has both a CTE & Graduation Plan, report the Graduation Plan.
  4. If the student has more than 1 Graduation Plan, report the plan with the most recent start date.
O

  schoolReference   A reference to the related School resource. 
  1. Reports the fields that are part of the Natural Key for the School resource.


M

 schoolYearType
Reference  
The school year the student is being reported in.
  1. Reports the end year of the calendar.
O

  studentReference   A reference to the related Student resource. 
  1. Report the reference for the student being reported.


M

 educationPlans  An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled. 
  1. This is optional, does not report.
O

 employedWhileEnrolled  An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education. 
  1. This is optional, does not report.
O

entryGradeLevel
Descriptor 
 The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session. 
  1. Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. If a mapping is not available, the record will error.
MStudent Information> General> Enrollments> Grade
 entryGradeLevel
ReasonDescriptor 
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. This is optional, does not report.
O

 entryTypeDescriptor  A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Report the Ed-Fi Code Value mapped to the Start Status selected.
  2. If blank, do not report.
OStudent Information> General> Enrollments> Start Statusenrollment.startstatus
 exitWithdrawDate  The month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. 
  1. Report the enrollment end date.
OStudent Information> General> Enrollments> End Dateenrollment.enddate
 exitWithdrawType
Descriptor 
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Report the Ed-Fi Code Value from the End Status selected.
  2. If blank, do not report.
OStudent Information> General> Enrollments> End Statusenrollment.endstatus
 primarySchool  Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. 
  1. Report 'True' if Service Type = P: Primary.
  2. Otherwise, report 'False'.
OStudent Information> General> Enrollments> Service Typeenrollment.type
 repeatGradeIndicator  An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back. 
  1. Look at the student's last enrollment record prior to the enrollment that is reporting and report the following:
    • Report 'True' of End Action is = R: Retain.
    • Report 'False' if the End Action = P: Promote, D: Detain or NULL.
      • The prior enrollments start date must be before the reporting enrollment's start date.
OStudent Information> General> Enrollments> End Actionenrollment. endAction
 residencyStatus
Descriptor 
An indication of the location of a persons legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit.
  1. Report 'Resident of admin unit and school area' if the Resident and Serving District fields are either NULL or = to the reporting district.
    • This can be any combination of NULL or populated (ex. Serving District can be NULL and Resident District = to reporting District).
  2. Report 'Resident of admin unit, but other school area' when the Serving District is not = to Reporting District.
    • The Resident District must be NULL or = to the reporting district to report.  If not, then report blank.
  3. Report 'Resident of this state, but not of this admin unit' when the Resident District is not = Reporting District.
    • The Serving District must be NULL or = to the reporting district to report.  If not, then report blank.

Student Information> General> Enrollments>

enrollment.residentdistrict

and/or

enrollment.servingdistrict

 schoolChoiceTransfer  An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116. 
  1. Reports 'True' when the checkbox is checked.
  2. Reports 'False' when the checkbox is not checked.
OStudent Information> General> Enrollments> School Choiceenrollment. schoolChoiceProgram
districtOfResidence
Reference
This association indicates any relationship between a student and an education organization other than however the state views enrollment.
  1. Reports the district number selected in the Home District field on the enrollment being reported.
    • report the default value if populated.
  2. If Home District is NULL, report the District Number of where the student is enrolled.
  3. The format for this field must be 'XX-XXXX'.
M

Student Information> General> Enrollments> Home District

Or

System Admin> Resources> District> District Number

enrollment.residentdistrict

or

district.number

schoolOfResidence
Reference
Reports if populated on student enrollment.

Report as xx-xxxx-xxx

Example: Home District Number 280017 +Resident School Number 007 will report as 28-0017-007.

MStudent Information> General> Enrollments> School of Assignment
reportingSchool
Reference
A reference to the related School resource.The identifier assigned to a school by the State Education Agency (SEA).RSystem Administration > Resources > School > State School Number
ExcpectedHighSchool
ofGraduation
An indication of where the student is expected to graduate from.

If the student is expected to graduate from a High School that the student is currently NOT enrolled in, report that information from the Expected Grad High School field on enrollment.

If the student will be graduating from the school they are currently enrolled in, we do not need to report this field.

CStudent Info> General> Enrollment> State Reporting> Expected Grad High School
FullTimeEqivalencyAn indication of the students FTE.Send the integer provided in enrollment> Percent Enrolled. If blank, do not report. It will error on the state side.CStudent Info> General> Enrollment> Percent Enrolled
StudentDaysEnrolledAn override field for student calendars.Send this data if the Student Days Enrolled field is populated. If not, do not report.CStudent Info> General> Enrollment> Student Days Enrolled
etag




Type/Descriptor

Click here to expand...

Entry Grade Level Descriptors

Code ValueDescriptionShort Description
Adult EducationAdult EducationAdult Education
Early EducationEarly EducationEarly Education
Eighth gradeEighth gradeEighth grade
Eleventh gradeEleventh gradeEleventh grade
Fifth gradeFifth gradeFifth grade
First gradeFirst gradeFirst grade
Fourth gradeFourth gradeFourth grade
Grade 13Grade 13Grade 13
Infant/toddlerInfant/toddlerInfant/toddler
KindergartenKindergartenKindergarten
Ninth gradeNinth gradeNinth grade
No grade levelNo grade levelNo grade level
OtherOtherOther
PostsecondaryPostsecondaryPostsecondary
Preschool/PrekindergartenPreschool/PrekindergartenPreschool/Prekindergarten
Second gradeSecond gradeSecond grade
Seventh gradeSeventh gradeSeventh grade
Sixth gradeSixth gradeSixth grade
Tenth gradeTenth gradeTenth grade
Third gradeThird gradeThird grade
Twelfth gradeTwelfth gradeTwelfth grade
UngradedUngradedUngraded

Entry Type Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
100Still EnrolledStill Enrolled
101Original EntryOriginal Entry
102Transfer InTransfer In
103Re-entryRe-entry

Exit Withdraw Type Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
200Transfer Out; Intra-DistrictTransfer Out;Intra-District
201Transfer OutTransfer Out
202Drop OutDrop Out
203Completer: DiplomaCompleter: Diploma
204Completer: No DiplomaCompleter: No Diploma
205Not Enrolled; Eligible to ReturnNo Enrolled; Eligible to Return
206DeceasedDeceased
208Maximum AgeMaximum Age
209Withdrawal from Mandatory AttendanceWithdrawal from Mandatory Attendance
299End of School YearEnd of School Year


Residency Status Descriptors

Ed-Fi Code ValueEd-Fi Short Description Ed-Fi Description

00

Not applicable

Not applicable

01Contracted in from another Nebraska public school districtContracted in from another Nebraska public school district
02Contracted in from nonpublic schoolContracted in from nonpublic school
03Contracted in from another stateContracted in from another state
04NCLB School Choice StudentNCLB School Choice Student
05Contracted out to another Nebraska public school districtContracted out to another Nebraska public school district
06Optioning in from another Nebraska public school districtOptioning in from another Nebraska public school district
07Contracted out to another stateContracted out to another state
08Learning Community Open EnrollmentLearning Community Open Enrollment