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

ActionTrigger
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.
PostReport if a student has an enrollment where Coord. Early Intervention = Y: Yes or has a record in Student Information > Program Participation > State Programs > CEIS.
PostReport if a student has an enrollment where 3rd party Service Provider is NOT NULL or "NONE: None".
PostWhen 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/DeleteWhen a School Override is set on Enrollment.
DeleteWhen a start date changes.
DeleteWhen 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Post/Delete

Natural Key changes:

  • If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted 
DeleteCascading 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 TableEd-Fi ActionFields
programsPutThe primary table used for sending data for this resource.
programparticipationPutThe 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.

  1. 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.
  2. 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.

  1. Report "48856" for educationOrganizationId for all programs.


  2. 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.
  3. 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:
      1. Report "Cocurricular Programs" for program type.
      2. 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.,

  1. Reports the Student Reference

M



beginDate

The month, day, and year on which the Student first received services.

  1. 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.
  2. 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.
  3. If the record is for the Third Party - CESA program, report the start date of the enrollment determining the record.

  4. If the record is for the Third Party - Other program, report the start date of the enrollment determining the record.

  5. 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.,

  1. 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
  2. If the record is for a Section 504 program, report the earliest of:
    1. the Section 504 End Date
    2. OR the enrollment End Date
    3. If no exit date exists, report blank
  3. For Coordinating Early Intervening Services:
    1. 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.
    2. If the record is triggered from the Coord. Early Intervention field on enrollment, report the end date of the enrollment determining the record.
    3. Otherwise, report blank
  4. If the record is triggered from an enrollment for the following programs:
    1. Third Party - CESA program
    2. Third Party - Other program
    3. Then, report the end date of the enrollment determining the record.
    4. 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.,

  1. Optional, do not report.

O



servedOutsideOf

RegularSession

Indicates whether the student received services during the summer session or between sessions.,

  1. Optional, do not report.

O



enrollmentStatus


  1. Optional, do not report.

O



services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.,

  1. Optional, do not report.

O