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.

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

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.

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. educationOrganizationId = Ed-Fi School ID programName = Section 504 Placement (Hard-Coded) programTypeDescriptor = Section 504 Placement (Hard-Coded)	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
studentReference	Reports the fields that are part of the Natural Key for the Students resource. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
endDate	The month, day, and year on which the student exited the program or stopped receiving services. Reports the End Date of the Section 504 record.	C	Student Information > Program Participation > Section 504 > End Date	Section504.endDate
section504Plans	An unordered collection of student Section 504 Program Association Section 504 Plans. Reports the below data elements in an array: section504PlanDescriptor Reports the Ed-Fi Code mapped to the Accommodation(s) selected on the Section 504 record.	M	Student Information > Program Participation > Section 504 > Accommodation	Section504.disability

Descriptors

Click here to expand...

programTypeDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
section504Placement	Section 504 Placement	uri:/gadoe.org/ProgramTypeDescriptor	Section 504 Placement

section504PlanDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
Attention Deficit Hyperactivity Disorder	Attention Deficit Hyperactivity Disorder	uri://gadoe.org/Section504PlanDescriptor	Attention Deficit Hyperactivity Disorder
Autism Spectrum Disorder	Autism Spectrum Disorder	uri://gadoe.org/Section504PlanDescriptor	Autism Spectrum Disorder
Bipolar Disorder	Bipolar Disorder	uri://gadoe.org/Section504PlanDescriptor	Bipolar Disorder
Cancer	Cancer	uri://gadoe.org/Section504PlanDescriptor	Cancer
Cerebral Palsy	Cerebral Palsy	uri://gadoe.org/Section504PlanDescriptor	Cerebral Palsy
Cystic Fibrosis	Cystic Fibrosis	uri://gadoe.org/Section504PlanDescriptor	Cystic Fibrosis
Deafness	Deafness	uri://gadoe.org/Section504PlanDescriptor	Deafness
Down Syndrome	Down Syndrome	uri://gadoe.org/Section504PlanDescriptor	Down Syndrome
Drug or Alcohol Abuse	Drug or Alcohol Abuse	uri://gadoe.org/Section504PlanDescriptor	Drug or Alcohol Abuse
Dual Sensory Impairment	Dual Sensory Impairment	uri://gadoe.org/Section504PlanDescriptor	Dual Sensory Impairment
Dyslexia	Dyslexia	uri://gadoe.org/Section504PlanDescriptor	Dyslexia
Emotional or Behavioral Disorder	Emotional or Behavioral Disorder	uri://gadoe.org/Section504PlanDescriptor	Emotional or Behavioral Disorder
Epilepsy	Epilepsy	uri://gadoe.org/Section504PlanDescriptor	Epilepsy
Muscualr Distrophy	Muscualr Distrophy	uri://gadoe.org/Section504PlanDescriptor	Muscualr Distrophy
Iintellectual Disability	Iintellectual Disability	uri://gadoe.org/Section504PlanDescriptor	Iintellectual Disability
Specific Learning Disability	Specific Learning Disability	uri://gadoe.org/Section504PlanDescriptor	Specific Learning Disability
SPNA Bifida	SPNA Bifida	uri://gadoe.org/Section504PlanDescriptor	SPNA Bifida
Traumatic Brain Injury	Traumatic Brain Injury	uri://gadoe.org/Section504PlanDescriptor	Traumatic Brain Injury
Visual Impairment	Visual Impairment	uri://gadoe.org/Section504PlanDescriptor	Visual Impairment
Any Rare Disease	Any Rare Disease	uri://gadoe.org/Section504PlanDescriptor	Any Rare Disease
Other Reason	Other Reason	uri://gadoe.org/Section504PlanDescriptor	Other Reason
Hearing Impairment	Hearing Impairment	uri://gadoe.org/Section504PlanDescriptor	Hearing Impairment

Student Section 504 Program Associations (Georgia v3.6.1)