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

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

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

Alternative Education (03 Programs)

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

Click here to expand...

ActionTrigger
Post

When the student has a CTE 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 CTE program must exist in the ODS prior to sending a Student Program Association for CTE. If the CTE 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 will be performed if the natural key of the record is being changed. A Put will be performed otherwise.

  • When the following information on the student's associated GNETS record is changed:
    • CTE Record ID (New CTE record)
    • Start Date
    • End Date
  • 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 CTE 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...

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

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

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

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

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

ActionTrigger
NoneWhen a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionTrigger
Post/Delete

Natural Key changes:

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

campusObjectTypeObject Key Data Source
ProgramParticipationparticipationID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPutThe primary table used for sending data for this resource.
programparticipationPutThe primary table used for sending data for this resource.

Object Data Elements

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 LabelBusiness Requirement and Business RulesM, C, or OData 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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
MCensus > People > Demographics > Student State IDStudent.stateID
beginDateThe 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


endDateThe 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
CStudent Information > Academic Planning > Programs > Academic Program > End DateProgramParticipation.endDate

Alternative Education (01 Programs)

Click here to expand...

Data Element LabelBusiness Requirement and Business RulesM, C, or OData 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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.

MN/AN/A
beginDateReport the Start Date.M

Student Information > Program Participation > State Programs > Alternative Education > Start Date

AltProgram.startDate


endDateReport the End Date.CStudent Information > Program Participation > State Programs > Alternative Education > End DateAltProgram.endDate

Alternative Education (03 Programs)

Click here to expand...

Data Element LabelBusiness Requirement and Business RulesM, C, or OData 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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 District Number
  • programName = Career Academy (Hard-Coded).
  • programTypeDescriptor = 03A (Hard-Coded).
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.

MN/AN/A
beginDateReport the Start Date.M

Student Information > Program Participation > Career and Technical Education > Start Date

CareerTechnicalEducation.startDate


endDateReport the End Date.CStudent Information > Program Participation > Career and Technical Education > End Date
CareerTechnicalEducation.endDate

Flags

Click here to expand...

Data Label ElementBusiness Requirement and Business RulesM,C, or OData Source GUI PathDatabase Field
educationOrganizationReferenceThe 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.entityID
programReferenceThe 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


studentReferenceA reference to the related Student resource.

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

  • studentUniqueId = Student State ID
MCensus > People > Demographics > Student State IDStudent.stateID
beginDateThe 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


endDateThe 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
CStudent Information > General > Flags > End DateProgramParticipation.endDate

Gifted & Talented

Click here to expand...

Data Label ElementBusiness Requirement and Business RulesM,C, or OData Source GUI PathDatabase 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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


studentReferenceA reference to the related Student resource.

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

  • studentUniqueId = Student State ID
MCensus > People > Demographics > Student State IDStudent.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."
MStudent Information > Program Participation > Gifted > Start DateGifted.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.
CStudent Information > Program Participation > Gifted > End DateGifted.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 ElementBusiness Requirement and Business RulesM,C, or OData Source GUI PathDatabase 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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

studentReferenceA reference to the related Student resource.

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

MN/AN/A
beginDate

Report the Start Date.

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

CStudent Information > Program Participation > State Programs > GNETS Program >End Date
SupportEnvironment.endDate

Graduation Programs

Click here to expand...

Data Label ElementBusiness Requirement and Business RulesM,C, or OData Source GUI PathDatabase 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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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


studentReferenceA reference to the related Student resource.

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

  • studentUniqueId = Student State ID
MCensus > People > Demographics > Student State IDStudent.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
CStudent Information > Academic Planning > Programs > Graduation Program > End DateProgramParticipation.endDate

Programs

Click here to expand...

Data Label ElementBusiness Requirement and Business RulesM,C, or OData Source GUI PathDatabase Field
educationOrganizationReference

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

  • educationOrganizationId = Ed-Fi School ID
MSystem Administration > Resources > School > Ed-Fi School IDSchool.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
MCensus > People > Demographics > Student State IDStudent.stateID
beginDateReport 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
CStudent Information > Program Participation > Programs > End DateProgramParticipation.endDate

Type/Descriptors

Programs

Click here to expand...

programReferredByDescriptor

