Nebraska Ed-Fi Data v3.5 - 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.

ActionTrigger
PostWhen a new blended learning group is created and the status is set to Active and at least one student is assigned to the Blended Learning Group:
  • A separate record will be sent for each school where there is at least one student added to the group based on the school of the student's enrollment.
  • Do not send a record if the Blended Learning Group is only assigned to students with enrollments in a calendar that is marked exclude.
  • Do not send a record if the Blended Learning Group is only assigned to students with enrollments in a school that is marked exclude.
PutUpdate modalityTypeDescriptor when a Blended Learning Group is either assigned to a calendar day or removed from all calendar days in a school.
PutRecalculate modalityTime whenever a Blended Learning Group is either added or removed on the Calendar Days.
DeleteIf the Blended Learning Group is marked as Archived.

Resource Toggle/Resync

Action

Business Rule

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, Deletes

Action

Business Rule

Post/Delete

Natural Key changes: 

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 Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted.
DeleteCascading Deletes:  N/A - no dependent resources

Scope Year

Business Rules

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.


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.

Report a unique record for each school where there is at least one student added to the Blended Learning Group based on the school where the student is enrolled. Report from th.e state school number

M




programReference 

A reference to the related Program.

Reports the reference for the Learning Modality program.

M



programName
The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.
Report the name of the Blended Learning Group.
M


programTypeDescriptor
The formal name of the program of instruction, training, services or benefits available through federal, state or local agencies .
Always report 'Learning Modality' in this field for all Learning Modality Programs.
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.

Reports the start date from the Blended Learning Group.

M

Scheduling > Blended Learning Groups

blendedlearning

groupassignment.

startdate




endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

Reports the end date from the Blended Learning Group.

M

Scheduling > Blended Learning Groups

blendedlearning

groupassignment.

enddate




modalityTypeDescriptor
Defines the Modality that is being reported as either 'In Person' or 'Remote'.
If group is assigned to at least 1 day in the calendar report 'Remote" else report 'In Person'.
M
System Administration > Calendar > Calendar > Days

modalityTimeTypeDescriptor
Defines the unit(s) of time reporting the the Modality Time Descriptor.
Report 'Days'.
M


modalityTime
The amount of time the student spends in that Modality.
Look across all calendars/schedule structures the group is assigned in a school and count a unique number of days beginning with the earliest calendar start date through the max calendar end date that the group is tied to.
M
System Administration > Calendar > Calendar > Days

reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Optional, does not report.

O



servedOutsideOf

RegularSession

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

Optional, does not report.

O



enrollmentStatus


Optional, does not report.

O



services

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

Optional, does not report.

O