Nebraska Ed-Fi Data v2.0

Classic ViewSystem Administration > Ed-Fi

Search Terms: Ed-Fi 

This article defines all of the elements of data sent per entity between Campus and the Ed-Fi system. 

This information is only for Nebraska customers using Ed-Fi version 2.0. To view Ed-Fi v3.1 information, please refer to the following article: Nebraska Ed-Fi data - v3.1

 Future scheduling data is suppressed until the active year is changed and a resync is completed. when syncing data from Campus to Ed-Fi.

Data in calendars marked as Exclude will not send data to Ed-Fi.

An entity is a collection of related data which is sent in a cluster of data elements from Campus to Ed-Fi. Select the following links to view what data elements are contained and sent within that entity:

Understand Object Triggering Tables

The Object Triggering Logic Tables describe what actions within Campus result in data being triggered to sync to Ed-Fi.

Example of an Object Triggering Logic Table

The following table lists the definition of each potential Action:

ActionDefinition
PostThis will insert new records and data within Ed-Fi.
PutThis action will update existing information within Ed-Fi.
 Get This action is used for items that are pre-loaded by NDE.  For example, Courses and Programs.
DeleteThis will delete records and data within Ed-Fi.

Understand Object Data Element Tables

The Object Data Element tables describe all of the elements contained within a reporting entity. Each element is given a description of what it is and any potential logic used to calculate the element, if the element is mandatory for reporting to Ed-Fi (indicated by an M), where the data is pulled from the Campus database and where the pulled information is entered within the Campus UI.

Elements marked as M are mandatory elements which must report data to Ed-Fi in order to meet reporting requirements. Elements marked as O are optional elements which are not mandatory for the Ed-Fi requirement but can be populated and report data for additional state-specific reporting purposes. Elements listed as C are conditional elements which are not required to report but will report data if the data is present within Campus.

Example of a Object Data Elements Table

Understand Type/Descriptor Tables

The Type/Descriptor section describes each element and their corresponding Campus to Ed-Fi value translation that is occurring.

If the element is reporting a Descriptor, the Ed-Fi Code Value is reported.

If the element is reporting a Type, the Ed-Fi Short Description is reported.

Example of a Type/Descriptor Table


Entities and Elements

The following lists all the currently available and syncing entities and their respective elements. 


Calendar Dates

This entity represents a day in the school calendar.

Only current calendars and previous scope years will send data.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Day and/or Day Event is created and saved, or the Instruction checkbox is marked.

  • Days can be set either manually or by using the Day Reset tool.
  • Day Events can be set either manually or by using the Multi-Day Event Wizard.
  • A record is sent for each date that meets the reporting criteria.
  • When there is more than one calendar/schedule structure, any day that has a day event reports. If the same day in multiple calendars have events that are not the same, all events report.
  • If the same day in different calendars/schedule structures have the same event, only one record reports.
  • A record is not sent if the Calendar Exclude checkbox is marked.
Put

When a Day Event or Duration is changed or saved.

Delete

When the Instruction checkbox is unmarked or a Day Event is deleted and saved.

  • When removing a day event, there must only be one day event reported to send a delete record. If there is more than one day event, the day updates instead of deletes.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports the calendar dates in the scope year that the calendar is aligned to .

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •  A resync must be done after the Active Year is changed to send data. 

Object Data Elements

Click here to expand...

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
dateMonth, day and year of the date being reported.MDay.daySystem Administration > Calendar > Calendar > Days > Date
calendarEvents

An unordered collection of calendarDateCalendarEvents. This entity represents a day in the school calendar.

Reports the data from the Day or Day Event for the date being reported. See the  Type/Descriptor section below for more information.

This element reports an array of the following data elements:

ON/AN/A
calendar Event Descriptor

Holds the types of scheduled or unscheduled events for the day (e.g., Instructional day, Teacher-only day, Holiday, Make-Up da, Weather day, Student late arrival/early dismissal day).

  • Reports 01: Instruction Day if Instruction checkbox is marked on the day. Otherwise, reports the Ed-Fi Code of the Day Event that is selected and saved.
  • If Instruction is not marked and there is not a day event, a record does not report.
MDay.duration or Calendar.studentDay

System Administration > Calendar > Calendar > Days > Day Detail > Duration

System Administration > Calendar > Calendar > Student Day

eventDuration

Reports the duration of the day event being reported.

 

This is an optional field and does not report. 

ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

ON/AN/A

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for  Calendar Event . The Ed-Fi code value needs to be mapped to the Ed-Fi code field in System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences to send. A record will not send if the Ed-Fi Code field is blank.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi DescriptionNotes
01Instructional DayInstructional Day
02Teacher Only DayTeacher Only Day
03HolidayHoliday
04Make-up DayMake-up Day
05Weather DayWeather Day
06Student late/arrival/early dismissalStudent late arrival/early dismissal
07Emergency DayEmergency Day
08StrikeStrike
09OtherOther
10PlannedPlanned
11UnplannedUnplanned
96December GradDecember GradThe student must have an Enrollment End Date on the date the code is placed on the calendar through Day Events and must have a Graduation End Status on the enrollment in order to report as a December Grad.
97Early GradEarly Grad
98Start of CalendarStart of Calendar
99End of CalendarEnd of Calendar

Calendar Date Events

This entity represents a day in the school calendar.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Day and/or Day Event is created and saved, or the Instruction checkbox is marked.

  • Days can be set either manually or by using the Day Reset tool.
  • Day Events can be set either manually or by using the Multi-Day Event Wizard.
  • A record is sent for each date that meets the reporting criteria.
  • When there is more than one calendar/schedule structure, any day that has a day event reports. If the same day in multiple calendars have events that are not the same, all events report.
  • If the same day in different calendars/schedule structures have the same event, only one record reports.
  • A record is not sent if the School Exclude or Calendar Exclude checkbox is marked.
Put

When a Day Event or Duration is changed or saved.

Delete

When the Instruction checkbox is unmarked or a Day Event is deleted and saved.

  • When removing a day event, there must only be one day event reported to send a delete record. If there is more than one day event, the day updates instead of deletes.

Days report by the school, not by the calendar. When working with multiple calendars/schedule structuresm it is possible a day could be reporting even if it is not in the calendar in which you are working. 

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports the calendar dates in the scope year that the calendar is aligned to .

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •  A resync must be done after the Active Year is changed to send data. 

Object Data Elements

Click here to expand...

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
School Reference

A reference to the related School resource.

Reports the following elements that are part of the Natural Key for the Schools resource:

  •  schoolId 
MN/AN/A
dateMonth, day and year of the date being reported.MDay.dateSystem Administration > Calendar > Calendar > Days > Date
calendar Event Descriptor

Holds the types of scheduled or unscheduled events for the day (e.g., Instructional day, Teacher-only day, Holiday, Make-Up da, Weather day, Student late arrival/early dismissal day).

  1. Reports the data from the Day or Day Event for the Date being reported.
  2. If a grade level is selected on the Day Event, report it for only that grade level's calendar.
  3. If multiple grade levels are selected, report for all grade level selected calendars.
  4. If no grade level is selected, report for all grade level calendars.
  5. When a planned or unplanned shortened day is selected, overrides any Instructional day that was previously selected.
  6. Non-Ed-Fi codes are are counted for those calendars as active days.
    Note: If a 10 or 11 instructional code is being used to indicate a planned or unplanned shortened day, that code should REPLACE the 01-Instructional code on the day.  Do not send an 01-Instructional with a 10-Planned Shortened Day as they are both Instructional codes.
O

System Administration > Calendar > Calendar > Days > Day Events


eventDuration

The amount of time for the event as recognized by the school. 1 day = 1, 1/2 day = .5, 1/3 day = .33.

Value entered in the Duration field is divided by the value in the Student Day (instructional minutes) field. Reports to the nearest .00.


O

Calendar.studentDay

Day.duration

System Administration > Calendar > Calendar > Days > Day Detail > Duration

System Administration > Calendar > Calendar > Student Day

etag

A unique system-generated value that identifies the version of the resource.

ON/AN/A

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for  Calendar Event . The Ed-Fi code value needs to be mapped to the Ed-Fi code field in System Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences to send. A record will not send if the Ed-Fi Code field is blank.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi DescriptionNotes
01Instructional DayInstructional Day

Instructional day code must be set for each day that is marked as Instructional. We will not be using the checkbox to determine what day is instructional or not.

It is recommended that this code is applied to each day using the Multi-Event tool and then modified for the days that are not instructional.

02Teacher Only DayTeacher Only Day
03HolidayHoliday
04Make-up DayMake-up Day
05Weather DayWeather Day
06Student late/arrival/early dismissalStudent late arrival/early dismissal
07Emergency DayEmergency Day
08StrikeStrike
09OtherOther
10PlannedPlanned
11UnplannedUnplanned
96December GradDecember GradThe student must have an Enrollment End Date on the date the code is placed on the calendar through Day Events and must have a Graduation End Status on the enrollment in order to report as a December Grad.
97Early GradEarly Grad
98Start of CalendarStart of Calendar
99End of CalendarEnd of Calendar

Calendars

This entity represents a school calendar.

 

Only current calendars and previous scope years will send data.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new calendar is created.

  • Do not send a record if the Calendar Exclude checkbox is marked.
  • Do not send a record if the School Exclude checkbox is marked.
Put

When the calendar End Date is changed.

PutWhen a calendar name is changed.
Delete/PostWhen the calendar Start Date is changed.

Days report by school (not by calendar). When working with multiple calendars/schedule structures, it is possible a day could be reporting even if it is not in the calendar in which you are working. 

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports the calendar dates in the scope year that the calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Class Periods resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference 

A reference to the related School resource.

Reports the following elements that are part of the Natural Key for the Schools resource:

  •  schoolID 
MSchool.numberSystem Administration > Resources > School > State School Number 
schoolYearTypeReference

A reference to the related SchoolYearType resource.

Reports the fields that are part of the Natural Key for the SchoolYear resource

MN/AN/A
beginDateMonth, day, and year of the date of the first day of the reporting calendar. Reports the first day of the reporting calendar.Mcalendar.startDateSystem Administration > Calendar > Calendar > Start Date
name

The name of the calendar. Reports from System Administration > Calendar > Calendar > Name + Grade Level. The logic of the transformer will break each grade level into its own calendar to send to Advisor.

MCalendar.nameSystem Administration > Calendar > Calendar > Name + Grade Level
typeDescriptor

Indicates the type of calendar.

 

This is an optional field and does not report.

ON/AN/A
endDateReports the last day of the calendar.ODay.dateSystem Administration > Calendar > Calendar > Days > Date
calendarDateEvents

An unordered collection of calendarCalendarDateEvents. The dates associated with the Session.

ON/ASystem Administration > Calendar > Calendar > Days > Day Detail
Calendar Date Event Descriptor

The descriptor holds the types of scheduled or unscheduled evens for the day (e.g., instructional day, teach only day, holiday, make-up day, weather day, student late arrival/early dismissal day).

  1. Reports Instructional Day if the day event code 01: Instructional Day is present.
  2. Otherwise, reports the Ed-Fi Code from the data dictionary of the day event that is selected and saved.
  3. If there is no 01: Instructional Day event code and there are no other day event codes, do not report this day.
  4. If one or more grade levels are selected on a day event, report that event for only those grade level calendars.
  5. When a grade level within one calendar is split between two or more schedule structures, split the calendars for this grade level and add the Schedule Structure name to calendar name.
  6. If no grade level is selected, report for all grade levels.
    Note: If a 10 or 11 instructional code is being used to indicate a planned or unplanned shortened day, that code should REPLACE the 01-Instructional code on the day.  Do not send an 01-Instructional with a 10-Planned Shortened Day as they are both Instructional codes.
M

Day.duration

Calendar.studentDay

System Administration > Calendar > Calendar > Days > Day Detail

System Administration > Calendar > Calendar > Student Day

gradeLevel

An unordered collection of calendarGradeLevels. Indicates the GradeLevel associated with the Calendar.

 

This is an optional field and does not report.

ON/AN/A
sessions

An unordered collection of calendarSessions. Reference to the Session associated with the Calendar

 

This is an optional field and does not report.

ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

 

This is an optional field and does not report.

ON/AN/A

Class Periods

This entity represents the designation of a regularly scheduled series of class meetings at designated times and days of the week.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Period Schedule is created and saved.

  • A separate record is sent for each Period Schedule/Period Name/Schedule Structure ID combination created.
  • Records are not sent if the Calendar Exclude checkbox is marked.
PostWhen a Period Schedule Name or Period Name is changed and saved.
Delete  When a Period Schedule Name or Period Name is changed and saved.
DeleteWhen a Period Schedule or Period is deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports the class periods in the scope year that the calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Class Periods resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference 

A reference to the related School resource.

Reports the following elements that are part of the Natural Key for the Schools resource:

  •  schoolID 
MSchool.numberSystem Administration > Resources > School > State School Number 
name

Indicates the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, etc).

The Period Schedule Name + Period Name + Schedule Structure ID reports (with a space between each value).

 

The maximum value for this field is 20 characters. The Period Schedule Name or Period Name may have to be abbreviated if the concatenation exceeds the 20 character limit. 

M

PeriodSchedule.name

Period.name

ScheduleStructure. structureID

System Administration > Calendar > Calendar > Periods, Schedule Structure
etag

A unique system-generated value that identifies the version of the resource.

 

This is an optional field and does not report.

ON/AN/A

Course Offering

This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section with Section Placement is created and saved.

  •  Do not send if course is marked as Inactive or State Exclude.
  •   Do not send records if the Calendar Exclude check box is checked.  
  •    1 record will report per Course and Term Type combination.   
Delete/PostWhen the Local Course Number is changed.
Delete/PostIf the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.
Put

When Course information is changed and saved. 

  •  Send a Put when the local course name, attendance, unit attendance or SCED Seq Number is changed. 
DeleteWhen a section is deleted.
DeleteWhen a section schedule placement is removed and saved.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports course offerings for the scope year the courses calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Course Offering resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
courseReference

Reports the following elements that are part of the Natural Key for the Course resource:

  •  educationOrganizationReference 
  •   code  
MN/AN/A
schoolReference

Reports the following elements that are part of the Natural Key for the Schools resource:

  •   schoolID  
M

District.number

School.number

System Administration > Resources > School > State School Number

System Administration > Resources > District Information > State District Number

sessionReference

Reports the following elements that are part of the Natural Key for the Sessions resource:

  1. Term Descriptor will report based on section schedule placement of the sections of the course.
  2. If Term Descriptor Override is checked and there is an existing mapping for the course, Term Descriptors will report based on the mapping.

M

term.edfiType

term.startDate

term.endDate

System Administration > Calendar > Calendar > Terms > Term Type Name

System Administration > Calendar > Calendar > Terms > Start Date, End Date

localCourseCodeThe local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.MCourse.numberScheduling > Course > Number
localCourseTitleThe descriptive name given to a course of study offered in the school, if different from the CourseTitle.OCourse.nameScheduling > Course > Name
InstructionalTimePlanned

The plannned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course.

 

This field is optional and does not report. 


ON/AN/A
curriculumUsed

An unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

 

This field is optional and does not report.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

 

This field is optional and does not report.


ON/AN/A

Course Transcripts

 This entity is the final record of a student's performance in their courses at the end of a semester or school year. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When transcript records are posted for a student for a course with a state code.

  • Transcript records are only reported when a district number is entered that is equal to the district number where the student is enrolled.
  • Transcript records are not reported if they were posted from a course in an excluded calendar. If the transcript is manually entered, it only reports if the student has an enrollment in a calendar not marked as excluded.
  • A student record is not sent for an enrollment that is marked as State Exclude or No Show.
  • Upon a resync, all years' transcript records report in the configured year(s). The School that the student is enrolled must be selected in the Resync toool.
Post/DeleteWhen any part of the Natural Key is changed.
PutWhen any field not part of the Natural Key is changed.
Delete

When a transcript record is deleted for a student.

Transcript records only delete when a student has only one Student School Association record for a specific school and year and that record is deleted. If a new Student School Association record is created, existing records do not repost; a resync must be completed to resend the data.

DeleteWhen the State Exclude or No Show checkboxes are marked on the enrollment. If the boxes are unmarked, the data does not repost; a resync must be completed to resend the data.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

All transcript records that meets the posting logic, regardless of school year, is sent.

Data will only send for the years that have valid configuration.
Users must perform a resync on the Course Transcript record at the beginning of each new scope year for data to send.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Course Transcripts resource.

Data Element DescriptionCampus Database FieldCampus GUI Location
  studentAcademic
RecordReference
 
 
 

Reports the following Natural Key elements for the Student Academic Record resource:

  •  educationOrganizationReference 
  •   schoolYearTypeReference  
  •   studentReference  
  •      termType     
MN/AN/A
 courseEducation
OrganizationId
 
 

The Education Organization that provided the reported instruction. 

 

This element is optional and does not report. 


MN/AN/A
courseCode 

The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.

Report the Course State Code.

M

TranscriptCourse.
statecode

Student Information > General > Transcripts > State Code

  courseAttemptResultType   

The result from the student's attempt at taking the course (e.g., Pass, Fail, Incomplete, Withdrawn).

When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the Result Type:

  • Report  the Ed-Fi Code from the mapping for the following options:
    1. When the sum of credits Earned is >= the sum of credits Attempted.
    2. When the sum of credits Earned is blank or = 0.
    3. When the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted.
M

Transcriptcredit.
creditsAttempted

 Transcriptcredit.
creditsEarned
 

Student Information > General > Transcripts > Earned

 Student Information> General > Transcripts > Attempted 

attemptedCreditType 

The type of credits or units of value attempted for the completion of a course. 

 

This element is optional and does not report. 


ON/AN/A
attemptedCreditConversion 

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

This element is optional and does not report. 


ON/AN/A
attemptedCredit The number of credits attempted for a course. Logic reports the sum of credits from the Attempted field on the Transcript record being reported.OTranscriptcredit.
creditsAttempted
Student Information > General > Transcripts > Attempted
earnedCreditType 

The type of credits or units of value awarded for the completion of a course.

 

This element is optional and does not report. 


ON/AN/A
earnedCreditConversion 

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

This element is optional and does not report. 


ON/AN/A
earnedCredit 

The number of credits awarded or earned for the course. Logic reports the sum of credits from the Earned field on the Transcript record being reported. 

MTranscriptcredit.
creditsEarned
Student Information > General > Transcripts > Earned
gradeLevelDescriptor 

The student's grade level at time of course. 

Logic reports the mapped Grade Level from the Grade the student was in when they completed the reporting course from the enrollment record in the same School Year as the transcript record. Only Primary enrollment records are reported.

  • If the student does not have a corresponding enrollment record, report blank
O Enrollment.gradeStudent Information > General > Enrollments > Grade
methodCreditEarnedType 

The method used for gaining credits (i.e., classroom, examination, transfer, etc).

 

This element is optional and does not report. 

ON/AN/A
finalLetterGradeEarned 

The final letter grade earned for the course. 

  • If the posted score is not an integer, that posted score reports.
  • If the posted value is an integer, the Final Number Grade Earned (below) reports.
OTranscriptCourse.scoreStudent Information > General > Transcripts > Current Score, Name
finalNumericGradeEarned 

 The final numeric grade earned for the course. 

  •  If the posted value is an integer, that posted value reports.
     
  •  If the posted value is not an integer, the Final Letter Grade Earned (above) reports.
     
OTranscriptCourse.scoreStudent Information > General > Transcripts > Current Score, Name
courseRepeatCodeType 

Indicates that an academic course has been repeated by a student and how that repeat is to be computed in the student''s academic grade average.

 

This element is optional and does not report. 


ON/AN/A
schoolId The school where the student completed instruction. The State School Number from the transcript record is reported.OTranscriptCourse.
schoolNumber
Student Information > General > Transcripts > School Number
courseTitle Reports the name of the course completed. The Course Name from the transcript record is reported.OTranscriptCourse.
courseName
Student Information > General > Transcripts > Course Name
localCourseCode Reports the local course number. The Course Number from the transcript record is reported.OTranscriptCourse.
courseNumber
Student Information > General > Transcripts > Course Number
localCourseTitle The Course Name from the transcript record is reported.OTranscriptCourse.
courseName
Student Information > General > Transcripts > Course Name
additionalCredits 

An unordered collection of courseTranscriptAdditionalCredits. This entity is the final record of a student's performance in their courses at the end of a semester or school year.

 

This element is optional and does not report. 


ON/AN/A
 externalCourses 

An unordered collection of courseTranscriptExternalCourses. This entity is the final record of a student's performance in their courses at the end of a semester or school year.

Report this value when the District Number entered on the Transcript record is not equal to the district in which the student is enrolled for the record being report.

This element reports an array of the following data elements:

ON/AN/A
nameOfInstutionThe name of the institution that provided the instruction. Reports the school name entered on the transcript record.OTranscriptCourse. schoolNameStudent Information > General > Transcripts > School Name
externalCourseCodeThe course code from the institution that provided the instruction. Reports the State Code for the record.OTranscriptCourse.stateCodeStudent Information > General > Transcripts > State Course Code
externalCourseTitleThe course title from the institution that provided the instruction. Reports the Course Name.OTranscriptCourse. courseNAmeStudent Information > General > Transcripts > Course Name

Course

 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

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
GetNo Trigger. This is a look-up as Courses are pre-loaded by NDE. NDE uses the state school number of 1 for all state courses.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Course resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 education
Organization
Reference
 

A reference to the related EducationOrganization resource.

Reports the following elements that are part of the Natural Key for the Schools resource:

  •  schoolId 
MN/AN/A
 code The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. The State Course Number is reported.MCourse.stateCodeScheduling > Courses > Course > State Code
title

The descriptive name given to a course of study offered in a school or other institution or organization. 

In departmentalized classes at the elementary, secondary, and post-secondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). 

  For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).  

MCourse.nameScheduling > Courses > Course > Name
numberOfPartsThe number of parts identified for a course. The number in the SCED Sequence Part m field is reported. If null, a value of 1 is reported.
Mcourse.sced SequenceMax Scheduling > Courses > Course > SCED Sequence (part m) 
academicSubject
Descriptor

The intended major subject area of the course. 

 

 

This field is optional and does not report.


ON/AN/A
description

A description of the content standards and goals covered in the course. Reference may be made to state or national content standards. 

 

 

This field is optional and does not report.


ON/AN/A
dateCourseAdopted

The date the district adopted the course.

 

 

This field is optional and does not report.


ON/AN/A
highSchoolCourse
Requirement

An indication that this course credit is required for a high school diploma.

 

 

This field is optional and does not report.


ON/AN/A
gpaApplicability
Type

An indicator of whether or not this course being described is included in the computation of the student’s Grade Point Average, and if so, if it is weighted differently from regular courses.

 

 

This field is optional and does not report.


ON/AN/A
definedByType

Specifies whether the course was defined by the SEA, LEA, school or national organization.

 

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
CreditType

The type of credits or units of value awarded for the completion of a course.

 

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
Credit

The minimum amount of credit available to a student who successfully completes the course.

 

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
CreditType

The type of credits or units of value awarded for the completion of a course.

 

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
Credit

The maximum amount of credit available to a student who successfully completes the course.

 

 

This field is optional and does not report.


ON/AN/A
careerPathwayType

The career cluster or pathway representing the career path of the Vocational/CTE concentrator.

 

 

This field is optional and does not report.


ON/AN/A
timeRequired
ForCompletion

The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class.

 

 

This field is optional and does not report.


ON/AN/A
competencyLevels

