Tool Search: Ed-Fi
This entity is a plan outlining the required credits, credits by subject, credits by course, and other criteria required for graduation. A graduation plan may be one or more standard plans defined by an education organization and/or individual plans for some or all students.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Graduation Program is mapped to a Graduation Plan Descriptor in the Ed-Fi Graduation Plan Preferences. |
| The graduation program must be flagged as active to report. | |
| The program must have a Category of 'Graduation'. | |
| The program must have a Code of 'edfi'. | |
| For a Graduation Program, the Ed-Fi Graduation Plan and Cohort/Graduation Active Start Year and End Year fields must be populated to report. | |
| If two programs have the same Graduation Program Type/Descriptor and School Year and are marked State Reported with a Code of "edif', the last record to be updated will be the one reported. | |
| Use the Scope Year logic to determine if the record is eligible to report. | |
| Post | For the Department of Corrections only:
|
| Put | If the sum of the total number of required credits changes on a reported Graduation program. |
| If the minRawScore for CE, CS, or NHSHE change. | |
| If Active, State Reported, End Cohort Year, Start Cohort Year change in Program > Graduation Programs > Graduation Program Detail. | |
| Delete | Graduation Plans will not delete due to the association across multiple cohort years. |
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 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 | Natural Key changes: If the mapping is changed for the Graduation Plan Type Descriptors and a resync is completed the new program will post and the existing program will remain. |
| Delete | Graduation Plans will not delete due to the association across multiple cohort years |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
The record will send to any year in which the Graduation Plan overlaps.
|
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| Graduation Plan Type Descriptors | Graduation |
| Academic Subject Descriptors | Graduation |
Identity Mapping Object Key
| Campus Object Type | Object Key Data Source |
|---|---|
| Program | program ID - Cohort End Year |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| programs | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Graduation Plans resource.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| graduationPlanType Descriptor | The type of academic plan the student is following for graduation: for example, Minimum, Recommended, Distinguished, or Standard | Report 'Standard'. | M | ||
| educationOrganization Reference | The identifier assigned to an education organization. | Report the school Ed-Fi ID for DoC schools only when the 'Report By School' checkbox is checked in the Graduation Plans resource preferences and the configuration year is 2022 or later.:
| M | Program Admin > Programs > Graduation Programs > Graduation Program Detail > School | |
| graduationSchoolYear TypeReference | A reference to the related SchoolYearType resource. | Reports the End Year for each year a record is reporting based on the Cohort years the Graduation Plan covers. | M | Program Admin > Graduation Programs > Graduation Program Detail > Cohort/Graduation Active End Year | program.endCohortYear |
| creditsBySubjects | An unordered collection of graduation Plan Credits By Subjects. The total number of credits required in a subject to graduate. Only those courses identified as a high school course requirement are eligible to meet subject credit requirements. | This field is optional and does not report. | O | ||
| academicSubject Descriptor | The intended major subject area of the graduation requirement. | Report the Ed-Fi code for the reported subject (credit type). | M | Program Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type | |
| credits | The value of credits or units awarded for the completion of a course for each subje. | Report the total credits from the Total column of the reported credit type with a mapped academicSubjectDescript. | M | Program Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type | |
| totalRequiredCredits | The value of credits or units of value awarded for the completion of a course. | Sum the total number of required credits associated with the credit types being reported. | M | Program Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type | |
graduationPlanExtensions (communityService) | Total hours of Community Service required for graduati. |
| M | Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Min Raw | |
graduationPlanExtensions (civicsExam) | Is passing a civics test a requirement for high school graduation. |
| M | Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code | |
graduationPlanExtensions (miscellaneousRequired Credits) | Reason for Miscellaneous Required Credits is not 0. |
| M | Program Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type Grading & Standards > Credit Groups > Credit Group Detail > Comments | |
graduationPlanExtensions (nonHSHealthEducation Credits) | Credits of Health Education requirement fulfilled in Grade 7 and/or Grade. |
| M | Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Min Raw |
