Wyoming Ed-Fi Data

Classic View: System 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. 

 
    • Future data is suppressed when syncing data from Campus to Ed-Fi. Only past and present data is synced.
    • Data in calendars marked as Exclude will not send data to Ed-Fi.
    • Person-related records do not trigger a send of data to Ed-Fi if the person does not have an Ed-Fi ID value assigned.
    • Ed-Fi ignores custom field data entered in Campus.

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.

Image 1: 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.
GetThis action is used for items that are pre-loaded by ADE.  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.

Image 2: Example of a Object Data Elements Table

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

Image 3: 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.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

Days report by school not calendar in Ed-Fi, so when working with multiple calendars/schedule structures it is possible a day could be reporting even if it is not in the calendar you are working in.

ActionTrigger
Post

When a Day and/or a Day Event is created and saved or the Instruction check box is checked.

  • Days can be set either manually or by the Day Reset tool.
  • Day Events can be set either manually or by the Multi Day Event Wizard.
  • Send a record for each date that meets the reporting criteria.
  • When there is more than 1 calendar/schedule structure, any day that has a day event will report. If the same day in multiple calendars have events that are not the same, all events will report.
  • If the same day in different calendar/schedule structures have the same event, only 1 record will report. 
  • Do not send a record if the Calendar Exclude checkbox is checked.
PutWhen a Day Event or Duration is changed and saved.
Delete

When the Instruction check box is unchecked or a Day Event is deleted and saved.

  • When removing a day event there must only be 1 day event reported to send a delete. If there is more than 1 it will update the day, not delete.

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

schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resourceThe following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
date

Month, day, and year of the date being reported.

MDay.dateSystem Administration > Calendar > Calendar > Days > Date
calendarEvents

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

  • Data is reported from the Day or Day Event for the Date being reported. 

See the Calendar Event Descriptor table in the Type/Descriptor section below.


N/AN/A
Calendar Event Descriptor

This descriptor hold the types of scheduled or unscheduled events for the day.

Logic reports as follows:

  • Reports 'Instructional Day' if the Instructional Day box is marked on the day.
  • Otherwise, logic reports the Ed-Fi code from the data dictionary of the Day Event that is selected and saved.
  • If Instruction is not marked for the day and there is not a day event mapped to an Ed-Fi code, no record is reported.

See the Calendar Event Descriptor table in the Type/Descriptor section below.

M

Day.instruction

System Administration > Calendar > Calendar > Day
eventDurationReports the duration of the day event being reportedON/AN/A
_etag

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

This 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 Calendar Event Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Emergency dayEmergency dayEmergency day
HolidayHolidayHoliday
Instructional dayInstructional dayInstructional day
Make-up dayMake-up dayMake-up day
OtherOtherOther
Student late arrival/early dismissalStudent late arrival/early dismissalStudent late arrival/early dismissal
Weather dayWeather dayWeather day
Teacher only dayTeacher only dayTeacher only day
StrikeStrikeStrike



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 will be sent for each Period Schedule/Period Name/Schedule Structure ID combination created.
  • Do not send records if the Calendar Exclude check box is checked
PostWhen a Period Schedule Name or Period Name is changed and saved.
DeleteWhen 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 resourceMN/AN/A
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
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
etag

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

ON/AN/A

Cohorts

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
Post

When a Program Session is added and is mapped to a Cohort Type.

  • The Program can only be created from Program Admin> Programs> Programs tab
PutWhen the Category or Description changes.
Post/DeleteWhen the Program mapping changes.
DeleteWhen the Program Session is deleted.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Cohorts resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resourceMN/AN/A
educationOrganizationReference
(educationOrganizationId contained in this property)
A reference to the related EducationOrganization resource. Reports the State District number.Mdistrict.numberSystem Administration > Resources > District Information > State District Number
identifier The name or ID for the cohort. Reports the Program Session ID.Mprogramsession. programSessionIDProgram Admin > Programs > Program > Program Sessions ID
description

The description of the cohort and its purpose.


  1. Reports text in the Description field.
  2. If NULL, reports the same as the id property (identifier).
Oprogram.descriptionProgram Admin > Program s> Programs> Description
type

The type of the cohort (academic intervention, attendance intervention, discipline intervention, breakout session, etc.).

Reports the Cohort Type selected on the mapping page for the program being reported.

M

scopeType

The scope of cohort (e.g., campus, district, classroom).

  1. Reports the Ed-Fi Code from the selected category.
  2. If a Category is not selected or the Ed-Fi Code is NULL, does not report.
Oprogram.program CategoryProgram Admin > Program s> Programs > Category
academicSubjectDescriptorThe subject for an academic intervention (e.g., science, mathematics)ON/AN/A
programsAn unordered collection of cohort programs. The optional program associated with this cohort (e.g., Special Education)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...

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Academic InterventionAcademic InterventionAcademic Intervention
Attendance InterventionAttendance InterventionAttendance Intervention
Discipline InterventionDiscipline InterventionDiscipline Intervention
Classroom PulloutClassroom PulloutClassroom Pullout
Extracurricular ActivityExtracurricular ActivityExtracurricular Activity
Field TripField TripField Trip
Principal Watch ListPrincipal Watch ListPrincipal Watch List
Counselor ListCounselor ListCounselor List
In-school SuspensionIn-school SuspensionIn-school Suspension
Study HallStudy HallStudy Hall
OtherOtherOther


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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
DistrictDistrictDistrict
SchoolSchoolSchool
NetworkNetworkNetwork
ClassroomClassroomClassroom
TeacherTeacherTeacher
PrincipalPrincipalPrincipal
CounseleorCounselorCounselor
StatewideStatewideStatewide
OtherOtherOther



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.

This resource will not push data for Courses marked as Inactive or State Exclude. 

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.
PostWhen the Local Course Number or Term type Override is changed.
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.
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 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:

  • EntityID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
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

N/AN/A
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
InstructionalTimePlannedThe 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.ON/AN/A
curriculumUsedAn unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses.ON/AN/A
etagA unique system-generated value that identifies the version of the resource.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 and they have a valid Student School Association for the Scoped Year.

  • When a resync is completed, all transcript records for all years will send for the Student
  • The School that the Student is enrolled must be selected in the Resync Tool
Post/DeleteWhen a transcript record is modified we always do a post/delete and never do a "Put".
Delete

When a transcript record is deleted for a student.

Delete

Transcript records will only delete when a student has only 1 Student School Association record for a specific Year and that record is deleted.

 

If a new Student School Association record is created, existing records will not re-post, 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
Transcript records will send to each scope year where the student has a Student School Association, regardless of the Transcript School Year. 
Data will only send for the years that have valid configuration.
A resync must be completed at the beginning of each year so that all years transcript records will be loaded in the ODS.

Object Data Elements

Click here to expand...

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

Data ElementDescriptionCampus Database FieldCampus GUI Location
courseReference

The unique identifier of the resource.

Natural Key fields for the Course resource:

  • Education Organization Reference
  • Code
M N/AN/A
schoolReference

A reference to the related School resource.

Reports the Natural Key fields for the School resource:

  • schoolID

If the School ID is not valid, this field will report blank

ON/AN/A
studentAcademic
RecordReference

A reference to the related Student Academic Record resource.

Reports the Natural Key fields for the Student Academic Record resource:

  • educationOrganizationReference
  • schoolYearTypeReference
  • studentReference
  • termDescriptor
MN/AN/A
courseAttemptResultType

The result from the student''s attempt to take the course, for example: Pass, Fail, Incomplete, Withdrawn.

Look at the Score Group where from the Current Score posted on the transcript record and report the following:

  1. Report 'Pass' when the posted score has the Passing check box checked on the score group where the grade was posted from
  2. Report 'Withdrawn' when the posted score has a State Score = W, WF, or WP.
  3. Report 'Incomplete' when the posted grade has a State Score = I.  
  4. Report 'Fail' when the posted grade does not have the Passing check box checked on the score group where the grade was posted from
M

TranscriptCourse.score

Scorelistitem.passingScore

Scorelistitem.statescore


Student Information > General > Transcripts > Score

Grading Standards > Score Groups & Rubrics > State Score

attemptedCreditType

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

 

This field 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 field is optional and does not report.

ON/AN/A
attemptedCredits

The number of credits attempted for a course

Report 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 field 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 field is optional and does not report.

ON/AN/A
earnedCredits

The number of credits awarded or earned for the course.

Report the sum of credits from the Earned field on the Transcript record being reported.

MTranscriptcredit.
creditsEarned
Student Information > General > Transcripts > Earned
whenTakengrade
LevelDescriptor

Student's grade level at time of course.

  1. If the grade selected on the manual transcript record matches a valid Ed-Fi code, report the grade.
    1. If the grade selected on the manual transcript record does not match a valid Ed-Fi code, find a calendar in the school year within the district that has a non-null State Grade Level mapping for that grade and report the Ed-Fi code mapped to that State Grade Level.
      1. When no matching grade found with a state grade level mapping, do not report this property.
  2. When posted, report the Ed-Fi code mapped to the State Grade Level from the Grade indicated on the transcript Grade field.
ON/AStudent Information > General > Transcript > Transcript Course Editor > Grade

System Administration > Calendar > Calendar > Grade Levels > Grade Level Detail > State Grade Level Code
methodCreditEarnedType

The method the credits were earned, for example: Classroom, Examination, Transfer. 

 

This field is optional and does not report.

ON/AN/A
finalLetterGradeEarned

The final letter grade earned for the course.

  1. Look at the Score Group where from the Current Score posted on the transcript record and report the following:
  2. Report the State Score mapped to the Current Score posted to the transcript record for posted courses when State Score on the Score Group or rubric is NOT = 99
    1. When State Score = 99 or is null, report the 'Score' on the grading Score Group or Rubric if it is a not an integer 
      1. When an integer, report blank.
O

Transcriptcourse.score

Scorelistitem.passingScore

Scorelistitem.statescore

Student Information > General > Transcripts > Current Score

Grading Standards > Score Groups & Rubrics > State Score

finalNumericGradeEarned

The final numeric grade earned for the course.

Look at the Score Group where from the Current Score posted on the transcript record and report the following:

  1. If the State Score mapped to the Current Score is = 99 or blank, report the 'Score' on the Score Group or Rubric if it is an integer
    1. else, report blank
O

Transcriptcourse.score

Scorelistitem.passingScore

Scorelistitem.statescore


Student Information > General > Transcripts > Current Score

Grading Standards> Score Groups & Rubrics> State Score

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 field is optional and does not report.

ON/AN/A
CourseTitle

Reports the name of the course completed.

Report the Course Name from the transcript record

OTranscriptcourse.
courseName
Student Information > General > Transcripts > Course Name
alternativeCourseCode

The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. 

 

This field is optional and does not report.

ON/AN/A
earnedadditionalCredits

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 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 Course Attempt Result Type:

Ed-Fi Short DescriptionEd-Fi Description
PassPass
FailFail
IncompleteIncomplete
WithdrawnWithdrawn



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

Only courses with State Course Codes will send data.

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
codeThe 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 > 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 > Course > Name
numberOfPartsThe number of parts identified for a course. The number in the SCED Sequence Part N field is reported. This field reports a default value of 1 for all courses.Mcourse.sced
SequenceNum
Defaults to 1 for all courses
academicSubject
Descriptor

The intended major subject area of the course. NEDM: Secondary Course Subject Area. See the Type/Descriptor table below.

  • Courses are pre-loaded and this value has been identified in the courses by course number
OData is preloaded by the StateData is preloaded by the State
description

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

OData is preloaded by the StateData is preloaded by the State
dateCourseAdoptedThe date the district adopted the course.OData is preloaded by the StateData is preloaded by the State
highSchoolCourse
Requirement
An indication that this course credit is required for a high school diploma.OData is preloaded by the StateData is preloaded by the State
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.OData is preloaded by the StateData is preloaded by the State
definedByTypeSpecifies whether the course was defined by the SEA, LEA, school or national organization.OData is preloaded by the StateData is preloaded by the State
minimumAvailable
CreditType
The type of credits or units of value awarded for the completion of a course.OData is preloaded by the StateData is preloaded by the State
minimumAvailable
CreditConversion
Conversion factor that when multiplied by the number of credits is equivalent to Carnegie unitsOData is preloaded by the StateData is preloaded by the State
minimumAvailable
Credit
The minimum amount of credit available to a student who successfully completes the course.OData is preloaded by the StateData is preloaded by the State
maximumAvailable
CreditType
The type of credits or units of value awarded for the completion of a course.OData is preloaded by the StateData is preloaded by the State
maximumAvailable
CreditConversion
Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.OData is preloaded by the StateData is preloaded by the State
maximumAvailable
Credit
The maximum amount of credit available to a student who successfully completes the course.OData is preloaded by ArizonaData is preloaded by the State
careerPathwayTypeThe career cluster or pathway representing the career path of the Vocational/CTE concentrator.OData is preloaded by the StateData is preloaded by the State
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.OData is preloaded by the StateData is preloaded by the State
competencyLevelsAn 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.OData is preloaded by the StateData is preloaded by the State
gradeLevelsAn 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.OData is preloaded by the StateData is preloaded by the State
IdentificationCodesAn 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.OData is preloaded by the StateData is preloaded by the State
learningObjectivesAn 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.OData is preloaded by the StateData is preloaded by the State
learningStandardsAn 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.OData is preloaded by the StateData is preloaded by the State
levelCharacteristicsAn 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.OData is preloaded by the StateData is preloaded by the State
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 Academic Subject Descriptor:

State CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
ELElementaryELElementary Core SubjectElementary Core Subject
FAFine and Performing ArtsFAFine and Performing ArtsFine and Performing Arts
FLForeign LanguageFLForeign Language and LiteratureForeign Language and Literature
LAEnglish and Language ArtsLAEnglish Language ArtsEnglish Language Arts
MAMathMAMathematicsMathematics
NANon Academic (Attendance, etc)NANon AcademicNon Academic
OTOther (ROTC, Driver's Ed, etc)OTOther AcademicOther Academic
PEPhysical Education and HealthPEPhysical, Health, and Safety EducationPhysical, Health, and Safety Education
REReadingREReadingReading
SCScienceSCScienceScience
SSSocial Studies and HistorySSSocial StudiesSocial Studies
VEVocational EducationVECareer and Technical EducationCareer and Technical Education



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 is aligned to a reported Behavior Event.

  • When Offender Type = U or N, do not populate a record.
  • Do not send if the student's enrollment is marked as No Show or State Exclude.
  • Do not send if the student is in a calendar marked as Exclude.
  • Do not send if the student is in a School 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.
DeleteWhen a resolution is deleted.
DeleteWhen all resolutions are removed from the incident.
DeleteWhen all Behavior Events that are removed from the Incident.
DeleteWhen the student's Role changes to anything other than Offender or Participant.
DeleteWhen all non-excluded enrollments in the school and year are deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on 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 Discipline Action resource.

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

A reference to the related School resource

This is optional and does not report.

ON/AN/A
responsibility
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource of the school where the incident occurred. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
studentReference

Reports data from the Ed-Fi ID field that is part of the natural key for the Student resource of the school where the incident occurred. The following elements are reported:

  • studentUniqueId
MPerson.edfiIDCensus > People > Demographics > EdFi ID
identifierIdentifier assigned by the education organization to the discipline action.MBehaviorResolution.
resolutionID
Behavior > Behavior Management > Resolution > Resolution ID
disciplineDateThe month, day, and year of the discipline actionMBehaviorResolution.
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 is optional and does not report.

ON/AN/A
actualDiscipline
ActionLength

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

This is optional and does not report.

ON/AN/A
lengthDifference
ReasonType

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

This is optional and does not report.

ON/AN/A

relatedToZero
TolerancePolicy

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 is optional and does not report.

ON/AN/A
disciplines

An unordered collection of disciplineActionDisciplines.


N/AN/A
Discipline Descriptor

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.

  1. Report the Ed-Fi Code value from the mapping for the state resolution code selected
  2. If the Ed-Fi Code is NULL or is not mapped to a state code, then do not report.

See the Discipline Descriptor table in the Type/Descriptor section below.

O

N/A

Behavior > Behavior Management > Resolution Details > Resolution Type
disciplineIncidents

An unordered collection of disciplineActionDisciplineIncidents.

ON/AN/A
staffs

An unordered collection of disciplineActionStaffs.

This is optional and does not report.

ON/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 Discipline Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Removal from ClassroomRemoval from ClassroomRemoval from Classroom
IIn School SuspensionIn School Suspension
OOut of School SuspensionOut of School Suspension
EExpulsion (No Educational Services Provided)Expulsion (No Educational Services Provided)
SExpulsion (Educational Services Provided)Expulsion (Educational Services Provided)
Community ServiceCommunity ServiceCommunity Service
ROtherOther
AAlternative Placement by School PersonnelAlternative Placement by School Personnel
HAlternative Placement by Hearing Officer due to IDEAAlternative Placement by Hearing Officer due to IDEA
JJuvenile Court SystemJuvenile Court System



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"

  • Incident must have at least 1 behavior event associated and a Role that is mapped to an Ed-Fi Value
  • Posting can occur if a new event is added after Incident is marked as "Complete"
  • Do not send if the student's enrollment is marked as No Show or State Exclude
  • Do not send if the student is in a calendar marked as Exclude
  • Do not send if the student is in a School marked as Exclude
Delete/Post

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

  • If the Date of Incident is changed and saved
  • If the Event Type is changed and saved
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
DeleteWhen an incident is deleted
Delete

When the associated student enrollment is deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on 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 Discipline Incident resource.

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

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MSchool.entityIDSystem Administration > Resources > School > Entity ID
staffReference

A reference to the related Staff resource.

This is optional and does not report.

ON/AN/A
incidentIdentifierThe 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 offendersMBehaviorIncident.
incidentID
Behavior > Behavior Management > Incident ID
incidentDateThe month, day, and year on which the incident occurred.MBehaviorIncident.
timestamp
Behavior > Behavior Management > Date of Incident
incidentTime

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

This is optional and does not report.

ON/AN/A
incidentLocationType

Identifies where the incident occurred and whether or not it occurred on campus.

Logic reports the Ed-Fi code mapped to the selection in the Location field on the Incident.

OBehaviorIncident.
location
Behavior Management > Location
reporterDescription
Descriptor

Information on the type of individual who reported the incident.

This is optional and does not report.

ON/AN/A
reporterName

Identifies the reporter of the incident by name.

This is optional and does not report.

ON/AN/A
reportedTo
LawEnforcement

Indicator of whether the incident was reported to law enforcement.

This is optional and does not report.

ON/AN/A
caseNumber

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

This is optional and does not report.

ON/AN/A
incidentDescription

The description for an incident.

This is optional and does not report.

ON/AN/A
incidentCost

The value of any quantifiable monetary loss directly resulting from the incident.

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

 ON/AN/A
behaviorDescriptor

Report all behavior events that are associated with the incident

  1. Report the Ed-Fi code value from the mapping provided for the state code selected on the event.
  2. If the event is not mapped to a state code, report the Ed-Fi code from the mapping for the District/School code.
  3. If a code is not mapped, do not report.
M

N/A

Behavior > Behavior Management > Event Type
behaviorDetailedDescriptionReport the Details entered on the Incident
  1. Ed-Fi accepts 1024 characters in this field, truncate remaining information from Campus if there are more characters
OBehaviorIncident. descriptionBehavior > Behavior Management > Incident Detail Information
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).

This does not report.

ON/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 Behavior Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
School ViolationSchool ViolationSchool Violation
State OffenseState OffenseState Offense
School Code of ConductSchool Code of ConductSchool Code of Conduct
OtherOtherOther

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
On campusOn campusOn campus
Off campusOff campusOff campus
School busSchool busSchool bus



Grade

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 mapped to an Ed-Fi Grade Type.

  • Standards will not report to Ed-Fi
  • Do not report if the Course is marked as Inactive or State Excluded
  • Do not send records if the Calendar Exclude check box is checked
  • Do not send records is the student's enrollment is marked as no show or State Excluded
PutWhen a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type.
Delete

When a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type.

DeleteWhen the Student School Association record is deleted for the school in which the grades are associated.
DeleteWhen the No Show or State Exclude check boxes are checked.
Delete/InsertWhen any field that is part of the Natural Key is changed.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Grades will post to the scope year the course's calendar is aligned to.

  • 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 Grade resource.

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

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

 

MN/A N/A 
studentSection
AssociationReference

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

  • When a student has more than 1 eligible Student Section Association record (for example, a course that covered 2 periods and or multiple period schedules) the grade will report on section association with the highest period schedule sequence and or period sequence.
MN/A N/A 
type

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

Reports the Ed-Fi Code from the mapping for  the Grading Task.

If the grading task is not mapped, do not report.

See the Grade Type table in the Type/Descriptors section below.

MN/A Grading & Standards > Grading Tasks
performanceBase
ConversionType

The performance base conversion assessed for the student.

 

This field is optional and will not report.

N/A N/A 
 letterGradeEarned

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

Logic will determine if the posted score is an integer or not:

  1. If the posted value is not an Integer, then report the posted score here
  2. If the posted value is an Integer, then report in the Numeric Grade Earned field below.
 O GradingScore.scoreGrading & Standards > Score Groups & Rubrics > Score
numericGradeEarned

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

Logic determines if the posted score is an integer or not:

  1. If the posted value is an Integer, then report the posted score
  2. If the posted value is not an Integer, then report in Letter Grade Earned field above.
OGradingScore.scoreGrading & Standards > Score Groups & 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 will not report.

N/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 Grade Type:

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 an calendar event in the Calendar Dates resource before Grading Periods can send.  User needs to perform a day reset prior to filling out Grading Periods tab.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

 

Grading Periods cannot be deleted in WY due to the Dependency of the core Ed-Fi model where it is required for Sessions report grading periods.

ActionTrigger
Post

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

  • Do not send records if the Calendar Exclude check box is checked.
PutWhen the Grading Period End Date is updated and saved.
Delete

When a Grading Period is deleted.

  • If there are multiple calendars/schedule structures only send a delete 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, send delete of old record and post of new record.

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
schoolReference

Reports the Natural Key for the Schools resource the grading period is aligned to.

MN/A N/A 
beginDate

The start date of the grading period.

Report the start date from the Grading Period being reported:

  • If there is more than 1 calendar or schedule structure, report a record for each Grading Period & Start Date Combination.
  • The date entered must be an Instructional day on the Days tab.
Medfigradingperiod.startSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endDate

The end date of the grading period.

Report the end date from the Grading Period being reported:

  • If there is more than 1 calendar or schedule structure, report the latest end date.
  • The date entered must be an Instructional day on the Days tab.
Mdfigradingperiod.endDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
descriptor

The name of the grading period. See the Grading Period Descriptor table in the Type/Descriptor section below.

  • Report the code value from the Grading Period Name selected.
 Medfigradingperiod.nameSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Count the number of instructional days on the Days tab that occur during the start and end date for the grading period
    • If there is more than 1 calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures
    • Instructional days will not send an update if changed after original post unless a resync is completed.
N/A System Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

 

This element is optional and does not report.

 term.seq System Administration> Calendar> Terms> Seq 
 _etag N/AON/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 Grading Period Descriptor:

State CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01First Six WeeksFirst Six WeeksFirst Six WeeksFirst Six Weeks
02Second Six WeeksSecond Six WeeksSecond Six WeeksSecond Six Weeks
03Third Six WeeksThird Six WeeksThird Six WeeksThird Six Weeks
04Fourth Six WeeksFourth Six WeeksFourth Six WeeksFourth Six Weeks
05Fifth Six WeeksFifth Six WeeksFifth Six WeeksFifth Six Weeks
06Sixth Six WeeksSixth Six WeeksSixth Six WeeksSixth Six Weeks
07First Nine WeeksFirst Nine WeeksFirst Nine WeeksFirst Nine Weeks
08Second Nine WeeksSecond Nine WeeksSecond Nine WeeksSecond Nine Weeks
09Third Nine WeeksThird Nine WeeksThird Nine WeeksThird Nine Weeks
10Fourth Nine WeeksFourth Nine WeeksFourth Nine WeeksFourth Nine Weeks
11First Four WeeksFirst Four WeeksFirst Four WeeksFirst Four Weeks
12Second Four WeeksSecond Four WeeksSecond Four WeeksSecond Four Weeks
13Third Four WeeksThird Four WeeksThird Four WeeksThird Four Weeks
14Fourth Four WeeksFourth Four WeeksFourth Four WeeksFourth Four Weeks
15Fifth Four WeeksFifth Four WeeksFifth Four WeeksFifth Four Weeks
16Sixth Four WeeksSixth Four WeeksSixth Four WeeksSixth Four Weeks
17Seventh Four WeeksSeventh Four WeeksSeventh Four WeeksSeventh Four Weeks
18Eighth Four WeeksEighth Four WeeksEighth Four WeeksEighth Four Weeks
19Ninth Four WeeksNinth Four WeeksNinth Four WeeksNinth Four Weeks
20First SemesterFirst SemesterFirst SemesterFirst Semester
21Second SemesterSecond SemesterSecond SemesterSecond Semester
22First TrimesterFirst TrimesterFirst TrimesterFirst Trimester
23Second TrimesterSecond TrimesterSecond TrimesterSecond Trimester
24Third TrimesterThird TrimesterThird TrimesterThird Trimester
25End of YearEnd of YearEnd of YearEnd of Year
26Summer SemesterSummer SemesterSummer SemesterSummer Semester
27First Summer SessionFirst Summer SessionFirst Summer SessionFirst Summer Session
28Second Summer SessionSecond Summer SessionSecond Summer SessionSecond Summer Session
29Third Summer SessionThird Summer SessionThird Summer SessionThird Summer Session
30First Grading PeriodFirst Grading PeriodFirst Grading PeriodFirst Grading Period
31Second Grading PeriodSecond Grading PeriodSecond Grading PeriodSecond Grading Period
32Third Grading PeriodThird Grading PeriodThird Grading PeriodThird Grading Period
33Fourth Grading PeriodFourth Grading PeriodFourth Grading PeriodFourth Grading Period
34Fifth Grading PeriodFifth Grading PeriodFifth Grading PeriodFifth Grading Period
35Sixth Grading PeriodSixth Grading PeriodSixth Grading PeriodSixth Grading Period
36Seventh Grading PeriodSeventh Grading PeriodSeventh Grading PeriodSeventh Grading Period
37Eighth Grading PeriodEighth Grading PeriodEighth Grading PeriodEighth Grading Period
38Ninth Grading PeriodNinth Grading PeriodNinth Grading PeriodNinth Grading Period
39Tenth Grading PeriodTenth Grading PeriodTenth Grading PeriodTenth Grading Period
40Eleventh Grading PeriodEleventh Grading PeriodEleventh Grading PeriodEleventh Grading Period
41Twelfth Grading PeriodTwelfth Grading PeriodTwelfth Grading PeriodTwelfth Grading Period


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

State CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
COConductConductConductConduct
EXExamExamExamExam
FIFinalFinalFinalFinal
GPGrading PeriodGrading PeriodGrading PeriodGrading Period
MIDMid-Term GradeMid-Term GradeMid-Term GradeMid-Term Grade
PROProgress ReportProgress ReportProgress ReportProgress Report
SESemesterSemesterSemesterSemester




Graduation Plan

This entity is a plan outlining the required credits, credits by subject, credits by course, and other criteria required for graduation. A graduation plan may be one or more standard plans defined by an education organization and/or individual plans for some or all students.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Career Tech Program or a Graduation Program is mapped to a Graduation Plan Descriptor in Graduation Plan Preferences.

  • The program must be flagged as active to report.
  • For a Career Tech Program the Cohort/Graduation Active Start Year field must be populated to report.
  • For a Graduation Program, the Ed-FI Graduation Plan and Cohort/Graduation Active Start Year fields must be populated to report
    • A separate record will report for each School Year that aligns with the Cohort/Graduation Active Start Year and Cohort/Graduation Active End Year
    • If the Cohort/Graduation Active End Year is NULL, a separate record will report starting with the Cohort/Graduation Active Start Year and ending 4+ years from the current year.
  • If two programs have the same Graduation Program Type/Descriptor and School Year, the last record to be updated will be the one reported.
  • Use the Scope Year logic below to determine if the record is eligible to report.