An unordered collection of courseCompetencyLevels. 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.

 

 

This field is optional and does not report.


ON/AN/A
gradeLevels

An unordered collection of courseGradeLevels. 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.

 

 

This field is optional and does not report.


ON/AN/A
identificationCodes

An unordered collection of courseIdentificationCodes. 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.

 

 

This field is optional and does not report.


ON/AN/A
learningObjectives

An unordered collection of courseLearningObjectives. 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.

 

 

This field is optional and does not report.


ON/AN/A
learningStandards

An unordered collection of courseLearningStandards. 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.

 

 

This field is optional and does not report.


ON/AN/A
levelCharacteristics

An unordered collection of courseLevelCharacteristics. 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.

 

 

This field is optional and does not report.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource. 

 

 

This field is optional and does not report.


ON/AN/A

Discipline Action

This event entity represents actions taken by an education organization after a disruptive event that is recorded as a discipline incident.

Object Triggering Logic

Click here to expand...
This table describes logic for triggering syncing of this object.


ActionTrigger
Post

Reports when a Behavior Resolution is added to an incident that is marked as Complete and saved

  • Only reports behavior resolutions that have state code with an Ed-Fi Code value and are aligned to a reported Student Discipline Incident Association record.
  • Data is not sent if the student's enrollment is marked as No Show or State Exclude.
  • Data is not sent if the student is in a calendar marked as Exclude.
Delete/Post

When data that is part of the Natural Key is changed.

  • If the resolution date is changed do a delete and post.
Delete/Post

When the Incident's status is changed.

  • Delete when the status is changed from Completed to In Progress.
  • Post when the status is changed from In Progress to Completed.
PutWhen a state mapped discipline is added or removed and there are other state mapped resolutions on the incident.
DeleteWhen a resolution is deleted.
DeleteWhen all resolutions mapped to a State Resolution code with an Ed-Fi Code are removed from the incident.
DeleteWhen all Behavior Events that are mapped to a State Code with an Ed-Fi value are removed from the Incident.
DeleteWhen the student's Role changes to anything other than Offender or Participant.
DeleteIf the state mapping on the event is changed to NULL or Not State Reported and no other state mapped event exists on the incident.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records are only sent to the school year to which the incident date is aligned based on the School Year Start and End Dates.

  • If School Year Start Date is null, 7/1/XXXX is used as the default start date.
  • If School Year End Date is null, 6/30/XXXX is used as the default end date.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Grades resource.

Data Element LabelData Elements

Campus Database Field

Campus GUI Location
idThe unique identifier of the resource. M N/AN/A
 assignmentschoolReference 

 A reference to the related School resource. 

 

This field is optional and does not report.

O N/AN/A 
   responsibilityschoolReference   

  A reference to the related School resource. Reports the fields that are part of the Natural Key for the Schools resource of the school where the incident occurred.  

  •   school ID  
M N/AN/A
   studentReference   

A reference to the related Student resource:

  • studentUniqueID
M N/AN/A
   identifier   Identifier assigned by the education organization to the discipline action. Reports the  Resolution ID.
 

BehaviorResolution. resolutionID

Behavior> Behavior Management> Resolution> Resolution ID
 disciplineDate The month, day, and year of the discipline action. Reports the Resolution Start Date.M

BehaviorResolution. timestamp

Behavior> Behavior Management> Resolution> Resolution Start Date
  length  

  The length of time in school days for the Discipline Action (e.g. removal, detention), if applicable.  

 

This field is optional and does not report.

O N/AN/A
  actualDisciplineActionLength  

  The length of time in school days for the Discipline Action (e.g. removal, detention), if applicable.  

 

This field is optional and does not report.

 
 

O N/AN/A
  lengthDifferenceReasonType  

Indicates the reason for the difference, if any, between the official and actual lengths of a student s disciplinary assignment.

 

This field is optional and does not report.

O N/AN/A
  relatedToZeroTolerancePolicy  

  An indication of whether or not this disciplinary action taken against a student was imposed as a consequence of state or local zero tolerance policies.  

 

This field is optional and does not report.

ON/AN/A
  disciplines  

  An unordered collection of disciplineActionDisciplines.   

   This element is an array that reports the following data:   

O N/AN/A
disciplineDescriptor

This descriptor defines the type of action or removal from the classroom used to discipline the student involved as a perpetrator in a discipline incident.

Reports the Ed-Fi Code value from the state resolution code selected.

See the Type/Descriptor options below.

O
Behavior > Behavior Management > Resolution Details > Resolution Type
  disciplineIncidents     An unordered collection of disciplineActionDisciplineIncidents.   ON/AN/A

DisciplineIncidentReference


A reference to the related Discipline Incident resource:

  • schoolReference
  • incidentIdentifier
  • incidentDate

Reports the reference from the Discipline Incident record to which the resolution is associated.

ON/AN/A
staffs  An unordered collection of disciplineActionStaffs.   ON/AN/A
Staff Reference

A reference to the related Staff resource:

  • staffUniqueID

Reports the reference for the Staff assigned to the Behavior Admin Staff Name.

If the person does not have an Ed-Fi ID, do not report.

 ON/AN/A
lengthDecimal

  The length of time in school days for the Discipline Action if applicable.  

Report the value entered in the Duration in School Days field on Resolution Editor

MBehaviorResolution. schoolDaysDuractionBehavior > Behavior Management> Resolution Details> Duration in School Days
UnilateralRemovalDescriptor

Reports for Special Education Students only when applicable.

Reports the Ed-Fi Code from the value selected in the dropdown list. See the Type/Descriptor options below.

If null or 00, does not report.

OBehaviorResolution. removalReason2Behavior > Behavior Management> Resolution Details> Special Ed Unilateral Removal
GFSAExpulsionModified ToLessThanOneYear

Reports 'True' when Duration Shortened check box is checked and Alternate Program Status is not NULL or 00 on the resolution being reported. Otherwise, reports False.

OBehaviorResolution. modificationReasonBehavior > Behavior Management> Resolution Details> Duration Shortened
GFSAAlternative Placement

Reports 'True' when Alternate Program Status on the resolution is not NULL or 00 on the resolution being reported. Else, reports 'False'

OBehaviorResoltuion. removalReasonBehavior > Behavior Management> Resolution Details> Alternate Program Status
etagA unique system-generated value that identifies the version of the resource. O N/AN/A

Type/Descriptors

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for   Discipline Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Removal from ClassroomRemoval from Classroom
02In School SuspensionIn School Suspension
03Out of School SuspensionOut of School Suspension
04ExpulsionExpulsion
05Community ServiceCommunity Service
06OtherOther
07Partial Day Out-Of-School SuspensionPartial Day Out-Of-School Suspension
08No action for incidentNo action for incident
09In-School SuspensionIn-School Suspension

This table describes the Ed-Fi Value mapped and reported for   Unilateral Removal Descriptors. 

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01

Unilateral Removal by School District

Unilateral Removal by School District

02Unilateral Removal by State Level Hearing OfficerUnilateral Removal by State Level Hearing Officer



Discipline Incident

This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.   Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Reports a behavior incident when the incident's Status is marked and saved as Complete.

  • The incident must have at least one behavior event associated that is mapped to a State Event code that has an Ed-Fi value AND has a participant with a Role of Offender or Participant.
  • The posting can occur if a new event is added after the incident is marked complete.
  • Information is not sent if the enrollment record is marked as No Show or State Exclude.
  • Information is not sent if the calendar is marked as Exclude.
Delete/Post

When data that is part of the Natural Key is changed.

  • If the Date of the incident is changed and saved.
  • If the Event Type is changed and saved.
Delete/Post

When the Incident Status is changed.

  • Delete when the status is changed from Completed to In Progress.
  • Post when the status is changed form In Progress to Completed.
DeleteWhen an incident is deleted.
DeleteWhen all Events AND Resolutions that are mapped to a state code are removed from the incident.
DeleteWhen the behavior event State Mapped code is changed to Null or Not State Reported and there are no other state mapped codes on incident for that student.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records are only sent to the school year to which the incident date is aligned based on the School Year Start and End Dates.

  • If School Year Start Date is null, 7/1/XXXX is used as the default start date.
  • If School Year End Date is null, 6/30/XXXX is used as the default end date.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Grades resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

A reference to the related Schools resource.

  • schoolID
MN/AN/A
staffReference

A reference to the related Staff resource.

 

This field is optional and does not report. 

ON/AN/A
incidentIdentifier

locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders.

Reports the Incident ID.

MBehaviorIncident. incidentIDBehavior > Behavior Management > Incident ID
incidentDate

The month day, and year on which the incident occurred.

Reports the Date of the Incident.

MBehaviorIncident. timestampBehavior > Behavior Management > Date of Incident
incidentTime

An indication of the time of day the incident took place.

 

This field is optional and does not report.

ON/AN/A
incidentLocationType

Identifies where the incident occurred and whether or not it occurred on campus, for example: On campus Administrative offices area Cafeteria area Classroom Hallway or stair.

 

This field is optional and does not report.


ON/AN/A
reporterDescription Descriptor

Information on the type of individual who reported the incident. When known and/or if useful, use a more specific option code (e.g., "Counselor" rather than "Professional Staff"); for example:Student Parent/guardian Law enforcement officer Nonschool personnel Representative of visiting school.

 

This field is optional and does not report.


ON/AN/A
reporterName

 Identifies the reporter of the incident by name.

 

This field is optional and does not report.

ON/AN/A
reportedToLawEnforcement

Indicator of whether the incident was reported to law enforcement.

 

This field is optional and does not report.


ON/AN/A
caseNumber

The case number assigned to the incident by law enforcement or other organization.

 

This field is optional and does not report.


ON/AN/A
incidentDescription

The description for an incident.

 

This field is optional and does not report.


ON/AN/A
incidentCost

The value of any quantifiable monetary loss directly resulting from the incident. Examples include the value of repairs necessitated by vandalism of a school facility, the value of personnel resources used for repairs or consumed by the incident.

 

This field is optional and does not report.


ON/AN/A
behaviors

An unordered collection of disciplineIncidentBehaviors. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

 

This field is optional and does not report.


ON/AN/A
weapons

An unordered collection of disciplineIncidentWeapons. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

 

This field is optional and does not report.


ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Grades

This educational entity represents an overall score or assessment tied to a course over a period of time (i.e., the grading period). Student grades are usually a compilation of marks and other scores.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a grade is posted to a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated.

  • Standards do not report.
  • If a course is marked as Inactive or State Excluded, data does not report.
  • If a calendar is marked as Calendar Exclude checkbox is marked, data does not report.
  • If a student's enrollment record is marked as State Exclude or No Show, data does not report.
  • Check to see if the student has a Student Section Association in the Ed-FI identity Mapping table before sending.
    • If the Student Section Association does not exist, the record will go to the Error Log with a message stating:  Student (First Name Last Name, Ed-Fi ID) does not have a Student Section Association record for the course (Course Number Course Name).  This record must exist before Grades can be sent.
PutWhen a grade is updated on a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated.
DeleteWhen a grade is deleted from a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated
DeleteWhen the Student School Association record is deleted for the school in which the grades are associated.
DeleteWhen the No Show or State Exclude checkboxes are marked.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Grades post to the scope year in which the course's calendar is aligned.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Grades resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
gradingPeriodReference

A reference to the related GradingPeriod resource.

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

  • beginCalendarDateReference
  • descriptor
MN/AN/A
studentSection AssociationReference

A reference to the related Student Section Association resource.

Reports the fields that are part of the Natural Key for the Student Section Association resource.

  • sectionReference
  • studentReference
  • beginDate

When a student has more than one eligible Student Section Association record, the grade reports on section association with the highest period schedule sequence and/or period sequence.

MN/AN/A
type

The type of grade (e.g., Exam, Final, Grading Period, Progress Report).

  1. Reports the Ed-Fi Code from mapping for the Grading Task.
  2. If the grading task is not mapped, do not report.

 See the  Type/Descriptor  section below following this table.  

M
Grading and Standards > Grading Tasks
performanceBase ConversionType

The performance base conversion assessed for the student. 

 

This field is optional and does not report.

ON/AN/A

letterGradeEarned

A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

Determination is made to see  if the posted score is an integer or not:

  • If the posted value is not an integer, the posted score reports.
  • If the posted value is an integer, the value reports in the numericGradeEarned field.
MGradingScore.scoreGrading and Standards > Score Groups and Rubrics > Score
numericGradeEarned

A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

Determination is made to see  if the posted score is an integer or not:

  • If the posted value is an integer, the posted score reports.
  • If the posted value is not an integer, the value reports in the letterGradeEarned field.
MGradingScore.scoreGrading and Standards > Score Groups and Rubrics > Score
diagnosticStatement

A statement provided by the teacher that provides information in addition to the grade or assessment score.

 

This field is optional and does not report.

O

N/AN/A
evaluator1Controlling DistrictCode

The County District Number associated with the Staff ID or 00-0000 if the Staff ID provided is from an agency that does not report staff data to NDE.

The District Number reports from the Assigned District Code for the teacher assigned to the section where the grade being reported is posted.

  • Reports in 00-0000 format.
  • Only reports staff who have a type of P or T.
  • The District Assignment selected on the Staff History must equal the District Assignment record where the Assignment Code is populated.
  • If there is more than one staff on the Staff History record that meets this criteria, the Primary Teacher reports. If there is not a primary teacher, the staff with the most recent start date based on the Staff History Start Date reports. If the Staff History dates are the same, the person with the highest personID reports. The staff can have an end date on Staff History and report if there is not a staff member that is added to the Staff History that meets this criteria.
CCustomEmplyoment AssignmentCensus > People > District Assignment > Assignment Code
evaluator1StaffID

The Staff ID (may or may not be the district employee/staff member) corresponding to the teacher of the course.

Reports the State Staff ID of the person if that person meets the criteria for reporting evaluator1ControllingDIstrictCide.

CPerson.StaffStateIDCensus > People > Demographics > Staff State ID
dualCredit

Indicates if the student earned both high school and postsecondary credit.

Does the course have the Dual Credit Eligible checkbox selected on the course from which the grade originates?

  • If No, reports 0 on the Dual Credit Code column.
  • If Yes, does the student have the Dual Credit checkbox marked on the Roster Batch Edit tab for the course from which the grade originates?
    • If Yes, does the student have a passing grade?
      • If Yes, reports 1 on the Dual Credit Code column for this report.
      • If No, reports 2 on the Dual Credit Code column for this report.
    • If the student does not have the Dual Credit checkbox selected on the Roster Batch Edit tab, reports 0.

If the student is scheduled in two sections of the same course and one has the Dual Credit checked and one does not, the most recent roster record reports.

O

Course.dualCredit

Roster.status

ScoreListItemn. passingScore

Scheduling > Course

Scheduling > Course > Section > Roster Batch Edit

Grading & Standards > Score Groups & Rubrics > Passing

This table describes data elements sent within the Grades resource.

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reports for Dual Credit Types.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
0Not ApplicableThis course is not eligible for dual credit
1YesThis course is eligible for dual credit and the student earned both high school and postsecondary credit.
2NoThis course is eligible for dual credit but the student did not earn both high school and postsecondary credit.

This table describes the Ed-Fi Value mapped and reported for   Grades Types.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1ConductConduct
2ExamExam
3FinalFinal
4Grading PeriodGrading Period
5Mid-Term GradeMid-Term Grade
6Progress ReportProgress Report
7SemesterSemester



Grading Periods

This entity represents the time span for which grades are reported (quarter, semester, final, etc.). The Start and End dates must have a calendar event in the Calendar Dates resource before Grading Periods can send. Users need to perform a day reset prior to filling out the Grading Periods tab.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new Grading Period is created and saved on the Grading Periods tab.

  • If the Calendar Exclude checkbox is marked, records are not sent.
PutWhen the Grading Period End Date is updated and saved.
Delete

When a Grading Period is deleted.

  • If there are multiple calendars/schedule structures, a delete is only sent if there are no other Grading Periods set with the same name and start date in the same school.
  • If the name or start date change, the old record is deleted and the new record is posted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports the grading periods in the scope year that the calendar is aligned to.

 Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Grading Periods resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource. MN/AN/A
schoolReferenceReports the natural key of the School resource to which the grading period is aligned.MN/AN/A
 beginCalendarDateReference 

The start date of the grading period.

Reports the start date from the Grading Period being reported. If there is more than one calendar or schedule structure, a record reports for each Grading Period and Start Date Combination.

The entered date must be an instructional day on Calendar Days tab.

M System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endCalendarDateReference

The end date of the grading period.

Reports the end date from the Grading Period being reported. If there is more than one calendar or schedule structure, the latest end date reports.

The entered date must be an instructional day on the Calendar Days tab.

M
System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
 descriptor 

The name of the grading period. 

Reports the code value from the Grading Period Name selected.

M
System Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
totalInstructionDays

The total number of instructional days in the grading period.

The number of instructional days on the Days tab that occur during the start and end date of the grading period are counted.

  • If there is more than one calendar or schedule structure, the distinct number of instructional days from all calendars/schedule structures report.
  • Instructional days will not send an update if changed after the original post unless a resync is completed.
M
System Administration > Calendar > Calendar > Days
periodSequence

The sequence of the grading period.

 

This field is optional and does not report.

ON/AN/A
_etagA unique system-generated value that identifies the version of the resource. ON/AN/A

Local Education Agency

This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.

Reports the District Information for a school.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
GetN/A
PutN/A
DeleteN/A
 

LEA is preloaded to Ed-Fi so there is no trigger logic necessary at this time.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Local Education Agency resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
educationService
CenterReference
A reference to the related EducationServiceCenter resource.ON/A
N/A
stateEducation
AgencyReference
A reference to the related StateEducationAgency resource.ON/A
N/A
 localEducation
AgencyId
 

EducationOrganization Identity column. 

Reports the State District Number (right-padded to 9 digits). 

MDistrict.number

System Administration > Resources > District Information > State School Number

stateOrganizationIdThe identifier assigned to an education agency by the State Education Agency (SEA), also known as the State LEP ID, NEDM: IdentificationCode, LEA Identifier.M N/AN/A
nameOfInstitutionThe full, legally accepted name of the institution.
M N/AN/A
shortNameOfInstitutionA short name for the institution.O N/AN/A
webSiteThe public web site address (URL) for the educational organization.O N/AN/A
operationalStatusTypeThe current operational status of the education organization (e.g., active, inactive).O N/AN/A
parentLocalEducation
AgencyId
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. O N/AN/A
categoryTypeThe category of LEA/District (e.g., Independent or Charter).M N/AN/A
addresses An unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. O N/AN/A
educationOrganization
Categories
 An unordered collection of educationOrganizationCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. ON/AN/A
identificationCodes An unordered collection of educationOrganizationIdentificationCodes. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. ON/AN/A
institutionTelephones An unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. ON/AN/A
internationalAddresses An unordered collection of educationOrganizationInternationalAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. ON/AN/A
accountabilities An unordered collection of localEducationAgencyAccountabilities. This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations. ON/AN/A
etagN/AON/AN/A

Locations

This entity represents the physical space where students gather for a particular class/section. The location may be an indoor or outdoor area designated for the purpose of meeting the educational needs of students.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
PostWhen a new Room is created and saved.
PostWhen a Room is added to a section that does not already exist in Ed-Fi.
PostWhen a Room Name is changed and saved.
PutWhen the Maximum Number Of Seats is modified.
Delete

When a Room is deleted.

DeleteWhen a Room Name is changed and saved.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Rooms are not aligned to a year so all Rooms will send to each scoped year.

Data will only send for the years that have valid configuration.
A resync must be completed on the Locations resource when a new scope year is connected in order for this data to send.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Locations resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 schoolReference 

Reports the following elements that are part of the Natural Key for the School resource:

  •   schoolID  
MSchool.numberSystem Administration > Resources > School > State School Number
  classroom
IdentificationCode
 
 
A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.M

 Room.name 

System Administration > Resources > Resources > Rooms > Name
maximumNumber
OfSeats
The maximum number of seats the class can maintain. The value in the Capacity field is reported.ORoom.capacitySystem Administration > Resources > Resources > Capacity
optimalNumber
OfSeats

The number of seats that is most favorable to the class. 

 

This field is not collected or reported.

ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Parents

This entity represents a parent or guardian of a student, such as mother, father or caretaker. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When the Guardian checkbox is marked AND one person is a student and one person is not a student. 

  • The guardian does NOT have to be a member of the same household as the student to report.
  •  Start date must be on or before today's date. 
  •   End date must be on or after today's date.  
  •    Person must have an Ed-Fi ID to send.   
  •     A record will not send if the student they are associated with has an enrollment marked as a no show, state exclude or enrollment is in a calendar marked as Exclude.
  • The active guardian record with the latest start date reports.
  • If there are no active guardian records, the inactive guardian with the latest start date reports.
Put

A record is updated when any of the following are changed and saved:

  •  When the person’s identity record is changed.
  •   When one of the person’s household locations is changed.  
  •    When one of the person’s household memberships is changed.   
  •     When one of the person’s relationships that is marked Guardian is changed.
  • When the contact information for phone or email is changed.
DeleteParent record is a shared resource among all districts in the state and cannot be deleted. When the Student Parent Association is removed, the district will no longer have authorization to see the parent record.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

A parent record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

  •  The related pair start date must be null or on/before the scope year end date to report.
  •   The related pair end date must be null or on/after the scope year end date to report.  
Data will only send for the years that have valid configuration.
A resync must be completed on the Parents resource when a new scope year is connected in order for this data to send.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  •   Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  •   Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

Object Data Elements

Click here to expand...

This table describes data elements sent within the Parents resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 parent UniqueId A parent's Ed-Fi ID is reported.MPerson.edFiIdCensus > People > Demographics > EdFi ID
personalTitle Prefix

A prefix used to denote the title, degree, position or seniority of the person. 

 

This element is not collected or reported.

CN/AN/A
firstName

The reporting parent's first name. This is reported from the person's most recent identity record.

M

Identity.firstName 

Census > People > Identities > First Name

middleName

The reporting parent's middle name. This is reported from the person's most recent identity record.

O

Identity.middleName

 Census > People > Identities > Middle Name

lastSurname

The reporting parent's last name. This is reported from the person's most recent identity record.

MIdentity.lastName

Census > People > Identities > Last Name

generation CodeSuffix

An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record.

C

Identity.suffix

 Census > People > Identities > Suffix

maidenName

The person's maiden name, if applicable.

 

This element is not collected or reported.

ON/AN/A
sexType

The person's gender. This is reported from the person's most recent identity record.


 

This element is not collected or reported.


ON/A

 N/A

loginId

The login ID for the user; used for security access control interface.

 

This element is not collected or reported.


MN/AN/A
addresses

Reports the person's address(es). Reports the most current Primary address that is marked as "Mailing".

  • If more than one primary address is marked as mailing, the address with the most recent Household Membership Start Date reports.
  • Otherwise, the address with the most recent Address Start Date reports.
  • This does not report if the Address Location Detail or the Household Membership is marked as Private.

Scope Year logic is used to determine the eligibility of records.

  See the  Type/Descriptor  section below following this table.   

This element reports an array of the following data elements:

O

HouseholdLocation.
mailing

HouseholdMember.
startDate

Householdlocation.
StartDate

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressType

Reports the Address Type value mapped in the section and table below.

All addresses report as Home.

MN/AN/A
streetNumberName

The street number and street name or post office box number of an address.

Reports the Address PO Box + Number + Street + Tag + Prefix + Dir

