Wisconsin Ed-Fi Data v3.5 - Student Program Associations
Last Modified on 10/22/2022 10:41 am CDT
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
Report a record based on the student enrollment:
If Ed-Fi Configuration Profile = Choice + Private Opt In or Choice Only, do not send any records.
Report from any enrollment determining a record. If the student has multiple qualifying enrollments in the same school, report a record for each unique start date..
Do not send a record based on an enrollment that is marked as State Exclude, No Show, or WISE Exclude.
Do not send a record based on an enrollment is in a calendar marked as State Exclude or Summer School.
Do not send a record driven from any enrollment with Service Type = Partial (S).
Do not send a record for an enrollment in a School marked Exclude or where Entity ID is NULL.
Post
Report if a student has an enrollment where Coord. Early Intervention = Y: Yes or has a record in Student Information > Program Participation > State Programs > CEIS.
Post
Report if a student has an enrollment where 3rd party Service Provider is NOT NULL or "NONE: None".
Post
When a Section 504 record is created.
Post
When Exclude on calendar or school in which the student is enrolled is unchecked.
Post
A record is added to Student Information > Program Participation > State Programs > Instruction Mode with a Start Date and End Date that fall within the config year
Do not post if the student's enrollment is in a calendar marked Exclude..
Do not post if the student's enrollment is in a school that is marked Exclude.
Do not post if the student's enrollment record is marked No Show, State Exclude, or WISE Exclude.
AND
The student's State Enrollment Type = Primary or PPP
Put
If the Start Date, End Date, or Learning Modality of the Instruction Mode record is changed.
Delete
If the Instruction Mode record is deleted.
Delete/Post
When School Number is changed for an Instruction Mode record.
Delete
When an end date is entered or changed for an existing record:
When Coord. Early Intervention is set to N: No OR NULL or a record is deleted.
When 3rd Party Service Provider is changed.
If set to NONE: None OR NULL.
If changed from CESA: Cooperative Educational Service Agency to another value.
If changed from another value to CESA: Cooperative Educational Service Agency.
When the enrollment is marked State Exclude, No Show or WISE Exclude.
When the enrollment determining the record is deleted.
When the service type for the enrollment determining the record is changed to Partial (S).
When calendar or school in which the student is enrolled is marked Exclude.
Post/Delete
When a School Override is set on Enrollment.
Delete
When a start date changes.
Delete
When a Section 504 record 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.
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.
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 EducationOrganization resource. The ID for school in the StudentSchoolAssociation record which includes the ‘Begin Date’ of this association.
A reference to the Student School Association Resource.
Report from the enrollment active on the beginDate of the Program record.
Report first from the School Override.
Otherwise report from the Enrollment School.
Reports the fields that are part of the Natural Key for the School resource.
M
System Administration > Resources > District Information> Ed-Fi District Number
district.entityId
programReference
A reference to the related Program resource.
Report "48856" for educationOrganizationId for all programs.
If the trigger posting the record is for an Section 504 record:
Report "Section 504 Placement" for program type.
Report "Section 504 Placement" for program name.
If the trigger posting the record is for based on enrollment:
If Coord. Early Intervention is Y: Yes or a record exists in Student Information > Program Participation > State Programs > CEIS with a start date on or after the enrollment determining the record, then:
Report "Cocurricular Programs" for program type.
Report "Coordinated Early Intervening Services" for program name.
If 3rd party Service Provider = CESA: Cooperative Educational Service Agency:
Report "Regular Education" for program type.
Report "Third Party - CESA" for program name.
Otherwise if 3rd party Service Provider is NOT NULL:
Report "Regular Education" for program type.
Report "Third Party - Other" for program name.
If the trigger posting the record is for Modality:
Report 'Modality' for Program Type.
For program name, report based on the following:
f the student has an Instruction Mode record (Student Information > State Programs > Instruction Mode) with Start and End Dates that fall within the config year:
Report the Learning Modality value selected. (In-Person, Remote, Hybrid)
If multiple records exist with different School Numbers, send multiple records with matching EdOrg references.
M
Student Information > General > Enrollment > Coord. Early Intervention
Student Information > Program Participation > State Programs > CEIS
Student Information > General > Enrollment > 3rd party Service Provider
Student Information > Program Participation > Section 504
Student Information > Program Participation > State Programs > Instruction Mode
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.
If the record is for the ELL program, report the Identified Date from the LEP record determining the record if it is within the config year (7/1/xx - 6/30/xx):
Otherwise, if the EL Identified date is in a previous year, report the start date from the earliest enrollment that sends a Student School Association record.
If the record is for the Coordinated Early Intervening Services program:
Report the start date of the CEIS record (Student Info > Program Participation > State Programs > CEIS, if a record exists
Or the enrollment determining the record if the Coord. Early Intervention is set to Yes.
If the record is for the Third Party - CESA program, report the start date of the enrollment determining the record.
If the record is for the Third Party - Other program, report the start date of the enrollment determining the record.
If the record is for the Section 504 program, report the latest of:
the Section 504 Start date
the enrollment Start date
If the record is for Modality, report the Start Date of the Instruction Mode record.
M
Student Information > General > Program Participation > LEP > Identified Date
Student Information > General > Enrollment > Start Date
Student Information > Program Participation > State Programs > CEIS > Start Date
Student Information > Program Participation > Section 504 > Start Date
Student Information > Program Participation > State Programs > Instruction Mode >Start Date
endDate
The month, day, and year on which the Student exited the Program or stopped receiving services.,
If the record is for the ELL program, report the Program Exit Date from the LEP record determining the record.
If no exit date exists, report blank
If the record is for a Section 504 program, report the earliest of:
the Section 504 End Date
OR the enrollment End Date
If no exit date exists, report blank
For Coordinating Early Intervening Services:
If the record is triggered from a record in Student Information > Program Participation > State Programs > CEIS, report the End Date of the CEIS record, if populated.
If the record is triggered from the Coord. Early Intervention field on enrollment, report the end date of the enrollment determining the record.
Otherwise, report blank
If the record is triggered from an enrollment for the following programs:
Third Party - CESA program
Third Party - Other program
Then, report the end date of the enrollment determining the record.
If no end date exists, report blank.
If the record is for Modality, report the End Date of the Instruction Mode record:
If no end date exists, report blank.
C
Student Information > General > Program Participation > LEP > Program Exit Date
Student Information > General > Enrollment > End Date
Student Information > Program Participation > State Programs > CEIS > End Date
Student Information > Program Participation > Section 504 > End Date
Student Information > Program Participation > State Programs > Instruction Mode >End Date
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.,
