Student School Associations (Texas v4.0)

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

If the student has End Date = NOT NULL, report End Date + 1 day.

    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 the Student has an Attribution Code mapped to an Ed-Fi Code = NOT NULL, report the Campus ID of the Residence + Resident School.

    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.