Put

If the sum of the total number of required credits changes on a reported Graduation program.

DeleteGraduation Plans will not delete due to the association across multiple cohort years

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Records will report for each year the Career Tech Program or a Graduation Program is active.

  • Data will only send for the years that have valid configuration.
  • A resync will need to be done at the beginning of each new scope year to be populated.

Object Data Elements

Click here to expand...

This table describes data elements sent within the Graduation Plan resource.

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

A reference to the related Education Organization resource. Reports the District Number.

M

N/A N/A 
graduationSchool
YearTypeReference
A reference to the related SchoolYearType resource. Reports the End Year in the School Year being reported based on the Cohort years the Graduation Plan covers.MN/A N/A 
typeDescriptor 

This descriptor defines the set of graduation plan types.

  • Report 'Career and Technical Education' when the program is created and saved (the cte field in the program table is = 1).
  • Report the Ed-Fi Code from the value selected in the Ed-FI Graduation Plan field.

See the Graduation Plan Type table in the Type/Descriptors section below.

Program.
edfiPlanType
Program Admin > Programs > Graduation Programs > Graduation Program Detail or Career Tech Programs
individualPlan 

 An indicator of whether the GraduationPlan is tailored for an individual.

 

This field is optional and does not report.

 N/A N/A
totalRequiredCredits

The total number of credits required for graduation under this plan.

  • Report '0' when the program is 'Career and Technical Education'.
  • When reporting from a Graduation Plan, sum the total number of required credits associated with the program being reported.

 Calculated value from the CreditRequirement table
totalRequiredCreditType

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

 

This field is optional and does not report.

 O N/A N/A
totalRequired
CreditConversion

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

 

This field is optional and does not report.

 O N/A N/A
creditsByCourses 

An unordered collection of graduation Plan Credits By Courses. The total credits required for graduation by taking a specific course, or by taking one or more from a set of courses. 

 

This field is optional and does not report.

 O N/A N/A
creditsBySubjects 

An unordered collection of graduation Plan Credits By Subjects. The total number of credits required in a subject to graduate. Only those courses identified as a high school course requirement are eligible to meet subject credit requirements. 

 

This field is optional and does not report.

ON/AN/A
requiredAssessments 

An unordered collection of graduation Plan Required Assessments. The total credits required for graduation by taking a specific course, or by taking one or more from a set of courses. 

 

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 Graduation Plan Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
CTECareer and Technical EducationCareer and Technical Education
DistinguishedDistinguishedDistinguished
MinimumMinimumMinimum
RecommendedRecommendedRecommended
StandardStandardStandard




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.
DeleteWhen a Room Name is changed and saved.
Delete

When a Room is deleted.

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:

  • EntityID
MSchool.entityIDSystem Administration > Resources > School > EntityID
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
etag

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

 

This field is optional and does not report.

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 check box is checked AND 1 person is a student and 1 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.
  • 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.
  • Report the active guardian record.

  • If multiple active guardian records, report the one with the latest Start Date.
  • If there are no active guardian records, report the inactive guardian record with the latest start date.

Put

A record will be 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.
DeleteA Parent 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
parentUniqueIdA parent's Ed-Fi ID is reported.MPerson.edFiIdCensus > People > Demographics > EdFi ID
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
firstNameThe reporting parent's first name. This is reported from the person's most recent identity record.M

Identity.firstName

Census > People > Identities > First Name

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

Identity.middleName

 Census > People > Identities > Middle Name

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

Identity.lastName

 Census > People > Identities > Last Name

generationCodeSuffixAn 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

A person's gender. 

 

This element is not collected or reported.

ON/AN/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

Report the person's address(s).

Reports the Primary address that is marked as "Mailing"

  1. If more than 1 Primary Address is marked as Mailing, report address with most recent Household Membership Start Date
  2. Else, report the address with most recent Address Start Date
  3. Do not report if the Address Location Detail or Household Membership is marked as "Private"
O

Household Addresses > Mailing

Household Membership > Start Date

Household Addresses > Start Date

addressType

The type of home address. See the Address Type table in the Type/Description section below.

M

streetNumberName

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

  • Reports Address PO Box + Number + Street + Tag + Prefix + Dir
M

Address.postOfficeBox

Address.number

Address.street

Address.tag

Address.prefix

Address.dir

Households > Address Info
apartmentRoom
SuiteNumber
The apartment, room, or suite number of an address.OAddress.aptHouseholds > 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.cityHouseholds > Address Info > City
stateAbbreviation
Type
The 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.MAddress.zipHouseholds > Address Info > Zip Code
nameOfCounty

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

 

This is optional and does not report.

Oaddress.county Households> 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
electronicMails

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

  1. Reports the email address entered for that person
    1. Do not report if Email is marked as "Private"
  2. If blank, does not report
OContact.emailCensus > People > Demographics > Email
electronicMailTypeReports the mail type. See the Electronic Mail Type table in the Type/Description section below.MN/AN/A
electronic
MailAddress
The 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
primaryEmail
AddressIndicator
An 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

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

  1. Reports the Phone numbers entered in the Personal Contact Information for that person
    • Do not report Phone Number is marked as "Private"
  2. If blank, does not report
O

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

Census > People > Demographics > Personal Contact Information > Other Phone, Work Phone, Cell Phone, Pager
telephone
NumberType
Reports the number type. See the Telephone Number Type table in the Type/Description section 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
telephoneNumberThe 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
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
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 Layout

Click here to expand...

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

Campus ValueEd-Fi TypeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Other Phone1HomeHomeHome
Does not report, not collected in Campus2FaxFaxFax
Cell Phone3MobileMobileMobile
Does not report, not collected in Campus4UnlistedUnlistedUnlisted
Work Phone5WorkWorkWork
Pager6OtherOtherOther
Does not report, not collected in Campus7Emergency 1Emergency 1Emergency 1
Does not report, not collected in Campus8Emergency 2Emergency 2Emergency 2


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

Campus ValueEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Primary email reports as "Home/Personal"1Home/PersonalHomeHome
Primary email reports as "Home/Personal"2OrganizationOrganizationOrganization
Primary email reports as "Home/Personal"3OtherOtherOther
Secondary email reports as "Work"4WorkWorkWork

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

Campus ValueEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-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



Programs

This entity represents any program designed to work in conjunction with, or as a supplement to, the main academic program. Programs may provide instruction, training, services or benefits through federal, state or local agencies. Programs may also include organized extracurricular activities for students.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Special Education:
When a student in the year and calendar reporting has the following:

  1. A locked "WY" IEP (Print format must start with "WY") exists where:
    1. The IEP is active during the scope year date range
Post

Career and Technical Education:
When a Career Tech Program with the following is assigned to a student:

  1. Active = Checked
  2. State Reported = Checked
Post

Title I Part A:
When a student has the following:

  1. Student Info > General > Enrollments > State Reporting Fields > Title 1 = Checked
Post

EL:

When an EL record is active for a student in the scope year.

  1. Student Info > General > Program Participation > English Learners (EL)

Scope Year Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

Logic

Special Education: Record will report for each year in which there is a locked "WY" IEP

  • There must be at least 1 locked IEP that has a Start or End Date within the school year Start and End Date range
  • If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX

Career and Technical Education: Record will report for each year where an active and state reported Career Tech Program is assigned to a student

  • There must be at least 1 Career Tech Program that has a Start or End Date within the school year Start and End Date range
  • If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX

Title I Part A: Record will report for each year in which there is a student with Title 1 = Checked.

  • The enrollment with Title 1 = Checked must be within the Ed-Fi scope year

Early Learning (EL): Record will report for the year(s) in which a student has an active EL record.

  1. There is a student with an EL record that is active at least 1 day in the Ed-Fi scope year where:
    1. Identified Date NOT = Null
    2. Program Exit Date >= calendar Start Date or is null
    3. Identified Date <= calendar End Date
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 Programs resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idN/AMN/AN/A
educationOrganization
Reference

Reports the following elements that are part of the Natural Key for the EducationOrganization resource.

  • localEducationAgencyId
MCustomDistrict.
value
System Administration > Resources > District Information > State District ID
type

Reports the Program Type from the short description based on the program the student participates. See the Program Types table in the Type/Description section below.

Special Education:

  • Report "Special Education".

Career and Technical Education:

  • Report "Career and Technical Education".

Title I Part A:

  • Report "Title I Part A".

Early Learning (EL):

  • Report "English as a Second Language (ESL)".
MN/AN/A
name

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

Special Education:

  • Report "Special Education".

CTE Program:

  • Report the Ed-Fi code mapped to the selection in Program Admin > Programs > Career Tech Programs > Cluster.

Title I Part A:

  • Report "Title I Part A".

Early Learning (EL):

  • Report "English as a Second Language (ESL)".
MN/AN/A

Type/Descriptors

  Click here to expand...

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Long Description
CTE ProgramCareer and Technical EducationCareer and Technical Education
SPEDSPEDSPED

Title 1 Part A

Title 1 Part ATitle 1 Part A
English as a Second Language (ESL)English as a Second Language (ESL)English as a Second Language (ESL)

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Long Description
CTE ProgramCareer and Technical EducationCareer and Technical Education
SPEDSPEDSPED

Title 1 Part A

Title 1 Part ATitle 1 Part A
English as a Second Language (ESL)English as a Second Language (ESL)English as a Second Language (ESL)




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
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 if the sequence. If the course has only onle part, the value of this section attribute should be 1.

  1. Report the code selected in Scheduling > Courses > Course > Course Editor > Course Inventory Sequence Part (Course.sequencePart)
  2. When Course Inventory Sequence Part = Null, report 1.
MN/AN/a
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. If NULL, do not report 

 

This element does not report in Wyoming.

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.
 

This element does not report in Wyoming.

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

Type/Descriptor Layout

  Click here to expand...

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


Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Report the Ed-Fi Code Value when the Attendance and/or Positive Attendance is checked on the course 01Attendance TrackedAttendance Tracked
Report the Ed-Fi Code Value when the Course has a grading task assigned to the course02Graded CreditGraded Credit Available

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


Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Report the Ed-Fi Code Value when the Attendance and/or Positive Attendance is checked on the course 01Attendance TrackedAttendance Tracked
Report the Ed-Fi Code Value when the Course has a grading task 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. 

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

 

Data will not report for calendars marked as Exclude.

ActionTrigger
Post

When a new Term Schedule 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, group the Terms together so only 1 record will report per Term Type.
  • If there are multiple Calendars or Schedule structures in a School with the same Term Types, only 1 record can report to Ed-Fi.  Report the earliest Term Start Date and latest Term End Date.
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 will report 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 will not send from the override field
Put

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

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:

  • EntityID
MN/AN/A
schoolYearTypeReferenceA reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported. MN/AN/A
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.edfiTypeNameSystem Administration > Calendar > Calendar > Terms > Term Type Name
termDescriptor

This descriptor defines the term of a session during the school year (e.g., Fall Semester). See the Term Descriptor mapping in the Type/Descriptor section below.

  1. When reporting from Term Descriptors mapping, report the Ed-Fi Code for the value selected
    1. When Ed-Fi Term Type = Null, or when no Ed-Fi code exists, do not report.
  2. When reporting from the Term Descriptor Overrides, report the Ed-Fi code value selected
 O

Term.edFiTermType

Course.edFiTermType

Section.edFiTermType

System Administration > Calendar > Calendar > Terms > Term Type

OR

Scheduling > Courses/Sections

beginDate

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

  1. When reporting from a Term Schedule, report the start date of the term being reported 
    1. If more than 1 term has the same Term Type selected, report the earliest start date
  2. When reporting from a Term Type Override on a section:
    1. Report the start date from mapping the course is aligned to.
MTerm.startDateSystem Administration > Calendar > Calendar > Terms > Start Date
endDate

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

  1. When reporting from a Term Schedule, report the end date of the term being reported 
    1. If more than 1 term has the same Term Type selected, use the latest end date
  2. When reporting from a Term Type Override on a section:
    1. Report the end date from 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 the term is associated with. 

  1. When reporting from Term Schedule, count the total number of instructional days from the Days tab from the calendar and schedule structure the term is associated with
    1. A day reset must be completed before the days will calculate.  Use the resync after day reset is completed to have instructional days calculated and sent.
    2. If more than 1 term schedule has the same Term Type, count the distinct number of instructional days from all terms for that Term Type
  2. When reporting from Term Type Override, count the  number of instructional days that fall on/between the start and end dates.
 

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.ON/AN/A
gradingPeriods An unordered collection of sessionGradingPeriods.ON/AN/A
gradingPeriodReference

Report a record for each Grading Period reported in the Grading Periods Resource that occurs in the session being reported.

When reporting from Term Type Override, reference all grading periods that are associated with any course or section with the same Term Type Override

  • The course is associated with the grading task of the grading period
  • The section is placed in the term of the grading period

If there is not a Grading Period association with the Session, the array will be NULL and the Session record will error

MN/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 Term Descriptor:

CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
COContinuousContinuousContinuousContinuous
1SFall SemesterFall SemesterFall SemesterFall Semester
2SSpring SemesterSpring SemesterSpring SemesterSpring Semester
SSSummer SemesterSummer SemesterSummer SemesterSummer Semester
1TFirst TrimesterFirst TrimesterFirst TrimesterFirst Trimester
2TSecond TrimesterSecond TrimesterSecond TrimesterSecond Trimester
3TThird TrimesterThird TrimesterThird TrimesterThird Trimester
FYFull YearFull YearFull YearFull Year
MTMiniTermMiniTermMiniTermMiniTerm
1QFirst QuarterFirst QuarterFirst QuarterFirst Quarter
2QSecond QuarterSecond QuarterSecond QuarterSecond Quarter
3QThird QuarterThird QuarterThird QuarterThird Quarter
4QFourth QuarterFourth QuarterFourth QuarterFourth Quarter
OTOtherOtherOtherOther
8MEighth MiniTermEighth MiniTermEighth MiniTermEighth MiniTerm
11MEleventh MiniTermEleventh MiniTermEleventh MiniTermEleventh MiniTerm
5MFifth MiniTermFifth MiniTermFifth MiniTermFifth MiniTerm
1MFirst MiniTermFirst MiniTermFirst MiniTermFirst MiniTerm
4MFourth MiniTermFourth MiniTermFourth MiniTermFourth MiniTerm
9MNinth MiniTermNinth MiniTermNinth MiniTermNinth MiniTerm
2MSecond MiniTermSecond MiniTermSecond MiniTermSecond MiniTerm
7MSeventh MiniTermSeventh MiniTermSeventh MiniTermSeventh MiniTerm
6MSixth MiniTermSixth MiniTermSixth MiniTermSixth MiniTerm
10MTenth MiniTermTenth MiniTermTenth MiniTermTenth MiniTerm
3MThird MiniTermThird MiniTermThird MiniTermThird MiniTerm
12MTwelfth MiniTermTwelfth MiniTermTwelfth MiniTermTwelfth MiniTerm



