Wisconsin Ed-Fi Data v3.5 - Graduation Plans

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.

ActionTrigger
PostWhen 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:

  1. 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.
PutIf 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.
DeleteGraduation 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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

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.

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


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Graduation Plan Type DescriptorsGraduation
Academic Subject DescriptorsGraduation

Identity Mapping Object Key

Campus Object TypeObject Key Data Source
Programprogram ID - Cohort End Year


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPost/Put/DeleteThe 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 LabelBusiness RequirementBusiness RulesM, 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.:
  1. 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.
  2. If the 'Report by School' checkbox is unchecked, report only one record for the district.
MProgram 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.

MProgram 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).MProgram Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type
creditsThe 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.MProgram Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type
totalRequiredCreditsThe 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.MProgram Admin > Programs > Graduation Programs > Graduation Program > Credit Requirements > Credit Type

graduationPlanExtensions

(communityService)


Total hours of Community Service required for graduati.
  1. Report the Min Raw value for Test Code 'CS'.
  2. 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.
  1. If a Test Code of 'CE' exists in Test Requirements, report 'true'.
  2. Otherwise, report 'false'.
MProgram Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code

graduationPlanExtensions

(miscellaneousRequired

Credits)


Reason for Miscellaneous Required Credits is not 0.
  1. 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.
  2. 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.
  1. Report the Min Raw value for Test Code 'NHSHE'.
  2. If a test does not exist in Test Requirements with a Test Code of 'NHSHE', report 0.
MProgram Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Test Code

Program Admin > Programs > Graduation Programs > Graduation Program > Test Requirements > Min Raw



Type/Descriptor

Click here to expand...

Graduation Plan Type Descriptor

Code ValueShort DescriptionDescription
StandardStandard

uri://ed-fi.org/GraduationPlanTypeDescriptor


Academic Subject Descriptors

Code ValueDescriptionNamespace
English Language and LiteratureEnglish Language and Literatureuri://ceds.ed.gov/AcademicSubjectDescriptor
MathematicsMathematicsuri://ceds.ed.gov/AcademicSubjectDescriptor
Life and Physical SciencesLife and Physical Sciencesuri://ceds.ed.gov/AcademicSubjectDescriptor
Social Sciences and HistorySocial Sciences and Historyuri://ceds.ed.gov/AcademicSubjectDescriptor
Fine and Performing ArtsFine and Performing Artsuri://ceds.ed.gov/AcademicSubjectDescriptor
MiscellaneousMiscellaneousuri://ceds.ed.gov/AcademicSubjectDescriptor
World LanguagesWorld Languagesuri://ceds.ed.gov/AcademicSubjectDescriptor
HealthHealthuri://dpi.wi.gov/AcademicSubjectDescriptor
Physical EducationPhysical Educationuri://dpi.wi.gov/AcademicSubjectDescriptor
Computer ScienceComputer Scienceuri://dpi.wi.gov/AcademicSubjectDescriptor
Career Technical EducationCareer Technical Educationuri://dpi.wi.gov/AcademicSubjectDescriptor
Personal FinancePersonal Financeuri://dpi.wi.gov/AcademicSubjectDescriptor
Recommended ElectiveRecommended Electiveuri://dpi.wi.gov/AcademicSubjectDescriptor