Programs (Georgia 3.6.1)

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 tables below describe logic for triggering syncing of this object.

Academic Programs, Flags, Graduation Programs, and Programs

Click here to expand...

Action	Trigger
Post	When a Flag or Program that is mapped to an Ed-Fi Code in Resource Preferences AND a student within the reporting school has a reportable record for that Flag or Program. All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).
Delete/Post/Put	A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed. When the following elements on Flags are changed: Name When the following elements on Graduation Programs are changed: Name School When the following elements on Academic Programs are changed: Name School When the following elements on Programs are changed: Name School(s) District Wide
Delete	If a mapping is removed from Resource Preferences. Programs will only be deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is therefore recommended that Student Program Associations is always resynced with Programs.

Action

Trigger

Post

When a Flag or Program that is mapped to an Ed-Fi Code in Resource Preferences AND a student within the reporting school has a reportable record for that Flag or Program.

All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).

Delete/Post/Put

A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed.

When the following elements on Flags are changed:
- Name
When the following elements on Graduation Programs are changed:
- Name
- School
When the following elements on Academic Programs are changed:
- Name
- School
When the following elements on Programs are changed:
- Name
- School(s)
- District Wide

Delete

If a mapping is removed from Resource Preferences. Programs will only be deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is therefore recommended that Student Program Associations is always resynced with Programs.

Alternative Education (01 Programs)

Alternative Education programs assigned to students in Student Information > Program Participation > State Programs > Alternative Education.

Click here to expand...

Action	Trigger
Post	When a student in the school has an Alternative Education program record that overlaps an Enrollment in the configured year. All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).
Delete/Post/Put	A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed. When the following elements on Alternative Education records are changed: Start Date End Date Alternative School ID
Delete	Programs are only deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is recommended that Student Program Associations is always resynced with Programs.

Action

Trigger

Post

When a student in the school has an Alternative Education program record that overlaps an Enrollment in the configured year.

All students reference the same program record once it is created (Do not create duplicate program records for the exact same program).

Delete/Post/Put

A DELETE/POST is performed if the element being changed is part of the natural key for the resource. Otherwise, a PUT is performed.

When the following elements on Alternative Education records are changed:
- Start Date
- End Date
- Alternative School ID

Delete

Programs are only deleted after a resync is completed and 'All Schools' is checked on resync. All Student Program Association records must be deleted before a Program can be deleted. It is recommended that Student Program Associations is always resynced with Programs.

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

Action

Trigger

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
Special Education: Record will report for each year in which there is a locked IEP or NPSP. If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX
English Learner (EL) and Immigrant: Record will report for each year where an active LEP service exists. LEP service must be active at least one day within or the Scope Year. If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.
Title 1: Record will report for each year in which there is a student that has a Title I program. The program with the selection must be within the Ed-Fi scope year.
Early Childhood: Record will report for each year in which there is a student that has an Early Childhood program. The program with the selection must be within the Ed-Fi scope year
FRAM:Record will report for each year in which there is a student that has a food service program. The program with the selection must be within the Ed-Fi scope year
Data will only send for the years that have valid configuration.

Logic

Special Education: Record will report for each year in which there is a locked IEP or NPSP.

If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX

English Learner (EL) and Immigrant: Record will report for each year where an active LEP service exists.

LEP service must be active at least one day within or the Scope Year.
If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.

Title 1: Record will report for each year in which there is a student that has a Title I program.

The program with the selection must be within the Ed-Fi scope year.

Early Childhood: Record will report for each year in which there is a student that has an Early Childhood program.

The program with the selection must be within the Ed-Fi scope year

FRAM:Record will report for each year in which there is a student that has a food service program.

The program with the selection must be within the Ed-Fi scope year

Data will only send for the years that have valid configuration.

Resource Preferences

Data Element Label	Mapping Needed
Program Type Descriptors	Programs
Program Type Descriptors - Flags	Flag

Object Data Elements

This table describes data elements sent within the Programs resource.

Academic Programs, Flags, Graduation Programs, and Programs

Click here to expand...

Data Element Label	Business Rules	M, C, or O	Data Source GUI Path	Database Field
programName	Flags: Report the Flag Name. Grad Programs + Academic Programs + Programs: Report the Program Name.	M	Program Admin > Flags > Name Program Admin > Programs > Name	Program.name
programTypeDescriptor	Report the Ed-Fi Code the Flag or Program is mapped to in Resource Preferences.	M	System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences > Programs	N/A
educationOrganizationReference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID If a school is specified in the School dropdown, the Program will only report under that school. If no school is specified in the School dropdown OR the District Wide checkbox is checked, ALL schools in the district will report the Program record. Flags will always report for ALL schools.	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID

Data Element Label

Business Rules

M, C, or O

Data Source
GUI Path

Database Field

programName

Flags: Report the Flag Name.
Grad Programs + Academic Programs + Programs: Report the Program Name.

Program Admin > Flags > Name

Program Admin > Programs > Name

Program.name

programTypeDescriptor

