This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a program is marked and the record overlaps the configured year. |
| Post | When a student is added to a Blended Learning Group that is marked Active.
|
| Put | When the student is given an End Date. |
| Put | If the start date of the blended learning group is changed. |
| Put | If the end date of the blended learning group is changed |
| Delete/Post | When part of the records Natural Key changes:
|
| Delete | When the Section 504 checkbox is unmarked or when the record no longer overlaps the configured year. |
| Delete | If the student is removed from a blended learning group. |
| Delete | If the Blended Learning Group is marked as Archived. |
| Delete. | If the student's enrollment is deleted. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| 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 changes:
|
| Delete | Cascading Deletes: N/A no resources exists under this resource. |
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 program association record is associated with. |
| Data will only send for the years that have valid configuration. |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| ProgramParticipation | participationID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| programs | Put | The primary table used for sending data for this resource. |
| programparticipation | Put | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Student Program Association resource.
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
id | The unique identifier of the resource | M | |||
educationOrganization Reference | A reference to the related Education Organization resource. |
| M | ||
programReference | A reference to the related Program. |
| M | ||
studentReference | A reference to the related Student resource. |
| M | ||
beginDate | The month, day, and year on which the Student first received services. |
| M | Student Information > General > Enrollments | blendedlearninggroup assignment.startdate |
endDate | The month, day, and year on which the Student exited the Program or stopped receiving services., |
| O | blendedlearninggroup assignment.enddate | |
reasonExitedDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. |
| O | ||
servedOutsideOf RegularSession | Indicates whether the student received services during the summer session or between sessions. |
| O | ||
enrollmentStatus |
| O | |||
services | An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program. |
| O |