Code ValueDescriptionNamespaceShort Description
1Referred by system's automatic referral procedureuri://gadoe.org/ProgramReferredByDescriptorReferred by system's automatic referral procedure
2Referred by teacheruri://gadoe.org/ProgramReferredByDescriptorReferred by teacher
3Referred by parent/guardianuri://gadoe.org/ProgramReferredByDescriptorReferred by parent/guardian
4Referred by selfuri://gadoe.org/ProgramReferredByDescriptorReferred by self
5Referred by peeruri://gadoe.org/ProgramReferredByDescriptorReferred by peer
6Referred by otheruri://gadoe.org/ProgramReferredByDescriptorReferred by other
9Not referreduri://gadoe.org/ProgramReferredByDescriptorNot referred

participationStatusDescriptor

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

reasonExitedDescriptor

Code ValueDescriptionNamespaceShort Description
1ACCESS for EL proficiencyuri://gadoe.org/ReasonExitedDescriptorACCESS for EL proficiency
2Exited out of state or from a non public schooluri://gadoe.org/ReasonExitedDescriptorExited out of state or from a non public school
3Reclassification Team Decisionuri://gadoe.org/ReasonExitedDescriptorReclassification Team Decision

programTypeDescriptor

Code ValueDescriptionNamespaceShort Description
04DBefore/After Schooluri://gadoe.org/ProgramTypeDescriptorBefore/After School
04ESaturday/Weekend Programuri://gadoe.org/ProgramTypeDescriptorSaturday/Weekend Program
04FSummeruri://gadoe.org/ProgramTypeDescriptorSummer
04AExtended Dayuri://gadoe.org/ProgramTypeDescriptorExtended Day
04BExtended Weekuri://gadoe.org/ProgramTypeDescriptorExtended Week
04CExtended Yearuri://gadoe.org/ProgramTypeDescriptorExtended Year
02AGNETS - Center Baseduri://gadoe.org/ProgramTypeDescriptorGNETS - Center Based
02BGNETS - School Baseduri://gadoe.org/ProgramTypeDescriptorGNETS - School Based
03ACareer Academyuri://gadoe.org/ProgramTypeDescriptorCareer Academy
01AAlternative Education  Program for disruptive studentsuri://gadoe.org/ProgramTypeDescriptorAlternative Education  Program for disruptive students
01BChoice - Early College/Gateway to Collegeuri://gadoe.org/ProgramTypeDescriptorChoice - Early College/Gateway to College
01DChoice - Non-Traditional  High School (Performance Learning Centers)uri://gadoe.org/ProgramTypeDescriptorChoice - Non-Traditional  High School (Performance Learning Centers)
01GEMO/Vendor Operateduri://gadoe.org/ProgramTypeDescriptorEMO/Vendor Operated
01EChoice - Non-Traditional High School (Open Campus/Evening School/Other)uri://gadoe.org/ProgramTypeDescriptorChoice - Non-Traditional High School (Open Campus/Evening School/Other)
01HProgram for Non-Disruptive Studentsuri://gadoe.org/ProgramTypeDescriptorProgram for Non-Disruptive Students
05ABefore/After Schooluri://gadoe.org/ProgramTypeDescriptorBefore/After School
05BDuring Schooluri://gadoe.org/ProgramTypeDescriptorDuring School
05CSaturday Programuri://gadoe.org/ProgramTypeDescriptorSaturday Program
05DIntercessionuri://gadoe.org/ProgramTypeDescriptorIntercession
05ESummeruri://gadoe.org/ProgramTypeDescriptorSummer
English Learner (EL)English Learner (EL)uri://gadoe.org/ProgramTypeDescriptorEnglish Learner (EL)
Gifted and TalentedGifted and Talenteduri://gadoe.org/ProgramTypeDescriptorGifted and Talented
HomelessHomelessuri://gadoe.org/ProgramTypeDescriptorHomeless
Section 504 PlacementSection 504 Placementuri://gadoe.org/ProgramTypeDescriptorSection 504 Placement
Special EducationSpecial Educationuri://gadoe.org/ProgramTypeDescriptorSpecial Education
Student School Food ServiceStudent School Food Serviceuri://gadoe.org/ProgramTypeDescriptorStudent School Food Service