Tennessee Ed-Fi Data v3.1 - Student School Associations

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
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. Do not send records if student has multiple active enrollments in the same School / Calendar. Do not send records if the Calendar Exclude checkbox is checked in the calendar the student is enrolled. Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled. Do not send a record if the No Show check box is checked.
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 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.
Delete	When the No Show checkbox is checked.

Resource Toggle and Resync Logic

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

Action	Business Rule
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.
Put	If 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'.
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	Business Rule
Post/Delete	Natural Key changes: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers. 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

Action

Business Rule

Post/Delete

Natural Key changes:

If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers.
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 Descriptors	Enrollment Start Status
Exit Withdraw Type Descriptors	Enrollment End Status

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Enrollment	enrollmentID

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.
person	Post/Delete	Student ID in Student Reference
graduation	Put	Class of School Year Type Reference
programs	Put	Graduation Plan Reference
programparticipation	Put	Graduation Plan Reference

Object Data Elements

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

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

The unique identifier of the resource.

entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.

Report the enrollment start date.

Student Information> General> Enrollments> Start Date

enrollment.startdate

calendar
Reference

A reference related to the Calendar resource.

IC Field

JSON Field

Logic

Instructional Program Number

calendarCode

If Instructional Program Number equals null or blank, populate “99”.

Otherwise,

populate Instructional Program Number.

State School Number / State District Number

schoolId

State District Number + State School Number

End Year

schoolYear

Populate the End Year of the school year tied to the configured year.

classOfSchoolYear
TypeReference

The year the student is expected to graduate.

This is optional, does not report.

graduationPlan
Reference

A reference to the related Graduation Plan resource.

This is optional, does not report.

schoolReference

A reference to the related School resource.

District Number + School Number

schoolYear
TypeReference

The school year in which the student is being reported.

Reports the fields that are part of the Natural Key for the School Year Type resource

studentReference

A reference to the related Student resource.

Report the reference for the student being reported.

educationPlans

An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled.

This is optional, does not report.

employedWhile
Enrolled

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.

This is optional, does not report.

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.

Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
If a mapping is not available, the record will error.

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

This is optional, does not report.

entryTypeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Report the Ed-Fi Code Value mapped to the Start Status selected.
If blank, do not report.

Student Information> General> Enrollments> Start Status

enrollment.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. NEDM: Exit/Withdraw Date

Report the enrollment end date.

Student Information> General> Enrollments> End Date

enrollment.enddate

exitWithdraw
TypeDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Report the Ed-Fi Code Value from the End Status selected.
If blank, do not report.

Student Information> General> Enrollments> End Status

enrollment.endstatus

primarySchool

Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.

Report 'True' if Service Type = P: Primary.
Else, report 'False'.

Student Information> General> Enrollments> Service Type

enrollment.type

repeatGrade
Indicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.

This is optional, does not report.

Student Information> General> Enrollments> End Action

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

This is optional, does not report.

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.

This is optional, does not report.

Student Information> General> Enrollments> School Choice

enrollment. schoolChoiceProgram

associatedPrimary
School

The following EIS 041 Student Enrollment definitions apply:

Primary District ID - Report the District ID of the student's primary or 'home' school.
Primary School ID - Report the ID of the school providing service, when not students primary/home school.

If Service Type = S: Partial, report District ID + School ID of the most recent enrollment with a Service Type = P: Primary.

Primary enrollment must be in the same school year.

studentSchoolAssociation
CharacteristicDescriptors

This is optional, does not report.

studentSchoolAssociation
InstructionalGrade
Descriptors

The following EIS 043 Student Instructional Grade definitions apply:

Instructional Grade Assignment - Report the instructional grade to which the student is assigned during the instructional service period.
Instr Grade Assignment Date - Report the date the student was assigned to the instructional grade.

See array section for logic.

Student Information > General > Enrollments

StudentSchoolAssociation
FundingStatusDescriptor

The following elements of the Funding Status Descriptor are mapped to EIS 042 Student Ineligibility Funding Status:

fundingStatusDescriptor
fundingStatusBeginDate
fundingStatusEndDate

This is optional, does not report.

instructionalService
Descriptors

This element is mapped to EIS 081 Student TA Instructional Services.

