Programs (Core v3.X)

Tool Search: Ed-Fi

This entity represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services or benefits through federal, state or local agencies. Programs may also include organized extracurricular activities for students.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When Flag is created and is mapped to an Ed-FI Program Type Descriptor and a resync is completed

  • The Program record will Post when the first student is given an eligible Flag record that is mapped.
  • All students will reference the same programs once the first one is created.
Post

Post a Program when a student is assigned to a program record in the following areas.  The record must overlap the configured year and have a Student School Association record to report.

  • Career Tech Program
  • Title I
  • SPED - locked IEP
  • Homeless
  • EL
  • Migrant
  • FRAM Eligibility
DeleteIf a mapping is removed from Resource Preferences. Programs will only be deleted when a mapping is removed after a resync is completed and 'All Schools' is checked on resync. Programs are at the district level and students in another school may have a Student Program Association record that references the Program.  All Student Program Association records must be deleted before a Program can be 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 change:

  • LEA Reference - District Numbers cannot change after data has been sent.  If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
  • If the Program Name or Program Type Descriptor mapping changes.

Delete

Cascading Deletes:  If the Natural Key changes, the following resources will be deleted/reposted.

  • Student Program Associations, Student Homeless Program Associations, Student Migrant Program Associations, Student Title 1 Part A Program Associations, Student Neglected or Delinquent Program Associations, Student Language Instruction Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Food Service Eligibility Associations.
  • If a mapping to the Ed-Fi Program Type Descriptor is removed or changed, a resync must be completed on 'All Schools' to delete/repost Student Program Associations.  If only 1 school is selected, only Student Program Association records associated with that school will be updated and the Program will remain until a resync on 'All Schools' for Programs is completed.


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 record is associated with.
Data will only send for the years that have valid configuration.


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Program Type DescriptorsPrograms
Program Type Descriptors - FlagsFlags


Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
ProgramprogramID
Plan'sped'


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

programsPost

The primary table used for sending data for this resource

programparticipationPost

The primary table used for sending data for this resource

title1Post

The primary table used for sending data for this resource

lepPost

The primary table used for sending data for this resource

migrantPost

The primary table used for sending data for this resource

homelessPost

The primary table used for sending data for this resource

POSEligiblityPost

The primary table used for sending data for this resource

Error Log

Error

Possible Causes/How to Fix

409: Failed to delete programs resource.

[message:The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'generalStudentProgramAssociation' entity.]

There are dependent resources in the Ed-Fi ODS so the Program record cannot be deleted.  Use the delete tool to remove any dependent data before the course can be removed.


Object Data Elements

This table describes data elements sent within the Programs resource.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field

id  

The unique identifier of the resource.


M


programName The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.
  1. If reporting from Flags, report the Flag Name.
  2. If reporting from a program area in Campus, report the Program Type Descriptor the program is mapped to:
    • Student Program Associations

    • Student Homeless Program Associations

    • Student Migrant Program Associations

    • Student Title 1 Part A Program Associations

    • Student Neglected or Delinquent Program Associations

    • Student Language Instruction Program Associations,

    • Student CTE Program Associations

    • Student Special Education Program Associations

    • Student Food Service Eligibility Associations.

M

Program Admin> Flags> Name


OR


Program Admin> Programs> Career Tech Programs


Or


Student Information> Program Participation> Homeless


Or


Student Information> Program Participation> Migrant


OR


Student Information> Program Participation> Title 1


OR


Student Information> Program Participation> ELL


Or


Special Education> IEP


OR


FRAM > Eligibility

program.name

or

EdFiMapping.edFiValue

programTypeDescriptor

The formal name of the program of instruction, training, services or benefits available through federal, state or local agencies.

  1. If reporting from Flags, report the Ed-Fi code to which the flag is mapped.
  2. If reporting from a program area in Campus, report the Program Type Descriptor the program is mapped to:
    • Student Program Associations

    • Student Homeless Program Associations

    • Student Migrant Program Associations

    • Student Title 1 Part A Program Associations

    • Student Neglected or Delinquent Program Associations

    • Student Language Instruction Program Associations

    • Student CTE Program Associations

    • Student Special Education Program Associations

    • Student Food Service Eligibility Associations.

M

Program Admin> Flags> Name


OR


Program Admin> Programs> Career Tech Programs


Or


Student Information> Program Participation> Homeless


Or


Student Information> Program Participation> Migrant


OR


Student Information> Program Participation> Title 1


