Student Section 504 Program Associations (Georgia v3.6.1)
Last Modified on 07/29/2024 12:21 pm CDT
In This Article
This association represents Students in a Section 504 Plan.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action
Trigger
Post
Report a record when a student has a Section 504 plan that overlaps an enrollment AND the configured school year.
Do not report a record if the any of the following exclusions are present:
Enrollment State Exclude
Enrollment No Show
Enrollment Grade Exclude from State Reporting
Calendar Exclude
School Exclude
The Programs record must exist in the ODS prior to sending a Student Section 504 Program Associations record.
If the Programs record does not already exist in the ODS, the Programs record will be sent prior to the Student Section 504 Program Associations record.
If there are multiple Section 504 records, use the following priority list to determine which one should report:
Earliest Start Date
Blank/NULL Section 504 record End Date
Latest Section 504 record End Date
Highest Section 504 record ID
If there are multiple enrollments, use the following priority list to determine which one should report:
Primary > Partial > SPED
Earliest Start Date
Latest Enrollment ID
Delete/Post/Put
A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.
When the following information on a Section 504 program changes:
Section 504 Program ID (New Section 504 record)
Start Date
End Date
Accommodation
When the following information on an Enrollment changes:
Enrollment ID (New Enrollment)
Start Date
End Date
No Show
State Exclude
Delete
When the enrollment being reported off of is deleted.
When the enrollment is changed to no longer overlap the configured year.
When the student is excluded through their enrollment, calendar, grade level, or school.
When the Section 504 record being reported off of is deleted.
When the Section 504 record is changed to no longer overlap the configured year.
Resource Toggle/Resync
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.
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
Trigger
Post/Delete
Natural Key change:
LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the Program Name or Program Type Descriptor mapping changes and a resync is completed
If the Begin Date of the Section 504 record changes
Delete
Cascading Deletes: N/A - no dependent resources
Scope Year Logic
This table describes scope year logic of this object.
Logic
The record will send to any year the Section 504 record overlaps with if the student has an enrollment in that year
Data will only send for years that have valid configuration.
Resource Preferences
Data Element Label
Mapping Needed
section504PlanDescriptor
Accommodation
Object Data Elements
This table describes data elements sent within the Student Section 504 Plan Program Association resource.
Data Element Label
Business Requirement and Business Rules
M, C or O
Data Source GUI Path
Database Field
beginDate
The earliest date the student is involved with the program. Typically, this is the date the student becomes eligible for the program.
Reports the Begin Date of the Section 504 record.
M
Student Information > Program Participation > Section 504 > Begin Date
Section504.startDate
educationOrganizationReference
Reports the fields that are part of the Natural Key for the Local Education Agency resource.
Reports the fields that are part of the Natural Key for the Schools resource.
educationOrganizationId = Ed-Fi School ID
M
System Administration > Resources > School > Ed-Fi School ID
School.entityID
programReference
Reports the fields that are part of the Natural Key for the Programs resource.
Reports the fields that are part of the Natural Key for the Programs resource.