Nebraska Ed-Fi Data v3.1 - Student Program Associations

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

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. Do not post if the student's enrollment in in a calendar marked exclude. Do not post if the student's enrollment is in a school that is marked exclude.
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: When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post.
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: If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted.
Delete	Cascading Deletes: N/A no resources exists under this resource.

Action

Trigger

Post/Delete

Natural Key changes:

If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted.

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.	Reports the District State Number.	M
programReference	A reference to the related Program.	Reports Program reference. For Learning Modality, reports the reference for the Learning Modality program.	M
studentReference	A reference to the related Student resource.	Reports the Student Reference.	M
beginDate	The month, day, and year on which the Student first received services.	When the checkbox for a program is marked, report the Start Date. For Learning Modality, Report the start date from the Blended Learning Group.	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.,	When the checkbox for a program is marked, report the End Date. For Learning Modality, Report the end date from the Blended Learning Group.	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.	Optional, do not report.	O
servedOutsideOf RegularSession	Indicates whether the student received services during the summer session or between sessions.	Optional, do not report.	O
enrollmentStatus		Optional, do not report.	O
services	An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.	Optional, do not report.	O