Student School Associations (Texas v4.0)

Tool Search: Ed-Fi

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

Object Triggering Logic

ActionTrigger
Post

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

  • When a student has two enrollments in the same School, Calendar, and Schedule Structure with the same start date, reports from the enrollment service type in the following order:
    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When a student has two Primary enrollments in the same school with the same start date, post the record with the highest enrollment ID.
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority posts a new record.
  • Does not send records if any of the following exist:
    • Calendar Exclude checkbox is marked in the calendar the student is enrolled.
    • School Exclude checkbox is marked in the calendar the student is enrolled.
    • No Show checkbox is marked.
Post

When the start date for an enrollment is changed.

  • Data does not send when an enrollment with a lower priority is changed.
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 do not trigger a delete.
Delete

When the start date of an enrollment is changed.

DeleteWhen the No Show checkbox is marked.

Resource Toggle and Resync Logic

Action

Business Rule

NoneIf a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data will send.
PutIf the natural key of the Calendar Reference is changed, a put is 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 is 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 is deleted from the ODS.
ResyncIf a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

Action

Business Rule

Post/Delete

Natural Key changes:  

  • If the School Number/Ed-Fi School Number changes, a delete/post occurs 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 are deleted and reposted.  If a dependent resource is turned off, all dependent resources are deleted and not reposted.
Delete

Cascading Deletes:  If the Student School Association is deleted, all dependent resources are 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

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

Resource Preferences

Data Element Label

Mapping Needed

Entry Type DescriptorsEnrollment Start Status
Exit Withdraw Type DescriptorsEnrollment End Status

Identity Mapping Object Key

campusObjectType

Object Key Data Source

EnrollmentenrollmentID

Event Queue Detail

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.

Click here to expand...

Data Element LabelBusiness RequirementLogicM, C or OLocation

   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.   

Reports the enrollment start date.

MStudent Information > General > Enrollments > Start Date

enrollment.startdate
calendarReferenceA reference related to the Calendar resource.

Reports the Calendar reference for the calendar in which the student is enrolled that is being reported.

O
classOfSchoolYearType
Reference  
The year the student is expected to graduate. This is optional, does not report.


O
graduationPlanReferenceA reference to the related Graduation Plan resource.

This is optional, does not report.

O
schoolReference  A reference to the related School resource. 

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


M
schoolYearTypeReference  The school year in which the student is being reported.

This is optional, does not report.

O
studentReference  A reference to the related Student resource. 

Report the reference for the student being reported.


M
educationPlans An unordered collection of student School Association Education Plans. This association represents the school in which a student is enrolled. 

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. 

This is optional, does not report.

O
entryGradeLevelDescriptor 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. Reports the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. The record errors if a mapping is not available.
MStudent Information > General > Enrollments > Grade
entryGradeLevelReason
Descriptor 
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.

O
entryTypeDescriptor A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Reports the Ed-Fi Code Value mapped to the Start Status selected.
  2. If blank, does not report.
OStudent 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 

Reports the enrollment end date.

OStudent Information > General > Enrollments > End Date

enrollment.enddate
exitWithdrawTypeDescriptor A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Reports the Ed-Fi Code Value from the End Status selected.
  2. If blank, does not report.
OStudent 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. 

This is optional, does not report.

OStudent Information > General > Enrollments > Service Type

enrollment.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. This is optional, does not report.OStudent Information > General > Enrollments > End Action

enrollment. endAction
residencyStatusDescriptor 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.O

Student Information > General > Enrollments > Resident District / Serving District



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.

OStudent Information > General > Enrollments > School Choice

enrollment. schoolChoiceProgram
fullTimeEquivalencyThe full-time equivalent ratio for the student s assignment to a school for services or instruction. For example, a full-time student would have an FTE value of 1 while a half-time student would have an FTE value of 0.5.This is optional, does not report.O
ADAEligibilityDescriptorThe eligibility status of the student as reflected in the attendance accounting records of the district.Reports mapped Ed-Fi Code of ADA Eligibility from the ADA record that is active within the enrollment range.


If more than one record is active within an enrollment's range, reports the most recent ADA record.

