Wisconsin Ed-Fi Data v3.5 - Graduation Plans

Classic View: System Administration > Ed-Fi

Search Terms: 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: When the 'Report by School' checkbox is marked on the Graduation Plans resource preferences page, report the Ed-Fi School ID based on the school populated in Program Admin > Programs > Graduation Programs > Graduation Program Detail > School for configuration years 2022 and later.
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. Data will only send for years that have valid configuration.

Logic

The record will send to any year in which the Graduation Plan overlaps.

Data will only send for years that have valid configuration.

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.: Report the Ed-Fi School ID based on the School populated in Program Admin > Programs > Graduation Programs > Graduation Program Detail: For Graduation Programs mapped to 'Standard' in the Resource Preferences, if the School IS NOT populated on the mapped Graduation Program, report as a district record. If School IS populated for Graduation Programs mapped to 'Standard' in Resource Preferences, send a record for the School selected with the School Ed-Fi ID. If the 'Report by School' checkbox is unchecked, report only one record for the district.	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.	Report the Min Raw value for Test Code 'CS'. If a test does not exist in Test Requirements with a Test Code of 'CS', report 0.	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.	If a Test Code of 'CE' exists in Test Requirements, report 'true'. Otherwise, report 'false'.	M	Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code
graduationPlanExtensions (miscellaneousRequired Credits)	Reason for Miscellaneous Required Credits is not 0.	If the total for the credit type mapped to the 'Miscellaneous' academicSubjectDescriptor <>0, report the Comments for the Credit Group with a PESC Name of 'Miscellaneous' that is associated with the reported graduation program. Otherwise, report null.	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.	Report the Min Raw value for Test Code 'NHSHE'. If a test does not exist in Test Requirements with a Test Code of 'NHSHE', report 0.	M	Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Min Raw

Type/Descriptor

Graduation Plan Type Descriptor

Code Value	Short Description	Description
Standard	Standard	uri://ed-fi.org/GraduationPlanTypeDescriptor

Academic Subject Descriptors

Code Value	Description	Namespace
English Language and Literature	English Language and Literature	uri://ceds.ed.gov/AcademicSubjectDescriptor
Mathematics	Mathematics	uri://ceds.ed.gov/AcademicSubjectDescriptor
Life and Physical Sciences	Life and Physical Sciences	uri://ceds.ed.gov/AcademicSubjectDescriptor
Social Sciences and History	Social Sciences and History	uri://ceds.ed.gov/AcademicSubjectDescriptor
Fine and Performing Arts	Fine and Performing Arts	uri://ceds.ed.gov/AcademicSubjectDescriptor
Miscellaneous	Miscellaneous	uri://ceds.ed.gov/AcademicSubjectDescriptor
World Languages	World Languages	uri://ceds.ed.gov/AcademicSubjectDescriptor
Health	Health	uri://dpi.wi.gov/AcademicSubjectDescriptor
Physical Education	Physical Education	uri://dpi.wi.gov/AcademicSubjectDescriptor
Computer Science	Computer Science	uri://dpi.wi.gov/AcademicSubjectDescriptor
Career Technical Education	Career Technical Education	uri://dpi.wi.gov/AcademicSubjectDescriptor
Personal Finance	Personal Finance	uri://dpi.wi.gov/AcademicSubjectDescriptor
Recommended Elective	Recommended Elective	uri://dpi.wi.gov/AcademicSubjectDescriptor