Staff Cohort Association

This association indicates the Staff associated with a cohort of students.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Staff is assigned as "Instructor" to a Program Session that is reported as a Cohort in the Scoped Year.

  • The Cohort can only be created from Program Admin> Programs> Programs tab.
  • The Staff member must have an Ed-Fi ID to report.
PutWhen the end date is updated on the Program Sessions tab.
Delete/PostWhen any part of the Natural Key changes.
DeleteWhen the Program Session is deleted.
DeleteWhen staff is removed from the "Instructor" field.

Object Data Elements

Click here to expand...

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

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
cohortReference
(educationOrganizationId contained in this property)
Reports the the Natural Key of the Cohort resource.Mdistrict.numberSystem Admin > Resources > District Information > District Detail > State District Number
staffreference
Reports the the Natural Key of the Staff resource.M

beginDate

The month, day, and year on which the Staff was first identified as part of the Cohort.

Reports the Start Date the staff is assigned to the Program Session.

O

programSession.startdatePrograms Admin > Programs > Program Sessions > Start Date
endDate

The month, day, and year on which the Staff was removed as part of the Cohort.

  1. Reports the End Date the staff is ended from the Program Session.
  2. If NULL, does not report.
OprogramSession.enddatePrograms Admin > Programs > Program Sessions > End Date

studentRecordAccess

 

This element is optional and does not report.

ON/AN/A
etagA 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 checkbox checked and a District Assignment Code populated.

OR

 When a person has a District Assignment record and the District Staff checkbox 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 Assignment Code field 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.
Put

N/A, a delete and insert occurs when any field is edited and saved. 

Delete/PostWhen the person’s employment assignment record is changed
Delete/Post

When the person’s employment record is changed.

Delete/PostIf there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted.
Delete/Post

When the Assignment Code, Start Date or End date is modified on the District Assignment record.

DeleteWhen a District Assignment record is deleted.
DeleteWhen a District Employment record is deleted
DeleteWhen a District Employment record > District Staff is unchecked 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 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.

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.

 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
EmploymentAssociationReference

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

  • educationOrganizationReference
  • staffReference
  • employmentStatusDescriptor
  • hireDate
N/AN/A
educationOrganizationReference

A reference to the related EducationOrganization resource.

  1. First look to District Employment > District Staff.  If the checkbox is checked, report staff with the District Number.
  2. If the District Staff checkbox is not checked, report the State School Number.
MN/AN/A
staffReference

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

  • staffUniqueId
MN/AN/A
staffClassificationDescriptor

The titles of employment, official status, or rank of education staff.

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.
MEmploymentAssignment.
assignmentCode
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. This element reports the Start Date from the District Assignment being reported.

  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.
EmploymentAssignment.
startDate
Census > People > District Assignment > Start Date
positionTitle

The descriptive name of an individual's position. 

  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.
OEmployment.
edFiOrgTitle
Census > People> District Employment > Ed-Fi Org Title > Ed-Fi 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.

  1. When reporting from the District Employment record, report the District Employment End Date
    1. If NULL, do not report
  2. When reporting from the District Assignment record, report the District Assignment End Date
    1. If NULL, do not report
EmploymentAssignment.
endDate
Census > People > District Assignment > End Date
orderOfAssignment

Describes whether the assignment is this the staff member's primary assignment, secondary assignment. 

 

This element is optional and does not report.

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

 

The Data Dictionary for Ed Org Title/Staff Classification is an unlocked list that is managed by the districts.

To create a new or modify an existing Ed-Fi Org Title Code:

  1. When Ed-Fi Org Title Code on District Employment is not null, a record will be sent for that employee.
    1. When Ed-Fi Org Title Code on District Employment is null, a record will not be sent for that employee

Field Logic :

  1. When Ed-Fi Org Title's Standard code = 000, the educationOrganizationReference will report 000.
  2. When Ed-Fi Org Title's Standard code = NA, the Position Title will report blank.  Else, Position Title will report the ED-Fi Short description which is the Name field in the data dictionary.



Staff Education Organization Employment Association

This association indicates the education organization an employee, contractor, volunteer or other service provider is formally associated with typically indicated by which organization the staff member has a services contract with or receives compensation from.

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. The Employment Status field is not mapped in Resource Preferences.
PutN/A, a delete and insert occurs when any field is edited and saved. 
Delete/PostWhen the person’s employment assignment record is changed.
Delete/PostWhen the person’s employment record is changed.
Delete/Post

If there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted.

DeleteWhen a District Assignment record is deleted.
DeleteWhen a District Employment record is deleted.
DeleteWhen a District Employment record > District Staff checkbox is removed, 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 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 Education Organization Employment Association resource.

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

Logic first looks to District Employment > District Employment > Ed-Fi Org Title droplist.  When  District Employment > Ed-Fi Org Title's Standard Code = 000, report EdOrgRef with District Number.

  1. First look to District Employment > District Staff.  If the checkbox is checked, report staff with the District Number.
  2. If the District Staff checkbox is not checked, report the State School Number from the District Assignment record.


MN/ASystem Administration> Resources> District Information> State District Number

OR

System Administration> Resources> School> State School Number

staffReference

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

  • staffUniqueId
MN/AN/A
employmentStatus
Descriptor

This descriptor defines the type of employment or contract.

  1. When reporting from the District Employment record, report 'Tenured or permanent'
  2. When reporting from the District Assignment tab, report the value in the Ed-Fi code field from the 'Type' droplist 
    1. Report the attribute Default Value if available and the field is NULL in the DB
    2. If the 'Type' field is NULL and there is no Default Value, report 'Tenured or permanent'
MEmployment
assignment.type
Census > People > District Assignment > Type
hireDate

The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid).

  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
MEmployment
assignment.startDate
Census > People > District Assignment > Start Date
endDate

The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). 

  1. When reporting from the District Employment record, report the District Employment End Date
    1. If NULL, do not report
  2. When reporting from the District Assignment record, report the District Assignment End Date
    1. If NULL, do not report
OEmployment
assignment.endDate
Census > People > District Assignment > End Date
separationType

The type of employment separation (e.g., Voluntary separation, Involuntary separation, Mutual agreement, Other, etc).

This is not collected within Campus and is not reported.

ON/AN/A 
separationReason
Descriptor

This descriptor defines the reasons for terminating the employment.

This is not collected within Campus and is not reported.

N/A N/A 
department

The department or su-organization the employee/contractor is associated with in the Education Organization.

This is not collected within Campus and is not reported.

ON/AN/A
fullTimeEquivalency

The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting.

This is not collected within Campus and is not reported.

N/AN/A
offerDate

Date at which the staff member was made an official offer for this employment.

This is not collected within Campus and is not reported.

ON/AN/A
hourlyWage

Hourly wage associated with the employment position being reported.

This is not collected within Campus and is not reported.

O  N/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 Employment Status Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
ProbationaryProbationaryProbationary
ContractualContractualContractual
Substitute/temporarySubstitute/temporarySubstitute/temporary
Tenured or permanentTenured or permanentTenured or permanent
Volunteer/no contractVolunteer/no contractVolunteer/no contract
Employed or affiliated with outside organizationEmployed or affiliated with outside organizationEmployed or affiliated with outside organization
Non-contractualNon-contractualNon-contractual
Employed part-timeEmployed part-timeEmployed part-time
Employed or affiliated with outside agency part-timeEmployed or affiliated with outside agency part-timeEmployed or affiliated with outside agency part-time
OtherOtherOther

 



Staff Education Organization Identity Associations

This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

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 and the District Employment > Ed-Fi Org Title's Standard Code = 000

OR

When a person has a District Assignment record and District Employment > Ed-Fi Org Title is blank or the Standard Code does not = 000


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 staff records are 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 check boxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
  • When Census > People > Demographics > Personal Contact Info > Email = Null.
PutWhen any data is edited for the person in the Data Elements fields below.
PutWhen the person’s employment assignment record is changed.
PutWhen the person’s employment record is changed.
Delete

We will not send any deletes for this resource.

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 or District Employment record that is aligned to a scoped year

Report when a staff has an active District Assignment or District Employment 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.

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 use

Object Data Elements

Click here to expand...

This table describes data elements sent within the Staff Education Organization Identity Associations resource.

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

educationOrganizationReference/
educationOrganizationId

A reference to the related EducationOrganization resource.

MN/A

System Administration > Resources > District Info > District Editor > District Detail > State District Number

System Administration > Resources > School > Entity ID

staffReference/staffUniqueIdA reference to the related Staff resource.MN/AN/A
electronicMailAddress

The electronic mail (e-mail) address listed for an individual or organization.

MN/ACensus > People > Demographics > Personal Contact Info > Email
telephones

An unordered collection of staffEducationOrganizationIdentityAssociationTelephones. The 10-digit telephone number, including the area code, for the person.

 ON/AN/A
TelephoneNumberType

The type of communication number listed for an individual or organization.

Only report when the applicable UI field is NOT = Null:

  • Report "Mobile" when reporting from Census > People > Demographics > Personal Contact Info > Cell Phone
  • Report "Other" when reporting from Census > People > Demographics > Personal Contact Info > Other Phone
  • Report "Work" when reporting from Census > People > Demographics > Personal Contact Info > Work Phone
M

N/A

Census > People > Demographics > Personal Contact Info
TelephoneNumberThe telephone number including the area code, and extension, if applicable.MN/ACensus > People > Demographics > Personal Contact Info
OrderOfPriorityOptional and does not reportON/AN/A
TextMessageCapabilityIndicatorOptional and does not reportON/AN/A
_etag

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

ON/AN/A



Staff

This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

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.

OR

When a person has a District Assignment record that overlaps the configured year and they have an Ed-Fi ID.

Do NOT report a record when the following scenario is true: 

  • There is no Ed-FI ID for the staff person. 
  • The staff records are not active based on the Scope Year logic listed below
Put

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

  • When the person’s identity record is changed.
  • When the person’s employment assignment record is changed.
  • When the person’s employment record is changed.
  • When one of the person’s section staff history records is changed.
  • When one of the person’s employment credentials is changed.
DeleteStaff records are a shared resource among all districts, this record will not delete.

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.

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

Object Data Elements

Click here to expand...

This table describes data elements sent within the Staff resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
staffUniqueIdA unique alpha-numeric code assigned to a staff. The staff member's Ed-Fi ID is reported.MCensus.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
firstNameThe staff member's legal first name. The first name form the person's current identity record is reported.MIdentity.firstNameCensus > People > Identities > First Name
middleNameThe staff member's legal middle name. The middle name form the person's current identity record is reported.CIdentity.
middleName
Census > People > Identities > Middle Name
lastSurnameThe staff member's legal last name. The last name form the person's current identity record is reported.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). The suffix form the person's current identity record is reported.CIdentity.suffixCensus > People > Identities > Suffix
maidenName

The person''s maiden name, if applicable.

 

This element is currently not reported or collected.


ON/A N/A 
sexTypeThe person's gender.MIdentity.genderCensus > People > Identities > Gender
birthDateThe month, day, and year on which an individual was born. The Birth Date from the person's current identity record is reported.MIdentity.birthDateCensus > People > Identities > Birth Date
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. 

Report from "Is the individual Hispanic/Latino?" from the person's current identity:

  1. If droplist is = Yes, report "true"
  2. If droplist is = No or NULL, report "false"
MIdentity.
hispanicEthnicity
Census > People > Identities > Date Entered US
oldEthnicityType

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. 

 

This element is optional and is not reported.

OIdentity.
raceEthnicityFed
Historical data in Campus database
highestCompletedLevel
OfEducationDescriptor

The highest level of completed for a staff member. The Education value from the person's Credentials tab is reported. 

  1. Report the Ed-Fi Code value from from the person's Credentials tab when the Credential Type is = ED:  Education
  2. If there is not a valid credential, report the Ed-Fi Code Value from Education droplist on the person's District Employment record 
  3. If there is no Education record or the Ed-Fi code value is NULL, do not report.

Scope Year logic is used to determine the Scope Year to post or update.

See the Level of Education Descriptors table in the section below for the Ed-Fi value that is reported.

ON/A

Census > People > Credentials

Census > People > District Employment

yearsOfPrior
ProfessionalExperience

The total number of years that an individual has previously held a similar professional position in one or more education institutions. 

 

This element is currently not reported or collected.

ON/AN/A
yearsOfPrior
TeachingExperience

The total number of years that an individual has previously held a teaching position in one or more education institutions. 

 

This element is currently not reported or collected.

ON/AN/A
highlyQualifiedTeacher

An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for ALL sections being taught.

This element reports True when the person has a Credential Type = HQ: Highly Qualified.

  • Start date must be on or before today's date
  • End date must be NULL, or on or after today's date 

This element reports False when the person is a teacher on any active course section and does not have an HQ: Highly Qualified Credential.

If person is not a teacher, do not report a record.

Scope Year logic is used to determine the Scope Year to post or update.

ON/ACensus > People > Credentials
loginId

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

 

This element is currently not reported or collected.

ON/A N/A 
citizenshipStatusType

 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/A N/A 
addresses

 Report the person's address(es). 

 

This element is optional and is not reported.

ON/AN/A
credentials

 An unordered collection of staffCredentials. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.


 

This element is optional and is not reported.

ON/AN/A
electronicMails

An unordered collection of staffElectronicMails. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. 

See the Electronic Mail Types table in the section below for the Ed-Fi value that is reported. This element is an array which also reports the following data:

OContact.email

Census > People > Demographics > Email