M

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Household Addresses > Address Info
apartmentRoom
SuiteNumber
The apartment, room, or suite number of an address. This element reports the value entered in the Apt field.OAddress.aptHousehold Addresses > Address Info > Apt
buildingSiteNumber

The number of the building on the site, if more than one building shares the same address.

 

This is optional and does not report. 

ON/AN/A
cityThe name of the city in which an address is located. MAddress.cityHousehold Addresses > Address Info > City
stateAbbreviation
Type
The abbreviation for the state (within the United States) or outlying area in which an address is located.MAddress.stateHousehold Addresses > Address Info > State
postalCodeThe five or nine digit zip code portion of an address.MAddress.zipHousehold Addresses > Address Info > Zip Code
nameOfCounty

The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.

Reports the County for the addressing being reported


Oaddress.countyHouseholds> Address Info> County
countyFIPSCode

5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county.

 

This is optional and does not report. 

ON/AN/A
latitude

The geographic latitude of the physical address.

 

This is optional and does not report. 

ON/AN/A
longitude

The geographic longitude of the physical address.

 

This is optional and does not report. 

ON/AN/A
beginDate

The first date the address is valid. For physical addresses, the date the person moved to that address.

 

This is optional and does not report. 

ON/AN/A
endDate

The last date the address is valid. For physical addresses, this would be the date the person moved from that address.

 

 

This is optional and does not report. 

ON/AN/A
electronic Mails

The email address of the reporting parent. If the email address is marked as Private, data is not sent.

This element reports an array of the following data elements:

OContact.emailCensus > People > Demographics > Email
electronicMailType

This element will report the Ed-Fi Electronic Mail Type value described in the table and section below.

The Secondary Email Address reports as Work.

MN/AN/A
electronicMailAddressThe numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.
MContact.emailCensus > People > Demographics > Email
primaryEmailAddressIndicatorAn indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.ON/AN/A
identification
Documents

Reports an unordered collection of the parent's identification documents.

 

This element is not collected or reported..

ON/AN/A
international
Addresses

Reports an unordered collection of the parent's international addresses.

 

This element is not collected or reported.


ON/AN/A
otherNames

Reports an unordered collection of the parent's other known names (aliases).

 

This field is optional and does not report.

ON/AN/A
telephones

Reports an unordered collection of the parent's telephone numbers (Other Phone, Work Phone, Cell Phone, Pager). If the telephone numbers are marked as Private, data is not sent. 

If blank, does not report.

Scope Year logic is used to determine the eligibility of records.

O

Contact.homephone

Contact. workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
telephoneNumberTypeReports the Ed-Fi value described in the Telephone Number Type section and table below.MN/AN/A
orderOfPriority

The order of priority assigned to telephone numbers to define which number to attempt first, second, etc.  

This field is optional and does not report.

ON/AN/A
textMessage
CapabilityIndicator

An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.

 

This field is optional and does not report.

ON/AN/A
telephoneNumber

The 10-digit telephone number, including the area code, for the person.

M

Contact.homephone

Contact. workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
etag

A unique system-generated value that identifies the version of the resource.

 

This field is optional and does not report.


ON/AN/A

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

 This table describes the Ed-Fi Value mapped and reported for    Telephone Number   : 

Code in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Other Phone 1HomeHomeHome

 

This is not collected or reported.

FaxFaxFax
Cell Phone 3MobileMobileMobile

 4 

 

This is not collected or reported.

UnlistedUnlistedUnlisted
Work Phone5WorkWorkWork
Pager  6OtherOtherOther

 7 

 

This is not collected or reported.

Emergency 1Emergency 1Emergency 1

 8 

 

This is not collected or reported.

Emergency 2Emergency 2Emergency 2

This table describes the Ed-Fi Value mapped and reported for Address Type:

Code in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short Description Ed-Fi Description
All address report as "Home"1HomeHomeHome
2PhysicalPhysicalPhysical
3MailingMailingMailing
4OtherOtherOther
5WorkWorkWork
6BillingBillingBilling
7TemporaryTemporaryTemporary
8Father AddressFather AddressFather Address
9Guardian AddressGuardian AddressGuardian Address
10Mother AddressMother AddressMother Address
11ShippingShippingShipping
12SheltersShelters, Transitional housing, Awaiting Foster CareShelters, Transitional housing, Awaiting Foster Care
13DoubledDoubled - up (i.e., living with another family)Doubled - up (i.e., living with another family)
14UnshelteredUnsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)Unsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)
15HotelMotelHotels/MotelsHotels/Motels

This table describes the Ed-Fi Value mapped and reported for Electronic Mail:

Code in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
All address report as "Home/Personal"   1Home/PersonalHomeHome
2OrganizationOrganizationOrganization
3OtherOtherOther
4WorkWorkWork

Post Graduate Activities

NDE specific entity for capturing the CE post graduation activity details. The Post School Survey template is provided for all 12th grade Career Education Concentrators identified as a [School-Year] completer with diploma and is submitted ONE-YEAR AFTER high school graduation.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When Diploma Date, Post Grad Plans and Post Grad Activity Determination are all populated and saved on a student's Graduation tab.

  • Student must have an enrollment that is associated with a Student School Association record in order for the record to send for the year the Diploma Date is aligned to.
  • Graduation records are only resynced if the student has an enrollment in one of the schools selected in the school year corresponding to the student's diploma date.
Delete/Post

When any value is changed and saved in the Diploma Date, Post Grad Plans or Post Grad Activity Determination fields.

DeleteWhen any of the Diploma Date, Post Grad Plans or Post Grad Activity Determination fields are changed to NULL and saved.
DeleteWhen all enrollments that generated a Student School Association record have been deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Only reports for the school year that the student's Diploma Date is aligned with.

  • Report when the Diploma Date overlaps with the School year Start and End Dates.
  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Calendar Dates resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
localEducationAgencyReference

The education organization where the student graduated.

Reports the District Number.

Mdistrict.numberSystem Administration> Resources> District Information
schoolYearTypeReference 

A reference to the related SchoolYearType resource.

Reports the end year of the school year that the Diploma Date is aligned to

MN/AN/A
studentReference

A reference to the related Student resource.

Reports the Natural Key for the Student resource.

MN/AN/A
activityDescriptor 

This descriptor contains code to describe the student's activity after completion.

  1. Reports the Ed-Fi Code from the value selected in the droplist.
  2. If NULL, the record does not report.
Mgraduation.postGradPlansStudent Information > General > Graduation> Post Grad Plans
determinationDescriptor 
 

This descriptor contains a code that indicates the method of determining the Post Graduate Activity value.

  1. Reports the Ed-Fi Code from the value selected in the droplist.
  2. If NULL, the record does not report.
MGraduation.postGradDeterminationsStudent Information > General > Graduation> Post Grad Activity Determination

Type/Descriptor

Click here to expand...

Post Graduate Activity Descriptor

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
0UnavailableUnavailable
12 Year College2 Year College
24 Year College4 Year College
3EmploymentEmployment
4MilitaryMilitary
5Not TrackedNot Tracked

Post Graduate Activity Determination Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
0UnavailableUnavailable
1Administrative Records matchAdministrative Records match
2Follow-up SurveyFollow-up Survey
3ObservationObservation
4Exit SurveyExit Survey

Schools

This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
GetNo Trigger, this is a look-up as schools are pre-loaded by DOE. When a new school is created and saved, it matches on the State School Number to determine reporting school.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Schools resource.

 

At this time, only  schoolId  is reported. All other elements are not reported.

Data ElementDescriptionCampus Database FieldCampus GUI Location
id  The unique identifier of the resource .MN/AN/A
localEducation
AgencyReference
 A reference to the related LocalEducationAgency resource ON/AN/A
 schoolId Reports the School ID as a concatenation of the State District Number + State School.M

District.number

School.number

System Administration > Resources > School > State School Number

System Administration > Resources > District Information > State District Number

stateOrganizationId The identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifier  MN/AN/A
nameOfInstitution The full, legally accepted name of the institution. NEDM: Name of Institution  MN/AN/A
shortNameOfInstitution A short name for the institution ON/AN/A
webSite The public web site address (URL) for the educational organization ON/AN/A
operationalStatus
Type
 The current operational status of the education organization (e.g., active, inactive)ON/AN/A
type The instructional categorization of the school (e.g., Regular, Alternative, etc.)  ON/AN/A
charterStatusType A school or agency providing free public elementary or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority and designated by such authority to be a charter school ON/AN/A
titleIPartASchool
DesignationType
 Denotes the Title I Part A designation for the school ON/AN/A
magnetSpecialProgram
EmphasisSchoolType
 A school that has been designed: 1) to attract students of different racial/ethnic backgrounds for the purpose of reducing, preventing, or eliminating racial isolation; and/or 2)to provide an academic or social focus on a particular theme (e.g., science/math, performing arts, gifted/talented, or foreign language).  ON/AN/A
administrativeFunding
ControlDescriptor
This descriptor holds the type of education institution as classified by its funding source (e.g., public or private)ON/AN/A
internetAccessTypeIndicates the type of Internet access that is availableON/AN/A
addresses An unordered collection of educationOrganizationAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
educationOrganization
Categories
 An unordered collection of educationOrganizationCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
identificationCodes An unordered collection of educationOrganizationIdentificationCodes. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
institutionTelephones An unordered collection of educationOrganizationInstitutionTelephones. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
internationalAddresses An unordered collection of educationOrganizationInternationalAddresses. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
schoolCategories An unordered collection of schoolCategories. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups ON/AN/A
gradeLevels An unordered collection of schoolGradeLevels. This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. ON/AN/A
etagN/AON/AN/A

Section

This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium.

This entity reports per section per term type combination.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section is created and saved.

  • Room and Section Placement are required in order for the section to send.
  • One record reports for each section, term type, class period combination.
  • If the Calendar Exclude checkbox is marked, data is not sent.
  • If the Course is marked as State Exclude, data is not sent.
PostWhen a section schedule placement is changed and saved.
PostWhen the Local Course Number or Term type Override is changed.
Put

When any fields listed below are changed:

  •  When the local course name, attendance, unit attendance or SCED Seq Number is changed and saved on the Course editor.
  •   When the Room or Instructional Setting is changed and saved on a section.  
  •    When the Credit field is changed and saved on a Grading Task assigned to the course.   
DeleteWhen a section is deleted.
DeleteWhen Section Placement is changed or removed and saved on a section.
DeleteWhen the Local Course Number or Term type Override is changed.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Reports Sections in the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Section resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
 id The unique identifier of the resource.MN/AN/A
  classPeriod Reference  

Reports the following elements that are part of the Natural Key for the Class Periods:

  •     id    
  •      name     

M

N/AN/A
 courseOffering Reference 

Reports the following elements that are part of the Natural Key for the Course Offering:

  •  schoolReference 
  •   sessionReference  
  •     localCourseCode    
MN/AN/A
 locationReference 

Reports the following elements that are part of the Natural Key for the Locations resource:

  •  schoolReference 
  •    classroomIdentificationCode   
MN/AN/A
 schoolReference 

Reports the following elements that are part of the Natural Key for the Schools resource:

  •   EntityID  
MN/AN/A
 sessionReference 

Reports the following elements that are part of the Natural Key for the Sessions resource:

  •  id 
  •   schoolReference     
     
     
  •    schoolYearTypeReference   
MN/AN/A
uniqueSectionCodeA unique identifier for the section, that is defined for a campus by the classroom, the subjects taught, and the instructors that are assigned. This element reports the section ID of the section being reported.MN/AN/A
sequenceOfCourse

When a section is part of a sequence of parts for a course, the number of the sequence is reported. If the course has only onle part, the value of this section attribute should be 1. 

 The value in the SCED Sequence Part n field is reported. If null, a value of 1 is reported. 

MN/AScheduling > Courses > Course > SCED Sequence (part n)
educational EnvironmentType

The setting in which a child receives education and related services. For example, Center-based instruction Home-based instruction, Hospital class, Mainstream Residential care, treatment facility. 

Logic reports the Ed-Fi Code value from the Instructional Setting selected on the course section being reported.

OSection.
instructionalSetting
Scheduling > Course > Section > Instructional Setting
mediumO fInstructionType

The media through which teachers provide instruction to students and students and teachers communicate about instructional matters.

This element is optional and does not report.

ON/AN/A
populationServed Type

The population for which the course was designed.

This element is optional and does not report.

ON/AN/A
availableCredit Type

The type of credits or units of value awarded for the completion of a course.

This element is optional and does not report.

ON/AN/A
availableCredit
Conversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This element is optional and does not report.

ON/AN/A
instructionLanguage
Descriptor
This element is optional and does not report.ON/AN/A
availableCredit

Credits or units of value awarded for the completion of a course. Logic calculates this as follows:

  • Sum the total number of credits from the Grading Tasks on the course
  • Divide by the number of terms the course section occurs
OGradingTaskCredit.
Credit
Scheduling > Courses > Course > Grading Tasks > Credit
characteristics

This descriptor defines characteristics of a section, such as whether attendance is taken and the section is graded. This reports when the following are added:

  • Attendance and/or Positive Attendance check box is checked on a course.
  • A grading task is added and saved to a course.
OGradingTaskCredit.
Credit

Scheduling > Course > Attendance/Positive Attendance

Scheduling > Course > Grading Tasks

sectionCharacteristic Descriptor

Defines the characteristics of a section, such as whether attendance is taken and the section is graded.

See the Type/Description Layout for more information.

ON/AN/A
programs

An unordered collection of sectionPrograms. This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. 

This element is optional and does not report.

ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

This element is optional and does not report.

ON/AN/A
deliveriesField contains code to describe the method of delivery of a section

Reports the Ed-Fi code from the value selected in the dropdown list. If the field is blank or the Ed-Fi Code is null, this does not report.

  • 0 - Classroom - Not Career Academy (NONE PUBLISHED)
  • 1 - Synchronous - Not Career Academy (1 - Synchronous District Learning)
  • 2 - Asynchronous - Not Career Academy (2 - Asynchronous Distance Learning)
  • 3 - Career Academy Synchronous (3 - Career Academy AND 1 Synchronous Distance Learning)
  • 4 - Career Academy Asynchronous (3 - Career Academy AND 2 Synchronous Distance Learning)
  • 5 - Career Academy in Classroom (3 - Career Academy)
  • 6 - Iowa School for the Deaf Courses (4 Iowa School for the Deaf)
OCourse. deliveryModelScheduling > Courses > Course Delivery Model

Type/Descriptor Layout

  Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Section Delivery Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1Synchronous Distance LearningSynchronous Distance Learning
2Asynchronous Distance LearningAsynchronous Distance Learner
3Career AcademyCareer Academiy
4Iowa School for the DeafIowa School for the Deaf

This table describes the Ed-Fi Value mapped and reported for SectionCharacteristicDescripto  rID.

SectionCharacteristic DescriptorIDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Attendance is marked on the course01Attendance TrackedAttendance Tracked
Grading Task is assigned to the course02Graded CreditGraded Credit Available

This table describes the Ed-Fi Value mapped and reported for Section Delivery Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1Synchronous Distance LearningSynchronous Distance Learning
2Asynchronous Distance LearningAsynchronous Distance Learner
3Career AcademyCareer Academiy
4Iowa School for the DeafIowa School for the Deaf

This table describes the Ed-Fi Value mapped and reported for SectionCharacteristicDescripto  rID.

SectionCharacteristic DescriptorIDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Attendance is marked on the course01Attendance TrackedAttendance Tracked
Grading Task is assigned to the course02Graded CreditGraded Credit Available

Sessions

This entity represents the prescribed span of time when an education institution is open, instruction is provided and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations.

In order to report properly, the Ed-Fi Term Type field needs to be populated on the Calendar Term Detail editor. This ties the Course Section to the Term. If the Course Section needs to use a different term type, the Ed-Fi Term Type Override field needs to be populated on the Course Section Editor. See the Additional Logic and Considerations for more information.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new Term is created and saved that is mapped to a Term Type and a resync of Sessions is completed:

  • If the same Term Type is selected on multiple Terms, Terms are grouped together so only one record reports per Term Type. 
  • If there are multiple Calendars or Schedule Structures in a school with the same Term Types, only one record reports to Ed-Fi. The earliest Term Start Date and latest Term End Date reports.
  • Records are not sent when the Calendar Exclude checkbox is marked.
Post

When a Term Descriptor Override is selected on a Course or Section and saved and the course is mapped to a Term Descriptor Override and a resync of Sessions is completed.

  • The Session reports the start and end dates based on the mapping of the course section.
  • If the same Term Type is selected in the Terms tab and the Term Type Override, a record is not sent from the override field.
  •  Records are not sent when the Calendar Exclude checkbox is marked.

Start and End dates are not part of the natural Key. This means only one record per Term Type can be sent to Ed-Fi. Logic has been implemented to determine the priority of what start and end dates to use for a Term Type.

Put

When the Grading Period or term name, start or end dates are changed and saved.

  • The term dates can change either on the Terms tab or by changing Section Schedule Placement on a section.
Delete

 Terms are never deleted; they are only used as a reference. They remain if a Term Schedule is deleted or Term Types are changed.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Reports Sessions for the scope year the calendar is aligned to.
Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Sessions resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 schoolReference    

Reports the following elements that are part of the Natural Key for the School resource:

  •   schoolID  
MSchool.numberSystem Administration > Resources > School > School Number
 schoolYearTypeReference     A reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported. MN/AN/A
 termType    

The term for the session during the school year. This element reports the corresponding Term Type based on the sum of total terms in the term schedule and the sequence of the terms being reported.

MTerm.edfiTypeSystem Administration > Calendar > Calendar > Terms > Term Type
nameThe identifier for the calendar for the academic session. This element reports the Schedule Structure + Term Name with a - separating the names (e.g., Main - Term 1). MTerm.edfiTypeSystem Administration > Calendar > Calendar > Terms > Term Type Name
beginDate

The term start date. This element reports the start date of the term being reported.

 When reporting from a Term Schedule, the start date of the term being reported reports. If more than one term has the same Term Type selected, the earliest start date reports.

When reporting from a Term Type Override on a section, the start date from the mapping the course is aligned to.

MTerm.startDateSystem Administration > Calendar > Calendar > Terms > Start Date
endDate

The term end date. This element  eports the end date of the term being reported. 

When reporting from a Term Schedule, the end date of the term being reported reports. If more than one term has the same Term Type selected, the latest end date is used.

When reporting from a Term Type Override on a section, the end date from the from the mapping the course is aligned to.

Term.endDateSystem Administration > Calendar > Calendar > Terms > End Date
totalInstructionalDays

This element reports the total number of instructional days from the Days tab from the calendar and schedule structure in which the term is associated. 

If more than one term schedule has the same Term Type, the distinct number of instructional days from all terms for that Term Type is counted.

 

A day reset must be completed before the days will calculate.  Use the resync function of Ed-Fi Tools to have instructional days calculated and sent.

MN/AN/A
academicWeeks 

An unordered collection of sessionAcademicWeeks.

This field is optional and does not report.

ON/AN/A
gradingPeriods 

An unordered collection of sessionGradingPeriods. This element is an array that reports the following data:

ON/AN/A
gradingPeriodReference

Reference to the related    Grading Periods resource.

  •  beginCalendarDateReference
  • gradingPeriodDescriptor

A record reports for each Grading Period reported that occurs in the session being reported.

  • If the Session is being reported from the Term Type Override field on a course or section, look at the Grading Task(s) that are assigned to the course that have a Grade Type assigned and report the grading periods associated with the grading task(s) assigned to it.
ON/AN/A
etag
A unique system-generated value that identifies the version of the resource.ON/AN/A

Staff Education Organization Assignment Association

This association indicates the education organization to which a staff member provides services; also known as school of service.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
 Post 

When a person has a District Employment record with the District Staff check box checked and a District Assignment Code populated.

OR

When a person has a District Assignment record and the District Staff check box is not checked.

Do NOT report a record if any one of the following scenarios are true:  

  1. There is not an Ed-FI ID for the staff person.
  2. The staff records are not active based on the Scope Year logic listed below.
  3. If the record is being triggered from a District Assignment record and it is marked as Exclude.

  4. If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  5. If data is sent prior to the Exclude checkboxes being checked, the data will remain and the user will need to use the Delete Tool to remove data.
  6. If Ed-Fi Exclude is marked on the District Employment record.
  7. If the Assignment code is not mapped in Resource Preferences.

If school staff member has more than 1 qualifying District Assignment record, a record will generate for each eligible School/Start date.

PutOnly deletes and posts occur for this resource.
Delete/PostWhen the person’s employment assignment record is changed.
Delete/PostWhen the person’s employment record is changed.
Delete/PostIf there are two District Assignment records that create the same natural key and one is deleted, the remaining record is posted.
Delete/PostWhen the record is posted from the District Assignment record and the Assignment Code, Start Date or End Date is changed.
DeleteWhen a District Employment record is deleted.
DeleteWhen a District Assignment record is deleted.
DeleteWhen a District Employment record has the District Staff checkbox unmarked AND no district assignment exists for the staff.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
A record reports when a person has a District Assignment or District Employment that is aligned to a scope year.

Reports when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.

  •  If School Year Start Date is NULL, 7/1/XXXX is the default start date used.   
     
  •   If School Year End Date is NULL, 6/30/XXXX is the default end date used.  

Data only sends for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic applies to determine to which scope year(s) to report the data:

  •  Current Year: Records are compared to the current date to determine if the record is eligible to report.
  •   Previous Years: The record's date must be on or before the school's year end date defined in the School Years editor. If blank, the default date of 6/30/XXXX is used.  
  •    Future Years: The record's date must be on or after the school's year start date defined in the School Years editor. If blank, the default date of 7/01/XXXX is used.   

 Object Data Elements

Click here to expand...

This table describes data elements sent within the Staff Education Organization Agreement Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
StaffEducationOrganization
EmploymentAssociation Reference

Reports the data that is part of the Natural Key for the Staff Education Organization Employment Association resource:

  •   educationOrganizationReference  
  •    staffReference   
  •     employmentStatusDescriptor    
  •        hireDate       


 

This is optional and does not report.

ON/AN/A
 educationOrganization Reference 

A reference to the related EducationOrganization resource. 

  • When the District Employment > District Staff checkbox is marked, report the District Number + 000.

  • If District Staff is not checked, report from District Assignment and report District Number + state school number of the school of assignment.
M

Employment.edFiOrgTitle 

 OR

District.number + School.number

Census > People > District Employment > Ed-Fi Org Title > Standard Code

 Census > People > District Assignment (District Number + School of Assignment State School Number)

 staffReference 

Reports the data that is part of the Natural Key for the Staff resource:

  •   staffUniqueId  
MN/AN/A
   staffClassification Descriptor   

  The titles of employment, official status, or rank of education staff. This element    reports the value in the Ed-Fi code field from the value selected in the Assignment Code droplist on the District Assignment and the Ed-Fi Org Title field.   If the field is blank or does not match a valid code, a value of '02' reports for Teacher.

Report the Ed-Fi code mapped to the value selected:

  1. If reporting from District Employment, report the Ed-Fi Code mapped to the District Assignment Code selected.
  2. If reporting from District Assignment, report the Ed-Fi Code mapped to the Assignment Code selected.
  3. Look to see if a default value is saved in the Attribute Dictionary when reporting.
  4.  If a code is not mapped or Assignment Code is not selected, report '02' for Teacher.

The Assignment Code Data Dictionary is an unlocked list that is managed by the districts. To create a new or modify an existing Assignment Code:

  1. Create Type code in the Attribute Dictionary> Employment Assignment > Assignment Code dictionary if it does not already exist.
  2. The Ed-Fi Code Value MUST be entered in the Ed-Fi value field for it to send to Ed-Fi

 

