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

Tool Search: 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.
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 an LEP record is created or changed. Do not send a record for LEP Program Status of "Pending" or "Not LEP". ELL Served on LEP record must be "S: Served - No T3" OR "T: T3 Served".
Put	When an LEP Program Status is changed to "Exited LEP"
Delete	When an end date is entered or changed for an existing record: When Coord. Early Intervention is set to N: No OR NULL. 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).
Post/Delete	When a School Override is set on Enrollment.
Delete	When a start date changes.
Delete	When an LEP record is deleted or LEP Program Status is changed to "Pending" or "Not LEP".
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.

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
programReference	EL Services

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
educationOrganizationReference	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 LEP record, Report "Cocurricular Programs" for program type. Report "ELL Served" for program name. 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 = Y: Yes. 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.	M	Student Information > Special Ed > General > Documents > IEP > Enrollment Editor Student Information > General > Program Participation > LEP > Program Status Student Information > General > Program Participation > LEP > ELL Served Student Information > General > Enrollment > Coord. Early Intervention Student Information > General > Enrollment > 3rd party Service Provider Student Information > Program Participation > Section 504
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 enrollment determining the record 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	M	Student Information > General > Program Participation > LEP > Identified Date Student Information > General > Enrollment > Start Date Student Information > Program Participation > Section 504 > 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 If the record is triggered from an enrollment for the following programs; Coordinated Early Intervening Services program 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 program is marked on multiple enrollments with the same start date, populate end date only if all enrollments are ended use the latest enrollment end date	C	Student Information > General > Program Participation > LEP > Program Exit Date Student Information > General > Enrollment > End Date Student Information > Program Participation > Section 504 > 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
servedOutsideOfRegularSession	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

Appendix

EL ProgramReference

Code	Program Type	Program Name
LIEP-Bilingual	Language Instruction Education Program - Bilingual Program	Dual Language Immersion
LIEP-Bilingual	Language Instruction Education Program - Bilingual Program	Developmental or Late - Transitional Bilingual Program
LIEP-Bilingual	Language Instruction Education Program - Bilingual Program	Heritage language program or Indigenous language program
LIEP-Bilingual	Language Instruction Education Program - Bilingual Program	Transitional Bilingual Education
LIEP-ESL	Language Instruction Education Program - ESL Program	ESL - Integrated or Co-teaching models
LIEP-ESL	Language Instruction Education Program - ESL Program	No ESL program available
LIEP-ESL	Language Instruction Education Program - ESL Program	ESL - Sheltered Instruction
LIEP-ESL/Bilingual	Language Instruction Education Program - ESL/Bilingual	Content-Based ESL-Bilingual
LIEP-ESL/Bilingual	Language Instruction Education Program - ESL/Bilingual	Newcomer-Bilingual
LIEP-ESL/Bilingual	Language Instruction Education Program - ESL/Bilingual	Integrated EL-Special Education
LIEP-ESL/Bilingual	Language Instruction Education Program - ESL/Bilingual	Newcomer-ESL