Census> People> Demographics> Secondary Email

electronicMailTypeThis element reports the Electric Mail mapping. The Email (primary) address reports as 'Work'. The Secondary Email address reports as 'Home/Personal'.
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.email

Census > People > Demographics > Email

Census> People> Demographics> Secondary Email

primaryEmail
AddressIndicator
An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.ON/AN/A
identificationCodes

An unordered collection of staffIdentificationCodes. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. 

This element reports the State Staff ID and/or the License Number form the District Employment record. If License Number on the District Employment record is null, the License Number form the Credentials tab is reported if is a value of Licensure/Certification.

If the Local Staff Number is populated, this value is reported. 

Scope Year logic is used to determine the Scope Year to post or update.

See the Staff Identification System Type table in the section below for the Ed-Fi value that is reported.

This element is an array which also reports the following data:

ON/ACensus > People >Demographics > State Staff ID

and/or

Census > People > District Employment > License

or

Credentials > License Number

Staff Identification System TypeThis element reports the short description from the Staff Identification Code mapping described in the table and section below.MN/AN/A
Assigning Organization Identification CodeThe organization code or name assigning the Staff Identification Code.ON/AN/A
Identification Code

A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity. Reporting Logic is as follows:

  1. Report the Staff State ID if populated
  2. Report the  License Number from the District Employment Record
    1. Start Date must be on or before today's date
    2. End Date must be on or after today's date 
  3. If License Number from District Employment is NULL, Report the License Number from the Credentials tab when the type = Licensure/Certification 
    1. Start Date must be on or before today's date 
    2. End Date must be on or after today's date
    3. If staff has more than 1 eligible record, report the most recent start date.  
      1. If start date is the same, report highest id.
MN/AN/A
identificationDocuments

An unordered collection of staffIdentificationDocuments. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

 

This element is currently not reported or collected.


ON/A N/A 
internationalAddresses

An unordered collection of staffInternationalAddresses. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

 

This element is currently not reported or collected.


ON/AN/A 
languages

An unordered collection of staffLanguages. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

 

This element is currently not reported or collected.

ON/AN/A
otherNames

 An unordered collection of staffOtherNames. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

 

This element is currently not reported or collected.

ON/AN/A 
races

An unordered collection of staffRaces. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. 

This element looks at the Race Ethnicity checkboxe(s) marked on the person's Identity record. See the Race Type table in the section below for the Ed-Fi value that is reported.

This element is also an array which reports the following data:

O

Identity.
raceEthnicity

and

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

This element reports the short description mapped based on the Race Type table in the section below.

Identity.
raceEthnicity

and

RaceEthnicity.
raceid

 Census > People > Identities > Race/Ethnicity
telephones

An unordered collection of staffTelephones. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

This element reports the phone numbers entered in the person's Personal Contact Information editor. See the Telephone Number table in the section below for the Ed-Fi value that is reported.

This element is an array which reports the following additional data:

O

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

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

telephoneNumberTypeThis element reports the short description mapped in the Telephone Number Type table listed in the section below.MN/AN/A
orderOfPriorityThe order of priority assigned to telephone numbers to define which number to attempt first, second, etc.ON/AN/A
textMessage
CapabilityIndicator
An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.ON/AN/A
telephoneNumberThe 10-digit telephone number, including the area code, for the person. This element reports the phone numbers entered in the person's Personal Contact Information editor.M

Contact.homephone

Contact.workphone

Contact.cellphone

Contact.pager

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

An unordered collection of staffVisas. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

 

This element is currently not reported or collected.

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 Level of Education Descriptors:

Code in CampusName in CampusEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
HSHigh School DiplomaNNoneNone
GEDGED or EquivalentNNoneNone
AAssociatesAAssociatesAssociates Degree (two years or more)
AAAssociate of Arts (A.A.)AAssociatesAssociates Degree (two years or more)
ASAssociate of Science (A.S.)AAssociatesAssociates Degree (two years or more)
AASAssociate of Applied Science (A.A.S.)AAssociatesAssociates Degree (two years or more)
BBachelorsBBachelor'sBachelor's
BABachelor of Arts (B.A.)BBachelor'sBachelor's
BSBachelor of Science (B.S.)BBachelor'sBachelor's
BFABachelor of Fine Arts (B.F.A.)BBachelor'sBachelor's
BBABachelor of Business Administration (B.B.A.)BBachelor'sBachelor's
BEDBachelor of Education (B.Ed.)BBachelor'sBachelor's
FPDFirst Professional DegreeMMaster'sMaster's
MMastersMMaster'sMaster's
MAMaster of Arts (M.A.)MMaster'sMaster's
MSMaster of Science (M.S.)MMaster'sMaster's
MEDMaster of Education (M.Ed.)MMaster'sMaster's
MBAMaster of Business Administration (M.B.A.)MMaster'sMaster's
CAGSCertificate in Advanced Graduate StudyBBachelor'sBachelor's
JDJuris DoctorDDoctorateDoctorate
EDDEducational Doctorate (Ed.D.)DDoctorateDoctorate
EDSEducational Specialist (Ed.S.)DDoctorateDoctorate
PHDDoctor of Philosophy (Ph.D.)DDoctorateDoctorate
MDDoctor of Medicine (MD)DDoctorateDoctorate
PSDDoctor of Psychology (Psy.D.)DDoctorateDoctorate


This table describes the Ed-Fi Value mapped and reported for Level of Education Descriptors (District Employment):

Code in CampusCampus NameEd-Fi CodeEd-Fi Short Description Ed-Fi Description
1Doctorate

D

Doctorate

Doctorate

2Master's degree 30+ semester hrs MMasters Masters
3Master's degreeMMasters Masters
4Bachelor's degree 30+ semester hrsBBachelorsBachelors
5Bachelor's degreeBBachelorsBachelors
6Less than bachelor's degreeNNoneNone




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 is created or changed 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 records are not active based on the Scope Year logic listed below
PutN/A, a delete and insert occurs when any field is edited and saved. 
Delete/InsertWhen the person’s employment assignment record is changed.
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 or District Employment record that is aligned to a scoped year.

  • Report when a staff has an active District Assignment or District Employment 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 resourceMN/A N/A 
schoolReference

Reports data from the SchoolID field that is part of the natural key for the Schools resource. The following elements are reported:

  • schoolID
MN/A N/A 
staffReference

Reports data from the SchoolID field that is part of the natural key for the Staff resource. The following elements are reported:

  • staffUniqueId
MN/A N/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 . A default value of Regular Education is reported if no program name is assigned.

See the Program Assignment Descriptors table in the Type/Descriptor section below.

N/A N/A 
schoolYearThe reporting school year.ON/A N/A 
academicSubjectsAn unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.N/A N/A 
gradeLevels An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services.N/A N/A 
_etag A unique system-generated value that identifies the version of the resourceN/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 Program Assignment Descriptors:

Ed-Fi CodeEd-Fi Short Description Ed-Fi Description

Bilingual/English as a Second Language

Bilingual/English as a Second Language

Bilingual/English as a Second Language

Regular EducationRegular EducationRegular Education
OtherOtherOther
Title I-Non-AcademicTitle I-Non-AcademicTitle I-Non-Academic
Special EducationSpecial EducationSpecial Education
Title I-AcademicTitle I-AcademicTitle I-Academic

 



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

Report a StudentAcademicRecord instance for each school year in which the student has a transcript record and they have a Student School Association record for the scoped year.

  • When the "Ed-Fi Transcript Term Override" field on the Transcript is null on a manually added course, record will provide an error with the following message, "Ed-Fi Transcript Term Override field must not be null."
  • We will post to update the Cumulative Earned Credits field when the Earned Credit field is updated or a new transcript record is added added/deleted with a Earned Credit Value that is not null and is greater than 0
DeleteStudent Academic Records will only delete when a student has only 1 Student School Association record for a specific Year and all Student School Association records are deleted.
Delete

When the State Exclude or No Show check boxes are checked on the student's enrollment.

 

If these boxes are unchecked, the data will not post. A resync must be completed in order to resend the data.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Records will send to each scope year in which the Course Transcript record is posted.

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 Academic Record resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
N/AidThe unique identifier of the resource.MN/AN/A
educationOrganization
Reference

A reference to the related EducationOrganization resource.

Reports the District Number


MN/AN/A
schoolYearTypeReference

A reference to the related SchoolYearType resource.

Reports the end year for the transcript record being reported

MN/AN/A
studentReference

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

  • studentUniqueId
MN/AN/A
termDescriptor

The term for the session during the school year. See the Term Descriptor table in the Type/Descriptor section below.

  1. Report the Ed-Fi code for the value selected in "Ed-Fi Transcript Term Override" field on the transcript.
    1. If NULL, Report the Term Descriptor based on the Course Term Type Override, else Section Term Type Override.  
  2. When the Ed-Fi Transcript Term Override and both the Course Term and the Section Term Override fields are Null, report the Term Descriptor for the term aligned to the Grading Score for the posted Grade.
  3. Else, report the Ed-Fi Code from the Ed-Fi Transcript Term Descriptor Override in the SAR preferences.
  4. If an Term cannot be determined, provide error.
  5. When the SAR is posted only from the Graduation Record because there are no Course Transcripts records for the student, report the Ed-Fi Term Descriptor from the Sessions Resource Preferences that the Diploma Date falls in.   
    1. If the Diploma Date is outside of any of the Term Dates for that School Year, report the Ed-Fi Term Descriptor from the Term with the latest End Date.
    2. If the Diploma Date is aligned to more than 1 Term Descriptor, report the value from the highest TermId.
MN/AN/A
cumulativeEarnedCreditType

Key for Credit.

This is optional and does not report.

ON/AN/A
cumulativeEarnedCredit
Conversion

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

This is optional and does not report.

ON/AN/A
cumulativeEarnedCredits

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.

  1. Sum the total number of credits the student has earned based on the total number of Credits Earned the student has in the Transcript Credit table.
    1. Report '0' if the student does not have any Credits Earned
  2. This value will be the same for all Student Academic Records that are being updated, regardless of Term Type or Year.
OCalculated value from the earned credit field in the transcriptcredit tableStudent Information > General > Transcripts
cumulativeAttemptedCreditType

Key for Credit

This is optional and does not report.

ON/AN/A
cumulativeAttempted
CreditConversion

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

This is optional and does not report.

ON/AN/A
cumulativeAttemptedCredits

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 is optional and does not report.

ON/AN/A
cumulativeGradePointsEarned

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 is optional and does not report.

ON/AN/A
cumulativeGradePointAverage

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 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 is optional and does not report.

ON/AN/A
projectedGraduationDate

The month and year the student is projected to graduate.

This is optional and does not report.

ON/AN/A
sessionEarnedCreditType

Key for Credit

This is optional and does not report.

ON/AN/A
sessionEarnedCreditConversion

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

This is optional and does not report.

ON/AN/A
sessionEarnedCredit

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

This is optional and does not report.

ON/AN/A
sessionAttemptedCreditType

Key for Credit.

This 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 is optional and does not report.

ON/AN/A
sessionAttemptedCredit

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

This is optional and does not report.

ON/AN/A
sessionGradePointsEarned

The number of grade points an individual earned for this session

This is optional and does not report.

ON/AN/A
sessionGradePointAverage

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

This is optional and does not report.

ON/AN/A
classRanking

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

This is optional and does not report.

ON/AN/A
academicHonors

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

This is optional and does not report.

ON/AN/A
diplomas

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

This 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 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 is optional and does not report.

ON/AN/A
_etag

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

This 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 Term Descriptor:

CodeNameEd-Fi CodeEd-Fi Short DescriptionEd-Fi Description
1QFirst QuarterFirst QuarterFirst QuarterFirst Quarter
2QSecond QuarterSecond QuarterSecond QuarterSecond Quarter
3QThird QuarterThird QuarterThird QuarterThird Quarter
4QFourth QuarterFourth QuarterFourth QuarterFourth Quarter
1SFall SemesterFall SemesterFall SemesterFall Semester
2SSpring SemesterSpring SemesterSpring SemesterSpring Semester
SSSummer SemesterSummer SemesterSummer SemesterSummer Semester
1TFirst TrimesterFirst TrimesterFirst TrimesterFirst Trimester
2TSecond TrimesterSecond TrimesterSecond TrimesterSecond Trimester
3TThird TrimesterThird TrimesterThird TrimesterThird Trimester
FYFull YearFull YearFull YearFull Year
MTMiniTermMiniTermMiniTermMiniTerm
COContinuousContinuousContinuousContinuous
OTOtherOtherOtherOther
8MEighth MiniTermEighth MiniTermEighth MiniTermEighth MiniTerm
11MEleventh MiniTermEleventh MiniTermEleventh MiniTermEleventh MiniTerm
5MFifth MiniTermFifth MiniTermFifth MiniTermFifth MiniTerm
1MFirst MiniTermFirst MiniTermFirst MiniTermFirst MiniTerm
4MFourth MiniTermFourth MiniTermFourth MiniTermFourth MiniTerm
9MNinth MiniTermNinth MiniTermNinth MiniTermNinth MiniTerm
2MSecond MiniTermSecond MiniTermSecond MiniTermSecond MiniTerm
7MSeventh MiniTermSeventh MiniTermSeventh MiniTermSeventh MiniTerm
6MSixth MiniTermSixth MiniTermSixth MiniTermSixth MiniTerm
10MTenth MiniTermTenth MiniTermTenth MiniTermTenth MiniTerm
3MThird MiniTermThird MiniTermThird MiniTermThird MiniTerm
12MTwelfth MiniTermTwelfth MiniTermTwelfth MiniTermTwelfth MiniTerm

Student Cohort Association

This entity represents any type of list of designated students for tracking, analysis, or intervention.

Object Triggering Logic

Click here to expand...

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Student is assigned to a Program that is reported as a Cohort in the configured year and they have a valid Student School Association in the current scoped year.

  • The Cohort can only be created from Program Admin > Programs > Programs tab.
PutWhen the end date is updated on the Student's Programs tab.
Delete/PostWhen any part of the Natural Key changes.
Delete/PostWhen 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 the Program Participation record is deleted.

Object Data Elements