M

EmploymentAssignment.
assignmentCode

Census> People> District Employment> District Assignment Code

Census> People> District Assignment> Assignment Code

 beginDate 

The month, day and year of the start or effective date of a staff member's employment, contract or relationship with the LEA.  

  1. When reporting from the District Employment record, report the District Employment Start Date.
  2. When reporting from the District Assignment record, report the District Assignment Start Date.

Employment.startDate

EmploymentAssignment.
startDate

Census > People > District Employment > Start Date

Census > People > District Assignment > Start Date

positionTitle

The descriptive name of an individual's position.This field reports the value in the Ed-Fi code field from the value selected in the Title dropdown list on the District Assignment editor. 

 

User must have any combination of RWAD access to view Ed-Fi Org Title Field.


  1. When reporting from the District Employment record, report the name from the District Assignment Code selected
  2. When reporting from the District Assignment record, report the name from the Assignment Code selected.
CEmployment.edFiOrgTitle

Census> People> District Employment> District Assignment Code

Census> People> District Assignment> Assignment Code

endDate

 The month, day and year of the end or termination date of a staff member's employment, contract or relationship with the LEA. This element r eports the End Date from the District Assignment being reported.

  1. When reporting from the District Employment record, report the District Employment End Date.
  2. When reporting from the District Assignment record, report the District Assignment End Date.
  3. When null, this does not report. 


Employment.endDate

OR

EmploymentAssignment.
endDate

Census > People > District Employment > End Date

Census > People > District Assignment > End Date

etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for  Ed-Fi Org Title: 

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi DescriptionStandard Code
01CounselorCounselor
02TeacherTeacher
03OtherOtherNA
04Assistant SuperintendentAssistant Superintendent
05SuperintendentSuperintendent000
06LEA AdministratorLEA Administrator
07School AdministratorSchool Administrator000
08School SpecialistSchool Specialist
09LEA SpecialistLEA Specialist
10Substitute TeacherSubstitute Teacher
11School LeaderSchool Leader
12Instructional CoordinatorInstructional Coordinator
13Librarians/Media SpecialistsLibrarians/Media Specialists
14Support Services StaffSupport Services Staff
15Operational SupportOperational Support
16Instructional AideInstructional Aide
17State AdministratorState Administrator
18PrincipalPrincipal
19Assistant PrincipalAssistant Principal
20LEA System AdministratorLEA System Administrator

District Staff

  Click here to expand...

The District Employment editor includes a District Staff checkbox. Users must have tool rights to the District Staff subright (Census > People > District Employment > District Staff) to see and edit the field. TThe District Assignment Code field displays when the District Staff checkbox has been marked and gives users access to the Ed-Fi Dashboards based on the Title that is selected for the staff. This field populates the Education Organization Reference, Staff Classification Descriptor and Position Title fields in the Staff Education Organization Assignment resource. If there are staff that should not have district level access in the dashboards, the staff member also needs at least one District Assignment record. The staff receives dashboard access to only the schools for which they have an active District Assignment record.

The District Employment editor includes a District Staff checkbox. Users must have tool rights to the District Staff subright (Census > People > District Employment > District Staff) to see and edit the field. TThe District Assignment Code field displays when the District Staff checkbox has been marked and gives users access to the Ed-Fi Dashboards based on the Title that is selected for the staff. This field populates the Education Organization Reference, Staff Classification Descriptor and Position Title fields in the Staff Education Organization Assignment resource. If there are staff that should not have district level access in the dashboards, the staff member also needs at least one District Assignment record. The staff receives dashboard access to only the schools for which they have an active District Assignment record.


Staff School Association

This association indicates the school(s) to which a teacher provides instructional services.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a District Assignment record created and saved for a staff member.

Do NOT report a record if any one of the following scenarios are true:  

  • There is not an Ed-FI ID for the staff person.
  • The District Assignment record is not active based on the Scope Year logic listed below.
  • If the record is being triggered from a District Assignment record and it is marked as Exclude.

  • If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  • If data is sent prior to the Exclude checkboxes being checked, the data will remain and the user will need to use the Delete Tool to remove data.
Delete/PostWhen the person’s employment assignment record is changed.
Delete/Post  If there are two District Assignment records that create the same natural Key and one is deleted, the remaining record is posted. 
DeleteWhen a District Assignment record is deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
A record will report when a person has a District Assignment record that is aligned to a scoped year.

Report when a staff has an active District Assignment record that overlaps with the School year Start and End Dates.

  •  If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  •   If School Year End Date is NULL, 6/30/xxxx will be the default end date used.  
Data will only send for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Staff School Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
schoolReference

Reports the data this part of the Natural Key for the Schools resource:

  • schoolID
MN/AN/A
  staffReference  

Reports the data that is part of the Natural Key for the Staff resource:

  •   staffUniqueId  
MN/AN/A
programAssignment Descriptor
The name of the program for which the individual is assigned; for example: Regular education Title I-Academic Title I-Non-Academic Special Education Bilingual/English as a Second Language.   

Reports a default value of 03.
M

N/A

N/A
schoolYearIdentifier for a school year.
 
ON/AN/A 
academicSubjects

An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.

ON/AN/A 
gradeLevels

 An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services. 


ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Staff Section Association  

This association indicates the course sections to which a student is assigned. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a staff with an Ed-Fi ID is added to a course section on Staff History.

  •  Must have a Staff Type of P: Primary Teacher or T: Teacher in the Section Staff History Table. 
  •  Records are not sent if the Calendar Exclude checkbox is marked.
     
  •  Records are not sent if the Course is marked as Inactive or is Excluded.
     
Put

When a Role mapped to an Ed-Fi code is added or changed to a teacher on the Staff History Record. 

When Start or End Dates are modified on the Staff History or District Assignment records.

DeleteWhen a staff member is deleted from Staff History.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports for Sections in the scope year the to which the course's calendar is aligned.

Future Years data will be suppressed until the Active Year is changed:

  • This allows the Schedule Wizard to be used and reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.
Data will only send for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Staff Section Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 sectionReference 

Reports the data that is part of the Natural Key for the Section resource:

  •  id 
  •    classPeriodReference   
  •     courseOfferingReference    
  •      locationReference     
  •       schoolReference      
  •        sessionReference       
MN/AN/A
  staffReference  

Reports the data that is part of the Natural Key for the Staff resource:

  •   staffUniqueId  
MN/AN/A
 classroomPosition
Descriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

  • Reports the  the Ed-Fi Codefrom the Role that is selected. See Type Descriptor for code values.
  • If a Primary Teacher is assigned to the section, reports a value of 01.
  • If other teachers are assigned to the section, reports a value of 03.
  • If a Primary Teacher is not assigned:
    • A value of 01 Teacher of Record reports for the teacher with the most recent start date. If the start dates are the same for the teachers, the staff with the lowest person ID reports.
    • All other teachers report a value of 03 Support Teacher.
    • If there was a Primary Teacher with an end date prior to the Term End Date, the other teachers remain as 03 unless their Role is changed.
  • If Role is XX: Not State Reported, a record does not report. Errors are not seen if a person is not state reported.
M

SectionStaffHistory.role

Course > Section > Staff History > Role
beginDate

The month, day and year of a teacher's assignment to the section. This element reports the Staff History Start Date, if populated.

If blank, logic looks at the District Assignment record for the teacher for that School and reports the Assignment Start Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for the section.

If District Assignment Start Date is prior to the lowest Term Start Date, report the lowest Term Start Date for that section.

 
M

SectionStaffHistory.
startDate

EmploymentAssignment.
startDate

Term.startDate

Course > Section > Staff History > Start Date

Census > People > District Assignment > Start Date

System Administration > Calendar > Calendar > Terms

endDate

The month, day and year of the last day of a teacher''s assignment to the section. This element reports the Staff History End Date, if populated. 

If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.

Otherwise, report the Term End Date for that section.

O

SectionStaffHistory.
endDate

EmploymentAssignment.
endDate

Course > Section > Staff History > End Date

Census > People > District Assignment > End Date

highlyQualified
Teacher

An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition.

 

This field is optional and does not report. 


ON/AN/A
teacherStudent
DataLinkExclusion

This element indicates the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

 

This field is optional and does not report.


ON/AN/A
percentage
Contribution

The percentage of time the teacher is responsible for the student.

 

This field is optional and does not report.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.


ON/A

N/A


Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Classroom Position Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Teacher of RecrdTeacher of Record
02Assistant TeacherAssistant Teacher
03Support TeacherSupport Teacer
04Substitute TeacherSubstitute Teacher
XXNot State ReportedNot State Reported

Not State Reported was added by Campus to allow districts to exclude teachers from state reporting. 


Student

Provide a summary of what the report/function will cover and the logistics around the data collection or reporting. 

 

The Student Resource is a shared record among all districts. If two districts have the same student in the same year, the last district to trigger data to Ed-Fi is the data stored in Ed-Fi. 

For example, if one district put in a first name of "Robert" and the second district put in a first name of "Rob", the last district to update the student record is what will appear in Ed-Fi and on both District's reports. This is true for all field logic in the Student Resource.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person.

  • Data is not sent if the enrollment is marked as State Exclude or No Show.
  • Data is not sent if the enrollment is in a calendar marked as State Exclude.
Put

When any student data is edited for the person in the Data Elements fields below.

  •  When the person’s identity record is changed.
  •   When one of the person’s household locations is changed.  
  •    When one of the person’s household memberships is changed.   
  •     When the person’s FRAM Eligibility is changed.    
  •      When the person’s EL record is changed.     
  •      When one or more disabilities is added to an IEP and is locked. The IEP must overlap with the student's enrollment. Disabilities are removed if the IEP is not locked.     
  •      When the person's NCLB Cohort Year is changed.      
  •      When the student is scheduled in a course with a type of AP or HR, or given a roster end date that is before the term end date for that course.     
  •      When the Type is changed on the Course editor.
     
     
     
     
     
DeleteStudent records are never deleted because Student records are a shared resource among all districts.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

A record will report when an enrollment is created and saved that is aligned to a scoped year.

  •  The enrollment must overlap with the scope year to report

Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  •   Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used   

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  •   Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student resource.

Indicates the student participated in High Ability Learner programs.Reports True when High Ability Learner is set to 2: Eligibile and Participating on the enrollment being report. Otherwise, reports False.OEnrollment. giftedTalentedStudent Information > General > Graduation Tab > NCLB Cohort Year

Indicates the student participated in High Ability Learner programs.Reports True when High Ability Learner is set to 2: Eligibile and Participating on the enrollment being report. Otherwise, reports False.OEnrollment. giftedTalentedStudent Information > General > Graduation Tab > NCLB Cohort Year

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
studentUniqueIdA unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.MPerson.edFiIdCensus >People > Demographics > EdFi ID
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person.

 

This element is currently not reported or collected.

CN/AN/A
firstName

The reporting student's first name. This is reported from the person's most recent identity record.

If Legal First and Last name fields are blank, the First Name reports.

M

Identity.legalFirstName

Identity.firstName 

Census > People > Identities > Protected Identity Information > Legal First Name

Census > People > Identities > First Name

middleName

The reporting student's middle name. This is reported from the person's most recent identity record.

If Legal First Name and Legal Last Name are populated and Middle Name is blank, a blank value reports.

If all legal name fields are blank, value reports from the Middle Name field.

O

Identity.legalMiddleName

Identity.middleName

Census > People > Identities > Protected Identity Information > Legal Middle Name

Census > People > Identities > Middle Name

lastSurname

The reporting parent's last name. This is reported from the person's most recent identity record.

Reports first from the Legal Last Name field. If Legal First and Last name fields are blank, value reports from the  Last Name field.

M

Identity.legalLastName

Identity.lastName

Census > People > Identities > Protected Identity Information > Legal Last Name

Census > People > Identities > Last Name

generation CodeSuffix

An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III). This is reported from the person's most recent identity record.

Reports first from the Legal Sufix field.

If Legal First Name and Legal Last Name are populated and Legal Suffix is blank, a blank value reports.

If Legal First and Last name fields are blank, value reports from the Suffix field, if populated.

C

Identity.legalSuffix

Identity.suffix

Census > People > Identities > Protected Identity Information > Legal Suffix

Census > People > Identities > Suffix

maidenName

The person's maiden name, if applicable.

 

This element is currently not reported or collected.

ON/AN/A
sexType

The person's gender. This is reported from the person's most recent identity record.

Reports the Legal Gender from the student's current identity record. If Legal Gender is not populated, the value reports from the student's Gender from the current Identity record.

Reports the following based on the value selected in the Gender or Legal Gender field:

  • Female
  • Male
  • Not Selected (Gender not populated)

 M

Identity.legalGender

Identity.gender

Census > People > Identity > Protected Identity Fields > Gender

 Census > People > Identity > Gender

birthDateThe month, day, and year on which an individual was born. The Birth Date from the student's currently Identity record is reported.MIdentity.birthDateCensus > People > Identities > Birth Date
cityOfBirth

The set of elements that capture relevant data regarding a person's birth, including birth date and place of birth.

 

This element is currently not reported or collected.

ON/AN/A
birthState
Abbreviation Type

The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.

 

This field is optional and does not report.


ON/AN/A
birthCountry
CodeType

The name of the country in which an individual was born. 

 

This field is optional and does not report.


ON/AN/A
dateEnteredUS

For students born outside of the US, the date the student entered the US. This element reports the value entered in the Date Entered US field.

CIdentity.
dateEnteredUS
Census > People > Identities > Date Entered US
multipleBirth Status

Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.)

 

This element is currently not reported or collected.

ON/AN/A
profile Thumbnail

File name for the ProfileThumbnail photograph.

 

This element is currently not reported or collected.

ON/AN/A
hispanicLatino
Ethnicity
An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. This element reports based on the value in the Is the individual Hispanic/Latino? field on the student's identity record.MIdentity.
hispanicEthnicity
Census > People > Identities > Is the individual Hispanic/Latino?
oldEthnicity Type

Previous definition of Ethnicity combining Hispanic/latino and race 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin.

Data is reported based on the value entered in the Federal Race Ethnicity field:

  • If = '1' then 'Hispanic'
  • If  = '2', then 'American Indian Or Alaskan Native'
  • If = '3' or '5', then 'Asian Or Pacific Islander'
  • If = '4' then  'Black, Not Of Hispanic Origin'
  • If = '6', then 'White, Not Of Hispanic Origin'
 

This element is currently not reported or collected.


ON/AN/A

economic
Disadvantaged

An indication of inadequate financial condition of an individual''s family, as determined by family income, number of family members/dependents, participation in public assistance programs, and/or other characteristics considered relevant by federal, state, and local policy. 

 

This field is optional and does not report.


ON/AN/A
displacement Status

Indicates a state health or weather related event that displaces a group of students, and may require additional funding, educational, or social services.

 

This element is currently not reported or collected.

ON/AN/A
loginId

The login ID for the user; used for security access control interface.

 

This element is currently not reported or collected.

ON/AN/A
international ProvinceOfBirth

For students born outside of the US, the Province or jurisdiction in which an individual is born.

 

This element is currently not reported or collected.

ON/AN/A
citizenship StatusType

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

 

This element is currently not reported or collected.

ON/AN/A
learningStyle

This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

 

This element is currently not reported or collected.

ON/AN/A
addresses

Reports the student's address(es). Logic reports the most current Primary address that is marked as "Mailing".

  • If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date
  •   Else, report the address with most recent Address Start Date

This element is an array that reports the following data:

O

HouseholdLocation.
mailing

HouseholdMember.
startDate

Householdlocation.
startDate

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressTypeAll addresses will report as 'Home'. This will report the Ed-Fi mapped value in the Address Type table in the section below.MN/A N/A 
streetNumberName

The street number and street name or post office box number of an address. 

 Reports the Address PO Box + Number + Street + Tag + Prefix + Dir 

M 

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info 
apartmentRoomSuiteNumberThe apartment, room, or suite number of an address. Address.aptHouseholds > Address Info > Apt
buildingSiteNumber

The number of the building on the site, if more than one building shares the same address.

 

This field is optional and does not report.

ON/AN/A
cityThe name of the city in which an address is located. Address.cityHouseholds > Address Info > City
stateAbbreviationTypeThe abbreviation for the state (within the United States) or outlying area in which an address is located.MAddress.stateHouseholds > Address Info > State
postalCodeThe five or nine digit zip code portion of an address.MSAddress.zipHouseholds > Address Info > Zip
nameOfCounty

The name of the county, parish, borough, or comparable unit (within a state) in which an address is located.

 

This field is optional and does not report.

ON/AN/A
countyFIPSCode
5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county


 

This field is optional and does not report.

ON/AN/A
latitude
The geographic latitude of the physical address


 

This field is optional and does not report.

ON/AN/A
longitude

The geographic longitude of the physical address.

 

This field is optional and does not report.

ON/AN/A
beginDate

The first date the address is valid. For physical addresses, the date the person moved to that address.

 

This field is optional and does not report.

ON/AN/A
endDate

The last date the address is valid. For physical addresses, this would be the date the person moved from that address.

 

This field is optional and does not report.

ON/AN/A
electronic Mails

An unordered collection of studentElectronicMails. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. 

 

This field is optional and does not report.


ON/AN/A
identification Codes

An unordered collection of studentIdentificationCodes. 

This element reports the Local Student Number, if populated.

This element is an array that reports the following data:

O

Person.
studentNumber

Census > People > Demographics > Local Student Number

studentIdentificationSystemTypeReports the short description from the Student Identification Code mapping listed in the table and section below.MN/AN/A
Assigning Organization Identification Code The organization code or name assigning the assessment identification code.ON/AN/A
Identification CodeA unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.MPerson.
studentNumber
Census > People > Demographics > Local Student Number
identification
Documents

An unordered collection of studentIdentificationDocuments. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

 

This element is currently not reported or collected.

ON/AN/A
indicators

An unordered collection of studentIndicators. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

 

This element is currently not reported or collected.

ON/AN/A
international
Addresses

An unordered collection of studentInternationalAddresses. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

 

This element is currently not reported or collected.

ON/AN/A
otherNames

An unordered collection of studentOtherNames. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

This element reports the student's name from a previous Identity record. 

 This element is an array that reports the following data: 

ON/ACensus > People > Identities
otherNameTypeThis reports the Other Name Type Ed-Fi value mapped in the Other Name Type table in the section below.MN/AN/A
personalTitlePrefix

A prefix used to denote the title, degree, position or seniority of the person. 

 

This element is not collected or reported.

CN/AN/A
firstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. MIdentity.firstNameCensus > People > Identities > First Name
middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.CIdentity.middleNameCensus > People > Identities > Middle Name
lastSurnameThe name borne in common by members of a family.MIdentity.lastNameCensus > People > Identities > Last Name
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).CIdentity.suffixCensus > People > Identities > Suffix Name
telephones

An unordered collection of studentTelephones. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

 

This element is optional and does not report.

ON/AN/A
visas

An unordered collection of studentVisas. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.

 

This element is currently not reported or collected.

ON/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A
limitedEnglish Proficient Duration

Indicates the length of time, as of the last Friday in September of the current school year, this student is eligible for EL services and has participated in an EL program and/or in the mainstream/regular classroom.

If the student has an EL program Status of EL, the difference between the date identified as the last Friday in September of the current school year and the identified date of the student's EL record is used:

  • If the date is less than one year, reports 0
  • If the date is greater than one year, but less than 2 years, reports 1
  • If the date is greater than 2 years, but less than  3 years, reports 2
  • If the date is greater than 3 years, but less than 4 years, reports 3
  • If the date is greater than  4 years, but less than 5 years, reports 4
  • If the date is greater than 5 years, reports 5
  • If the student has an EL Program Status that is not EL or is NULL, reports 6
M
Student Information > Program > Participation > English Learners > Program Status
English Proficient Resdesignation

Indicates if a student has been redesignated as English Fluent and, if redesignated, for how many school years.

  • If the student has an LEP Program Status of Exited LEP, a value of 04 reports.
  • If the student has an LEP Program Status that is not Exited LEP or is null, a value of 00 reports.
M


Student Information > Program Participation > English Learners (EL) > Program Status;

Student Information > Program Participation > English Learners (EL) > Exited Date

Limited English Proficient Eligiblity

An indication that the student is identified as an English Learner (EL). If the student is a Foreign Exchange Student, EL eligibility cannot be true.

  • Reports True when the student has an EL Program Status of EL or Exited EL and the EL Exit Date is on or after today's date. Admission Status on enrollment must not be 1 Exchange Student.
  • Otherwise, reports False.
OLep. programStatusStudent Information > Program Participation > English Learners (EL) > EL
Expected Graduation School Year Type Reference

Four years from the year student entered the Ninth grade (for students first time in high school in state). This value cannot be derived.

Reports the NCLB Cohort Year from the graduation tab when populated.

CGraduation. cohortYearNCLBStudent Informaiton > General > Graduation Tab > NCLB Cohort Year
HonorsOr AdvancedPlacement

Student is in grades 9-12 and participated in an honors program or advanced placement classes in accordance with local school board policy.

Reports True when the student meets the following criteria:

  • The student's state grade level is 09, 10, 11, or 12.
  • The student is scheduled in a course that has a Type = HR or AP.
  • The student's roster end date must be null or equal to the term end date to qualify.

Otherwise, reports False.

O

Course.Type

Enrollment.grade

Scheduling > Courses > Type

Student > General > Enrollment > General Enrollment Information > Grade

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Address Type:

Code in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

All address report as "Home"     


 1    HomeHomeHome
2PhysicalPhysicalPhysical
3MailingMailingMailing
4OtherOtherOther
5WorkWorkWork
6BillingBillingBilling
7TemporaryTemporaryTemporary
8Father AddressFather AddressFather Address
9Guardian AddressGuardian AddressGuardian Address
10Mother AddressMother AddressMother Address
11ShippingShippingShipping
12SheltersShelters, Transitional housing, Awaiting Foster CareShelters, Transitional housing, Awaiting Foster Care
13DoubledDoubled - up (i.e., living with another family)Doubled - up (i.e., living with another family)
14UnshelteredUnsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)Unsheltered (e.g. cars, parks, campgrounds, temp trailers including FEMA trailers, or abandoned buildings)
15HotelMotelHotels/MotelsHotels/Motels


This table describes the Ed-Fi Value mapped and reported for Other Name Type:

Code in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
All report as "Other Name" 


1AliasAliasAlias
2NicknameNicknameNickname
3Other NameOther NameOther Name
4Previous Legal NamePrevious Legal NamePrevious Legal Name


This table describes the Ed-Fi Value mapped and reported for Student Identification Type:

Identification Code in CampusEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

Local Student Number 

      


Canadian SINCanadian SINCanadian SIN
DistrictDistrictDistrict
FamilyFamilyFamily
FederalFederalFederal
LocalLocalLocal
National MigrantNational MigrantNational Migrant
OtherOtherOther
SchoolSchoolSchool
SSNSSNSSN

Student State ID 

 
StateStateState
State MigrantState MigrantState Migrant


This table describes the Ed-Fi Value mapped and reported for Primary Nighttime Residence:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Homeless - SheltersHomeless - Shelters
02Homeless - Double Up (living with another family)Homeless - Doubled up (living with another family)
03Homeless - UnshelteredHomeless - Unsheltered
05Homeless - Hotel or MotelHomeless - Hotel or Motel


This table describes the Ed-Fi Value mapped and reported for  English Proficient Redesignation Descriptor: 

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
00Not applicableNot applicable
02Redesignated as English Fluent Two Years or Less Two Years or LessRedesignated as English Fluent Two Years or Less Two Years or Less
03Redesignated as English Fluent More Than Two YearsRedesignated as English Fluent More Than Two Years