This is optional, does not report.

SupportService
Descriptors

This element is mapped to EIS 081 Student TA Support Services.

This is optional, does not report.

studentSchoolAssociation
StandardDays

The following EIS 047 Student Standard Day definitions apply:

Student Standard Day - Report the number of minutes for a full time student of this grade.
Student Std Day Effective Date - Report the date the student standard day became effective.

See array section for logic.

submittedforSchool
YearTypeReference

Key for School Year.

Using the End Date tied to the calendar of the student's enrollment, report the year.

System Administration > Calendar > Calendar > End Date

submittedByEducation
OrganizationReference
.educationOgranizationID

The identifier assigned to an education organization.

Populate the State District Number + State School Number of the student's enrollment.

System Administration > Resources > District Info, School

etag

Array Data Elements

Instruction Grade Descriptors

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
gradeLevelDescriptor	The following EIS 043 Student Instructional Grade definitions apply: Instructional Grade Assignment - Report the instructional grade to which the student is assigned during the instructional service period	From the state grade table, populate the code associated to the instructional grade.	O	Student Information > General > Enrollments > Grade	Enrollment.grade
beginDate	The following EIS 043 Student Instructional Grade definitions apply: Instr Grade Assignment Date - Report the date the student was assigned to the instructional grade	Populate Enrollment Start Date.	O	Student Information > General > Enrollments > Start Date	Enrollment.startDate
endDate		Optional, does not report.	O

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

gradeLevelDescriptor

The following EIS 043 Student Instructional Grade definitions apply:

Instructional Grade Assignment - Report the instructional grade to which the student is assigned during the instructional service period

From the state grade table, populate the code associated to the instructional grade.

Student Information > General > Enrollments > Grade

Enrollment.grade

beginDate

The following EIS 043 Student Instructional Grade definitions apply:

Instr Grade Assignment Date - Report the date the student was assigned to the instructional grade

Populate Enrollment Start Date.

Student Information > General > Enrollments > Start Date

Enrollment.startDate

endDate

Optional, does not report.

Standard Days

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
totalInstructionalMinutes	The following EIS 047 Student Standard Day definitions apply: Student Standard Day - Report the number of minutes for a full time student of this grade	If the student has an enrollment of Service Type equal to P:Primary, use the calendar of the student's enrollment to populate Student Day. Otherwise, Do not report.	O	System Administration > Calendar > Calendar > Student Day	Calendar.studentDay
effectiveDate	The following EIS 047 Student Standard Day definitions apply: Student Std Day Effective Date - Report the date the student standard day became effective.	Populate the start date of the student's enrollment.	O	Census > People > Enrollment > Start Date	Enrollment.startDate

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

totalInstructionalMinutes

The following EIS 047 Student Standard Day definitions apply:

Student Standard Day - Report the number of minutes for a full time student of this grade

If the student has an enrollment of Service Type equal to P:Primary,

use the calendar of the student's enrollment to populate Student Day.

Otherwise,

Do not report.

System Administration > Calendar > Calendar > Student Day

Calendar.studentDay

effectiveDate

The following EIS 047 Student Standard Day definitions apply:

Student Std Day Effective Date - Report the date the student standard day became effective.

Populate the start date of the student's enrollment.

Census > People > Enrollment > Start Date

Enrollment.startDate

Type/Descriptor

Entry Grade Level Descriptors

