Wisconsin Ed-Fi Data v3.3 - 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.

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.
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).
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.

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.	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
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	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
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.	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
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.,	Optional, do not report.	O