This table describes the Ed-Fi Value mapped and reported for   English Proficient Duration Descriptor:   

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
If the student has an EL Program Status = EL, then calculate the difference between the date identified as the last Friday in September of the current school year and the "Identified Date" of the student's EL record report a 0-5 based on the following:
0Less than one yearLess than one year
1More than one year and less than two yearsMore than one year and less than two years
2More than two years and less than three yearsMore than two years and less than three years
3More than three years and less than four yearsMore than three years and less than four years
4More than four years and less than five yearsMore than four years and less than five years
5More than five yearsMore than five years
6Not an EL studentNot an EL student

Student Academic Record

This educational entity represents the cumulative record of academic achievement for a student.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When transcript records are posted for a student for a course with a state code and they have a Student School Association record for the scoped year.

  • A record reports for each school year to which the transcript record is aligned.
  • Records do not report when the course is in an excluded calendar. If the transcript is manually entered, that information only reports if the student has an enrollment in a calendar that is not marked as excluded.
DeleteStudent Academic Records only delete when a student has only one Student School Association record for a specific school and year and all Student School Association records are deleted.
Delete/Post

If the natural key is changed.

If a term descriptor mapping changed either in the Sessions Preferences or the Ed-Fi Transcript Term Override.

If the Actual Term is changed on a Course Transcript Record and the Ed-Fi Transcript Term Override field is NULL.

If the Ed-Fi Transcript Term Descriptor Override mapping is changed.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
The Student Academic Record posts to any school year when it is associated with a Course Transcript record..
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Academic Record resource.

Data ElementDescriptionCampus DatabaseCampus GUI Location
id The unique identifier of the resource.MN/AN/A
educationOrganization Reference 

A reference to the related Education Organization resource.

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

  • schoolID

If the record is associated with any school in the district where the student is enrolled, the school number that is associated with the record being reported reports.

If the record is not associated with any school in the district where the student is enrolled, the state school number of '000000001' reports.

MN/AN/A
schoolYear TypeReference A reference to the related SchoolYearType resource. This element reports the end year of the school year being reported.MN/AN/A
studentReference

A reference to the related Student resource.

Reports the fields that are part of the Natural Key for the Student:

  • studentUniqueId
MN/AN/A
termType

The term for the session during the school year.

  • If transcript record was posted via the Post to Transcript tool, the term in which the grade occurred reports, based on the section schedule placement for the section the student was scheduled and the Term Type logic reported for that course/section.
  • If the transcript record was manually posted, the Term Type from the last term listed in the primary Term Schedule from the Calendar in which the student was enrolled reports. If a Term Type cannot be determined, the value 'Spring Semester' reports.
MN/AN/A
cumulativeEarned CreditType

Key for Credit.

 

This field is optional and does not report.

ON/AN/A
cumulativeEarned CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units

 

This field is optional and does not report.


ON/AN/A
cumulativeEarnedCredit

The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.

 

This field is optional and does not report.


ON/AN/A
cumulativeAttempted CredtType

Key for Credit

 

This field is optional and does not report.

ON/AN/A
cumulativeAttempted CredtConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

This field is optional and does not report.


ON/AN/A
cumulativeAttemptedCredit

The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled.

 

This field is optional and does not report.


ON/AN/A
cumulatveGrade PointsEarned

The cumulative number of grade points an individual earns by successfully completing courses or examinations during his or her enrollment in the current school as well as those transferred from schools in which the individual had been previously enrolled.

 

This field is optional and does not report.


ON/AN/A
cumulativeGrade PointAverage

   A measure of average performance in all courses taken by an individual during his or her school career as determined for record-keeping purposes. This is obtained by dividing the total grade points received by the total number of credits attempted. This usually includes grade points received and credits attempted in his or her current school as well as those transferred from schools in which the individual was previously enrolled.

 

This field is optional and does not report.

ON/AN/A
gradeValueQualifier

The scale of equivalents, if applicable, for grades awarded as indicators of performance in schoolwork. For example, numerical equivalents for letter grades used in determining a student's Grade Point Average (A=4, B=3, C=2, D=1 in a four-point system) or letter equivalents for percentage grades (90-100%=A, 80-90%=B, etc.).

 

This field is optional and does not report.


ON/AN/A
projectedGraduationDate

 The month and year the student is projected to graduate.

 

This field is optional and does not report.

ON/AN/A
sessionEarned CreditType

Key for Credit.

 

This field is optional and does not report.


ON/AN/A
sessionEarned CreditConversion

Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

This field is optional and does not report.


ON/AN/A
sessionEarnedCredit

 The number of an credits an individual earned in this session.

 

This field is optional and does not report.

ON/AN/A
sessionAttempted CreditType

Key for Credit

 

This field is optional and does not report.


ON/AN/A
sessionAttempted CreditConversion

 Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

 

This field is optional and does not report.

ON/AN/A
sessionAttemptedCredit

The number of an credits an individual attempted to earn in this session.

 

This field is optional and does not report.


ON/AN/A
sessionGrade PointsEarned

 The number of grade points an individual earned for this session.

 

This field is optional and does not report.

ON/AN/A
sessionGrade PointAverage

 The grade point average for an individual computed as the grade points earned during the session divided by the number of credits attempted.

 

This field is optional and does not report.

ON/AN/A
classRanking

 This educational entity represents the cumulative record of academic achievement for a student.

 

This field is optional and does not report.

ON/AN/A
academicHours

 An unordered collection of studentAcademicRecordAcademicHonors. This educational entity represents the cumulative record of academic achievement for a student.

 

This field is optional and does not report.

ON/ANA
diplomas                              

An unordered collection of studentAcademicRecordDiplomas. This educational entity represents the cumulative record of academic achievement for a student.

 

This field is optional and does not report.

This element reports an array of the following data elements:

ON/AN/A
diplomaType

The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements.

 

This field is optional and does not report.


MN/AN/A
diplomaAwardDate

 The month, day, and year on which the student met graduation requirements and was awarded a diploma. 

 

This field is optional and does not report.


NN/AN/A
diplomaLevelType

 The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements. Minimum high school program Recommended high school program Distinguished Achievement Program.

 

This field is optional and does not report.


ON/AN/A
cteCompleter

 Indicated a student who reached a state-defined threshold of vocational education and who attained a high school diploma or its recognized state equivalent or GED. 

 

This field is optional and does not report.


ON/AN/A
diplomaDescription

The description of diploma given to the student for accomplishments.

 

This field is optional and does not report.


ON/AN/A
diplomaAward ExpiresDate

 Date on which the award expires.

 

This field is optional and does not report.

ON/AN/A
achievementTitle

 The title assigned to the achievement. 

 

This field is optional and does not report.


ON/AN/A
achievementCategoryDescriptor

This descriptor defines the category of achievement attributed to the learner.

 

This field is optional and does not report.

MN/AN/A
achievementCategorySystem

The system that defines the categories by which an achievement is attributed to the learner.

 

This field is optional and does not report.


ON/AN/A
issuerName

 The name of the agent issuing the award. 

 

This field is optional and does not report.


ON/AN/A
issuerOriginURL

 The Uniform Resource Locator (URL) from which the award was issued. 

 

This field is optional and does not report.


ON/AN/A
criteria

 The criteria for competency-based completion of the achievement/award. 

 

This field is optional and does not report.


ON/AN/A
criteriaURL

The Uniform Resource Locator (URL) for the unique address of a web page describing the competency-based completion criteria for the achievement/award.

 

This field is optional and does not report.


ON/AN/A
evidenceStatement

 A statement or reference describing the evidence that the learner met the criteria for attainment of the achievement. 

 

This field is optional and does not report.


ON/AN/A
imageURL

 The Uniform Resource Locator (URL) for the unique address of an image representing an award or badge associated with the achievement.


 

This field is optional and does not report.


ON/AN/A
recognitions

An unordered collection of studentAcademicRecordRecognitions. This educational entity represents the cumulative record of academic achievement for a student.

 

This field is optional and does not report.


ON/AN/A
reportCards

An unordered collection of studentAcademicRecordReportCards. This educational entity represents the cumulative record of academic achievement for a student

 

This field is optional and does not report.


ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

 

This field is optional and does not report.


ON/AN/A

Student CE Program Association

 This association represents the CE program(s) that a student participates in or from which the student receives services. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Programs Fact record is created with a Program Name that begins with "Career Ed:..." and the record Start Date is not after the students enrollment End Date in the current calendar.

  • Report a record based on the student having an enrollment record in the calendar to which the Program Fact record is aligned.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not report any Program Facts records without a Start Date.
PostWhen the Program Name or the Start Date values are changed, the old record deletes, and a new record posts.
Post

When a new enrollment is created for a student that has a Program Fact record in the calendar in which the student is enrolled.

  • Enrollment start date must be after Program Fact start date.
  • Program Fact end date must be NULL or after enrollment start date.
PutUpdate the endDate if the student's enrollment record is ended prior to the End Date of the Program Fact record, or if the Program Fact record's end date is NULL.
PutUpdate the record if ' technicalSkillAttainmentDescriptor ', ' levelOfProgramParticipationDescriptor ' within the cePrograms array are updated.
PutUpdate the record if the endDate value in this resource is changed.
Delete/Post When the careerPathwayType value within the cePrograms array is changed, we must delete the original array data, and insert new array record. 
DeleteWhen the Program Name or the Start Date values are changed, the old record deletes, and a new record posts.
DeleteWhen all enrollments for a calendar that the Program Fact record is aligned to are deleted.
DeleteWhen the Programs Fact record is deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

When a new Program Fact record is created, the record reports in the Scope Year in which the record Start Date overlaps.

The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX is used as the default date.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student CE Program Association resource.

Data Element

DescriptionCampus DatabaseCampus GUI Location
idThe unique identifier of the resourceON/AN/A
studentUniqueID

A unique aphanumeric code assigned to a student.

The student's Ed-Fi ID reports.

MPerson.edFiIdCensus > People > Demographics > EdFi ID
programType

The program associated with the student.

Always reports 'Career and Technical Education' whenever the Programs Fact tab record has a Program Name of 'Career Ed: XXX."

MNEProgramsFact. programNameStudent Information > General > Programs Fact > Program Name

programEducation OrganizationId

The education organization where the student is participating in or receiving the program services.

Reports the Ed-Fi District Number associated with the student's enrollment.

MDistrict.numberSystem Administration > Resources > District Information > State District Number
beginDate

The month, day, and year on which the student  received services. NEDM: Beginning Date 

Reports the start date from the Program Fact record if:

  • Program Fact Start Date is after enrollment Start Date
  • Enrollment End Date must be NULL or after Program Fact start date

Report the Enrollment Start Date if:

  • Enrollment Start Date is after the Program Fact Start Date
  • Program Fact End Date is NULL or after Enrollment Start Date
 M

Enrollment.startDate

NEProgramsFact. startDate

Student Information > General > Enrollment > General Enrollment Information > Start Date

Student Information > General >Program Fact Tab > Start Date

programName

 The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies. 

 Report from the Program Name value from the selected Program. 

 Always reports 'Career and Technical Education' when the program name selected on Program Facts tab begins with 'Career Ed'
 

MNEProgramsFact. programNameStudent Information > General > Programs Fact > Program Name
educationOrganizationID

 The education organization where the student is participating in or receiving the program services. 

Reports the School Number based on the School selected on the School of Assignment on the reporting enrollment.

If this field is blank, reports the School Number associated with the enrollment.

 
 

 M School.number System Administration > Resources > School > State School Number
endDate

 The month, day, and year on which the student exited the program or stopped receiving services. NEDM: Ending Date. 

  • Reports the end date from Program Fact if populated. Program Fact End Date must be before Enrollment End Date
  • Reports Enrollment End Date if populated. Enrollment End date must be after Program Fact Start Date and before Program Fact End Date.
 C

 Enrollment.endDate

NEProgramsFact.endDate

Student Information > General > Enrollments > General Enrollment Information > End Date

Student Information > General > Program Facts tab > End Date

reasonExitedDescriptor

 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

 

This field is optional and does not report.

CN/AN/A
servedOutsideOf RegularSession

    Indicates whether the student received services during the summer session or between sessions.  


 

This field is optional and does not report.

CN/AN/A
earlyLearning SettingDescriptor

 The setting of the student's participation in the program. 


 

This field is optional and does not report.

CN/AN/A
services
 

This field is optional and does not report.

CN/AN/A
cePrograms      

 An unordered collection of studentCEProgramAssociationCEPrograms. This association is an NDE extension of the StudentProgramAssociation core table for Career Education Programs. 

This element reports an array of the following data elements:

CN/AN/A
careerCluster PathwayDescriptor

   The career cluster representing the career path of the Vocational/Career Tech concentrator. NEDM: Career Cluster.    

   Reports the Career Pathway Type from the program name selected in the dropdown list.
 
 
 

MNEProgramsFact. programNameStudent Information > General > Programs Fact > Program Name
cipCode

  Number and description of the CIP Code associated with the student's CTE program .

 

This field is optional and does not report.

ON/AN/A
primaryCTE ProgramIndicator

 A Boolean indicator of whether this CTE program, is the student's primary CTE program. 

 

This field is optional and does not report.

ON/AN/A
cteProgramCompletion Indicator

  A Boolean indicator of whether the student has completed the CTE program ,

 

This field is optional and does not report.

ON/AN/A
technicalSkill AttainmentDescriptor

 The technical skill attainment based on the highest rated method. 

  • Reports the EdFi code value from the Exit Reason selected.
  • If the Exit Reason is blank, reports as blank.

 See the Type/Descriptor section below following this table.  

 MNEProgramsFact. exitReasonStudent Information > General > Programs Fact > Exit Reason
levelOrProgram ParticipationDescriptor

 Provides additional information regarding the student's level of participation in the program.  Reports the Ed-Fi Code value.

 See the  Type/Descriptor  section below following this table.  

MNEProgramsFact. participationInfoCodeStudent Information > General > Programs Fact > Participation Info Code

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Program Name:

Program NameEd-Fi Short DescriptionCareer PathwayType
Career and Technical EducationCareer and Technical EducationAgriculture, Food and Natural Resources
Career and Technical EducationCareer and Technical EducationArchitecture and Construction
Career and Technical EducationCareer and Technical EducationArts, A/V Technology and Communications
Career and Technical EducationCareer and Technical EducationBusiness, Management and Administration
Career and Technical Education

Career and Technical Education

Education and Training
Career and Technical EducationCareer and Technical EducationFinance
Career and Technical EducationCareer and Technical EducationFoundational, Exploratory, Career Dev, or Other
Career and Technical EducationCareer and Technical EducationGovernment and Public Administration
Career and Technical EducationCareer and Technical EducationHealth Science
Career and Technical EducationCareer and Technical EducationHospitality and Tourism
Career and Technical EducationCareer and Technical EducationHuman Services
Career and Technical EducationCareer and Technical EducationInformation Technology
Career and Technical EducationCareer and Technical EducationLaw, Public Safety, Corrections and Security
Career and Technical EducationCareer and Technical EducationManufacturing
Career and Technical EducationCareer and Technical EducationMarketing, Sales and Service
Career and Technical EducationCareer and Technical EducationScience, Technology, Engineering and Mathematics
Career and Technical EducationCareer and Technical EducationTransportation, Distribution and Logistics

This table describes the Ed-Fi Value mapped and reported for Technical Skill Attainment Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
02Met Technical Skill Attainment through third party assessmentMet Technical Skill Attainment through third party assessment
03Met Technical Skill Attainment through Locally developed criterionMet Technical Skill Attainment through Locally developed criterion
04Did not meet Technical Skill AttainmentDid not meet Technical Skill Attainment
05Met Technical Skill Attainment through dual credit and/or coursesMet Technical Skill Attainment through dual credit and/or courses
11Artificial Insemination (AI) CertificationArtificial Insemination (AI) Certification
12Commercial Driver's LicenseCommercial Driver's License
13Emergency Medical Technician (EMT)Emergency Medical Technician (EMT)
14ForkliftForklift
15Livestock Quality Assurance CertificationLivestock Quality Assurance Certification
16Medication AidMedication Aid
17Mental Health First AidMental Health First Aid
18Microsoft Office Specialist CertificationMicrosoft Office Specialist Certification
19NCCER National RegistryNCCER National Registry
20Nursing Assistant/CNANursing Assistant/CNA
21OSHA 10hr. CertificationOSHA 10hr. Certification
22Pesticide Applications LicensePesticide Applications License
23Pharmacy TechnicianPharmacy Technician
24Phlebotomy TechnicianPhlebotomy Technician
25ServSafeServSafe
26W!SE Financial Literacy CertificateW!SE Financial Literacy Certificate
99Met Tech Skill Attainment Through Industry Certification: Other/UnknownMet Tech Skill Attainment Through Industry Certification: Other/Unknown

This table describes the Ed-Fi Value mapped and reported for Level of Program Participation:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Career Education ParticipantCareer Education Participant
02Career Education Participant with PostsecondaryCareer Education Participant with Postsecondary
03Career Education ConcentratorCareer Education Concentrator
04Career Education Concentrator with PostsecondaryCareer Education Concentrator with Postsecondary

Student Discipline Incident Association

This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

Object Triggering Data

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Posts

Reports a behavior event when the incident's Status is marked and saved as Complete.

  • Only reports Students associated with the reporting school and are the Offender or Participant.
  • Only reports events mapped to a State EVent code that has an Ed-Fi value.
  • Data is not sent if the student's enrollment is marked as No Show or State Exclude.
  • Data is not sent if the student is in a calendar marked as Exclude.
Delete/Post

When the Incident's Status is change.

  • Delete occurs when the status is changed from Completed to In Progress.
  • Post occurs when the Status is changed from In Progress to Completed
PutWhen the behavior event is changed to another state mapped code or a new event is added or removed.
DeleteDelete if the Role is changed to something that is not equal to the Offender or Participant.
DeleteWhen a student is deleted from all events that are mapped to a state event code.
DeleteWhen the behavior event State Mapped Code is changed to NULL or Not State Reporting and there are no other state mapped codes on the incident for that student.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records are only sent to the school year to which the incident date is aligned based on the School Year Start and End Dates.

  • If School Year Start Date is null, 7/1/XXXX is used as the default start date.
  • If School Year End Date is null, 6/30/XXXX is used as the default end date.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Discipline Incident Association resource.

Data ElementDescriptionCampus DatabaseCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
disciplineIncident Reference

A reference to the related Discipline Incident resource:

  • schoolReference
  • incidentIdentifier
  • incidentDate
MN/AN/A
studentReference

A reference to the related Student resource:

  • studentUniqueID
MN/AN/A
studentParticipation CodeType

The role or type of participation of a student in a discipline incident; for example: Victim Perpetrator Witness Reporter. 

Reports the Ed-Fi Code value from the Role that is selected for the Student being reported.

See the Type/Descriptor options below.

MBehaviorEvent.roleBehavior > Behavior Management > Participant Details > Role
behaviors  

An unordered collection of disciplineIncidentBehaviors. This event entity represents an occurrence of an infraction ranging from a minor behavioral problem that disrupts the orderly functioning of a school or classroom (such as tardiness) to a criminal act that results in the involvement of a law enforcement official (such as robbery). A single event (e.g., a fight) is one incident regardless of how many perpetrators or victims are involved. Discipline incidents are events classified as warranting discipline action.

This element reports an array of the following data elements:

ON/AN/A
behaviorDescriptor

This descriptor holds the categories of behavior describing a discipline incident.

  • Only reports behaviors with which the student is associated.
  • Reports the Ed-Fi code value from the mapped Behavior Event.
  • If the Behavior Event is not mapped, it does not report.

See the Type/Descriptor options below.

 O
Behavior > Behavior Management > Event Type
Detailed Description

 Specifies a more granular level of detail of a behavior involved in the incident. 

 

This field is optional and does not report.

 
 

 ON/AN/A
weapons 

An unordered collection of disciplineIncidentWeapons.See the Type/Descriptor options below.

This element reports an array of the following data elements:

C
Behavior > Behavior Management > Behavior Events > Weapons
weaponDescriptor

This descriptor defines the types of weapon used during an incident.

  • (Campus.1625 Logic) When reporting from the Weapons field on the Behavior Event Details, report the Ed-Fi code value for all students associated with the reporting behavior. If Ed-Fi Code value is NULL, do not report
  • (Campus.1629 Logic) When reporting from the Weapons field on the Participant(s) Details, report the Ed-Fi code value for each weapon aligned to the student. If Ed-Fi Code value is NULL, do not report
O
Behavior > Behavior Management > Participant(s) > Details > Weapon
Gun Free School Violation

Reports True when the associated student has a Weapon Code of 02, 05 or 08 AND has a Resolution with a State Code in 03, 04 or 05. Otherwise, reports false.

C
Behavior > Behavior Management > Behavior Event > Weapons, State Resolution Code
School Related ArrestIndicates if student was involved in a disciplinary incident that resulted in an arrest.MBehaviorResolution.auxiliaryCodeBehavior Management> Behavior Resolution
Referral To Law EnforcementIndicates if the incident was referred to law enforcement.MBehaviorResolution.lawEnforcementBehavior Management> Behavior Resolution
etag

A unique system-generated value that identifies the version of the resource.

ON/AN/A

Type/Descriptors

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Student Participation Code Types:

Ed-Fi Short DescriptionEd-Fi Description
VictimVictim
PerpetratorPerpetrator
WitnessWitness
ReporterReporter

This table describes the Ed-Fi Value mapped and reported for Behavior Types: 

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
51Special Ed: Drug OffensesSpecial Ed: Drug Offenses
54Special Ed: Dangerous WeaponsSpecial Ed: Dangerous Weapons
55Special Ed: Serious Bodily InjurySpecial Ed: Serious Bodily Injury
58Other State ReportableOther State Reportable
61HarassmentHarassment
62BullyingBullying
63Other School Code of ConductOther School Code of Conduct

This table describes the Ed-Fi Value mapped and reported for   Weapon Descriptor Types:   

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01ClubClub
02HandgunHandgun
03Knife (except pocketknife with blade of less than 2 ½ inches)Knife (except pocketknife with blade of less than 2 ½ inches)
04OtherOther
05Other FirearmOther Firearm
06Other ObjectOther Object
07Other Sharp ObjectsOther Sharp Objects
08Rifle/ShotgunRifle/Shotgun
09Substance Used as WeaponSubstance Used as Weapon
10UnknownUnknown
11Pocketknife with blade of less than 2 ½ inchesPocketknife with blade of less than 2 ½ inches

   
 
 
 


Student Early Learning Program Association

This association represents the Early Learning program that a student participates in or from which the student receives services.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Programs Fact tab record is created with a Program Name of either 'ECHEADST' or 'ERLYCHLD', and the record Start Date is not after the students enrollment End Date in the current calendar.

  • Reports a record based on the student having an overlapping enrollment record in the calendar to which the Program Fact record is aligned.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not report any Program Facts records without a Start Date.
  • If there are multiple qualifying early childhood Program Records of either 'ECHEADST' or 'ERLYCHLD', report the one with the latest Start Date.
  • If there are multiple qualifying early childhood Program Records of either 'ECHEADST' or 'ERLYCHLD', with the same Start Date, report the one with the highest record ID..
Post

When a new enrollment is created for a student that has a Program Fact record in the calendar in which the student is enrolled.

  • Enrollment start date must be after Program Fact start date.
  • Program Fact end date must be NULL or after enrollment start date.
Post