Click here to expand...

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

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.MN/AN/A
cohortReference
(educationOrganizationId contained in this property)
Reports the the Natural Key of the Cohort resource.Mdistrict.numberSystem Admin > Resources > District Information > District Detail > State District Number
studentreference
Reports the the Natural Key of the Studentresource.M

beginDate

The month, day, and year on which the student was first identified as part of the Cohort.

Reports the Start Date the student was assigned to the Cohort.

O

programparticipation.startdateStudent Information > Program Participation > Programs > Start Date
endDate

The month, day, and year on which the student was removed as part of the Cohort.

  1. Reports the End Date the studen tis ended from the cohort.
  2. If NULL, does not report.
Oprogramparticipation.enddateStudent Information > Program Participation > Programs > End Date

sections

 

This element is optional and does not report.

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

Student CTE Program Association

This association represents the CTE 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 Career Tech Program is assigned to the student and the record Start Date is not after the student's enrollment End Date in the current calendar.

  • Report a record based on the student having an enrollment record in the calendar in which the Career Tech Program record aligns
  • Do not send a 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 send a record if the Career Tech Program record has either "Active" or "State Reported" NOT = Checked
  • Do not send a record if enrollment is in a school marked as Exclude
Post/DeleteWhen the Program Name or careerPathwayType or the Start Date values are changed, the old record must be deleted, and a new Post must occur
PutWhen the cipCode for the reporting CTE record is changed.
PutUpdate the record if the endDate value in this resource is changed.
Delete

When all enrollments for a calendar in which that student has a Career Tech Program record are deleted.

DeleteWhen the Career Tech Program record is deleted.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

When a new Career Tech Program record is assigned to the student, the record will post to the scope year(s) that the overlapping enrollments are in.

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 CTE Program Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.O N/A N/A
studentReference

A unique alpha-numeric code assigned to a student

MstudentReference.
studentUniqueId
Census > People > Demographics > EdFi ID
programReference

A reference to the related Student resource.

MN/AN/A
educationOrganization
Reference
The education organization where the student is participating in or receiving the program services.MDistrict.numberSystem Administration > Resources > District Info > State District Number
beginDateThe month, day, and year on which the student first received services.MN/AStudent Information > Academic Planning > Programs > Career Tech Program > Career Tech Program Detail > Start Date
endDate

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

Logic reports as follows:

  1. Report the End Date in Student Info > Academic Planning > Programs > Career Tech Program > Career Tech Program Detail > End Date
    1. When End Date = Null, do not report.
  2. When > 1 CTE record is assigned to the student where the record has the same Cluster and Start Date, report the End Date based on the following hierarchy:
    1. Null End Date
    2. Latest End Date
CN/AStudent Information > Academic Planning > Programs > Career Tech Program > Career Tech Program Detail > End Date
ctePrograms

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

CN/AN/A
careerPathwayType

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

  1. Report the Ed-Fi code mapped to the Cluster associated with the CTE Program.
  2. When no selection is made in Cluster, do not report.
C

N/A

Program Admin > Programs > Career Tech Programs > Cluster
cipCode

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

  1. Report the State Code (CIP) from Program Admin> Programs> Career Tech Programs> Career Tech Program Detail> State Code (CIP)
  2. When "State Code (CIP)" = Null, do not report.
  3. When > 1 CTE program with the same Start Date and Cluster, report the CIP code from the record in which the End Date is derived.
ON/AProgram Admin > Programs > Career Tech Programs > Career Tech Program Detail > State Code (CIP)

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Agriculture, Food and Natural ResourcesAgriculture, Food and Natural ResourcesAgriculture, Food and Natural Resources
Architecture and ConstructionArchitecture and ConstructionArchitecture and Construction
Arts, A/V Technology and CommunicationsArts, A/V Technology and CommunicationsArts, A/V Technology and Communications
Business, Management and AdministrationBusiness, Management and AdministrationBusiness, Management and Administration
Education and TrainingEducation and TrainingEducation and Training
FinanceFinanceFinance
Government and Public AdministrationGovernment and Public AdministrationGovernment and Public Administration
Health ScienceHealth ScienceHealth Science
Hospitality and TourismHospitality and TourismHospitality and Tourism
Human ServicesHuman ServicesHuman Services
Information Technology
Information Technology
Information Technology
Law, Public Safety, Corrections and SecurityLaw, Public Safety, Corrections and SecurityLaw, Public Safety, Corrections and Security
ManufacturingManufacturingManufacturing
Marketing, Sales and ServiceMarketing, Sales and ServiceMarketing, Sales and Service
Science, Technology, Engineering and MathematicsScience, Technology, Engineering and MathematicsScience, Technology, Engineering and Mathematics
Transportation, Distribution and LogisticsTransportation, Distribution and LogisticsTransportation, Distribution and Logistics
OtherOtherOther



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

  • Incident must have at least 1 behavior event associated and a Role that is mapped to an Ed-Fi Value
  • Posting can occur if a new event is added after Incident is marked as "Complete"
  • Do not send if the student's enrollment is marked as No Show or State Exclude
  • Do not send if the student is in a calendar marked as Exclude
  • Do not send if the student's enrollment is in a school marked as Exclude
Delete/Post

When data that is part of the Natural Key is changed

  • If the Date of Incident is changed and saved
  • If the Event Type is changed and saved
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
DeeteWhen an incident is deleted
Delete

When all non-excluded enrollments in the school and year are deleted

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Discipline records will only send to the school year that the incident date is aligned to based on 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 Student Discipline Incident Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.M N/AN/A
discipline Incident Reference

Reports data from the fields that are part of the natural key for the Discpline Incident resource. The following elements are reported:

  • schoolReference
  • incidentIdentifier
MN/AN/A
studentReference

Reports data from the fields that are part of the natural key for the Student resource. The following elements are reported:

  • studentUniqueId
MN/AN/A
Student Participation Code Type

The role or type of participation of a student in a discipline incident.

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

  1. If the student has more that 1 role with different Ed-Fi Code values, the last one to sync wins
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.

 ON/AN/A
Behavior Descriptor

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


  1. Only report behaviors the student being reported is associated with.
  2. Report the Ed-Fi code value from the mapped Behavior Event.
  3. If the Behavior Event is not mapped, do not report.
O

N/A

Behavior > Behavior Management > Event Type
Detailed Description

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

This is optional 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...
 

The highlighted column indicates the reported value.

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

State CodeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
OffenderPerpetratorPerpetratorPerpetrator
ParticipantPerpetratorPerpetratorPerpetrator

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

State CodeNameEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
ALCALCOHOLState OffenseState OffenseState Offense
ARSARSONState OffenseState OffenseState Offense
BATBATTERYState OffenseState OffenseState Offense
BRKBREAKING AND ENTERING/BURGLARYState OffenseState OffenseState Offense
BULBULLYINGState OffenseState OffenseState Offense
CBLCYBER BULLYINGState OffenseState OffenseState Offense
DOCDISORDERLY CONDUCTSchool Code of ConductSchool Code of ConductSchool Code of Conduct
DRGDRUGS-EXCLUDING ALCOHOLState OffenseState OffenseState Offense
FITFIGHTINGState OffenseState OffenseState Offense
HARHARASSMENTState OffenseState OffenseState Offense
HOMHOMICIDEState OffenseState OffenseState Offense
KIDKIDNAPPING (ABDUCTION)State OffenseState OffenseState Offense
MVTMOTOR VEHICLE THEFTState OffenseState OffenseState Offense
OMCOTHER MAJOR OFFENSES/UNCLASSIFIEDOtherOtherOther
ROBROBBERYState OffenseState OffenseState Offense
STLLARCENY/THEFTState OffenseState OffenseState Offense
SXBSEXUAL BATTERYState OffenseState OffenseState Offense
SXHSEXUAL HARASSMENTState OffenseState OffenseState Offense
SXOSEX OFFENSESState OffenseState OffenseState Offense
TBCTOBACCOState OffenseState OffenseState Offense
TRETHREAT/INTIMIDATIONState OffenseState OffenseState Offense
TRSTRESPASSINGState OffenseState OffenseState Offense
VANVANDALISMState OffenseState OffenseState Offense
WPOWEAPONS POSSESSIONState OffenseState OffenseState Offense



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 on the Relationships tab.

  • The guardian does NOT have to be a member of the same household as the student to report.
  • Ed-Fi does not have relationship start or end dates, if a relationship is started anytime within a school year, the record will be added for that year. 

    • End Date must be blank or after school year end date defined in the School Years editor

    • Start Date must be on or before school year end date defined in the School Years editor

  • Report the person from the related pair that does not have an enrollment for the Parent Reference and the person that has an enrollment as the student reference.
    • If the student is a guardian of themselves (emancipated) then report the student as both the Parent and the Student.
    • If both people have a current enrollment, report the person with the higher age. 

    • If age cannot be determined, do not report a record

    • 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
PutWhen the relationship type is changed
Delete

When the Guardian check box is unchecked, relationship is end dated or deleted.

  • Ed-Fi does not have relationship start or end dates, if a relationship is ended within a school year, the record will be deleted for that year. 
  • End Date must be blank or after school year end date defined in the School Years editor
Delete

 Records will delete when a student has only 1 Student School Association record for a specific School and Year that record is deleted for. 

 

If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data

Delete

When the State Exclude or No Show check boxes are checked. 

 

if the boxes are unchecked the data will not re-post, 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

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 Relationship Type table in the section below for the Ed-Fi value that is reported.

ON/AN/A
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 will report true if there is a number entered in the Emergency Priority field for the parent being reported.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 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 or Exited EL, and the record overlaps the configured year.
PutWhen the student is given an EL Exit Date.
Delete/PostWhen part of the record's Natural Key changes.
Delete

 When a student's EL record is deleted or when the record no longer overlaps the configured year

Delete

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
Includes all programs being reported in the Programs resource. Need to update this page to include all programs.

Records will send to the scope year for the school year they are associated with based on the student's enrollment.

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 Program Association resource.

Data Element Label

Business Requirement

M, C or O

Data Source GUI Path

Database Field

id  

The unique identifier of the resource.

M



educationOrganizationReference 

A reference to the related EducationOrganization resource.

  1. Reports the District State Number.

M




programReference 

A reference to the related Program resource.

  1. Reports Program reference.

M



ProgramReference/educationalOrganizationId
  1. Reports Program reference.
M

ProgramReference/Type
  1. Reports Program reference. For EL, "English as a Second Language (ESL)".
M

ProgramReference/Name
  1. Reports Program reference. For EL, "English as a Second Language (ESL)".
M

studentReference

A reference to the related Student resource.

  1. Reports the Student Reference with StudentUniqueId.

M



servicesAn unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.M

services/ServiceDescriptor

 A globally unique identifier within this descriptor type.

  1. Reports a hardcoded codeValue of "LS".
  2. Report the Description in the namespace property.

See Descriptors section below.

M

services/beginDate

The month, day, and year on which the Student first received services.

  1. Reports the Identified Date when reporting from EL

M

Student Information> English Learners> Identified Date

lep.identifieddate

services/endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

  1. Report the EL > "Exit Date" when not = Null.
  2. When "Exit Date" = Null, do not report.

C

Student Information> English Learners> Exit Date

lep.exitdate

reasonExitedDescriptor

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

  1. When EL > "Exit Reason" NOT = Null:
    1. Report the Ed-Fi Code mapped to the selected value.
  2. When EL > "Exit Reason" = Null, do not report this property.

C

Student Information> English Learner > Exit Reason

EarlyLearning.exitReason

servedOutsideOfRegularSession

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

 

This element is optional and does not report.

O



enrollmentStatus

 

This element is optional and does not report.

O



Type/Descriptor

Click here to expand...

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

Ed-Fi CodeShort DescriptionDescription
MSMedical ServicesMedical Services
PTPhysical therapyPhysical therapy
OMOrientation and MobilityOrientation and Mobility
OTOccupational therapyOccupational therapy
CSCounselingCounseling services
PSPsychological servicesPsychological services
RERecreationRecreation services
AUAudiological ServicesAudiological Impairment
EIEducational InterpretingEducational Interpreting
LSSpeech/Language ServicesSpeech/Language Services
OYOtherOther
PCParent Counseling and TrainingParent Counseling and Training
RCRehabilitation CounselingRehabilitation Counseling
SHSchool Health ServicesSchool Health Services
SNSchool NurseSchool Nurse
SWSocial Work ServicesSocial Work Services
TRSpecial TransportationSpecial Transportation

This table describes the Ed-Fi Value mapped and reported for Reason Exited Descriptor:

Ed-Fi CodeShort DescriptionDescription
DODropped outDropped out
GCGraduated with other certificate or diplomaGraduated with other certificate or diploma
GDGraduated with regular diplomaGraduated with regular diploma
Moved out of stateMoved out of stateMoved out of state
RPReturned to regular programReturned to regular program
OtherOtherOther
MAReached maximum ageReached maximum age
MNNormal MatriculationNormal Matriculation
Suspended or expelled from schoolSuspended or expelled from schoolSuspended or expelled from school
TOTransferred to another district or schoolTransferred to another district or school
Unknown reasonUnknown reasonUnknown reason
PEParental ExitParental Exit
DEDeceasedDeceased

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 State Exclude check box is unchecked.

  • Do not post a record when the State Exclude check box is checked
  • When a student has two enrollments in the same school for the same start date report from the enrollment service type in the following order:

    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record
  • Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled
Post

When the start date for an enrollment is changed

  • When an enrollment with a lower priority is changed, data will not send
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 State Exclude check boxes are checked

  • When a student has two enrollments in the same school for the same start date, records will lower priority will 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.

  1. Report the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi
    1. Program Start Date must be on or before "today's" date to report
    2. Program End Date must be null or after "today's date to report
      1. If an end date is added in the current scoped year, delete the reference
ON/AStudent Information > Academic Planning > Programs
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.

Report only for students with an enrollment in grade 9-12:

  1. Populate the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
  2. When NCLB Cohort End Year = Null, do not report.
CGraduation.gradYearStudent Information > General > Graduation
schoolYearType
Reference

The school year the student is being reported in. The end year of the calendar year is reported.

ON/AN/A
studentReference

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

  • studentUniqueId
MN/AN/A
entryDateThe 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.

  1. Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. If a mapping is not available, the record will error.
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