OR


Student Information> Program Participation> ELL


Or


Special Education> IEP


OR


FRAM > Eligibility

EdFiMapping.edFiValue
educationOrganizationReference A reference to the related EducationOrganization resource.
  1. Reports the State District Number.
MSystem Administration> Resources> District Information> State District Number district.number
characteristicsReflects important characteristics of the Program, such as categories or particular indications.
O

learningObjectives References the LearningObjective(s) with which the Program is associated.
O

learningStandardsLearningStandard followed by this program.
O

programIdA unique number or alphanumeric code assigned to a program by a school, school system, a state, or other agency or entity.
  1. Reports the program ID from the flag or Career Tech Programs.
  2. Otherwise, report '1'.


OProgram Admin> Flags

program.programId

services Defines the services this program provides to students.
O

sponsors

Ultimate and intermediate providers of funds for a particular educational or service program or activity, or for an individual’s participation in the program or activity (e.g., Federal, State, ESC, District, School, Private Organization).


O

etag

O


Type/Descriptor

This table describes the Ed-Fi Value mapped and reported for ProgramType Descriptor:

Click here to expand...

Program Type Descriptors

Code ValueDescriptionNamespaceShort Description
Adult/Continuing EducationAdult/Continuing Educationuri://ed-fi.org/ProgramTypeDescriptorAdult/Continuing Education
Alternative EducationAlternative Educationuri://ed-fi.org/ProgramTypeDescriptorAlternative Education
AthleticsAthleticsuri://ed-fi.org/ProgramTypeDescriptorAthletics
BilingualBilingualuri://ed-fi.org/ProgramTypeDescriptorBilingual
Bilingual SummerBilingual Summeruri://ed-fi.org/ProgramTypeDescriptorBilingual Summer
Career and Technical EducationCareer and Technical Educationuri://ed-fi.org/ProgramTypeDescriptorCareer and Technical Education
Cocurricular ProgramsCocurricular Programsuri://ed-fi.org/ProgramTypeDescriptorCocurricular Programs
College PreparatoryCollege Preparatoryuri://ed-fi.org/ProgramTypeDescriptorCollege Preparatory
Community Service ProgramCommunity Service Programuri://ed-fi.org/ProgramTypeDescriptorCommunity Service Program
Community/Junior College Education ProgramCommunity/Junior College Education Programuri://ed-fi.org/ProgramTypeDescriptorCommunity/Junior College Education Program
Compensatory Services for Disadvantaged StudentsCompensatory Services for Disadvantaged Studentsuri://ed-fi.org/ProgramTypeDescriptorCompensatory Services for Disadvantaged Students
Counseling ServicesCounseling Servicesuri://ed-fi.org/ProgramTypeDescriptorCounseling Services
District-Funded GEDDistrict-Funded GEDuri://ed-fi.org/ProgramTypeDescriptorDistrict-Funded GED
Early Head StartEarly Head Starturi://ed-fi.org/ProgramTypeDescriptorEarly Head Start
Early Intervention Services Part CEarly Intervention Services Part Curi://ed-fi.org/ProgramTypeDescriptorEarly Intervention Services Part C
English as a Second Language (ESL)English as a Second Language (ESL)uri://ed-fi.org/ProgramTypeDescriptorEnglish as a Second Language (ESL)
Even StartEven Starturi://ed-fi.org/ProgramTypeDescriptorEven Start
Expelled EducationExpelled Educationuri://ed-fi.org/ProgramTypeDescriptorExpelled Education
Extended Day/Child Care ServicesExtended Day/Child Care Servicesuri://ed-fi.org/ProgramTypeDescriptorExtended Day/Child Care Services
Fee For ServiceFee For Serviceuri://ed-fi.org/ProgramTypeDescriptorFee For Service
Foreign ExchangeForeign Exchangeuri://ed-fi.org/ProgramTypeDescriptorForeign Exchange
Gifted and TalentedGifted and Talenteduri://ed-fi.org/ProgramTypeDescriptorGifted and Talented
Head StartHead Starturi://ed-fi.org/ProgramTypeDescriptorHead Start
Health Services ProgramHealth Services Programuri://ed-fi.org/ProgramTypeDescriptorHealth Services Program
High School Equivalency Program (HSEP)High School Equivalency Program (HSEP)uri://ed-fi.org/ProgramTypeDescriptorHigh School Equivalency Program (HSEP)
Home VisitingHome Visitinguri://ed-fi.org/ProgramTypeDescriptorHome Visiting
HomelessHomelessuri://ed-fi.org/ProgramTypeDescriptorHomeless
IDEAIDEAuri://ed-fi.org/ProgramTypeDescriptorIDEA
Immigrant EducationImmigrant Educationuri://ed-fi.org/ProgramTypeDescriptorImmigrant Education
Independent StudyIndependent Studyuri://ed-fi.org/ProgramTypeDescriptorIndependent Study
Indian EducationIndian Educationuri://ed-fi.org/ProgramTypeDescriptorIndian Education
International BaccalaureateInternational Baccalaureateuri://ed-fi.org/ProgramTypeDescriptorInternational Baccalaureate
Kindergarten - Extended DayKindergarten - Extended Dayuri://ed-fi.org/ProgramTypeDescriptorKindergarten - Extended Day
Kindergarten - Full DayKindergarten - Full Dayuri://ed-fi.org/ProgramTypeDescriptorKindergarten - Full Day
Kindergarten - Half DayKindergarten - Half Dayuri://ed-fi.org/ProgramTypeDescriptorKindergarten - Half Day
Library/Media Services ProgramLibrary/Media Services Programuri://ed-fi.org/ProgramTypeDescriptorLibrary/Media Services Program
Magnet/Special Program EmphasisMagnet/Special Program Emphasisuri://ed-fi.org/ProgramTypeDescriptorMagnet/Special Program Emphasis
Migrant EducationMigrant Educationuri://ed-fi.org/ProgramTypeDescriptorMigrant Education
Neglected and Delinquent ProgramNeglected and Delinquent Programuri://ed-fi.org/ProgramTypeDescriptorNeglected and Delinquent Program
Optional Flexible School Day Program (OFSDP)Optional Flexible School Day Program (OFSDP)uri://ed-fi.org/ProgramTypeDescriptorOptional Flexible School Day Program (OFSDP)
OtherOtheruri://ed-fi.org/ProgramTypeDescriptorOther
Prekindergarten - Extended DayPrekindergarten - Extended Dayuri://ed-fi.org/ProgramTypeDescriptorPrekindergarten - Extended Day
Prekindergarten - Full DayPrekindergarten - Full Dayuri://ed-fi.org/ProgramTypeDescriptorPrekindergarten - Full Day
Prekindergarten - Half DayPrekindergarten - Half Dayuri://ed-fi.org/ProgramTypeDescriptorPrekindergarten - Half Day
Preschool Special EducationPreschool Special Educationuri://ed-fi.org/ProgramTypeDescriptorPreschool Special Education
Public PreschoolPublic Preschooluri://ed-fi.org/ProgramTypeDescriptorPublic Preschool
Regular EducationRegular Educationuri://ed-fi.org/ProgramTypeDescriptorRegular Education
Remedial EducationRemedial Educationuri://ed-fi.org/ProgramTypeDescriptorRemedial Education
Section 504 PlacementSection 504 Placementuri://ed-fi.org/ProgramTypeDescriptorSection 504 Placement
Service LearningService Learninguri://ed-fi.org/ProgramTypeDescriptorService Learning
Special EducationSpecial Educationuri://ed-fi.org/ProgramTypeDescriptorSpecial Education
Student Retention/Dropout PreventionStudent Retention/Dropout Preventionuri://ed-fi.org/ProgramTypeDescriptorStudent Retention/Dropout Prevention
Substance Abuse Education/PreventionSubstance Abuse Education/Preventionuri://ed-fi.org/ProgramTypeDescriptorSubstance Abuse Education/Prevention
Teacher Professional Development/MentoringTeacher Professional Development/Mentoringuri://ed-fi.org/ProgramTypeDescriptorTeacher Professional Development/Mentoring
Technical PreparatoryTechnical Preparatoryuri://ed-fi.org/ProgramTypeDescriptorTechnical Preparatory
Title I Part ATitle I Part Auri://ed-fi.org/ProgramTypeDescriptorTitle I Part A
Title I Part D Subpart 1Title I Part D Subpart 1uri://ed-fi.org/ProgramTypeDescriptorTitle I Part D Subpart 1
Title I Part D Subpart 2Title I Part D Subpart 2uri://ed-fi.org/ProgramTypeDescriptorTitle I Part D Subpart 2
Vocational EducationVocational Educationuri://ed-fi.org/ProgramTypeDescriptorVocational Education