If the student does not have any Programs Fact ERLYCHLD or ECHEADST record (either because it is not active, or it is nonexistent) look at the student's active course roster in the current calendar to see if any Early Childhood value that is not NULL in a section.

  • If the student is scheduled into a single section with the Early Childhood value that is not NULL, report out based on that record.
  • If the student is scheduled into more than one section with the Early Childhood value that is not NULL, report out based on the section with the most recent Roster Start Date.
  • If the student is scheduled into more than one section with the Early Childhood value that is not NULL, and they all have the same Roster Start Date, or the Roster Start Dates are all NULL, report out based on the highest sectionID.
  • If the student has an active Programs Fact record and is scheduled in a section with the Early Childhood value that is not NULL, report the record from the Program Fact record only.
  • The course must have a state course code to report
Post

When the Program Name or the Start Date values are changed, the old record is deleted, and the new record is posted.

  • The start date can change either from the Programs Fact record or the Roster start date being changed.
  • The Program Name can change either from the Programs Name field on the Programs Fact record or the Early Childhood dropdown list on the section editor.
Delete/PostUpdate the endDate if the student's enrollment record is ended prior to the End Date of the Program Fact record, or if the Program Fact record's end date is NULL.
Delete/PostUpdate the record if the endDate value in this resource is changed.
Delete/PostUpdate the record if the roster end date value for the section associated with this record is added or changed.
Delete

When the Program Name or the Start Date values are changed, the old record is deleted, and the new record is posted.

  • The start date can change either from the Programs Fact record or the Roster start date being changed.
  • The Program Name can change either from the Programs Name field on the Programs Fact record or the Early Childhood dropdown list on the section editor.
DeleteWhen all enrollments for a calendar that the Program Fact record is aligned to are deleted.
DeleteWhen the Programs Fact record is deleted.
DeleteWhen the roster record is deleted.
DeleteWhen the Early Childhood value is set to null and saved on the section editor

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
When a new Program Fact record is created, the record will report in the Scope Year for which the record Start Date overlaps.
The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX is used as the default date.
Data only sends for the years that have valid configuration.
When the record is triggered from Course Sections, the record sends to the scope year for the school year for which the Course/Section's calendar is aligned.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Parent Association resource.

Data ElementDescriptionCampus DatabaseCampus GUI Location
idThe unique identifier of the resourceON/AN/A
studentUniqueID

A unique aphanumeric code assigned to a student.

The student's Ed-Fi ID reports.

MPerson.edFiIdCensus > People > Demographics > EdFi ID
programType

The program associated with the student.

Reports the following when reporting from Programs Fact tab:


    • If Program Name code from the selected Early Child record = 'ERLYCHLD', reports 'Public Preschool'
    • If Program Name code from the selected Early Child record = 'ECHEADST', reports 'Early Head Start'

Report the following when reporting from the Course Section:


    • If program name code from the selected Early Child record begins with ERLYCHLD', reports 'Public Preschool'
    • If Program Name code from the selected Early Child record begins with 'ECHEADST', reports 'Early Head Start'

 See the  Type/Descriptor  section below following this table.  

M

NEProgramsFact. programName

Course.programType

Student Information > General > Programs Fact > Program Name

Scheduling > Courses > Course > Section > Early Childhood > Program Name

programEducation OrganizationId

The education organization where the student is participating in or receiving the program services.

Reports the Ed-Fi District Number associated with the student's enrollment.

MDistrict.numberSystem Administration > Resources > District Information > State District Number
beginDate

The month, day, and year on which the student  received services. NEDM: Beginning Date 

Reports the start date from the Program Fact record if:

  • Program Fact Start Date is after enrollment Start Date
  • Enrollment End Date must be NULL or after Program Fact start date

Reports the student's start date in the section if reporting from the Course. Reports Earliest term start date if Roster Start date is NULL.

 M

Enrollment.startDate

Roster.startDate

Scheduling > Courses > Course > Section > Roster Start Date

System Administration > Calendar > Calendar > Terms > Start Date

Student Information > General >Program Fact Tab > Start Date

programName

 The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies. 

  • If Program Name code = 'ERLYCHLD', reports 'NDE Approved Early Childhood Ed Program, not Head Start.'
  • If Program Name code = 'ECHEADST', reports 'NDE Approved Early Childhood Ed Program, Head Start.'

 See the  Type/Descriptor  section below following this table.  

M

NEProgramsFact. programName

Course.programName

Student Information > General > Programs Fact > Program Name

Scheduling > Courses > Course > Section > Early Childhood > Program Name

educationOrganizationID

 The education organization where the student is participating in or receiving the program services. 

Reports the School Number based on the School selected on the School of Assignment on the reporting enrollment.

If this field is blank, reports the School Number associated with the enrollment.

 
 

 M School.number System Administration > Resources > School > State School Number
endDate

 The month, day, and year on which the student exited the program or stopped receiving services. NEDM: Ending Date. 

  • Reports the end date from Program Fact if populated. Program Fact End Date must be before Enrollment End Date
  • Reports the Roster End Date if populated. Reports the latest term end date if the Roster End Date is null.
 C

Roster.endDate

NEProgramsFact.endDate

Scheduling > Courses > Course > Section > Roster End Date

Student Information > General > Program Facts tab > End Date

reasonExitedDescriptor

 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 


 

This field is optional and does not report.

CN/AN/A
servedOutsideOf RegularSession

    Indicates whether the student received services during the summer session or between sessions.  


 

This field is optional and does not report.

CN/AN/A
earlyLearning SettingDescriptor

 The setting of the student's participation in the program. 

 Reports the following when reporting from Programs Fact tab:

  • Reports the Ed-Fi Code from the Participation Info Code selected.
  • Only reports values from codes with the 'EC...' prefix; otherwise do not report.

Report the following when reporting from the Course Section. Reports the Ed-Fi Code from the Early Childhood Code selected.

 See the  Type/Descriptor  section below following this table.  

CNEProgramsFact. participationInfoCodeStudent Information > General > Programs Fact > Participation Info Code
services

 An unordered collection of studentProgramAssociationServices. This association is an NDE extension of the StudentProgramAssociation core table for Early Learning Programs. 

 

This field is optional and does not report.

CN/AN/A

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Program Type/Name:

Program NameEd-Fi Short DescriptionCareer PathwayType
Career Ed: Agriculture, Food, and Natural Resources SystemsCareer and Technical EducationAgriculture, Food and Natural Resources
Career Ed: Architecture and ConstructionCareer and Technical EducationArchitecture and Construction
Career Ed: Arts, Audio/Visual, and CommunicationCareer and Technical EducationArts, A/V Technology and Communications
Career Ed: Business Management and AdministrationCareer and Technical EducationBusiness, Management and Administration
Career Ed: Education and Training

Career and Technical Education

Education and Training
Career Ed: FinanceCareer and Technical EducationFinance
Career Ed: Foundational, Exploratory, Career Dev, or OtherCareer and Technical Education
Career Ed: Government and Public AdministrationCareer and Technical EducationGovernment and Public Administration
Career Ed: Health SciencesCareer and Technical EducationHealth Science
Career Ed: Hospitality and TourismCareer and Technical EducationHospitality and Tourism
Career Ed: Human ServicesCareer and Technical EducationHuman Services
Career Ed: Information TechnologyCareer and Technical EducationInformation Technology
Career Ed: Law, Public Safety, Security, and CorrectionsCareer and Technical EducationLaw, Public Safety, Corrections and Security
Career Ed: ManufacturingCareer and Technical EducationManufacturing
Career Ed: MarketingCareer and Technical EducationMarketing, Sales and Service
Career Ed: Science, Technology, Engineering and MathematicsCareer and Technical EducationScience, Technology, Engineering and Mathematics
Career Ed: Transport, Distribution, Warehousing, LogisticsCareer and Technical EducationTransportation, Distribution and Logistics
English Language Learner (ELL)English as a Second Language (ESL)
NDE Approved Early Childhood Ed Program, Head StartEarly Head Start
NDE Approved Early Childhood Ed Program, not Head StartPublic Preschool
Rule 18 Interim-Program SchoolNeglected and Delinquent Program
Special EducationSpecial Education
Title I Part ATitle I Part A
504 DesignationSection 504 Placement
Gifted and TalentedGifted and Talented

This table describes the Ed-Fi Value mapped and reported for Early Learning Setting Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01NDE Grant Funded Early Childhood Education Program.Students in state grant funded center- based early childhood education program that has not yet been funded for three consecutive years; not eligible for state aid.
02Qualified NDE Grant Funded Early Childhood Education Program.Students in a state grant funded center- based early childhood education program that has been funded for three consecutive years; therefore, four year old students as of July 31 are eligible for state aid.
03NDE Approved Early Childhood Education Program.Students in a center-based Rule 11 approved early childhood education program that is not state grant funded and has not been approved for three consecutive years; not eligible for state aid.
04Qualified NDE Approved Early Childhood Education Program.Students in a center-based Rule 11 approved early childhood education program that is not state grant funded and has been approved for three consecutive years; therefore, four year old students as of July 31 are eligible for state aid.
05Early Childhood Birth to Age 3 Endowment Grant Program.Students age birth to age 3 served in a center-based program or a home visitation program or a combination of the two programs. Applies only to public school districts receiving an Early Childhood Birth to Age 3 Endowment Grant.
06Home-based Early Childhood Education Program.Students age birth to kindergarten entrance age served in a home visitation program.

Student Education Organization Demographics 

This association represents the student's education organization demographics.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person.

  • Data is not sent if the enrollment is marked as State Exclude or No Show.
  • Data is not sent if the enrollment is in a calendar marked as State Exclude.
  • Do not send a record if the enrollment is in a school marked as State Exclude.
Put

When any student data is edited for the person in the Data Elements fields below.

  •  When the person’s identity record is changed.
  •   When one of the person’s household locations is changed.  
  •    When one of the person’s household memberships is changed.   
  •     When the person’s FRAM Eligibility is changed.    
  •      When the person’s EL record is changed.     
  •      When one or more disabilities is changed and a student's IEP is locked or unlocked.      
  •          When a student's contact information is changed: email or phone number.
DeleteStudent records are never deleted because Student records are a shared resource among all districts.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

A record will report when an enrollment is created and saved that is aligned to a scoped year.

  •  The enrollment must overlap with the scope year to report 
  • Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  Records will be compared to today's date to determine if the record is eligible to report.
  •   Previous Years:  The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used   

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  •   Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

Object Data Elements

Click here to expand...
Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
studentUniqueIdA unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.MPerson.edFiIdCensus >People > Demographics > EdFi ID
EducationOrganizationReference

A reference to the related educationOrganization resource.

Reports the LEA ID.

  1. The LEA ID is the State District Number + 000.
M

district.number

System Administration> Resources> District Information> State District Number

and

000

studentReference

A reference to the related student resource.

Reports the reference for the student being reported.

M

sexType

A person''s gender.

  1. Reports the Legal Gender from the student's current identity record.
    a. If null, reports from Gender on the student's current identity record.
  2. Report the following based on the value selected in the droplist:
    1. If Female, reports 'Female'.
    2. If Male, reports 'Male'.
    3. If Blank, reports 'Not Selected'.
Midentity.GenderCensus > People > Identities > Gender
hispanicLatinoEthnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, ""Spanish origin,"" can be used in addition to ""Hispanic or Latino.""

Reports "Is the individual Hispanic/Latino?" from the student's current identity:

  1. If droplist is = Yes, reports "true".
  2. If droplist is = No, reports "false".
Midentity.hispanicEthnicityCensus > People > Identities > Date Entered US

schoolFood ServicesEligibility Descriptor

If the FRAM Snapshot checkbox is not marked.

This descriptor defines indications of a student's level of eligibility for breakfast, lunch, snack, supper and milk programs. 

If the current academic year's FRAM record is NULL, the previous academic year's FRAM record is used (if exists). 

If the previous academic year has a FRAM record, logic looks at the End Date:

  • Compare the End Date to today's date:
    • If the End Date is before today's date, do not use the prior year FRAM record, and report blank.
    • If the End Date is on or after the Effective Date selected, use the prior year FRAM record.

If the Hot Lunch Facility = ‘Yes’, report the following values:

  • If no eligibility record exists OR their Eligibility = Paid, report ‘0’
  • If there is an active eligibility record and Free status, and Special Milk Checkbox is off (unchecked), report code of ‘1’
  • If there is an active eligibility record and Reduced status, and Special Milk checkbox is off (unchecked), report ‘2’.
  • If there is an active eligibility record and Free or Reduced status, and Special Milk checkbox is on (checked), report ‘3’.

If the Hot Lunch Facility = ‘No’, report the following values:

  • If there is an active eligibility record and Free or Reduced Status, report as 3, ignoring the special milk checkbox.

If the Provision field on the School editor is set to CEP, report a 4 for all students.

 If the student has more than one enrollment, report from the Primary Enrollment. 

  •   If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order:
     
    •    S: Ancillary Enrollment
       
       
    • N: Special Education
  •     If the student has multiple enrollments with the same service type, report from earliest enrollment ID. 
  • Use the highest enrollmentID if multiple of same serviceTypes and startDates.

     Scope Year logic is used to determine the posting/updating logic for which year to post/update data to. 

Cposeligibility.eligibility

FRAM > Eligibility > Eligibility

 

If the FRAM Snapshot checkbox is marked.

If Student has a FRAM record as of October 1, report the October 1 Eligibility.
Note: Eligibility = F for Free or R for Reduced

Student does not have to have an active FRAM record at the time of sending the Student Education Organization Demographics resource. If the student has an eligibility ON October 1st, send the Eligibility on that record.
Note: If the student is end dated on October 1, this would still count and send.

New FRAM Eligibility will NOT trigger to send a record until after November 1. Note: Triggering will be turned back on when this tool is unchecked, however, FRAM changes that occurred before the trigger was active again will need a resync.


Note: The dates October 1 through November 1 are hard coded from the state and should not change.

C
FRAM > Eligibility > Eligibility
cohortYears

An unordered collection of studentCohortYears. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

Add four years to the school year when a student enters 9th grade.

If the Grad Year field in Index > Student Information > Graduation > State Reporting is populated, use this field as an override to send for the NCLB Cohort Year value.

M

languagesAn unordered collection of studentLanguages. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.OIdentity. homePrimary LanguageCensus > People > Demographics > Home Primary Language
languageDescriptor
  1. Reports the Code from the Home Primary Language saved on the student's current identity record.
    1. If a match cannot be found, then report from the Ed-Fi Code field.
    2. If  a match cannot be found to a valid  Ed-Fi value, do not report a record
  2. Reports the default value if saved on the Attribute and the code matches an Ed-Fi code. If the Home Primary Language is set as default of 1290, reports as English.
MIdentity. homePrimary LanguageCensus > People > Demographics > Home Primary Language
uses

An unordered collection of studentLanguages.

 If Home Primary Language = NOT NULL, report ‘Home language’.
ON/AN/A
programParticipations

An unordered collection of studentProgramParticipations. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.


 

This element is currently not reported or collected.


O

races

An unordered collection of studentRaces. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.

Logic reports based on the following:

  • Determine the Race/Ethnicity(s) that are checked on the student's current identity record.
    • Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id.
  • Do not report if the person does not have a Race/Ethnicity checked.

This element is an array that reports the following data:

O

IdentityRaceEthnicity

and

Racethnicity.raceId

Census > People > Identities > Race/Ethnicity
raceType

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

Reports the short description from the Race Type page linked under the Type/Descriptor section below based on the mapping provided.

M

IdentityRaceEthnicity

and

Racethnicity.raceId

Census > People > Identities > Race/Ethnicity

characteristics

   

 An unordered collection of studentCharacteristics. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. 

 This field reports the Ed-Fi Code Value from the Student Characteristic. See the Type/Descriptors below.  

 If the student has more than one enrollment, data reports from the Primary Enrollment.  

  • If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order: (1) S: Ancillary Enrollment, (2) N: Special Education.
  • If the student has multiple enrollments with the same service type, report from earliest enrollment id.

If a mapping is not found, data does not report.

This element is an array that reports the following data:

ON/AStudent Information > General > Enrollments > State Reporting.
Student Characteristic Descriptor

This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary education program under the jurisdiction of a school, education agency or other institution or program.

Mprogramparticipation. name
beginDate

The date the characteristic was designated.

 

This field is optional and does not report.

ON/AN/A
endDate

The date the characteristic was removed.

 

This field is optional and does not report.

ON/AN/A
designatedBy

The person, organization or department that designated the characteristic.

 

This field is optional and does not report.

ON/AN/A
immigrant Indicator Descriptor

Reference to the description that best reflects the student's Immigrant status.

  • If there is a code selected for the Immigrant field on the Enrollment record, the Ed-Fi Code reports.
  • If there is no Immigrant code selected, but there is a code for Birth Country,a value of 0 reports.
    • If it is not blank but has a value of 2330 (United States), 1790 (Puerto Rico), 2340 (United States Minor Outlying Islands) or 2310 (Virgin Islands US), a value of 0 reports.
  • If there is no Immigrant Code, and another code other than those listed above for Birth Country, see the Date Entered US Schools field. If this field is blank, a value of 0 reports.
  • If the Date Entered US field contains a date, a calculation is used against a full calendar year.
    • If a student is an immigrant less than 1 year, a value of '1' reports.
    • If a student is an immigrant greater than or equal to 1 year but less than or equal to 3 complete school years, a value of '2' reports.
    • If a student is an immigrant greater than 3 years, a value of '3' reports.

If a value of 3 reports for the student for this year, a value of 3 always reports for the student.

If the student has more than one enrollment, data reports from the primary enrollment.

  • If there is no primary enrollment, data reports from the Ancilarry Enrollment, then the Special Education enrollment.
  • If the student has multiple enrollments with the same service type, data reports from the enrollment with the earliest enrollment ID.
OEnrollment.immigrantStudent Information > General > Enrollments > State Reporting Fields > Immigrant
HighAbility LearnerEligibility

Indicates the student has been identified as a High Ability Learner (does not indicate participation).

Reports True when High Ability Learner is set to 1: Eligibile or 2: Eligible and Participating on the enrollment being reported. Otherwise, reports False.

OEnrollment. giftedTalentedStudent Information > General > Enrollments > High Ability Learner
HighAbility LearnerParticipant

Indicates the student participated in High Ability Learner programs.

Reports True when High Ability Learner is set to 2: Eligible and Participating on the enrollment being reported. Otherwise, reports False

OEnrollment. giftedTalentedStudent Information > General > Enrollments > High Ability Learner
HonorsOr AdvancedPlacement

Student is in grades 9-12 and participated in an honors program or advanced placement classes in accordance with local school board policy.

Reports True when the student meets the following criteria:

  • The student's state grade level is 09, 10, 11, or 12.
  • The student is scheduled in a course that has a Type = HR or AP.
  • The student's roster end date must be null or equal to the term end date to qualify.

Otherwise, reports False.

O

Course.Type

Enrollment.grade

Scheduling > Courses > Type

Student > General > Enrollment > General Enrollment Information > Grade

limitedEnglish
Proficiency Descriptor

An indication that the student has sufficient difficulty speaking, reading, writing, or understanding the English language, as to require special English Language services. Logic reports based on the following:

  • Reports 11 when the student has active EL Record.
  • Reports 12 when the parent Declined checkbox is checked and a date is entered in the Parent Declined Date field.
  • Reports 13 when the Program Status is Exited EL and an Exit Date is present, even if parent declined is marked on the record.
  • Reports 14 if the student does not have a record in EL State Reporting.

See the Type/Descriptors below.

O



Student Information > Program Participation > English Learners (EL) > EL
etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Types/Descriptors

Click here to expand...
 

The highlighted column indicates the reported value.


This table describes the Ed-Fi Value mapped and reported for Race Type:

Code in CampusRace/Ethnicity in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short Description
3Black or African American3

Black - African American

Black - African American 
1American Indian or Alaska Native 1American Indian - Alaskan NativeAmerican Indian - Alaskan Native 
4Native Hawaiian or Other Pacific Islander 4Native Hawaiian - Pacific IslanderNative Hawaiian - Pacific Islanders 
5White 5WhiteWhite 
2Asian 2AsianAsian 


This table describes the Ed-Fi Value mapped and reported for Language Type:

Campus CodeEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
eng
EnglishEnglishEnglish
spa
SpanishSpanishSpanish
All other codes
OtherOtherOther


This table describes the Ed-Fi Value mapped and reported for School Food Service Eligibility:

Ed-Fi Code ValueEd-Short DescriptionEd-Fi Description
0Not eligible for Free or Reduced Price MealsNot eligible for Free or Reduced Price Meals
1Eligible for Free MealsEligible for Free Meals
2Eligible for Reduced Price MealsEligible for Reduced Price Meals
3Eligible for Free Special MilkEligible for Free Special Milk
4Eligible for Community Eligibility ProvisionEligible for Community Eligibility Provision


This table describes the Ed-Fi Value mapped and reported for Immigrant:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
0Not an ImmigrantNot an Immigrant
1Immigrant LT 1 year (new immigrant)Immigrant LT 1 year (new immigrant)
2Immigrant GT = 1 year but LT = 3 complete school yearsImmigrant GT = 1 year but LT = 3 complete school years3
3Immigrant GT 3 yearsImmigrant GT 3 years


This table describes the Ed-Fi Value mapped and reported for  Limited English Proficient Descriptor: 

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
11English Learner, Receiving ServicesEnglish Learner, Receiving Services
12English Learner, Parent Opted Out Of ServicesEnglish Learner, Parent Opted Out Of Services
13Reclassified as English FluentReclassified as English Fluent
14Not an English LearnerNot an English Learner


 
 
 

This table describes the Ed-Fi Value mapped and reported for Student Characteristics:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi DescriptionLogic
 01AsyleeAsylee
02Displaced HomemakerDisplaced Homemaker
03Foster CareFoster Care
06Neglected or DelinquentNeglected or Delinquent
07MigrantMigrant
08Parent in MilitaryParent in Military
  1. If a district IS NOT using 'Military Connections'
    1. Short Description in Swagger = 'Parent in Military'
      1. Flag must have Military in the name.
      2. Flag must have overlapping dates with the students most current enrollment record.
  2. If a district IS using 'Military Connections'
    1. Short Description in Swagger = 'Parent in Military'
      1. If a student has a parent or guardian with a record on the 'Military Connections' tab (index> Census> People> Military Connections).
        1. Must be Military Connected in the most recent active enrollment for the student.
      2. Student may have the record for 'Military Connections' on their person record.
        1. If the students parent or guardian does not have the 'Military Connections' record but the student does, report that the student is Military Connected.
          1. Record must be active during the most recent active enrollment.
      3. Only two statuses can be counted as Active Military:
        1. Active Duty - Deployed
        2. Active Duty - Not Deployed
09PregnantPregnant
10RefugeeRefugee
12Single ParentSingle Parent
13Unaccompanied YouthUnaccompanied Youth
14LEAPs ParticipantLEAPs Participant
34Attended PreschoolAttended Preschool
35High MobilityHigh Mobility
36Ward of the StateWard of the StateReports if Ward of State checkbox is checked on enrollment.
37Foregin ExchangeForeign ExchangeReports if Admission Status = 1 on enrollment.
38Directory Information Opt OutDirectory Information Opt OutReports if Directory Opt Out is checked on enrollment.

Student Homeless Program Association

This associations captures homeless data separately from the Student resources. 

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

A record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

  •  The related pair start date must be null or on/before the scope year end date to report.   
     
  •   The related pair end date must be null or on/after the scope year end date to report.  

Data will only send for the years that have valid configuration.