OStudent Information > Program Participation > State Programs > ADA
StudentAttributionDescriptor
Characteristic of a student relating to their individual enrollment circumstances. It`
indicates whether the student:

  • attends an open enrollment charter school
  • is served in a juvenile justice alternative education program (JJAEP)
  • attends school in the district through a Public Education Grant (PEG)
  • attends school by means of a transfer between LEAs
  • attends school in the district, lives outside the boundaries of the state of Texas, and therefore is
    not an inter district transfer
  • lives in Texas  residential treatment center
  • is served by the Texas School for the Deaf as a parent referral
  • is enrolled in South Texas ISD (031-916);
    o is a student wit
    h a disability enrolled by their parent(s) in a private school (including a home school) but outside district boundaries and is served in a juvenile pre-adjudication secure detention facility or a juvenile post-adjudication secure correctional facility
  • lives in Texas but outside district boundaries and is served in a residential treatment center
  • is served by the Texas School for the Deaf as a parent referral
  • is enrolled in South Texas ISD (031-916)
  • is a student with a disability enrolled by their parent(s) in a private school (including a home
    school) but who receives special education and/or related services from the public school district
    under an individualized
    services plan (ISP)
  • is a child of a charter school employee
  • student-initiated transfer due to remote learning

Reports mapped Ed-Fi Code of Attribution Code.


OStudent Information > General > Enrollments
EnrollmentTrackingVerification
Descriptor
The status of the enrollment event.
O
CampusIdOfResidence

Former Element Name: CAMPUS-ID-OF-RESIDENCE


Indicates the unique campus identification number corresponding to the campus attendance area in which the student currently resides.


This field is reported for all charter school students and regular school district students who do not regularly reside in the school district they attend.

If Student has an Attribution Code mapped to an Ed-Fi Code = NOT NULL, report Campus ID of Residence.

Otherwise, does not report.


OStudent Information > General > Enrollments > State Reporting Fields > Campus ID of Residence > Attribution Code AND Campus ID of Residence
CampusIdOfAccountability

Former Element Name: CAMPUS-ID-OF-ACCOUNTABILITY


Indicates the unique campus identification number to which a student’s attendance and/or leaver accountability data are attributed for campus accountability purposes.


For the PEIMS Fall Submission, this field is reported for students who were enrolled at a DAEP or JJAEP campus on the PEIMS Fall snapshot date (last Friday in October).


For the PEIMS Summer Submission, this field is reported for students who have attendance data only at a DAEP and/or a JJAEP.


CAMPUS-ID-OF-ACCOUNTABILITY must be an active instructional campus in the reporting LEA ending in 001-698, and cannot be a DAEP or a JJAEP.

If School Type is DAEP or JJAEP, report value from Campus ID of Accountability.

Otherwise, report blank, even if Campus ID of Accountability is not blank.


This field is used for a student who was ONLY enrolled at a DAEP and/or JJAEP.

OStudent Information > General > Enrollments > State Reporting > Campus ID of Accountability AND System Administration > Resources > School > Type

Type/Descriptor

Click here to expand...

Entry Grade Level Descriptors

Code ValueDescriptionName SpaceShort Description
Adult EducationAdult Educationuri://ed-fi.org/GradeLevelDescriptorAdult Education
Early EducationEarly Educationuri://ed-fi.org/GradeLevelDescriptorEarly Education
Eighth gradeEighth gradeuri://ed-fi.org/GradeLevelDescriptorEighth grade
Eleventh gradeEleventh gradeuri://ed-fi.org/GradeLevelDescriptorEleventh grade
Fifth gradeFifth gradeuri://ed-fi.org/GradeLevelDescriptorFifth grade
First gradeFirst gradeuri://ed-fi.org/GradeLevelDescriptorFirst grade
Fourth gradeFourth gradeuri://ed-fi.org/GradeLevelDescriptorFourth grade
Grade 13Grade 13uri://ed-fi.org/GradeLevelDescriptorGrade 13
Infant/toddlerInfant/toddleruri://ed-fi.org/GradeLevelDescriptorInfant/toddler
KindergartenKindergartenuri://ed-fi.org/GradeLevelDescriptorKindergarten
Ninth gradeNinth gradeuri://ed-fi.org/GradeLevelDescriptorNinth grade
No grade levelNo grade leveluri://ed-fi.org/GradeLevelDescriptorNo grade level
OtherOtheruri://ed-fi.org/GradeLevelDescriptorOther
PostsecondaryPostsecondaryuri://ed-fi.org/GradeLevelDescriptorPostsecondary
Preschool/PrekindergartenPreschool/Prekindergartenuri://ed-fi.org/GradeLevelDescriptorPreschool/Prekindergarten
Second gradeSecond gradeuri://ed-fi.org/GradeLevelDescriptorSecond grade
Seventh gradeSeventh gradeuri://ed-fi.org/GradeLevelDescriptorSeventh grade
Sixth gradeSixth gradeuri://ed-fi.org/GradeLevelDescriptorSixth grade
Tenth gradeTenth gradeuri://ed-fi.org/GradeLevelDescriptorTenth grade
Third gradeThird gradeuri://ed-fi.org/GradeLevelDescriptorThird grade
Twelfth gradeTwelfth gradeuri://ed-fi.org/GradeLevelDescriptorTwelfth grade
UngradedUngradeduri://ed-fi.org/GradeLevelDescriptorUngraded

Entry Type Descriptors

Code ValueDescriptionNamespaceShort Description
TransferTransferuri://ed-fi.org/EntryTypeDescriptorTransfer
New to education systemNew to education systemuri://ed-fi.org/EntryTypeDescriptorNew to education system
Next year schoolNext year schooluri://ed-fi.org/EntryTypeDescriptorNext year school
OtherOtheruri://ed-fi.org/EntryTypeDescriptorOther
Re-entryRe-entryuri://ed-fi.org/EntryTypeDescriptorRe-entry

Exit Withdraw Type Descriptors

Code ValueDescriptionNamespaceShort Description
CompletedCompleteduri://ed-fi.org/ExitWithdrawTypeDescriptorCompleted
Died or is permanently incapacitatedDied or is permanently incapacitateduri://ed-fi.org/ExitWithdrawTypeDescriptorDied or is permanently incapacitated
DropoutDropouturi://ed-fi.org/ExitWithdrawTypeDescriptorDropout
End of school yearEnd of school yearuri://ed-fi.org/ExitWithdrawTypeDescriptorEnd of school year
Enrolled in a high school diploma programEnrolled in a high school diploma programuri://ed-fi.org/ExitWithdrawTypeDescriptorEnrolled in a high school diploma program
ExpelledExpelleduri://ed-fi.org/ExitWithdrawTypeDescriptorExpelled
GraduatedGraduateduri://ed-fi.org/ExitWithdrawTypeDescriptorGraduated
IncarceratedIncarcerateduri://ed-fi.org/ExitWithdrawTypeDescriptorIncarcerated
Invalid enrollmentInvalid enrollmenturi://ed-fi.org/ExitWithdrawTypeDescriptorInvalid enrollment
Involuntarily RemovedInvoluntarily Removeduri://ed-fi.org/ExitWithdrawTypeDescriptorInvoluntarily Removed
No showNo showuri://ed-fi.org/ExitWithdrawTypeDescriptorNo show
OtherOtheruri://ed-fi.org/ExitWithdrawTypeDescriptorOther
Reached maximum ageReached maximum ageuri://ed-fi.org/ExitWithdrawTypeDescriptorReached maximum age
TransferredTransferreduri://ed-fi.org/ExitWithdrawTypeDescriptorTransferred
WithdrawnWithdrawnuri://ed-fi.org/ExitWithdrawTypeDescriptorWithdrawn

Residency Status Descriptors

Code ValueDescriptionNamespaceShort Description
Resident of admin unit and school areaResident of administrative unit and usual school attendance area.uri://ed-fi.org/ResidencyStatusDescriptorResident of administrative unit and usual school attendance area.
Resident of admin unit that crosses statesResident of an administrative unit that crosses state boundaries.uri://ed-fi.org/ResidencyStatusDescriptorResident of an administrative unit that crosses state boundaries.
Resident of admin unit, but other school areaResident of administrative unit, but of other school attendance area.uri://ed-fi.org/ResidencyStatusDescriptorResident of administrative unit, but of other school attendance area.
Resident of another stateResident of another state.uri://ed-fi.org/ResidencyStatusDescriptorResident of another state.
Resident of this state, but not of this admin unitResident of this state, but not of this administrative unit.uri://ed-fi.org/ResidencyStatusDescriptorResident of this state, but not of this administrative unit.