Student Program Associations (Georgia 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 tables below describe the logic for triggering syncing of this object.

Academic Programs

Academic Programs are setup by the district/school in Program Admin > Programs > Academic Programs. Academic Programs are assigned to students in Student Information > Academic Planning > Programs > New Academic Program.

Click here to expand...

Action	Trigger
Post	When the student has an Academic Program record that overlaps an Enrollment and the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Academic Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Academic Program. The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise. When the following information on the student's associated Academic Programis changed: Academic Program ID (New Academic Program) Start Date End Date Program When the following information on the student's associated Enrollment changes: No Show State Exclude Start Date End Date When the following information on the Academic Program set-up changes: Name School
Delete	When the Academic Program Start and End Dates are changed so that they no longer overlap the configured year. When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Academic Program is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has an Academic Program record that overlaps an Enrollment and the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Academic Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Academic Program.
- The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise.

When the following information on the student's associated Academic Programis changed:
- Academic Program ID (New Academic Program)
- Start Date
- End Date
- Program
When the following information on the student's associated Enrollment changes:
- No Show
- State Exclude
- Start Date
- End Date
When the following information on the Academic Program set-up changes:
- Name
- School

Delete

When the Academic Program Start and End Dates are changed so that they no longer overlap the configured year.
When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Academic Program is deleted.
When the Enrollment is deleted.

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 the student has an Alternative Education record that overlaps an Enrollment in the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude A Programs record for the Alternative Education program must exist in the ODS prior to sending a Student Program Association for Alternative Education. If the Alternative Education Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise. When the following information on the student's associated Alternative Education record is changed: Alternative Education Record ID (New Gifted record) Start Date End Date Program Type Alternate School ID When the following information on the student's associated Enrollment changes: Enrollment ID (New Enrollment) No Show State Exclude Start Date End Date
Delete	When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Alternative Education record is deleted. When the Enrollment is deleted.

Action

Trigger

Post

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

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
A Programs record for the Alternative Education program must exist in the ODS prior to sending a Student Program Association for Alternative Education. If the Alternative Education Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise.

When the following information on the student's associated Alternative Education record is changed:
- Alternative Education Record ID (New Gifted record)
- Start Date
- End Date
- Program Type
- Alternate School ID
When the following information on the student's associated Enrollment changes:
- Enrollment ID (New Enrollment)
- No Show
- State Exclude
- Start Date
- End Date

Delete

When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Alternative Education record is deleted.
When the Enrollment is deleted.

Flags

Flags are set-up by the district/school in Program Admin > Programs > Flags. Flags are assigned to students in Student Information > General > Flags.

Click here to expand...

Action	Trigger
Post	When the student has a Flag record that overlaps an Enrollment and the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Flag must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Flag. The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise. When the following information on the student's associated Flagis changed: Flag ID (New Flag) Start Date End Date When the following information on the student's associated Enrollment changes: No Show State Exclude Start Date End Date When the following information on the Flag set-up changes: Name School
Delete	When the Flag Start and End Dates are changed so that they no longer overlap the configured year. When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Flag is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has a Flag record that overlaps an Enrollment and the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Flag must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Flag.
- The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise.

When the following information on the student's associated Flagis changed:
- Flag ID (New Flag)
- Start Date
- End Date
When the following information on the student's associated Enrollment changes:
- No Show
- State Exclude
- Start Date
- End Date
When the following information on the Flag set-up changes:
- Name
- School

Delete

When the Flag Start and End Dates are changed so that they no longer overlap the configured year.
When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Flag is deleted.
When the Enrollment is deleted.

Gifted & Talented

Gifted & Talented programs assigned to students in Student Information > Program Participation > Gifted.

Click here to expand...

Action	Trigger
Post	When the student has a Gifted record (does not need to overlap the configured year) AND an Enrollment that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude A Programs record for the Gifted and Talented program must exist in the ODS prior to sending a Student Program Association for Gifted and Talented. If the Gifted and Talented Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record. The most recent Gifted record in Campus is always used for reporting purposes. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise. When the following information on the student's associated Gifted record is changed: Gifted Record ID (New Gifted record) Start Date End Date Gifted Eligibility Gifted Referral When the following information on the student's associated Enrollment changes: No Show State Exclude Start Date End Date
Delete	When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Gifted record is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has a Gifted record (does not need to overlap the configured year) AND an Enrollment that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
A Programs record for the Gifted and Talented program must exist in the ODS prior to sending a Student Program Association for Gifted and Talented. If the Gifted and Talented Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record.
The most recent Gifted record in Campus is always used for reporting purposes.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise.

When the following information on the student's associated Gifted record is changed:
- Gifted Record ID (New Gifted record)
- Start Date
- End Date
- Gifted Eligibility
- Gifted Referral
When the following information on the student's associated Enrollment changes:
- No Show
- State Exclude
- Start Date
- End Date

Delete

When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Gifted record is deleted.
When the Enrollment is deleted.

GNETS (02_Programs)

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

Click here to expand...

Action	Trigger
Post	When the student has a GNETS record that overlaps an Enrollment in the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude A Programs record for the GNETS program must exist in the ODS prior to sending a Student Program Association for GNETS. If the GNETS Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise. When the following information on the student's associated GNETS record is changed: GNETS Record ID (New Gifted record) Start Date End Date Program Type When the following information on the student's associated Enrollment changes: Enrollment ID (New Enrollment) No Show State Exclude Start Date End Date
Delete	When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the GNETS record is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has a GNETS record that overlaps an Enrollment in the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
A Programs record for the GNETS program must exist in the ODS prior to sending a Student Program Association for GNETS. If the GNETS Programs record does not already exist in the ODS, it will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise.

When the following information on the student's associated GNETS record is changed:
- GNETS Record ID (New Gifted record)
- Start Date
- End Date
- Program Type
When the following information on the student's associated Enrollment changes:
- Enrollment ID (New Enrollment)
- No Show
- State Exclude
- Start Date
- End Date

Delete

When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the GNETS record is deleted.
When the Enrollment is deleted.

Graduation Programs

Graduation Programs are set-up by the district/school in Program Admin > Programs > Graduation Programs. Academic Programs are assigned to students in Student Information > Academic Planning > Programs > New Graduation Program.

Click here to expand...

Action	Trigger
Post	When the student has a Graduation Program record that overlaps an Enrollment and the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Graduation Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Graduation Program. The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise. When the following information on the student's associated Graduation Programis changed: Graduation Program ID (New Graduation Program) Start Date End Date Program When the following information on the student's associated Enrollment changes: No Show State Exclude Start Date End Date When the following information on the Graduation Program set-up changes: Name School
Delete	When the Graduation Program Start and End Dates are changed so that they no longer overlap the configured year. When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Graduation Program is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has a Graduation Program record that overlaps an Enrollment and the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Graduation Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Graduation Program.
- The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is changed. A Put is performed otherwise.

When the following information on the student's associated Graduation Programis changed:
- Graduation Program ID (New Graduation Program)
- Start Date
- End Date
- Program
When the following information on the student's associated Enrollment changes:
- No Show
- State Exclude
- Start Date
- End Date
When the following information on the Graduation Program set-up changes:
- Name
- School

Delete

When the Graduation Program Start and End Dates are changed so that they no longer overlap the configured year.
When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Graduation Program is deleted.
When the Enrollment is deleted.

Programs

Programs are set-up by the district/school in Program Admin > Programs > Programs. Programs are assigned to students in Student Information > Program Participation > Programs > New Program.

Click here to expand...

Action	Trigger
Post	When the student has a Program record that overlaps an Enrollment and the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Program. The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID
Delete/Post/Put	A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise. When the following information on the student's associated Programis changed: Program ID (New Program) Start Date End Date Program When the following information on the student's associated Enrollment changes: Enrollment ID (New Enrollment) No Show State Exclude Start Date End Date When the following information on the Program set-up changes: Name School(s) District Wide
Delete	When the Program Start and End Dates are changed so that they no longer overlap the configured year. When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year. When the Program is deleted. When the Enrollment is deleted.

Action

Trigger

Post

When the student has a Program record that overlaps an Enrollment and the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Program must be mapped in Resource Preferences > Programs prior to reporting a Student Program Associations record for the Program.
- The Programs record must exist in the ODS prior to sending a Student Program Associations record. If the Programs record does not already exist in the ODS and a mapping is present in Resource Preferences > Programs, the Programs record will be sent prior to the Student Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID

Delete/Post/Put

A Delete/Post is performed if the natural key of the record is being changed. A Put is performed otherwise.

When the following information on the student's associated Programis changed:
- Program ID (New Program)
- Start Date
- End Date
- Program
When the following information on the student's associated Enrollment changes:
- Enrollment ID (New Enrollment)
- No Show
- State Exclude
- Start Date
- End Date
When the following information on the Program set-up changes:
- Name
- School(s)
- District Wide

Delete

When the Program Start and End Dates are changed so that they no longer overlap the configured year.
When the Enrollment Start and End Dates are changed so that they no longer overlap the configured year.
When the Program is deleted.
When the Enrollment 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.

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: 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 an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. If the Program Name or Program Type Descriptor mapping changes and a resync is completed. 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 exist under this resource.

Action

Trigger

Post/Delete

Natural Key changes:

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 an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
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 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.

Academic Programs

Click here to expand...

Data Element Label	Business Requirement and Business Rules	M, C, or O	Data Source GUI Path	Database Field
educationOrganization Reference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Academic Program Name programTypeDescriptor = Ed-Fi Code mapped to the Academic Program in Resource Preferences > Programs	M	System Administration > Resources > School > Ed-Fi School ID Program Admin > Programs > Name	School.entityID Program.name
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
beginDate	The month, day, and year on which the Student first received services. Report the latest of the following dates: Academic Program Start Date Enrollment Start Date	M	Student Information > Academic Planning > Programs > Academic Program > Start Date Student Information > General > Enrollments > Start Date	ProgramParticipation.startDate Enrollment.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services. Report the Academic Program End Date If the calculated beginDate is after the Academic Program End Date, report the calculated beginDate. Do not report if Academic Program End Date is Blank / NULL	C	Student Information > Academic Planning > Programs > Academic Program > End Date	ProgramParticipation.endDate

Alternative Education (01 Programs)

Click here to expand...

Data Element Label	Business Requirement and Business Rules	M, C, or O	Data Source GUI Path	Database Field
educationOrganization Reference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Alternate School ID programName = Name of Program Type selected. programTypeDescriptor = Code of Program Type selected.	M	N/A	N/A
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.	M	N/A	N/A
beginDate	Report the Start Date.	M	Student Information > Program Participation > State Programs > Alternative Education > Start Date	AltProgram.startDate
endDate	Report the End Date.	C	Student Information > Program Participation > State Programs > Alternative Education > End Date	AltProgram.endDate

Flags

Click here to expand...

Data Label Element	Business Requirement and Business Rules	M,C, or O	Data Source GUI Path	Database Field
educationOrganizationReference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Flag Name programTypeDescriptor = Ed-Fi Code mapped to the Flag in Resource Preferences > Programs	M	System Administration > Resources > School > Ed-Fi School ID Program Admin > Programs > Name	School.entityID Program.name
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
beginDate	The month, day, and year on which the Student first received services. Report the latest of the following dates: Flag Start Date Enrollment Start Date	M	Student Information > General > Flags > Start Date Student Information > General > Enrollment > Start Date	ProgramParticipation.startDate Enrollment.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services. Report the Flag End Date If the calculated beginDate is after the Flag End Date, report the calculated beginDate. Do not report if Flag End Date is Blank / NULL	C	Student Information > General > Flags > End Date	ProgramParticipation.endDate

Gifted & Talented

Click here to expand...

Data Label Element	Business Requirement and Business Rules	M,C, or O	Data Source GUI Path	Database Field
educationOrganizationReference	A reference to the related Education Organization resource. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Gifted and Talented (Hard-Coded) programTypeDescriptor = Gifted and Talented (Hard-Coded)	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
beginDate	The month, day, and year on which the Student first received services. Report the Gifted Start Date This is intended to report the "Gifted Eligibility Date."	M	Student Information > Program Participation > Gifted > Start Date	Gifted.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services. Report the Gifted End Date Do not report if Gifted End Date is Blank / NULL.	C	Student Information > Program Participation > Gifted > End Date	Gifted.endDate
programParticipationStatuses	participationStatusDescriptor Report the Ed-Fi Code mapped to the value selected for Gifted Eligibility Do not report if Gifted Eligibility is Blank / NULL or has a value that is not mapped to an Ed-Fi Code statusBeginDate Report the Gifted Start Date Do not report any of the other data elements inside of this array, they are optional.	C	Student Information > Program Participation > Gifted > Gifted Eligibility Student Information > Program Participation > Gifted > Start Date	Gifted.startDate Gifted.participation
programReferredByDescriptor	Report the Ed-Fi Code mapped to the value selected for Gifted Referral. Do not report if Gifted Referral is Blank / NULL or has a value that is not mapped to an Ed-Fi Code	C	Student Information > Program Participation > Gifted > Gifted Referral	Gifted.giftedReferral

GNETS (02_Programs)

Click here to expand...

Data Label Element	Business Requirement and Business Rules	M,C, or O	Data Source GUI Path	Database Field
educationOrganizationReference	A reference to the related Education Organization resource. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Name of Program Type selected. programTypeDescriptor = Code of Program Type selected.	M	N/A	N/A
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource.	M	N/A	N/A
beginDate	Report the Start Date.	M	Student Information > Program Participation > State Programs > GNETS Program > Start Date	SupportEnvironment.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services. Report the End Date.	C	Student Information > Program Participation > State Programs > GNETS Program >End Date	SupportEnvironment.endDate

Graduation Programs

Click here to expand...

Data Label Element	Business Requirement and Business Rules	M,C, or O	Data Source GUI Path	Database Field
educationOrganizationReference	A reference to the related Education Organization resource. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	A reference to the related Program resource. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Graduation Program Name programTypeDescriptor = Ed-Fi Code mapped to the Graduation Program in Resource Preferences > Programs	M	System Administration > Resources > School > Ed-Fi School ID Program Admin > Programs > Name	School.entityID Program.name
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
beginDate	The month, day, and year on which the Student first received services. Report the latest of the following dates: Graduation Program Start Date Enrollment Start Date	M	Student Information > Academic Planning > Programs > Graduation Program > Start Date Student Information > General > Enrollment > Start Date	ProgramParticipation.startDate Enrollment.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services. Report the Graduation Program End Date If the calculated beginDate is after the Graduation Program End Date, report the calculated beginDate. Do not report if Graduation Program End Date is Blank / NULL	C	Student Information > Academic Planning > Programs > Graduation Program > End Date	ProgramParticipation.endDate

Programs

Click here to expand...

Data Label Element	Business Requirement and Business Rules	M,C, or O	Data Source GUI Path	Database Field
educationOrganizationReference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = Program Name programTypeDescriptor = Ed-Fi Code mapped to the Program in Resource Preferences > Programs	M	System Administration > Resources > School > Ed-Fi School ID Program Admin > Programs > Name	School.entityID Program.name
studentReference	Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
beginDate	Report the latest of the following dates: Program Start Date Enrollment Start Date	M	Student Information > Program Participation > Programs > Start Date Student Information > General > Enrollment > Start Date	ProgramParticipation.startDate Enrollment.startDate
endDate	Report the Program End Date If the calculated beginDate is after the Program End Date, report the calculated beginDate. Do not report if Program End Date is Blank / NULL	C	Student Information > Program Participation > Programs > End Date	ProgramParticipation.endDate

Type/Descriptors

Programs

Click here to expand...

programReferredByDescriptor

Code Value	Description	Namespace	Short Description
1	Referred by system's automatic referral procedure	uri://gadoe.org/ProgramReferredByDescriptor	Referred by system's automatic referral procedure
2	Referred by teacher	uri://gadoe.org/ProgramReferredByDescriptor	Referred by teacher
3	Referred by parent/guardian	uri://gadoe.org/ProgramReferredByDescriptor	Referred by parent/guardian
4	Referred by self	uri://gadoe.org/ProgramReferredByDescriptor	Referred by self
5	Referred by peer	uri://gadoe.org/ProgramReferredByDescriptor	Referred by peer
6	Referred by other	uri://gadoe.org/ProgramReferredByDescriptor	Referred by other
9	Not referred	uri://gadoe.org/ProgramReferredByDescriptor	Not referred

participationStatusDescriptor

Code Value	Description	Namespace	Short Description
2	Initial eligibility established this year	uri://gadoe.org/ParticipationStatusDescriptor	Initial eligibility established this year
3	Initial eligibility established in a previous year	uri://gadoe.org/ParticipationStatusDescriptor	Initial eligibility established in a previous year
4	Referred this year, but not eligible	uri://gadoe.org/ParticipationStatusDescriptor	Referred this year, but not eligible
6	Initial eligibility established using alternative method this year (only valid for GaDOE approved pilot schools in FY22)	uri://gadoe.org/ParticipationStatusDescriptor	Initial eligibility established using alternative method this year
9	Never eligible	uri://gadoe.org/ParticipationStatusDescriptor	Never eligible

reasonExitedDescriptor

Code Value	Description	Namespace	Short Description
1	ACCESS for EL proficiency	uri://gadoe.org/ReasonExitedDescriptor	ACCESS for EL proficiency
2	Exited out of state or from a non public school	uri://gadoe.org/ReasonExitedDescriptor	Exited out of state or from a non public school
3	Reclassification Team Decision	uri://gadoe.org/ReasonExitedDescriptor	Reclassification Team Decision

programTypeDescriptor

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

Student Program Associations (Georgia v3.6)

Object Triggering Logic

Academic Programs

Alternative Education (01 Programs)

Flags

Gifted & Talented

GNETS (02_Programs)

Graduation Programs

Programs

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Academic Programs

Alternative Education (01 Programs)

Flags

Gifted & Talented

GNETS (02_Programs)

Graduation Programs

Programs

Type/Descriptors

Programs

Related Articles