Student Program Associations (Wisconsin v3.6)

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 or has a record in Student Information > Program Participation > State Programs > CEIS.
Post	When a Section 504 record is created.
Delete	When Coord. Early Intervention is set to N: No OR NULL or a record is deleted.
Delete	When the enrollment is marked State Exclude, No Show or WISE Exclude.
Delete	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.
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.
Put	If the Learning Modality value of the Instruction Mode record is changed.
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.

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 that overlaps the student's enrollment determining the record and End Date is Null or after current date: Report "Cocurricular Programs" for program type if config year is 22-23 or earlier. If config year is 23-24 or later, report 'Coordinating Early Intervening Services'. Report "Coordinated Early Intervening Services" 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: If the student has an Instruction Mode record (Student Info > 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 the trigger posting the record is for Pupil Count: programName: Report the value selected for Program on the Pupil Count state program tab for any records with start date that falls within the config year 'Challenge academy' or '5 yr old Blended' programTypeDescriptor: Report 'Other' If no programs are selected for any Pupil Count records that fall within the config year, do not report.	M	Student Information > General > Enrollment > Coord. Early Intervention Student Information > Program Participation > State Programs > CEIS Student Information > Program Participation > Section 504 Student Information > Program Participation > State Programs > Instruction Mode Student Information > Program Participation > State Programs > Pupil Count
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 Coordinated Early Intervening Services program: Report the Start Date of the CEIS record (Student Info > Program Participation > State Programs > CEIS, if a record exists. If the CEIS Start Date is before enrollment Start Date, report Enrollment Start Date OR the enrollment determining the record if the Coord. Early Intervention is set to Yes. 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 > 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 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. Otherwise, if the enrollment is given an End Date and the CEIS record End Date is null, report the End Date from Enrollment 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 for Modality, report the End Date of the Instruction Mode record: If no end date exists, report blank.	C	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.,	Optional, do not report.	O

Types/Descriptors

Click here to expand...

Program Type

Code Value	Description	Namespace	Short Description
In Person	In Person	uri://dpi.wi.gov/ProgramTypeDescriptor	In-Person
Remote	Remote	uri://dpi.wi.gov/ProgramTypeDescriptor	Remote
Hybrid	Hybrid	uri://dpi.wi.gov/ProgramTypeDescriptor	Hybrid