An optional globally unique namespace that identifies this descriptor set. If supplied, the author is strongly encouraged to use the Universal Resource Identifier (http, ftp, file, etc.) for the source of the descriptor definition. Best practice is for this source to be the descriptor file itself, so that it can be machine-readable and be fetched in real-time, if necessary. Actual usage of this element for matching descriptors will be system-specific.

See the Entry Type Descriptor table in the section below for reported Ed-Fi code values.

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. NEDM: Exit/Withdraw Date. OEnrollment.endDateStudent Information > General > Enrollments > End Date
exitWithdrawType
Descriptor

The circumstances under which the student exited from membership in an educational institution.

See the Exit Withdrawal Reason Descriptor table in the section below for more information on the Ed-Fi code reported.

O

Enrollment.endStatus

Student Information > General > Enrollments > End Status
residencyStatus
Descriptor

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
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 Descriptor:

Code in CampusName in CampusEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
CPCourt PlacedOtherOtherOther
DIn District TransferTransferTransferTransfer
DPDistrict PlacedNew to education systemNew to education systemNew to education system
EEnrolledRe-entryRe-entryRe-entry
FEForeign Exchange StudentOtherOtherOther
FTESchedule FTE ChangeOtherOtherOther
HSHome SchoolOtherOtherOther
IIn State TransferTransferTransferTransfer
OOut of State TransferTransferTransferTransfer
PRPromotedRe-entryRe-entryRe-entry
RDReturnedRe-entryRe-entryRe-entry
RTRetainedOtherOtherOther
ZFirst Day in DistrictNew to education systemNew to education systemNew to education system


This table describes the Ed-Fi Value mapped and reported for Exit Withdrawal Type Descriptor:

Code in CampusName in CampusEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
108Grad. with WY Reg. Diploma and College Crs Study108Graduated with college bound courseGraduated with a Wyoming regular high school diploma with college bound course
124Grad. with WY Reg. Diploma W/O College Crs Study124Graduated without college bound courseGraduated with a Wyoming regular high school diploma without college bound course
132Completed school and received an other credential132Completed schoolCompleted school and received an "other" credential
140Dropped out140DropoutDropout
159Discontinued Schooling for GED or other ED159Enrolled in a GED or other training programEnrolled in a GED or other training program
167Expelled or involuntarily withdrawn167ExpelledExpelled
175Reached max age for services175Reached maximum ageReached maximum age
183Withdrawn due to significant illness183Significant IllnessSignificant Illness
205Permanent incapacitation205DeceasedDeceased
213Deceased213DeceasedDeceased
248Enrolled in a foreign exchange program (Return)248Enrolled in a foreign exchange programEnrolled in a foreign exchange program; student expected to return
256Foreign Exchange student returned to home country256Foreign student returned to home countryForeign student returned to home country following completion of foreign exchange program in the United States
264Emigrated to another country264Emigrated to another countryEmigrated to another country
280Mid-year change in the same school280Mid-year change in the same school to grade levelMid-year change in the same school to grade level, concurrent enrollment status, or home school status
302End of concurrent or home school enrollment302End of a concurrent or home school enrollment at a school at any timeEnd of a concurrent or home school enrollment at a school at any time during the year, including end of year
310Attendance through EOY; grade level advanced310Attendance through end-of-year; grade level advancedAttendance through end-of-year; grade level advanced
329Attendance through EOY; grade level retained329Attendance through end-of-year; retained in grade levelAttendance through end-of-year; retained in grade level
345In District Transfer - mid year (public)345Transferred mid-year to a different public school in the same Wyoming distTransferred mid-year to a different public school in the same Wyoming district
361Out of District Transfer (public)361Transferred to a public school in a different Wyoming districtTransferred to a public school in a different Wyoming district
396Out of State Transfer (public)396Transferred to a public school in a different stateTransferred to a public school in a different state
418In State Transfer (private)418Transferred to a private school in WyomingTransferred to a private school in Wyoming
426Out of State Transfer (private)426Transferred to a private school in a different stateTransferred to a private school in a different state
450Transferred to home schooling450Transferred to home schooling as the primary educational settingTransferred to home schooling as the primary educational setting

469

Transferred to an educational institution469Transferred to an institution that has an educational programTransferred to an institution that has an educational program




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 and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code.

OR

When a student has a Positive Attendance record and 'Positive Attendance' is mapped to an Ed-Fi code.

  • Report attendance for each school in which the student has a Student School Association record.
  • Attendance date must fall on or between enrollment start and end dates.
  • Unknown attendance events will not send an event to ed-fi. The original post will not appear until an excuseID is entered in the attendance table.
  • Do not send records if the student's enrollment is marked as a No Show or State Exclude.
  • Do not send records if attendance records are associated with a Calendar when the Exclude checkbox is checked.
  • A record will send for each distinct Date and Attendance Event Category Descriptor.
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 now allow updates in Ed-Fi.
DeleteDelete attendance record if all attendance is removed for the day for that Attendance Event Category Descriptor.
DeleteWhen an enrollment is deleted or the No Show or State Exclude check boxes are checked.

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic
Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.
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 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
MN/AN/A
studentReference

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

  • studentUniqueId
MN/AN/A
eventDateDate for this attendance event. MN/AN/A
attendanceEvent
CategoryDescriptor
Reports when a student has a verified attendance status/excuse combination that is mapped to an Ed-Fi code.
MN/AN/A
attendanceEventReason

The reported reason for a student's absence.

Reports the first 40 characters from the Comments entered in the Attendance being reported for that day
  1. If more than 40 characters exist, add "...." to indicate additional text not shown.
  2. If there is more than 1 comment entered for that day, report the comment from the last period that contains a comment.
  3. If blank, do not report.
Oattendance.comments
educational
EnvironmentType

The educational environment. 

 

This element is optional and does not report.

ON/AN/A
absenceAmountDescriptorN/AON/AN/A
instructionalMinutesN/AON/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
Excused AbsenceExcused AbsenceExcused Absence
Unexcused AbsenceUnexcused AbsenceUnexcused Absence
TardyTardyTardy
Exempt AbsenceExempt AbsenceExempt Absence



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 student is scheduled into a course section.

  • A record will send for each term the course occurs based on the section schedule placement and roster start date.
  • If roster start date is after the term end date, do not report a record for the prior term.
  • Only send records if the student has a enrollment in the schedule structure where the student is rostered and is not marked as No Show or State Exclude
  • Do not send records if the Calendar Exclude check box is checked.
Post

Send a new record if a student's roster start date is changed.

PutWhen section information is updated for a student or section.
PutWhen the course homeroom field is changed.
PutWhen the section 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.
 

This resource will not push data for Courses marked as Inactive or State Exclude. 

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:

  • Report 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, report the earliest term start date associated with the term descriptor selected for this section based on the section schedule placement.
M

Enrollment.startDate

Terms.startDate

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:

  1. Report the roster end date for the student 
    1. If a roster end date is entered, delete any records for future terms for that section
  2. If NULL, report the latest term end 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 the section is assigned to.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 and the Attendance Status + Attendance Excuse combination is mapped to an Ed-Fi code.

  • The student must have a Student Section Association record to report
  • Unknown attendance events will not send an event to ed-fi.  The original post will not trigger until an excuseID is entered in the attendance table
  • Do not send records if the student's enrollment is marked as a No Show or State Exclude
  • Do not send records if attendance records are associated with a Calendar when the Exclude check box is checked
  • A record will send for each distinct Date, Section and Attendance Event Category Descriptor
  • Do not send records 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 now allow updates in Ed-Fi
DeleteDelete attendance record if all attendance is removed for the day
DeleteWhen an enrollment is deleted or the No Show or State Exclude check boxes are checked
DeleteIf the student is removed from the course section

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

Attendance will send to the scope year for the school year the attendance dates are associated with based on the student's enrollment.

  • 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 Section Attendance Event resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
 id

The unique identifier of the resource

MN/AN/A
sectionReference

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

MN/A N/A 
studentReferenceReports the fields that are part of the Natural Key for the Student resourceMN/A N/A 
eventDateDate for this attendance event.MN/A N/A 
attendanceEvent
CategoryDescriptor

Key for AttendanceEventCategoryType.

Reports when a student has a verified attendance status/excuse combination that is mapped to an Ed-Fi code.

Reports when a student is given a positive attendance record for the course section and it is mapped to an Ed-Fi Code.

MN/A N/A 
attendanceEventReason

The reported reason for a student's absence.

Reports the first 40 characters from the Comments entered in the Attendance being reported for that day.

  1. If more than 40 characters exist, add "...." to indicate additional text not shown.
  2. If there is more than 1 comment entered for that day, report the comment from the last period that contains a comment.
  3. If blank, do not report.
O attendance.comments
educationalEnvironmentType

Key for EducationalEnvironment 

 

This element is optional and does not report.

O N/AN/A
etag

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

 

This element is optional and does not report.

O N/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
Excused AbsenceExcused AbsenceExcused Absence
Unexcused AbsenceUnexcused AbsenceUnexcused Absence
TardyTardyTardy
Exempt AbsenceExempt AbsenceExempt Absence

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.

  • Do not send a student record for an enrollment that is marked as State Exclude.
  • Do not send a record if 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 a student's IEP is locked or unlocked and/or a student's disability is changed
  • When a student's contact information is changed: email, phone number
  • When a student's LEP information is changed
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.

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.MDerson.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 student'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 Suffix 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
AbbreviationType

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

Logic determines the Birth State from the student's current identity record.

  • If blank, look for default value to report
  • Report the Code selected
    • If the Code does not equal an Ed-Fi Code or the Birth State field is blank with no default value, a null value is reported.
CIdentity.birthStateCensus > People > Identities > Birth State
birthCountry
CodeType

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

 

This element is optional and is not reported.

CIdentity.birthCountryCensus > People > Identities > Birth Country
dateEnteredUSFor 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
multipleBirthStatus

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
profileThumbnail

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.

Report "Is the individual Hispanic/Latino?" from the student's current identity:

  1. If droplist is = Yes, report "true"
  2. If droplist is = No, report "false"
MIdentity.
hispanicEthnicity
Census > People > Identities > Is the individual Hispanic/Latino?
oldEthnicityType

No longer reports data.

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. NEDM Economic Disadvantaged Status.

  1. Determine the student's SES or Meal eligibility status based on:
    1. See Business Rule S3 in Scope Year logic to determine the Scope Year to post or update.
    2. Eligibility Type must = SES or Meal
  2. Report 'true' if eligibility is = Free or Reduced
  3. Report 'false' if eligibility is = Paid, Non-reimbursable or NULL
OPosEligibility.eligibilityFRAM > Eligibility > Eligibility
schoolFoodServices
EligibilityDescriptor