A resync must be completed on the resource when a new scope year is configured in order for this data to send.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  •   Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Homeless Program Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
educationOrganization Reference

The education organization where the student is participating in or receiving the program services.

Reports District ID + 000.

MDistrict.number

System Administration > Resources > District Information > State District Number

programReference

A reference to the related Program resource.

Reports the Natural Key from the Programs Resource.

  • For programReference Type, report 'Other'
  • For programReference Name, report 'Homeless'
MN/AN/A
studentReference

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
beginDateReports the start date of when the student was identified as being homeless.Mhomeless.startDateStudent Information > Program Participation > Homeless > Start Date
endDateReports the end date of when the student was no longer considered to be homeless.Mhomeless.endDateStudent Information > Program Participation > Homeless > End Date
reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

 

This field is optional and does not report.

ON/AN/A
servedOutsideOfRegular Session

Indicates whether the student received services during the summer session or between sessions.

 

This field is optional and does not report.

ON/AN/A
primaryNighttime Resident

Best describes the student's living situation at the time the student was identified as homeless.

Reports the Ed-Fi Code from the value selected in the dropdown list on the Homeless tab. If the field is blank value does not report.

OHomeless.primaryNight TimeResidenceStudent Information > Program Participation > Homeless > Primary Nighttime Residence
unaccompaniedYouthIndicates whether or not the student, if homeless, is an unaccompoanied youth.
Homeless. unaccompaniedYouthStudent Information > Program Participation > Homeless > Unaccompanied Youth
services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.

 

This field is optional and does not report.

ON/AN/A

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Primary Nighttime Residence:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
 01SheltersShelters
 02Doubled Up
Doubled Up
 03UnshelteredUnsheltered
 05Hotel or Motel
Hotel or Motel

Student Parent Association

This association relates students to their parents, guardians or caretakers.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When the Guardian check box is checked AND one person is a student and one person is not a student.

  • The guardian does NOT have to be a member of the same household as the student to report.
  •  Start date must be on or before today's date. 
  •   End date must be on or after today's date.  

  A record is not sent if the student to which they are associated has an enrollment marked as No Show, State Exclude or the enrollment is in a calendar marked as Exclude.
 
 

PutWhen the Guardian check box is checked or relationship type is changed.
DeleteWhen the Guardian check box is unchecked, relationship is end dated or deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

A record will report when they are a guardian to a student with an enrollment aligned to a scoped year.

  •  The related pair start date must be null or on/before the scope year end date to report.   
     
  •   The related pair end date must be null or on/after the scope year end date to report.  

Data will only send for the years that have valid configuration.

A resync must be completed on the resource when a new scope year is configured in order for this data to send.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

  •  Current Year:  The records start date must be on or before today's date and the records end date must be on or after today's date.
  •   Previous Years:  The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor.  If blank, the default date of 6/30/xxxx is used.  
  •    Future Years:  The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor.  If blank, the default date of 7/01/xxxx is used.   

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Parent Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
 parentReference 

Reports the fields that are part of the Natural Key for the      Parents resource  

  •  parentUniqueId 
MN/AN/A
 studentReference 

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
relationType

The nature of an individual's relationship to a student.

  1. Report the Ed-Fi Code from the Ed-Fi Relation Type field that is mapped .
  2. If no mapping, do not report

 See the Relatiionship Type table in the section below for the Ed-Fi value that reports.

ORelatedPair.nameCensus > People > Relationships > Relationship
primaryContactStatus

Indicator of whether the person is a primary parental contact for the student.

This element reports True if the Guardian checkbox is marked on the Relationships tab. If the student has more than one guardian, the guardian with the earliest start date is reported. If start dates are the same or null for two guardians, the guardian with the lowest personID is reported.

ON/ACensus > People > Relationships > Guardian
livesWith

Indicator of whether the student lives with the associated parent. This element reports True if the student is in the same household of the parent being reported. Otherwise, reports False.

  • Both Student and Parent Household start date must be null or on/before the scope year end date to report.
  • Both Student and Parent Household end date must be null or on/after the scope year end date to report.
ON/ACensus > People > Households
emergency
ContactStatus
Indicator of whether the person is a designated emergency contact for the student. This element reports True if there is a number entered in the Emergency Priority field for the parent being reported. Otherwise, reports False.
ON/ACensus > People > Relationships > Emergency Priority
contactPriority

The numeric order of the preferred sequence or priority of contact. 

 

This data is not collected in Campus is not reported.

O N/AN/A 
contactRestrictions

Restrictions for student and/or teacher contact with the individual.

 

This data is not collected in Campus is not reported.

N/AN/A 
etagA unique system-generated value that identifies the version of the resource. N/AN/A

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Relationship Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

AuntAunt

BrotherBrother

BrotherInLawBrotherInLaw

CourtAppointedGuardianCourtAppointedGuardian

CousinCousin

DaughterDaughter

DaughterInLawDaughterInLaw

EmployerEmployer

FatherFather

Father, stepFather, step

FathersSignificantOtherFathersSignificantOther

FathersCivilPartnerFathersCivilPartner

FatherInLawFatherInLaw

FianceFiance

FianceeFiancee

Foster parentFoster parent

FriendFriend

GrandfatherGrandfather

GrandmotherGrandmother

Great auntGreat aunt

Great uncleGreat uncle

Great GrandparentGreat Grandparent

HusbandHusband

MothersSignificantOtherMothersSignificantOther

MotherMother

Mother, stepMother, step

MothersCivilPartnerMothersCivilPartner

NephewNephew

NieceNiece

OtherOther

SignificantOtherSignificantOther

SisterSister

SonSon

UnknownUnknown

UncleUncle

WardWard

WifeWife

Student Program Association 

 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

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
PostWhen a student has a EL Program Status = EL and the record overlaps the configured year
Post

When Flag is created and it is mapped to an Ed-FI Program Type and the record overlaps the configured year.

  • Do not create a record when the Flag is mapped to Title I Part A or Special Education
PutWhen either the student is given an EL Exit Date or an End Date on a reported Flag.
Delete/Post

When part of the records Natural Key changes.

  • When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post.
DeleteWhen a student's EL record is deleted or when the record no longer overlaps the configured year.
DeleteWhen a Flag is deleted or when the record no longer overlaps the configured year.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

The record will send to the scope year for the school year the enrollment is associated with.

Data will only send for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Parent Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
 educationOrganizationReference

A reference to the related EducationOrganization resource.

Report the Ed-Fi District Number that the reporting enrollment is associated with + 000

M

 programReference

A reference to the related Program resource.

Reports the Program reference.

M

studentReference

A reference to the related Student resource.

Reports the Student Reference

M

beginDate

The month, day, and year on which the Student first received services.

  1. Report the Identified Date when reporting from EL.
  2. Report the Start Date when reporting from Flags.
M


Title I, Section 504:
Student Information > General > Enrollments > Start Date

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

  1. Report the Exit Date when reporting from EL.
  2. Else, report the End Date when reporting from Flags.
O
Title I, Section 504:
Student Information > General > Enrollments > Start Date
reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

 

This field is optional and does not report.

O

servedOutsideOfRegularSession

Indicates whether the student received services during the summer session or between sessions.

 

This field is optional and does not report.

O

enrollmentStatus

Indicates the status of the student's enrollment.

 

This field is optional and does not report.

O

services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.

 

This field is optional and does not report.

O


Student School Association

This association represents the school in which a student is enrolled.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student or the No Show or State Exclude check box is unchecked.

  •  Do not post a record when the No Show or State Exclude check box is checked before initial save   . 
  •  When a student has two enrollments in the same school for the same start date, reports from the enrollment service type in the following order: 
    •  P: Prmary Enrollment 
    •  S: Partial/Ancillary 
    •  N: Special Ed Services 
  •  When an enrollment with a higher priority is deleted, the enrollment with the lower priority posts a new record. 
  •  Records are not sent if the Calendar Exclude checkbox is marked in the calendar in which the student is enrolled. 
  • Records are not sent if the School Exclude checkbox is marked in the calendar in which the student is enrolled. 
Post

When an enrollment record Start Date is modified.

When an enrollment with a lower priority is changed, data is not sent.

Post

When School of Assignment is populated from Null.

When School of Assignment is changed to a different value or blank.

PutWhen an enrollment is updated for a student.
PutWhen a change is made to the Graduation > NCLB Cohort End Year field.
PutWhen a student is  assigned to a Graduation or CTE Program or the start and /or end dates are modified.
Delete

When an enrollment is deleted or the No Show or State Exclude check box is checked on an existing enrollment.

When a student has two enrollments in the same school for the same start date, records with lower priority do not trigger a delete.

DeleteWhen the start date of an enrollment is changed.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

The record will send to the scope year for the school year the enrollment is associated with.

Data will only send for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student School Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
graduationPlan
Reference

A reference to the related GraduationPlan resource.

 

This is optional and does not report.

ON/AN/A
  schoolReference  

Reports the fields that are part of the Natural Key for the School resource:

  •   schoolReference  
  •     studentReference    
  •       entryDate      
MN/AN/A
classOfSchool
YearTypeReference

The year the student is expected to graduate.

 

This is optional and does not report.

ON/AN/A
schoolYearType
Reference

The school year the student is being reported in.

 

This is optional and does not report.

ON/AN/A
calendarReference

A reference to the Calendar resource.

  • beginDate
  • name
  • schoolID
R

Calendar.startDate

Calendar.name

School.stateSchoolNumber

System Administration > Calendar > Calendar > Start Date, Name

System Administration > Resources > School > State School Number

reportingSchoolReference

A reference to the related School resource.

  • Reports the School ID.
  • If the School of Assignment field is populated, reports the value in the School of Assignment field.
RSchool.stateSchoolNumber

System Administration > Resources > School > State School Number

or

Student Information > General > Enrollments > School of Assignment

  studentReference  

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
  entryDate  The month, day, and year on which an individual enters and begins to receive instructional services in a campus. MEnrollment.startDateStudent Information > General > Enrollments > Start Date
entryGradeLevel
Descriptor

The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.

Reports the Ed-Fi Code from the studentGradeLevel that is assigned to the gradelevel of the students current active enrollment.

MEnrollment.gradeStudent Information > General > Enrollments > Grade
entryGradeLevel
ReasonType

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

 

This is optional and does not report.

ON/AN/A
entryTypeDescriptor

Reports the enrollment entry status for a student. The Ed-Fi code value from the Start Status selected in the enrollment reports. If blank, data does not report. See the Type/Descriptor section below.

OEnrollment.
startStatus
Student Information > General > Enrollments > Start Status
repeatGradeIndicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.

 

This is optional and does not report.

ON/AN/A
schoolChoiceTransfer

An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116.

 

This is optional and does not report.

ON/AN/A
exitWithdrawDateThe month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.
OEnrollment.endDateStudent Information > General > Enrollments > End Date
exitWithdrawType
Descriptor

Reports the enrollment exist status for the student. Reports the Ed-Fi Code Value from the End Status selected in the enrollment record. If blank, data does not report.

OEnrollment.endStatusStudent Informaton > General > Enrollments > End Status
residencyStatus
Descriptor

 Reports the Ed-Fi Code Value from the Resident Status field selected on the enrollment record. If blank, data does not report.
 

OEnrollment.stateAidStudent Information > General > Enrollments > Resident Status
districtOfResidence

This association indicates any relationship between a student and an education organization other than however the state views enrollment.

Reports the district number selected in the Home District field on the enrollment being reported. Reports the default value if populate.

If the Home District is NULL, reports the District Number of where the student is enrolled.

District number format is in XX-XXXX.

M

Enrollment.residentDistrict

District.Number

Student Information > General > Enrollments > Home District

System Administration > Resources > District > District Number

fullTimeEquivalency

Reports the enrollment percentage for a student from the enrollment.

Reports the default value is populated. If null, reports 100.

MEnrollment. percentEnrolledStudent Information > General > Enrollments > Percent Enrolled
schoolOfResidence

Reports the the District Number and School Number on the student's enrollment. Report as xx-xxxx-xxx. Example: District Number 280017 + School Number 007 will report as 28-0017-007.

If Resident School is populated, report this as an override for SchoolofResidence.

Reports as blank if a School of Assignment is selected.

MN/AStudent Information > General > Enrollments
ExcpectedHighSchoolofGraduation

An indication of where the student is expected to graduate from.

If the student is expected to graduate from a High School that the student is currently NOT enrolled in, report that information from the Expected Grad High School field on enrollment.

If the student will be graduating from the school they are currently enrolled in, we do not need to report this field.

CN/AStudent Info> General> Enrollment> State Reporting> Expected Grad High School
primarySchoolIndicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. This element reports a value of True if Service Type = P: Primary.OEnrollment.typeStudent Information > General > Enrollments > Service Type
employedWhile
Enrolled

An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education.

 

This is optional and does not report.

ON/AN/A
educationPlans

An unordered collection of studentSchoolAssociationEducationPlans. This association represents the school in which a student is enrolled.

 

This is optional and does not report.

ArrayN/AN/A
etagA unique system-generated value that identifies the version of the resource.ON/AN/A

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Entry Type Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
100Still EnrolledStill Enrolled
101Original EntryOriginal Entry
102Transfer InTransfer In
103Re-entryRe-entry

This table describes the Ed-Fi Value mapped and reported for Exit Withdraw:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
200Transfer Out; Intra-DistrictTransfer Out;Intra-District
201Transfer OutTransfer Out
202Drop OutDrop Out
203Completer: DiplomaCompleter: Diploma
204Completer: No DiplomaCompleter: No Diploma
205Not Enrolled; Eligible to ReturnNo Enrolled; Eligible to Return
206DeceasedDeceased
208Maximum AgeMaximum Age
209Withdrawal from Mandatory AttendanceWithdrawal from Mandatory Attendance
299End of School YearEnd of School Year

This table describes the Ed-Fi Value mapped and reported for Residency Status:

Ed-Fi Code ValueEd-Fi Short Description Ed-Fi Description

00

Not applicable

Not applicable

01Contracted in from another Nebraska public school districtContracted in from another Nebraska public school district
02Contracted in from nonpublic schoolContracted in from nonpublic school
03Contracted in from another stateContracted in from another state
05Contracted out to another Nebraska public school districtContracted out to another Nebraska public school district
06Optioning in from another Nebraska public school districtOptioning in from another Nebraska public school district
07Contracted out to another stateContracted out to another state
08Learning Community Open EnrollmentLearning Community Open Enrollment

Student School Attendance Event

This event entity represents the recording of whether a student is in attendance on a daily basis at their school.

Object Triggering Logic

Click here to expand...
ActionTrigger
Post

When a new attendance event is verified for a student based on data in the attendanceExcuse table 

  • Reports attendance for each school for which the student has a Student School Association record.
  • Attendance date must fall on or between enrollment start and end dates.
  • Unknown attendance events are not sent. The original post does not appear untl an excuseID is entered in the attendanceExcuse table.
  • Records are not sent if the student's enrollment is marked as a No Show or State Exclude.
  • Records are not sent if attendance records are associated with a Calendar marked as Exclude.
  • A record is sent for each district school, date and attendance event category descriptor.
Delete/Post

N/A - only deletes and posts are sent for this resource. 

  •  If an attendance status is changed, the first event must be deleted from ed-fi and a new record sent.  The Attendance Event Category Descriptor is a primary key and does now allow updates in Ed-Fi.  
Delete/PostIf any part of the natural key is changed:  Section Reference, Student Reference, Event Date, Attendance Event Category Descriptor.
DeleteDelete attendance record if all attendance is removed for the day.
DeleteWhen an enrollment is deleted or the No Show or State Exclude checkboxes are marked.
 

Each calendar must be set with an attendance type to determine if the Student School Attendance Event or Student Section Attendance Event resource should be sent. 

Regardless of the Attendance Type droplist in the UI, a studentSchoolAttendanceEvents record is always sent  for all valid attendance records, and an additional studentSectionAttendanceEvent record is sent if section attendance is taken.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Attendance sends to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
Data only sends for the years that have valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student School Attendance Event resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
  schoolReference  

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

  •  entityID 
MN/AN/A
  sessionReference  

Reports the fields that are part of the Natural Key for the Sessions resource:

  • id
  •  schoolReference 
  •   schoolYearTypeReference  
  •   termType  
  •   name  

  Only reports the Term Type from the Terms tab that is associated with the date for which the attendance is being reported.
 
 

MN/AN/A
  studentReference  

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueId
MN/AN/A
  eventDate  Date for this attendance event. MN/AN/A
attendanceEvent CategoryDescriptorReport the Ed-Fi Code from the Attendance Event Category Descriptor below based when the student has an attendance record with the following attendance status and excuse:
  • Report '02' when the status = A and excuse = E
  • Report '03' when the status = A and excuse = U
  • Report '04' when the status = T and excuse is = E or U
MN/AN/A
attendanceEvent Reason

The reported reason for a student's absence.

 

This field is optional and does not report. 


ON/AN/A
attendanceDuration

The portion of the day to which the attendance event applies. A value of 1.00 would indicate that the event was for the entire school day. A value of 0.25 would indicate that the event was for one quarter of the school day. If a day is marked as less than a whole day, the students max absence for that day cannot exceed that days time percentage.

Note: The calculation is based ONLY on class period minutes.

  1. If a student day is marked as shortened either with the shortened day code or with or codes that indicate a shortened day.
    1. Code = 03, 04, 05, 06, 07, 08, 09, 11 (non-edfi)
  2. If Duration Minutes are less than the full day minutes.
  3. If there is not a Period Schedule to indicate a full day with shortened minutes.
    1. All periods are present with sorter time frames.
  • Calculation: (Total absence minutes) / (Total rostered Instructional minutes)
  1. Subtract any Present Minutes from the Total Absence Minutes value, if they are entered for an absence period.
  2. The calculation starts by adding the minutes between start and end times of the periods and processes through. Passing minutes, lunch minutes and non-instructional period minutes do not count.  Minutes for periods that are instructional where the student is not rostered in a course also do not count for that student.
  • Rounding: Round to the nearest hundredths value.
CN/AN/A
educational
EnvironmentType

The educational environment.

 

This field is optional and does not report.

ON/AN/A
absenceAmount Descriptor

Reports the absent amount for the student for a day. 

 

This field is optional and does not report.

ON/AN/A
instructionalMinutes

Reports the positive attendance minutes of instruction for a student for a day. 

 

This field is optional and does not report.


ON/AN/A
etagA unique system-generated value that identifies the version of the resourceON/AN/A

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Attendance Event Category Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
02Excused AbsenceExcused Absence
03Unexcused AbsenceUnexcused Absence
04TardyTardy
 

The following Ed-Fi values are not reported:

  • 01 - In Attendance
  • 05 - Early Departure

Student Section Association

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new attendance event is verified for a student on the course section and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code.

  •  A record reports for each section record this reported based on the Sections logic.
     
  •  If the roster start date is after the term end date, a record does not report for the prior term,
     
  •  Records are only sent if the student has an enrollment in the schedule structure where the student is scheduled and is not marked as No Show or State Exclude.
     
  •  Records are not sent if the Calendar Exclude checkbox is marked. 
PostSend a new record if a student's roster start date is changed.
Put

When section information is updated for a student or section.

  •  Update when the course or section's homeroom field is changed


DeleteWhen a student is deleted from a course section.
Delete

Delete any future records if the student is given a roster end date for the course.

  •  Roster End Date must be before Term Start date of future records 
DeleteDelete the record if a student's roster start date is changed

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Reports records in the scope year the course/section's calendar is aligned to.

Data will only send for the years that have valid configuration.

Future Years data will be suppressed until the Active Year is changed:

  •  This allows the Schedule Wizard to be used and reducing the number of records sent until the final schedule is completed.
  •   A resync must be done after the Active Year is changed to send data.  

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Section Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
 sectionReference 

Reports the fields that are part of the Natural Key for the Section resource:

  •  id 
  •    classPeriodReference   
  •     courseOfferingReference    
  •      locationReference     
  •       schoolReference      
  •        sessionReference       
MN/AN/A
  studentReference  

 Reports the fields that are part of the Natural Key for the Student resource :

  • studentUniqueId
MN/AN/A
 beginDate 

Month, day and year of the student''s entry or assignment to the section. If blank, default is the start date of the first grading period. Logic reports based on the following:

  • Reports the roster start date for the term record in which the start date occurs.
    • For any records in the future terms for that course, use the term start date.
  • If Start Date is NULL, reports the term start date associated with the term descriptor selected for this section based on section schedule placement.
M

Enrollment.startDate

Terms.startDate

Student Information > General > Enrollments > Start Date

OR

Student Information > General > Enrollments > Start Date

OR

System Administration > Calendar > Calendar > Terms

endDate

Month, day, and year of the withdrawal or exit of the student from the section. Logic reports based on the following: 

  • Report the roster end date for the student.
    • If a roster end date is entered, delete any records for future terms for that section.
  • If NULL, report the latest term start date associated with the term descriptor selected for this section based on the section schedule placement.
O

Roster.endDate

Terms.endDate

Student Information > General > Schedule > Roster End Date

OR

System Administration > Calendar > Calendar > Terms

homeroomIndicatorIndicator that the class is the student's designated homeroom used for daily attendance reporting. This element reports a value of True if the Homeroom checkbox is marked on the section or the course to which the section is assigned.O

Course.homeroom

Section.homeroom

Scheduling > Course > Homeroom

or

Scheduling > Course > Section > Homeroom

repeatIdentifierType

An indication as to whether a student has previously taken a given course.

 

This element is currently not reported or collected.

ON/AN/A
teacherStudent
DataLinkExclusion

Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

 

This element is currently not reported or collected.

ON/AN/A
etagA unique system-generated value that identifies the version of the resource. ON/AN/A

Student Section Attendance Event

This event entity represents the recording of whether a student is in attendance for a class.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new attendance event is verified for a student in a course section.

  • The student must have a Student Section Association record to report.
  • Unknown attendance events do not send an event to Ed-Fi. The original post does not trigger until an excuseID is entered in the attendance table.
  • Records are not sent if the student's enrollment is marked as a No Show or State Eclude.
  • Records are not sent if the attendance records are associated with a Calendar marked as Exclude.
  • A record is sent for each distinct date, section and attendance event category descriptor.
  • Records are not sent if the course does not have a State Course Code.
Put

N/A - Only deletes and posts are sent for this resource.

If an attendance status is changed, the first event must be deleted from Ed-Fi and a new record sent. The Attendance Event Category Descriptor is a primary key and does not allow updates in Ed-Fi.

DeleteWhen an attendance record for all of the attendance is removed for the date.
DeleteWhen an enrollment is deleted or the No Show or State Exclude checkboxes are marked.
DeleteWhen a student is removed from the course section.
 

Each calendar must be set with an attendance type to determine if the Student School Attendance Event or Student Section Attendance Event resource should be sent. 

Regardless of the Attendance Type droplist in the UI, a studentSchoolAttendanceEvents record is always sent  for all valid attendance records, and an additional studentSectionAttendanceEvent record is sent if section attendance is taken.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Attendance is only sent to the scope year for the school year associated with the attendance dates, based on the student's enrollment.
Data only sends for the years that have valid configurations

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Section Attendance Event resource.

Data ElementDescriptionCampus DatabaseCampus GUI Location
id  The unique identifier of the resource  MN/AN/A
sectionReference

A reference to the related Section resource.

Reports the fields that are part of the Natural Key for the Section resource:

  • classPeriodReference
  • courseOfferingReference
  • locationReference
  • schoolReference
  • sessionRefreince
MN/AN/A
studentReference

A reference to the related Student resource.