Code Value	Description	Name Space	Short Description
Adult Education	Adult Education	uri://ed-fi.org/GradeLevelDescriptor	Adult Education
Early Education	Early Education	uri://ed-fi.org/GradeLevelDescriptor	Early Education
Eighth grade	Eighth grade	uri://ed-fi.org/GradeLevelDescriptor	Eighth grade
Eleventh grade	Eleventh grade	uri://ed-fi.org/GradeLevelDescriptor	Eleventh grade
Fifth grade	Fifth grade	uri://ed-fi.org/GradeLevelDescriptor	Fifth grade
First grade	First grade	uri://ed-fi.org/GradeLevelDescriptor	First grade
Fourth grade	Fourth grade	uri://ed-fi.org/GradeLevelDescriptor	Fourth grade
Grade 13	Grade 13	uri://ed-fi.org/GradeLevelDescriptor	Grade 13
Infant/toddler	Infant/toddler	uri://ed-fi.org/GradeLevelDescriptor	Infant/toddler
Kindergarten	Kindergarten	uri://ed-fi.org/GradeLevelDescriptor	Kindergarten
Ninth grade	Ninth grade	uri://ed-fi.org/GradeLevelDescriptor	Ninth grade
No grade level	No grade level	uri://ed-fi.org/GradeLevelDescriptor	No grade level
Other	Other	uri://ed-fi.org/GradeLevelDescriptor	Other
Postsecondary	Postsecondary	uri://ed-fi.org/GradeLevelDescriptor	Postsecondary
Preschool/Prekindergarten	Preschool/Prekindergarten	uri://ed-fi.org/GradeLevelDescriptor	Preschool/Prekindergarten
Second grade	Second grade	uri://ed-fi.org/GradeLevelDescriptor	Second grade
Seventh grade	Seventh grade	uri://ed-fi.org/GradeLevelDescriptor	Seventh grade
Sixth grade	Sixth grade	uri://ed-fi.org/GradeLevelDescriptor	Sixth grade
Tenth grade	Tenth grade	uri://ed-fi.org/GradeLevelDescriptor	Tenth grade
Third grade	Third grade	uri://ed-fi.org/GradeLevelDescriptor	Third grade
Twelfth grade	Twelfth grade	uri://ed-fi.org/GradeLevelDescriptor	Twelfth grade
Ungraded	Ungraded	uri://ed-fi.org/GradeLevelDescriptor	Ungraded

Entry Type Descriptors

Code Value	Description	Namespace	Short Description
Transfer	Transfer	uri://ed-fi.org/EntryTypeDescriptor	Transfer
New to education system	New to education system	uri://ed-fi.org/EntryTypeDescriptor	New to education system
Next year school	Next year school	uri://ed-fi.org/EntryTypeDescriptor	Next year school
Other	Other	uri://ed-fi.org/EntryTypeDescriptor	Other
Re-entry	Re-entry	uri://ed-fi.org/EntryTypeDescriptor	Re-entry

Exit Withdraw Type Descriptors

Code Value	Description	Namespace	Short Description
Completed	Completed	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Completed
Died or is permanently incapacitated	Died or is permanently incapacitated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Died or is permanently incapacitated
Dropout	Dropout	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Dropout
End of school year	End of school year	uri://ed-fi.org/ExitWithdrawTypeDescriptor	End of school year
Enrolled in a high school diploma program	Enrolled in a high school diploma program	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Enrolled in a high school diploma program
Expelled	Expelled	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Expelled
Graduated	Graduated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Graduated
Incarcerated	Incarcerated	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Incarcerated
Invalid enrollment	Invalid enrollment	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Invalid enrollment
Involuntarily Removed	Involuntarily Removed	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Involuntarily Removed
No show	No show	uri://ed-fi.org/ExitWithdrawTypeDescriptor	No show
Other	Other	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Other
Reached maximum age	Reached maximum age	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Reached maximum age
Transferred	Transferred	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Transferred
Withdrawn	Withdrawn	uri://ed-fi.org/ExitWithdrawTypeDescriptor	Withdrawn

Residency Status Descriptors

Code Value	Description	Namespace	Short Description
Resident of admin unit and school area	Resident of administrative unit and usual school attendance area.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of administrative unit and usual school attendance area.
Resident of admin unit that crosses states	Resident of an administrative unit that crosses state boundaries.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of an administrative unit that crosses state boundaries.
Resident of admin unit, but other school area	Resident of administrative unit, but of other school attendance area.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of administrative unit, but of other school attendance area.
Resident of another state	Resident of another state.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of another state.
Resident of this state, but not of this admin unit	Resident of this state, but not of this administrative unit.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of this state, but not of this administrative unit.

Tennessee Ed-Fi Data v3.1 - Student School Associations

Object Triggering Logic

Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Array Data Elements

Type/Descriptor

Entry Grade Level Descriptors

Entry Type Descriptors

Exit Withdraw Type Descriptors

Residency Status Descriptors

Related Articles