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

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.

ActionTrigger
PostWhen a program is marked and the record overlaps the configured year.
PostWhen 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.
PutWhen 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.
DeleteWhen 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
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 will be deleted from the ODS.
ResyncIf 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.

ActionTrigger
Post/Delete

Natural Key changes:

  • If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted. 
DeleteCascading 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.

campusObjectTypeObject Key Data Source
ProgramParticipationparticipationID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPutThe primary table used for sending data for this resource.
programparticipationPutThe 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.

  1. Reports the District State Number.

M




programReference 

A reference to the related Program.

  1. Reports Program reference.
  2. For Learning Modality, reports the reference for the Learning Modality program.

M



studentReference

A reference to the related Student resource.

  1. Reports the Student Reference.

M



beginDate

The month, day, and year on which the Student first received services.

  1. When the checkbox for a program is marked, report the Start Date.
  2. 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.,

  1. When the checkbox for a program is marked, report the End Date.
  2. 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.

  1. Optional, do not report.

O



servedOutsideOf

RegularSession

Indicates whether the student received services during the summer session or between sessions.

  1. Optional, do not report.

O



enrollmentStatus


  1. Optional, do not report.

O



services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.

  1. Optional, do not report.

O