Reports the fields that are part of the Natural Key for the Student resource:

  • studentUniqueID
MN/AN/A
eventDate

Reports the date for the attendance event.

MN/AN/A
attendanceEvent CategoryDescriptor

Reports when a student has a verified attendance mark for a course section:

  • Reports 02 when status is A and excuse is E.
  • Reports 03 when status is A and excuse is U.
  • Reports 04 when status is T and Excuse is E or U.

See the Type/Description section below for accepted values.

MN/AN/A
attendanceEventReason

The reported reason for a student's absence.

 

This field is optional and does not report. 

 ON/AN/A
educationalEnvironment Type
 

 Reports the key for EducationalEnvironment.  

 

This field is optional and does not report.

 ON/AN/A
etag

A unique system-generated value that identifies the version of the resource.

 

This field is optional and does not report.

 ON/A N/A 

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Attendance Event Category Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionDescription

02

Excused Absence

Excused Absence

03

Unexcused Absence

Unexcused Absence

04

Tardy

Tardy

The following codes do not report:

01

In Attendance

In Attendance

05

Early Departure

Early Departure


Student Special Education Program Association

This entity reports the Special Education data for a student.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an IEP is created, active, and locked for a student.

  • The IEP start and end dates must overlap the enrollment.
  • If the student has multiple enrollments that are overlapping in the same school, information reports based on the primacy of Service Type (P: Primary, S: Partial, N: Special Ed).
  • If the student only has one enrollment, a record reports regardless of Service Type.
  • A record does not send for an enrollment that is marked as State Exclude or No Show.
  • A record does not send if an enrollment is in a calendar marked as Exclude.
Post

When a new enrollment is created for a student who has an active IEP.

  • Enrollment start date must be after the IEP start date.
  • IEP end date must be NULL or after the Enrollment Start Date.
Delete/Post

When any part of the natural key is changed.

  • When a SPED Setting is changed in an existing IEP and is relocked
  • When a SPED Entry Date is changed
Put

When any field that is not part of the natural key is changed, including the following:

  • End Date
  • Reason Exited Descriptor
  • Level of Program Participation Descriptor
  • Placement Type Descriptor
  • Special Education Percentage
  • To Take Alternate Assessment
  • Service Descriptor
  • Service Begin Date
  • Service End Date
DeleteWhen an IEP is deleted for a student
DeleteWhen a SPED Setting is changed for a student
DeleteWhen a SPED Entry Date is changed for a student
DeleteWhen all overlapping enrollments are deleted for a school

Note: Disability is not a primary key and is only conditional.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

When a new IEP is created, the record reports in the Scope Year in which the IEP Start Date overlaps.

The start date must be on or before the School Year End Date. If the School Year End Date is NULL, 6/30/XXXX is used as the default date.

When the record is triggered from enrollments, the record sends to the scope year for the school year for which the enrollment is associated.

Data only sends for the years that have valid configurations

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Special Education Program Association resource.

Data ElementDescriptionCampus DatabaseCampus GUI Location
id  The unique identifier of the resource  MN/AN/A
studentUniqueID

 A unique alphanumeric code assigned to the student.

Reports the Ed-Fi ID for the student.

 
MPerson.edFiIDCensus > People > Demographics > Ed-Fi ID
programType

The program associated with the student.

Reports 'Special Education' for all records.

 
MN/AN/A
programEducation OrganizationId

The education organization where the student is participating in or receiving the program services.

Reports the State District Number, which is right 0-padded to be 9 digits.

 M District.numberSystem Administration > Resources > District Information > State District Number
beginDate

 The month, day, and year on which the student first received services. NEDM: Beginning Date.

  • Looks at the most recent locked IEP Enrollment Status 'Entry Date' for the IEP first. If this field is populated, the entered date reports.
  • If the Entry Date is NULL, the Entry Date on the Special Ed Enrollment Editor reports.
  • If  the Special Ed Enrollment Editor Entry Date field is NULL, all calendars for all grades within student's enrollment history are reivewed to verify first locked reported IEP of IFSP. The date reported should be the start date located in the Education Plan editor for both the IEP and the IFSP.
 
 M

Enrollment.sped EntryDate

Plan.startDate

Student Information > General > Enrollments > Special Ed Fields > Entry Date

Student Information > Special Education > Documents > Plan > Current Plan >Education Plan > Start Date

programName

The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies  Programs are preloaded by NDE.  Report Name from provided list from NDE.

Reports 'Special Education' for all records.

 
MN/AN/A
educationOrganizationId

The education organization where the student is participating in or receiving the program services.

Reports the School number for the associated student's enrollment. The School ID is a concatenation of the State District Number + State School Number.

If the program is SPED, 504, Title I part A or Homeless, reports only District ID + 000.

 M

 District.number

School.number

System Administration > Resources > District Information > State District Number

System Administration > Resources > School > State School Number

endDate

 The month, day, and year on which the student exited the program or stopped receiving services.

Report the Special Ed Exit Date if populated on the overlapping enrollment record.

  • If a new enrollment record is created with a Start Date after the Special Ed Exit Date, and the enrollment overlaps the locked IEP, then report the Special Ed Exit Date from the new enrollment; If NULL, report End Date as blank.
  • If a new enrollment record is created that does not overlap the IEP, do not update the endDate.
  • If the enrollment is deleted, the end date reported would revert to the value saved in the previous (overlapping) enrollment.
  • When a student has an IEP that overlaps two or more school years,  look at the enrollments in the current active school year and order them by service type to find the Exit Date. The Exit Date should report as the the earliest and highest ordered enrollments Exit Date.
 CEnrollment.spedExitDateStudent Information > General > Enrollment > Special Ed > Exit Date
reasonExitedDescriptor

Reports the rason the student exited from SPED. 

Reports the Ed-Fi Code from the Special Ed Exit Reason if populated on the overlapping enrollment being reported.

  • If a new enrollment record is created with a Start Date after the Special Ed Exit Date, and the enrollment overlaps the locked IEP, then report the Special Ed Exit Reason from the new enrollment; If NULL, report Special Ed Exit Reason as blank.
  • If a new enrollment record is created that does not overlap the IEP, do nothing;
  • If the enrollment is deleted, the Special Ed Exit Reason reported would revert to the value saved in the previous (overlapping) enrollment.

See the Reason Exited Descriptor below for code mapping.

 
 CEnrollment.spedExitReasonStudent Information > General > Enrollment > Special Ed > Special Ed Exit Reason
servedOutside OfRegularSession

 Indicates whether the student received services during the summer session or between sessions. 

 

This field is optional and does not report.

 

ON/A N/A 
ideaEligibility

Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).

 

This field is optional and does not report.


 ON/A N/A 
specialEducation SettingDescriptor

Reports the Special Education setting for the student.

Reports the Ed-Fi code from the Special Ed Setting code selected in the locked IEP being reported.

See the Special Ed Setting Descriptor below for code mapping.

MEnrollment.spedSetting

Student Information > Special Education > Documents > Plan

Student Information > General > Enrollment > Special Ed Fields > Special Ed Setting

specialEducationHours PerWeek

The number of hours per week for special education instruction and therapy.

 

This field is optional and does not report.

ON/AN/A
schoolHoursPerWeek

Indicate the total number of hours of instructional time per week for the school that the student attends.

 

This field is optional and does not report.

ON/AN/A
multiplyDisabled

Indicates whether the student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee.

 

This field is optional and does not report.

ON/AN/A
medicallyFragile

Indicates whether the student receiving special education and related services is: 1) in the age range of birth to 22 years, and 2) has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and 3) requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and 4) lives with ongoing threat to his or her continued well-being.

 

This field is optional and does not report.

ON/AN/A
lastEvaluationDate

The date of the last special education evaluation.

 

This field is optional and does not report.

ON/AN/A
iepReviewDate

The date of the last IEP review.

 

This field is optional and does not report.

ON/AN/A
iepBeginDate

The effective date of the most recent IEP.

 

This field is optional and does not report.

ON/AN/A
iepEndDate

The end date of the most recent IEP.

 

This field is optional and does not report.

ON/AN/A
levelOfProgram ParticipationDescriptor

Provides additional information regarding the student's level of participation in the program.

Reports the value based on the student's age as of August 31st of the reporting year

  • If the student is/will be 3 years of age or older as of August 31st, then report out '05.
  • If the student is/will be younger than 3 years of age as of Augst 31st, then report out '06'.

See the Level of Program Participation Descriptor below for code mapping.

MN/AN/A
placementTypeDescriptor

Indicates placement type of the student.

Reports the Ed-Fi code from the Primary Placement Type selected in the enrollment being reported. If blank, report '0'.

See the Placement Type Descriptor below for code mapping.

MEnrollment.spedPrimary PlacementTypeStudent Information > General > Enrollment > Special Ed Fields > Primary Placement Type
specialEducationPercentage

The percentage of time the student spends receiving special education and/or related services separate from general education peers.

Reports the value entered in this field for the enrollment that overlaps with the locked IEP. Otherwise, reports '0'.

MEnrollment.spedWoPeersStudent Information > General > Enrollment > Special Ed Fields > Special Ed Without Peers
toTakeAlternateAssessment

 Indicates the student needs alternate assessment.

Reports based on the locked IEP:

  • If the locked IEP has at least one District Wide assessment  with the 'Alternate Assessment' checkbox selected, reports "True".
  • If the Alternate Assessment' checkbox is not selected, OR there is no IEP, report "False".
MPlan.alternateAssessmentsStudent Information > Special Ed > Documents > Plan > District Wide Assessments > Alternate Assessments
services

An unordered collection of studentProgramAssociationServices. This association represents the Special Education program(s) that a student participates in or receives services from. 

  1. If a student has multiple services of the same type in one IEP (start or end dates are within the start and end dates of the IEP)

    1. Report the service as one service.
      1. If there are date gaps in the service offering, still report it as one service.
  2. If there are two of the same services but they are active in two different IEPs, report them separately.
    1. Only one service of a type can be reported along with an IEP.
      1. If an IEP changes, it can have a new service.

 This element reports an array of the following data elements:

Note: In order to map Ed-Fi codes to state codes for services, see the Additional Logic and Considerations section at the bottom of the page.

ON/AN/A
serviceDescriptorWhen the locked IEP contains services with an EdFi code value. Otherwise, ignore the record.MPlan.relatedServicesStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services
primaryIndicatorThis field does not report.ON/AN/A
serviceBeginDateReport the Start Date value of the service being reportedOPlan.relatedServicesStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services
serviceEndDateReport the End Date value of the service being reported
Plan.relatedServicesStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services

disabilities





An unordered collection of studentDisabilities. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program.  

Reports the Ed-Fi Code Value from the Type/Descriptors below based on the Ed-Fi Code value for each disability the student meets.

C

Enrollment.disability1

 Enrollment.disability2

Enrollment.disability3

Student Information > General > Special Ed > Documents > IEP
disabilityDescriptor

The descriptor defines a student's impairment.

Reports the Ed-Fi Code from the Disabilities for the student being reported.

  • The student must have a locked IEP which overlaps in the current year with the student's enrollment end date or the current date, or which overlaps in previous scope years, the student's enrollment end date or if null, the last instructional date of the year.
  • The IEP must overlap with the student's enrollment record.
    • The service type on the enrollment in the active school year is used to determine priority of enrollments to use: Primary, Secondary, Special Education.
    • If the student has multiple enrollments with the same service type in the same school, the highest enrollment id is used.
  • If the student has a Special Education Exit Date that is on or before today's date:
    • The SPED Exit Date is on or after the enrollment end date, the disabilities continue to report.
    • If the enrollment has not ended or the SPED Exist Date is before the enrollment end date, disabilities do not report.
  • If the student has more than one disability, each disability up to 3 disabilities reports.
M

PlanState.disability1

PlanState.disability2

PlanState.disability3

Student Information > Special Ed > Documents > IEP > Primary Disability, Secondary Disability, Tertiary Disability
disabilityDiagnosisA description of the disability diagnosis.ON/AN/A
orderOfDisabilityThe order by severity of the student's disabilities: 1 - Primary, 2 - Secondary, 3 - Tertiary.ON/AN/A
disabilityDetermination SourceTypeKey for Disability Determination Source Type.ON/AN/A
serviceProviders

An unordered collection of studentSpecialEducationProgramAssociationServiceProviders. This association represents the Special Education program(s) that a student participates in or receives services from.

 

This field is optional and does not report.

ON/AN/A

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Reason Exited Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionDescription
SPED01Transferred to another school districtTransferred to another school district in Nebraska and continues with Early Intervention Services
SPED02Returned to full-time regular education programReturned to full-time regular education program. Include students with a disability whose parent revokes consent for special education and related services.
SPED03Graduated with a regular high school diplomaGraduated with a regular high school diploma
SPED04Received a certificate of completionReceived a certificate of completion
SPED05Reached maximum ageReached maximum age
SPED06DeceasedDeceased
SPED07Dropped OutDropped Out
SPED09Withdrawn by parentWithdrawn by parent
SPED11Transferred to another school district (Moved known to be continuing)Transferred to another school district (Moved known to be continuing)
SPED12Completion of the IFSP prior to the age of 3 years oldCompletion of the IFSP prior to the age of 3 years old
SPED13Exit to other programExit to other program, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED14Exit with no referralExit with no referral, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED16Moved out of stateMoved out of state
SPED17Attempts to contact parents unsuccessfulAttempts to contact parents unsuccessful

This table describes the Ed-Fi Value mapped and reported for Special Education Setting Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Home - not School AgedHome - not School Aged
02Community Based - not School AgedCommunity Based - not School Aged
03Other - not School AgedOther - not School Aged
05Separate SchoolSeparate School
06Separate ClassSeparate Class
07Residential FacilityResidential Facility
08Home - School AgedHome - School Aged
09Service Provider LocationService Provider Location
10Public SchoolPublic School
13Homebound/HospitalHomebound/Hospital
14Private School or Exempt (Home) SchoolPrivate School or Excempt (Home) School
15Correction/Detention FacilityCorrection/Detention Facility
16Regular Early Childhood Program, 10+ h/wk; Services at EC ProgramRegular Early Childhood Program, 10+ h/wk; Services at EC Program
17Regular Early Childhood Program, 10+ h/wk; Services outside EC ProgramRegular Early Childhood Program, 10+ h/wk; Services outside EC Program
18Regular Early Childhood Program, LT 10 h/wk; Services at EC ProgramRegular Early Childhood Program, LT 10 h/wk; Services at EC Program
19Regular Early Childhood Program, LT10 h/wk; Services outside EC ProgramRegular Early Childhood Program, LT10 h/wk; Services outside EC Program

This table describes the Ed-Fi Value mapped and reported for Level of Program Participation Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
05IDEA Part BIDEA Part B
06IDEA Part CIDEA Part C

This table describes the Ed-Fi Value mapped and reported for Placement Type Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
0Not ApplicableNot Applicable – Does not attend a Nonpublic School
1Nonpublic Placement - Parental PlacementNonpublic Placement - Parental Placement
2Nonpublic Placement - Other than Parental PlacementNonpublic Placement - Other than Parental Placement
3Nonpublic Placement – Parent Placemnt SPED Svcs from Res Dist Stud on IEPNonpublic Placement – Parental Placement, Special Education Services from Resident District, Student on IEP
4Nonpublic Placement – Parent Placemnt SPED Svcs Stud on Equitable Svcs PlanNonpublic Placement – Parental Placement, Special Education Services, Student on Equitable Services Plan

Student Title I Part A Program Association

 This association represents the Title I Part A program(s) that a student participates in or from which the student receives services. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved, and at least one of the Title I service checkboxes are marked, and Targeted Assistance is selected, it qualifies.

  • Only a single record per school, per student, per enrollment start date reports.
  • If there are multiple enrollments in the same school that qualify, and have the same enrollment start date, the record reports based on the primacy of Service Type (P: Primary, S: Partial, N: Special Education).
  • If there are multiple enrollments in the same school that qualify, with the same service type and enrollment start date, the highest enrollment ID reports.

A record does not report if the student's enrollment has any of the following indicated"

  • No Show
  • Enrollment State Exclude
  • Calendar Exclude
PostIf the service type is being changed for the enrollment record being reports in this resource, a new record for the new properly reports enrollment reports, if previously not the reporting enrollment.
PostWhen any field part of the natural key is updated.
Put

Update the record if any other fields in this resource are changed that are not part of the natural key.

  • When any enrollment record that previously had at least one Title I service checkbox selected and saved, and additional Title I services are selected and saved, update the services field.
  • When any enrollment record that previously had more than one Title I service checkbox selected and saved, and at least one Title I service is subsequently unchecked and saved, and there is at least one Title I service still selected, update the services field
DeleteIf the service type is being changed for the enrollment record being reported in this resource, delete the record if the enrollment is no longer the reported enrollment.
DeleteWhen any field part of the natural key is updated.
DeleteWhen any enrollment record that previously had at least one Title I service checkbox selected and saved, and all Title I services in that enrollment record are subsequently unchecked and saved, delete the record.
DeleteWhen any enrollment record that previously had at least one Title I  service checkbox selected and  saved, and the enrollment record is subsequently deleted, delete the record.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
The record sends to the scope year for the school year the enrollment to which it is associated.
Data only sends for the years that have a valid configuration.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Student Title I Part A Program Associations resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.ON/AN/A
studentUniqueIDA unique alphanumeric code assigned to a student.MPerson.edFiIdCensus > People > Demographics > EdFi ID
programType

The program associated with the student.

Reports the Title I Part A program. See the Type/Descriptor options below.

MN/AN/A
programEducationOrganizationId

 The education organization where the student is participating in or receiving the program services. 

Reports the Ed-Fi District Number for which the reporting enrollment is associated.

MN/AN/A
beginDate

 The month, day, and year on which the student first received services. NEDM: Beginning Date 

 Reports the Enrollment Start Date.
 

MEnrollment.startDateStudent Information > General > Enrollments > General Enrollment Information > Start Date
programName

 The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies. 

 Reports 'Title I Part A."
 

MN/AN/A
educationOrganizationId

 The education organization where the student is participating in or receiving the program services. 

Reports District ID + 000.

MDistrict.numberSystem Administration > Resources > District Information > State District Number
endDate

 The month, day, and year on which the student exited the program or stopped receiving services. NEDM: Ending Date. 

 Reports the Enrollment End Date.
 

CEnrollment.endDateStudent Information > General > Enrollments > General Enrollment Information > End Date
reasonExitedDescriptor

 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 

 

This is optional and does not report.

 
 

ON/AN/A
servedOutsideOf RegularSession

 Indicates whether the student received services during the summer session or between sessions. 


 

This is optional and does not report.



ON/AN/A
titleIPartA ParticipantType

 An indication of the type of Title I program, if any, in which the student is participating and served: Public Targeted Assistance Program Public Schoolwide Program Private school student participating Local Neglected Program NEDM: Title I Participlant 

  • Reports the Ed-Fi Code from the value selected in the Title 1 droplist on School Editor for which the reporting enrollment is associated.
  • If the Title 1 field on School is blank or does not have an Ed-Fi Code, reports "Local Neglected Program".
MSchool.titleISystem Administration > Resources > School > Title I
services

 An unordered collection of studentProgramAssociationServices. This association represents the Title I Part A program(s) that a student participates in or from which the student receives services. The association is an extension of the StudentProgramAssociation particular for Title I Part A programs. 

This element reports an array of the following data elements:

MN/AN/A
serviceDescriptor

 The ID of the Service Descriptor .

Reports a service for each Title 1 checkbox that is selected on the enrollment.

Reports the Ed-Fi code value that corresponds with the service selected.

See the Services Descriptor below for code mapping.

MEnrollment.titleIStudent Information > General > Enrollments > Title !
primaryIndicatorThis field does not report.ON/AN/A
serviceBeginDateThis field does not report.ON/AN/A
serviceEndDateThis field does not report.ON/AN/A

Type/Descriptors

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Program Names:

Program NameProgram Type (Ed-Fi Short Description)Career Pathway Type
Career Ed: Agriculture, Food, and Natural Resources SystemsCareer and Technical EducationAgriculture, Food and Natural Resources
Career Ed: Architecture and ConstructionCareer and Technical EducationArchitecture and Construction
Career Ed: Arts, Audio/Visual, and CommunicationCareer and Technical EducationArts, A/V Technology and Communications
Career Ed: Business Management and AdministrationCareer and Technical EducationBusiness, Management and Administration
Career Ed: Education and Training

Career and Technical Education

Education and Training
Career Ed: FinanceCareer and Technical EducationFinance
Career Ed: Foundational, Exploratory, Career Dev, or OtherCareer and Technical Education
Career Ed: Government and Public AdministrationCareer and Technical EducationGovernment and Public Administration
Career Ed: Health SciencesCareer and Technical EducationHealth Science
Career Ed: Hospitality and TourismCareer and Technical EducationHospitality and Tourism
Career Ed: Human ServicesCareer and Technical EducationHuman Services
Career Ed: Information TechnologyCareer and Technical EducationInformation Technology
Career Ed: Law, Public Safety, Security, and CorrectionsCareer and Technical EducationLaw, Public Safety, Corrections and Security
Career Ed: ManufacturingCareer and Technical EducationManufacturing
Career Ed: MarketingCareer and Technical EducationMarketing, Sales and Service
Career Ed: Science, Technology, Engineering and MathematicsCareer and Technical EducationScience, Technology, Engineering and Mathematics
Career Ed: Transport, Distribution, Warehousing, LogisticsCareer and Technical EducationTransportation, Distribution and Logistics
English Language Learner (ELL)English as a Second Language (ESL)
NDE Approved Early Childhood Ed Program, Head StartEarly Head Start
NDE Approved Early Childhood Ed Program, not Head StartPublic Preschool
Rule 18 Interim-Program SchoolNeglected and Delinquent Program
Special EducationSpecial Education
Title I Part ATitle I Part A
504 DesignationSection 504 Placement
Gifted and TalentedGifted and Talented


This table describes the Ed-Fi Value mapped and reported for Service Descriptors:

Ed-Fi ValueEd-Fi DescriptionLocal Campus Field
4Title I Civics GovtCivics
5Title I Early Childhood EducationEarly Childhood Education
6Title I Guidance CounselingGuidance Counseling
7Title I HealthHealth
8Title I MathMath
9Title I Reading ELAReading
10Title I ScienceScience
11Title I Social WorkSocial Work
12Title I Support OtherSupport Other
13Title I Vocational CareerVoc/Career



Additional Logic and Considerations

The following describes additional logic and considerations to be aware of when working with Ed-Fi.

Attendance

Only attendance that is “verified” will send to Ed-Fi. Unknown records marked by a teacher will not send. Negative attendance will send when it is given an excuse code.

 No Show/Excludes 

If the State Exclude or No Show buttons are marked or unmarked on an enrollment the record, they will be deleted/added from Ed-Fi.

Required Fields

The Room number on the Section editor will become required once Ed-Fi is enabled. This data is required for the section data to send to Ed-Fi. Do a check on all course sections prior to doing a resynch on the Schedule Data to verify all sections have a Room number.

Services

The Ed-Fi code values for services are mapped to state codes using the following process:

  1.  Enter the Ed-Fi code for state code services in System Administration > Custom > Attribute/Dictionary > Plan Service > Dictionary.
  2. Create or edit a service in System Administration > Special Ed > Services. The state code field is the field that has the Ed-Fi code attached to it. If a service is created or changed and it has a state code that has an Ed-Fi code, it will send.
  3. In order to have the service report through Ed-Fi, attach the created service to a student in Student Administration > Special Ed > Documents > IEP > IEP Services.