Report the Ed-Fi Code the Flag or Program is mapped to in Resource Preferences.

System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences > Programs

N/A

educationOrganizationReference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = Ed-Fi School ID
- If a school is specified in the School dropdown, the Program will only report under that school.
- If no school is specified in the School dropdown OR the District Wide checkbox is checked, ALL schools in the district will report the Program record.
  - Flags will always report for ALL schools.

System Administration > Resources > School > Ed-Fi School ID

School.entityID

Alternative Education (01 Programs)

Click here to expand...

Data Element Label	Business Rules	M, C, or O	Data Source GUI Path	Database Field
programName	Reports the Name of the Program Type selected.	M	Student Information > Program Participation > State Programs > Alternative Education > Program Type	N/A
programTypeDescriptor	Report the Code of the Program Type selected.	M	Student Information > Program Participation > State Programs > Alternative Education > Program Type	AltProgram.programCode
educationOrganizationReference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Alternative School ID	M	Student Information > Program Participation > State Programs > Alternative Education > Alternative School ID	AltProgram.locationID

Data Element Label

Business Rules

M, C, or O

Data Source
GUI Path

Database Field

programName

Reports the Name of the Program Type selected.

Student Information > Program Participation > State Programs > Alternative Education > Program Type

N/A

programTypeDescriptor

Report the Code of the Program Type selected.

Student Information > Program Participation > State Programs > Alternative Education > Program Type

AltProgram.programCode

educationOrganizationReference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = Alternative School ID

Student Information > Program Participation > State Programs > Alternative Education > Alternative School ID

AltProgram.locationID

Descriptors

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

Click here to expand...

Program Type Descriptor

Code Value	Description	Namespace	Short Description
04D	Before/After School	uri://gadoe.org/ProgramTypeDescriptor	Before/After School
04E	Saturday/Weekend Program	uri://gadoe.org/ProgramTypeDescriptor	Saturday/Weekend Program
04F	Summer	uri://gadoe.org/ProgramTypeDescriptor	Summer
04A	Extended Day	uri://gadoe.org/ProgramTypeDescriptor	Extended Day
04B	Extended Week	uri://gadoe.org/ProgramTypeDescriptor	Extended Week
04C	Extended Year	uri://gadoe.org/ProgramTypeDescriptor	Extended Year
02A	GNETS - Center Based	uri://gadoe.org/ProgramTypeDescriptor	GNETS - Center Based
02B	GNETS - School Based	uri://gadoe.org/ProgramTypeDescriptor	GNETS - School Based
03A	Career Academy	uri://gadoe.org/ProgramTypeDescriptor	Career Academy
01A	Alternative Education Program for disruptive students	uri://gadoe.org/ProgramTypeDescriptor	Alternative Education Program for disruptive students
01B	Choice - Early College/Gateway to College	uri://gadoe.org/ProgramTypeDescriptor	Choice - Early College/Gateway to College
01D	Choice - Non-Traditional High School (Performance Learning Centers)	uri://gadoe.org/ProgramTypeDescriptor	Choice - Non-Traditional High School (Performance Learning Centers)
01G	EMO/Vendor Operated	uri://gadoe.org/ProgramTypeDescriptor	EMO/Vendor Operated
01E	Choice - Non-Traditional High School (Open Campus/Evening School/Other)	uri://gadoe.org/ProgramTypeDescriptor	Choice - Non-Traditional High School (Open Campus/Evening School/Other)
01H	Program for Non-Disruptive Students	uri://gadoe.org/ProgramTypeDescriptor	Program for Non-Disruptive Students
05A	Before/After School	uri://gadoe.org/ProgramTypeDescriptor	Before/After School
05B	During School	uri://gadoe.org/ProgramTypeDescriptor	During School
05C	Saturday Program	uri://gadoe.org/ProgramTypeDescriptor	Saturday Program
05D	Intercession	uri://gadoe.org/ProgramTypeDescriptor	Intercession
05E	Summer	uri://gadoe.org/ProgramTypeDescriptor	Summer
English Learner (EL)	English Learner (EL)	uri://gadoe.org/ProgramTypeDescriptor	English Learner (EL)
Gifted and Talented	Gifted and Talented	uri://gadoe.org/ProgramTypeDescriptor	Gifted and Talented
Homeless	Homeless	uri://gadoe.org/ProgramTypeDescriptor	Homeless
Section 504 Placement	Section 504 Placement	uri://gadoe.org/ProgramTypeDescriptor	Section 504 Placement
Special Education	Special Education	uri://gadoe.org/ProgramTypeDescriptor	Special Education
Student School Food Service	Student School Food Service	uri://gadoe.org/ProgramTypeDescriptor	Student School Food Service

Object Triggering Logic

Academic Programs, Flags, Graduation Programs, and Programs

Alternative Education (01 Programs)

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Object Data Elements

Academic Programs, Flags, Graduation Programs, and Programs

Alternative Education (01 Programs)

Descriptors

Program Type Descriptor

Related Articles