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 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:
|
| Put | Update modalityTypeDescriptor when a Blended Learning Group is either assigned to a calendar day or removed from all calendar days in a school. |
| Put | Recalculate modalityTime whenever a Blended Learning Group is either added or removed on the Calendar Days. |
| Delete | If the Blended Learning Group is marked as Archived. |
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, 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. | |
| Delete | Cascading 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 |
