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 tables below describe the logic for triggering syncing of this object.
DECA
| Action | Trigger |
|---|---|
| Post | When a DECA Flag is created and the record overlaps the configured year. Flag must be checked State Reported. |
| Put | When information related to the record changes. A POST / DELETE will be performed if part of the natural key. A PUT will be performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year |
Educators Rising
| Action | Trigger |
|---|---|
| Post | When a EDR Flag is created and the record overlaps the configured year. Flag must be checked State Reported |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year |
FBLA
| Action | Trigger |
|---|---|
| Post | When a FBLA Flag is created and the record overlaps the configured year Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST / DELETE will be performed if part of the natural key. A PUT will be performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year |
FCCLA
| Action | Trigger |
|---|---|
| Post | When a FCCLA Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST / DELETE will be performed if part of the natural key. A PUT will be performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
FFA
| Action | Trigger |
|---|---|
| Post | When a FFA Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year |
HOSA
| Action | Trigger |
|---|---|
| Post | When a HOSA Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
MO Option Program
| Action | Trigger |
|---|---|
| Post | When the MO Option Prog box is checked within an active enrollment. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
MPP
| Action | Trigger |
|---|---|
| Post | When the MPP box is checked within an active enrollment. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
Pathways
| Action | Trigger |
|---|---|
| Post | When a Pathways Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
SkillsUSA
| Action | Trigger |
|---|---|
| Post | When a SkillsUSA Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
TSA
| Action | Trigger |
|---|---|
| Post | When a TSA Flag is created and the record overlaps the configured year. Flag MUST be checked State Reported. |
| Put | When information related to the record changes. A POST/DELETE is performed if part of the natural key. A PUT is performed if not part of the natural key. |
| Delete/Post | When part of the record's Natural Key changes
When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post |
| Delete | When a Flag is deleted or when the record no longer overlaps the configured year. |
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 | When 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 | When 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 | When 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 | When 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:
|
| Delete | Cascading Deletes: N/A - No resources exist 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 |
|---|---|
| ProgramParticipation | participationID |
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
Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
DECA
| Data Element Label | Business Requirement and Business Rules | M, C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociationProgramParticipationStatuses. The status of the student's program participation. Reports the fields that are part of the Natural Key for the programParticipationStatuses resource.
| M | Student Information> General> Flags> Flags |
Educators Rising
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags | M | Student Information > General > Flags > Start Date | programparticipation.startdate |
| educationOrganizationReference | The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration> Resources> District Information> State District Number | |
| programReference | The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation. Reports the fields that are part of the Natural Key for the programParticipationStatuses resource.
| M | Student Information> General> Flags> Flags |
FBLA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related Education Organization resource. Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | Reports the fields that are part of the Natural Key for the programParticipationStatuses resource.
| M | Student Information > General > Flags > Flags |
FCCLA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource | M | ||
beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related Education Organization resource. Reports fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation. Reports the fields that are part of the Natural Key for the programParticipationStatuses resource.
| M | Student Information > General > Flags > Flags |
FFA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation.
| M | Student Information > General > Flags > Flags |
HOSA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation.
| M | Student Information > General > Flags > Flags |
MO Option Program
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource.
| M | Student Information > General > Enrollments > State Reporting Fields > MO Option Prog |
MPP
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource.
| M | Student Information > General > Enrollments > State Reporting Fields > MPP |
Pathways
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation.
| M | Student Information > General > Flags > Flags |
SkillsUSA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation.
| M | Student Information > General > Flags > Flags |
TSA
| Data Label Element | Business Requirement and Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. Report the Start Date when reporting from Flags. | M | Student Information > General > Flags > Start Date | programparticipation. startdate |
| educationOrganizationReference | A reference to the related EducationOrganization resource Reports the fields that are part of the Natural Key for the Local Education Agency resource.
| M | System Administration > Resources > District Information > State District Number | |
| programReference | A reference to the related Program resource. Reports fields that are part of the Natural Key for the Programs resource.
| M | ||
| studentReference | A reference to the related Student resource.
| M | ||
| participationStatus | A reference to the related participation resource. Do not report. | O | ||
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation.
| M | Student Information > General > Flags > Flags |
Type/Descriptors
Programs
Participation Status
Code | Description | Namespace | Short Description |
|---|---|---|---|
| Active | Active | uri://dese.mo.gov/ParticipationStatusDescriptor | Active |
| 0 | No Participation | uri://dese.mo.gov/ParticipationStatusDescriptor | No Participation |
| 1 | Dues paying member, no participation | uri://dese.mo.gov/ParticipationStatusDescriptor | Dues paying member, no participation |
| 2 | Low level of participation | uri://dese.mo.gov/ParticipationStatusDescriptor | Low level of participation |
| 3 | Medium level of participation | uri://dese.mo.gov/ParticipationStatusDescriptor | Medium level of participation |
| 4 | High level of participation | uri://dese.mo.gov/ParticipationStatusDescriptor | High level of participation |
Program Type Descriptors
| Code | Description | Namespace | Short Description |
|---|---|---|---|
| Career and Technical Education | Career and Technical Education | uri://dese.mo.gov/ProgramTypeDescriptor | Career and Technical Education |
| Career Technical Student Organization | Career Technical Student Organization | uri://dese.mo.gov/ProgramTypeDescriptor | Career Technical Student Organization |
| Early Childhood Special Education | Early Childhood Special Education | uri://dese.mo.gov/ProgramTypeDescriptor | Early Childhood Special Education |
| English for Speakers of Other Languages | English for Speakers of Other Languages | uri://dese.mo.gov/ProgramTypeDescriptor | English for Speakers of Other Languages |
| Language Instruction | Language Instruction | uri://dese.mo.gov/ProgramTypeDescriptor | Language Instruction |
| Missouri Option Program | Missouri Option Program | uri://dese.mo.gov/ProgramTypeDescriptor | Missouri Option Program |
| Neglected Or Delinquent | Neglected Or Delinquent | uri://dese.mo.gov/ProgramTypeDescriptor | Neglected Or Delinquent |
| Public Preschool | Public Preschool | uri://ed-fi.org/ProgramTypeDescriptor | Public Preschool |
| Regular Education | Regular Education | uri://dese.mo.gov/ProgramTypeDescriptor | Regular Education |
| Special Education | Special Education | uri://dese.mo.gov/ProgramTypeDescriptor | Special Education |
| Title I Part A | Title I Part A | uri://dese.mo.gov/ProgramTypeDescriptor | Title I Part A |
| Title III | Title III | uri://dese.mo.gov/ProgramTypeDescriptor | Title III |