This descriptor defines indications of a student's level of eligibility for breakfast, lunch, snack, supper and milk programs.

  1. When 'Provision' = Null in the latest School History record with an Effective Date <= Current Date, report based on the student's FRAM record (req 3).
  2. When calendar Start Year >= Provision Base Year, AND calendar End Year <= Provision End Year on the School History record selected (most recent record that is <= Current Date :
    1. (Use the School History Record associated with the student's enrollment with the most recent Start Date that is <= Current Date)
      1. Prioritize reporting from schools based on the enrollments in the following order:
        1. P: Primary
        2. S: Partial
        3. N: Special Ed Services
    2. When 'National School Lunch Program (NSLP)' = NOT Checked, report X for all students in the school.
    3. When 'National School Lunch Program (NSLP)' = Checked, AND 'Provision' = 2 or 3 AND (Provision Type>NSLP) = Checked, report S for all students in the school.
    4. When 'National School Lunch Program (NSLP)' = Checked, AND 'Provision' NOT = 2 or 3, report based on the student's FRAM record (req 3).
  3. Else, report the Ed-Fi Code value mapped to the State Code from the student's most recent FRAM Eligibility record 
    1. If the End Date is before today's date, do not use the record
    2. If the End Date is on-or-after today's date, use the record.
    3. See Scope Logic rule S3.
  4. Else, report N.
CPosEligibility.eligibility

FRAM > Eligibility > Eligibility

System Administration > Resources > School > School History > USDA Programs

limitedEnglish
ProficiencyDescriptor

 An optional globally unique namespace that identifies this descriptor set. If supplied, the author is strongly encouraged to use the Universal Resource Identifier (http, ftp, file, etc.) for the source of the descriptor definition. Best practice is for this source to be the descriptor file itself, so that it can be machine-readable and be fetched in real-time, if necessary. Actual usage of this element for matching descriptors will be system-specific.

  1. Report "Y" when: 
    1. Student has an LEP record with the following:
      1. Identified Date <= Current Date.
      2. Program Exit Date = Null or > Current Date.
      3. Parent Declined NOT = Checked
    2. Report "R" when:
      1. Student has an LEP record with the following:
        1. Identified Date <= Current Date.
        2. Program Exit Date = Null or > Current Date.
        3. Parent Declined = Checked
    3. Report "1" when:
      1. Student's LEP record with the most recent Identified Date has  the following:
        1. Identified Date <= Current Date.
        2. Program Exit Date NOT = Null and < Current Date.
        3. Current Date <= First Year Monitoring Date
    4. Report "2" when:Student's LEP record with the most recent Identified Date has  the following:
      1. Identified Date <= Current Date.
      2. Program Exit Date NOT = Null and < Current Date.
      3. Current Date <= Second Year Monitoring Date
    5. Report "3" when:
      1. Student's LEP record with the most recent Identified Date has  the following:
        1. Identified Date <= Current Date.
        2. Program Exit Date NOT = Null and < Current Date.
        3. Current Date > Second Year Monitoring Date and <= Third Year Monitoring Date
    6. Report "4" when:
      1. Student's LEP record with the most recent Identified Date has  the following:
        1. Identified Date <= Current Date.
        2. Program Exit Date NOT = Null and < Current Date.
        3. Current Date > Third Year Monitoring Date and <= Fourth Year Monitoring Date
    7. Use the logic in S2 of Scope Year Logic to determine prior or future years logic.
  2. Otherwise, report "N".
ON/AN/A
displacementStatus

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
internationalProvince
OfBirth

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
citizenshipStatus
Type

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
  • If the Address Location Detail or Household Membership is marked as "Private" the address will not report

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
characteristics

Reflects important characteristics of the student's home situation: Immigrant, Migrant, Single Parent, and Unaccompanied Youth.

  1. Report the Ed-Fi Code Value from the Student Characteristic page linked below under Type/Descriptors WY based on the mapping provided for each characteristic the student meets
  2. If the student has more than one enrollment, report from the Primary Enrollment.
    1. If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order:
      1. S: Partial
      2. N: Special Education
    2.  If the student has multiple enrollments with the same service type, report from most recent enrollment id
  3. If a mapping is not found, do not report
M

Enrollment.immigrant

Enrollment.migrant

Enrollment.singleParent

Enrollment.
mvUnaccompaniedYouth

Student Information > General > Enrollments > State Reporting Field
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.


 

This element is optional and does not report.

ON/AN/A
disabilities

The disability condition(s) that best describes an individual's impairment.

  1. Report the Ed-Fi Code Value from the Disability Descriptor page linked below under Type/Descriptors WY based on the Ed-Fi code value for each disability the student meets.
  2. If the student has more than one enrollment, report from the Primary Enrollment.
    1. If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order:
      1. S: Partial
      2. N: Special Education
  3.  If the student has multiple enrollments with the same service type, report from earliest enrollment ID
O

Enrollment.disability1

Enrollment.disability2

Enrollment.disability3

Student Information > General > Enrollments > Special Ed Fields
electronicMails

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. 

  1. Reports the email address entered for that person
    1. Do not report if Email is marked as "Private"
  2. If blank, does not report
ON/AN/A
identificationCodes

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
languages

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

Report the Code from the Home Primary Language saved on the student's current identity record.

  1. If blank, do not report this field
  2. If the code does not match an Ed-Fi code, do not report a record
  3. Report default value if saved on the Attribute and the code matches an Ed-Fi code

This element is an array that reports the following data:

OIdentity.
homePrimaryLanguage
Census > People > Demographics > Home Primary Language
languageDescriptorAn unordered collection of studentLanguageUses. Language(s) the individual uses to communicate. This reports the Ed-Fi mapped value in the Language Type table in the section below.MIdentity.
nativeLanguage
Census > People > Identities > Native Language
uses

An unordered collection of studentLanguageUses. Language(s) the individual uses to communicate. 

 

This element is not collected or reported.

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

ON/AN/A
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.

This reports the Ed-Fi value mapped in the Race Type table in the section below.

M

IdentityRaceEthnicity

and

Racethnicity.raceId

Census > People > Identities > Race/Ethnicity
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.

  1. Reports the Phone numbers entered inthe Personal Contact Information for that person
    1. do not report Phone Number is marked as "Private"
  2. If blank, does not report
  3. See Business Rule S3 in Scope Year logic to determine the eligibility of records
  4. See Array section for data logic for each field
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

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for School Food Services Eligibility Type:

Reporting LogicCode in CampusEd-Fi Short DescriptionEd-Fi Description
Reports when the student has an active Eligibility with a State Eligibility Code = F:  Eligible for Free LunchFFreeFree

Reports when the student has an active Eligibility with a State Eligibility Code = P: Paid

OR

When a student does not have an active Eligibility record

NFull priceFull price
Reports when the student has an active Eligibility with a State Eligibility Code = R:  ReducedReduced priceReduced price
Non-reimbursable - does not report

This table describes the Ed-Fi Value mapped and reported for Limited English Proficiency Descriptor:

Reporting LogicEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Report "Y" when: 
  1. Student has an LEP record with the following:
    1. Identified Date <= Current Date.
    2. Program Exit Date = Null or > Current Date.
    3. Parent Declined NOT = Checked
YLimitedLimited
Report "R" when:
  1. Student has an LEP record with the following:
    1. Identified Date <= Current Date.
    2. Program Exit Date = Null or > Current Date.
    3. Parent Declined = Checked
RRefusalRefusal
Report "1" when:
  1. Student's LEP record with the most recent Identified Date has  the following:
    1. Identified Date <= Current Date.
    2. Program Exit Date NOT = Null and < Current Date.
    3. Current Date <= First Year Monitoring Date
1Limited Monitored 1Limited Monitored 1
Report "2" when:Student's LEP record with the most recent Identified Date has  the following:
  1. Identified Date <= Current Date.
  2. Program Exit Date NOT = Null and < Current Date.
  3. Current Date <= Second Year Monitoring Date
2Limited Monitored 2Limited Monitored 2
Otherwise, report "N"NNot LimitedNot Limited

This table describes the Ed-Fi Value mapped and reported for Student Characteristic Descriptors:

CharacteristicLogicEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Immigrant

If student is marked Immigrant = Checked, add Immigrant to the array

Otherwise do not report

Student Information > General > Enrollment > Immigrant

Immigrant

Immigrant 

Immigrant

Migrant

If student is marked Migrant Indicator = Checked, add Migrant to the array

Otherwise do not report

Student Information > General > Enrollment > Migrant

MigrantMigrantMigrant
Single Parent

If student is marked Single Parent = Checked, add Single Parent to the array

Otherwise do not report

Student Information > General > Enrollment > Single Parent

Single ParentSingle ParentSingle Parent
Unaccompanied Youth

If student is marked Unaccompanied Youth = Checked, add Unaccompanied Youth to the array

Otherwise do not report

Student Information > General > Enrollment > Unaccompanied Youth

Unaccompanied YouthUnaccompanied YouthUnaccompanied Youth

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
ATAutismAutism
DBDeaf-BlindnessDeaf-Blindness
HIHearing ImpairmentHearing Impairment
DDDevelopmental DelayDevelopmental Delay
LDSpecific Learning DisabilitySpecific Learning Disability
HLOther Health ImpairmentOther Health Impairment
OIOrthopedic ImpairmentOrthopedic Impairment
SLSpeech or Language ImpairmentSpeech or Language Impairment
BITraumatic Brain InjuryTraumatic Brain Injury
VIVisual ImpairmentVisual Impairment
CDCognitive DisabilityCognitive Disability
EDSerious Emotional DisabilitySerious Emotional Disability
MUMultiple DisabilitiesMultiple Disabilities



Student Special Education Program Association

This resource 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
  1. When a locked "WY" IEP (Print format must start with "WY") is created in the year, where:
    1. IEP Start Date <= Effective Date and student's enrollment End Date, AND IEP End Date >= student's enrollment Start Date in the Calendar
      (the IEP must overlap the enrollment)

AND WHEN:

  1. Student Information > General > Enrollments > Special Ed Fields>Service Start Date = NOT Null for the enrollment with the eligible IEP active within its date range.

If the student has multiple enrollments that are overlapping in the same school, report based on primacy of Service Type:

  1. P: Primary
  2. S: Partial
  3. N: Special Ed
  • If the student only has one enrollment, report a record regardless of Service Type
  • 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 Exclude
  • Do not send a record if enrollment is in a school marked as Exclude
Post

When a new enrollment is created for a student that has an active, locked "WY" IEP (Print format must start with "WY")

  • Enrollment start date must be on or after IEP start date
  • IEP end date must be NULL or after Enrollment start date
Delete/Post

When any part of the natural key is changed.

  • When a SPED Entry Date is changed
Delete/Post

When any field that is not part of the natural key is changed, including the following:

  • endDate
  • serviceDescriptor
  • serviceBeginDate
  • serviceEndDate
DeleteThe locked "WY" IEP is deleted or unlocked for a student
DeleteA Sped Entry Date is changed for a student
DeleteAll overlapping enrollments are deleted for a school
DeleteStudent Information > General > Enrollments > Special Ed Fields > Service Start Date in the enrollment that has an active IEP in its date range is set to Null

Scope Year Logic

Click here to expand...

This table describes scope year logic of this object.

Logic

When a new, locked "WY" print format IEP is created, the record will post to the school years that the overlapping enrollments are in.

When the record is triggered from enrollments, the record posts to the school years that the overlapping enrollments are in

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 Special Education Program Association resource.

Data ElementDescriptionCampus Database FieldCampus GUI Location
idThe unique identifier of the resource.M N/AN/A 
studentReference

A unique alpha-numeric code assigned to a student

MstudentReference.
studentUniqueId
Census > People > Demographics > EdFi ID
programReferenceA reference to the related Student resource.MN/AN/A
beginDate

The month, day, and year on which the Student first received services.

Logic will report the date in Student Information > General > Enrollments > Special Ed Fields > Service Start Date from the most recent (latest Start Date) Primary enrollment with enrollment Start Date <= Effective Date.

MN/AStudent Information > General > Enrollments > Special Ed Fields > Service Start Date
educationOrganization
Reference
The education organization where the student is participating in or receiving the program services.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.

  1. Report the date in Student Info> General> Enrollments> Special Ed Fields> Program Exit Date from the Primary enrollment when Program Exit Date = NOT Null, AND <= the Effective Date, AND falls within the calendar year associated with the enrollment.
  2. When Exit Date = Null OR > the Effective Date, do not report.
CN/AStudent Information > General > Enrollment > Special Ed > Exit Date
specialEducation
SettingDescriptor

Reports the Special Education setting for the student.

  1. Report the Ed-Fi code for the value selected in Student Info> General> Enrollments> Special Ed Fields> Special Ed Setting from the most recent (latest Start Date) Primary enrollment with enrollment Start Date <= Effective Date.
  2. When Special Ed Setting = Null, do not report.
ON/AN/A
services

An unordered collection of studentProgramAssociationServices. This association represents the Special Education program(s) that a student participates in or receives services from.

 ON/AN/A
serviceDescriptor

Report the Ed-Fi code from the locked "WY" IEP in the year> SPED Services> Service selection, AND also from the locked "WY" IEP in the year> Related Services > Service selection

When Ed-Fi code = Null, or when no Service/Related Service exists, do not report.

Report only those services belonging to an IEP with Start Date <= the effective date.

M

N/A

Student Information > Special Ed > SPED Services > Service

Student Information > Special Ed > Related Services > Service

primaryIndicatorThis is optional and does not reportON/AN/A
serviceBeginDateReport the Start Date value of the service being reportedON/A

Student Information > Special Ed > SPED Services > Start Date


Student Information > Special Ed > Related Services > Start Date
serviceEndDateReport the End Date value of the service being reportedON/A

Student Information > Special Ed > SPED Services > End Date


Student Information > Special Ed > Related Services > End Date

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported for Special Education Setting Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
SCInside regular class less than 40% of the dayInside regular class less than 40% of the day
RRInside regular class no more than 79% of dy and no less than 40% of the dayInside regular class no more than 79% of dy and no less than 40% of the day
PPParentally-placed in Private SchoolsParentally-placed in Private Schools
REInside regular class 80% or more of the dayInside regular class 80% or more of the day
HHHomebound/HospitalHomebound/Hospital
PHHomeschoolHomeschool
CFCorrectional FacilityCorrectional Facility
RFResidential FacilityResidential Facility
SSSeparate SchoolSeparate School
CPCourt PlacedCourt Placed



Student Title 1 Part A Program Association

This resource 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 a student has Title 1 = Checked on any enrollment

Only report a single record per school, per student, per enrollment Start Date

If the student has > 1 enrollment, where Title 1 checkbox = Checked, and the start date is the same, report based on the following hierarchy:

  1. Primary
  2. Partial
  3. Special Ed
If there are multiple enrollments that qualify, with the same Service Type and enrollment Start Date, report the highest enrollmentID

Do not report if the student's Enrollment has any of the following indicated:

  • No Show
  • Enrollment state exclude
  • Calendar exclude
  • School exclude
PostIf the service type is being changed for the enrollment record being reported in this resource, report a new record for the new properly reported enrollment, if previously not the reporting enrollment.
PostWhen any field part of the natural key is updated
PutUpdate the record if any other fields in this resource are changed that are not part of the natural key
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
Delete

When any enrollment record that previously had the Title 1 checkbox selected & 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 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 Title 1 Part A Program Association resource.

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

A unique alpha-numeric code assigned to a student. 

MStudentReference.
studentUniqueId
Census > People > Demographics > EdFi ID
programReference

A reference to the related Student resource.

MN/AN/A
beginDateThe month, day, and year on which the student first received servicesMN/AStudent Information > General > Enrollments > Start Date
educationOrganization
Reference
The education organization where the student is participating in or receiving the program services.MDistrict.numberSystem Administration > Resources > District Information > State District Number
endDateThe month, day, and year on which the student exited the program or stopped receiving services.MN/AStudent Information > General > Enrollments > 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 element is optional and does not report.

ON/AN/A
servedOutsideOfRegularSession

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

This element is optional and does not report.

ON/AN/A
titleIPartAParticipantTypeAn indication of the type of Title I program, if any, in which the student is participating and served: 
  • Was not served
  • Public Targeted Assistance Program
  • Public Schoolwide Program
  • Local Neglected Program

Logic will report as follows:

  1. Report the Ed-Fi code mapped to the selection in the schoolaAttribute.title1 field for all students in the school when:

    1. The latest (most recent Effective Date) School History record with an Effective Date <= the extract Effective Date, has schoolAttribute.title1 =

      1. Targeted Assistance Eligible - No Program

      2. Schoolwide Eligible - No Program

      3. schoolAttribute.title1 = Schoolwide Program
        OR

      4. Not a Title I School

    2. Report based on the enrollment Title 1 field when:

    3. schoolAttribute.title1 =

      1. Targeted Assistance Program

      2. Schoolwide Eligible - Targeted Assistance
        OR

      3. is Null

    4. Title 1 from enrollment:

      1. When student in the enrollment in the calendar year selected has:

      2. Enrollment.title1 = Checked, reports "Local Neglected Program".

      3. Enrollment.title1 = NOT Checked, reports "Was not served".

MN/ASystem Administration > Resources > School > Title 1

Type/Descriptor

Click here to expand...
 

The highlighted column indicates the reported value.

This table describes the Ed-Fi Value mapped and reported Title I Part A Participant Type:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
Public Targeted Assistance ProgramPublic Targeted Assistance ProgramPublic Targeted Assistance Program
Public Schoolwide ProgramPublic Schoolwide ProgramPublic Schoolwide Program
Local Neglected ProgramLocal Neglected ProgramLocal Neglected Program
Was not servedWas not servedWas not served



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.

AzEDS