Wisconsin Ed-Fi Data v2.0

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. 

This article is only for districts on Ed-Fi v2.0. Informaiton on Ed-Fi v3.1 is located in the Wisconsin Ed-Fi v3.1 article.

All resources depend on the selection of a Profile on the Ed-Fi Configuration tab.

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.

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

Understand Object Triggering Tables

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

Example of an Object Triggering Logic Table

The following table lists the definition of each potential Action:

ActionDefinition
PostThis will insert new records and data within Ed-Fi.
PutThis action will update existing information within Ed-Fi.
GetThis action is used for items that are pre-loaded. 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.

Data Element Labels in bold are part of the Natural Key and are required data elements for data to send to Ed-Fi.

Example of a Object Data Elements Table

Understand Type/Descriptor Tables

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

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

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

Example of a Type/Descriptor Table


Entities and Elements

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


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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Period Schedule is created and saved.

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

Scope Year Logic

This table describes scope year logic of this object.

Logic

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

Data only sends for the years that have valid configuration.

Future Years data is 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

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

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

Reports the Entity ID entered on the School editor.

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, Schedule Structure
etag

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

 

This is an optional field and does not report.

ON/AN/A

Courses

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 Data

This table describes logic for triggering syncing of this object.

ActionTrigger
Get

No Trigger. This is a look-up as Courses are pre-loaded. A match is not done on the State Course Code to see if the course exists in the ODS. 

  • Data for courses is not sent if marked as Exclude or not marked Active.
  • Data is not sent for Courses if the Calendar Exclude, School Exclude or Summer School checkbox is marked.

Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports for the scope year the courses to which the calendar is aligned.

Data only sends for the years that have valid configuration.

Future Years data is 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

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.

Courses are pre-loaded by the state and are all assigned to the reporting District Number 48856.

Mdistrict.NumberSystem Administration > Resources > District Information
 code The code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.
MCourse.numberScheduling > Courses > Course > Number
title

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

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

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

MCourse.nameScheduling > Courses > Course > Name
numberOfPartsThe number of parts identified for a course. The number in the SCED Sequence Part N field is reported. This field reports a default value of 1 for all courses.MCourse.sced
SequenceNum
 Scheduling > Courses > Course > SCED Sequence (part n) 
academicSubject
Descriptor

The intended major subject area of the course. 


  • Reports the Ed-Fi Code from the SCED SCED Subject Area
  • If NULL or Ed-Fi Value is blank, do not report.
OCourse.sced SubjectAreaScheduling > Courses > Course > SCED Subject Area
description

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

ON/AN/A
dateCourseAdopted

The date the district adopted the course.

 

This field is optional and does not report.


ON/AN/A
highSchoolCourse
Requirement

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

 

This field is optional and does not report.


ON/AN/A
gpaApplicability
Type

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

 

This field is optional and does not report.


ON/AN/A
definedByType

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

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
CreditType

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

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
CreditConversion

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

 

This field is optional and does not report.


ON/AN/A
minimumAvailable
Credit

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

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
CreditType

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

 

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
CreditConversion

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

 

This field is optional and does not report.


ON/AN/A
maximumAvailable
Credit

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

 

This field is optional and does not report.


ON/AN/A
careerPathwayType

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

 

This field is optional and does not report.


ON/AN/A
timeRequired
ForCompletion

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

 

This field is optional and does not report.


ON/AN/A
competencyLevels

An unordered collection of courseCompetencyLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

 

This field is optional and does not report.


ON/AN/A
gradeLevels

An unordered collection of courseGradeLevels. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

 

This field is optional and does not report.


ON/AN/A
identificationCodes


An unordered collection of courseIdentificationCodes. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

 This field is an array.

ON/AN/A
courseIdentification SystemDescriptor

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

  • Reports LEA Course Code when reporting the course number. 
  • Reports State Course Code when reporting the State Code. 
MN/AN/A
assigningOrganization IdentificationCode

The organization code or name assigning the staff Identification Code.

 

This field is optional and does not report.

ON/AN/A
identificationCode

A unique number or alphanumeric code assigned to a space, room, site, building, individual, organization, program, or institution by a school, school system, a state, or other agency or entity.

  • Reports the Course Number when reporting the LEA Course Code.
  • Reports the State Code when reporting the State Course Code.
M

Course.number

Course.statecode

Scheduling > Courses > Course > Number, State Code
learningObjectives

An unordered collection of courseLearningObjectives. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

 

This field is optional and does not report.


ON/AN/A
learningStandards

An unordered collection of courseLearningStandards. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

 

This field is optional and does not report.


ON/AN/A
levelCharacteristics

An unordered collection of courseLevelCharacteristics. This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

ON/AN/A
type

Specification of the specific program or designation associated with the course. For example: Ap, IB, Dual Credit, CTE, etc.

  • Reports the Ed-Fi Code from the Course Level Selected
  • If Ed-FI Code is NULL or field is blank, do not report
MCourse.honorsCodeScheduling > Courses > Course > Course Level
etag

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

 

This field is optional and does not report.


ON/AN/A

Course Offerings

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

Object Triggering Logic

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.

  • One record reports per Course and Term Type combination.
  • Do not send if course is marked as Inactive or State Exclude.
  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send records if the School Exclude checkbox is marked.
  • Do not send records if the Calendar is marked as Summer School.
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 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

This table describes scope year logic of this object.

Logic
Reports course offerings for the scope year the to which the calendar is aligned.
Data only sends for the years that have valid configuration.

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

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

Object Data Elements

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
courseReferenceA reference to the related Course resource.


  • Reports the code from the State Course Code.
  • If the State Course Code is NULL, do not process and remove from the Ed-Fi Queue. Otherwise, match to the State Ed-Fi Course.
  • Report sthe fields that are part of the Natural Key for the matching Course resource. If no match is found, an error reports in the error log with the following message: Error: No match found State Course code: AAAAA sent for Course BBBB Section CC.
    • AAAAA is the State Course code submitted, BBBB is the local Course Number, and CC is the Section of the course.
MCourse.stateCodeScheduling > Courses > Course > State Course Code
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

localCourseTitle

The descriptive name given to a course of study offered in the school, if different from the CourseTitle.

  • Reports first from CWCS Course Name.
  • If blank, reports Course Title.
O

Course.name


Scheduling > Course > CWCS Course Name, Name
courseOfferingCareerPathway

The cluster/career program pathway for the course.

  1. Reports the Ed-Fi value for Cluster/ Career Program Pathway(s) on the Course for careerPathwayType.
  2. If there are multiples, reports all.
  3. If the field is blank, does not report this element.

courseOfferingCareerPathway{careerPathwayType (string): careerPathway (cluster) of the 'CTE' courseOffering}

C
Scheduling > Course > Custom Data Elements > Cluster/ Career Program Pathway
InstructionalTimePlanned

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

 

This field does not report. 


ON/AN/A
curriculumUsed

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

 

This field does not report.

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

Discipline Actions

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

Object Triggering Logic

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.

  • Only reports when the Role = Perpetrator.
  • Do not send if the student's enrollment is marked as No Show or State Exclude, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school.
  • 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.

A separate record reports for each qualifying Resolution, even if they are attached to the same Student/Participant.

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 are removed from the Incident.
DeleteWhen the student's Role changes to anything other than Offender.
DeleteWhen all non-excluded enrollments in the school and year are deleted.
DeleteWhen the linked enrollment is deleted.
Delete/PostIf there is another Ed-Fi reporting enrollment in the district, post a new record with the studentSchoolAssociationReference pointing to the next qualifying enrollment.
DeleteWhen the student's enrollment is no longer reportable (marked No Show, State Exclude, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school). 

Scope Year Logic

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

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.

Reports the fields that are part of the Natural Key for the Schools resource of the school where the incident occurred.

ON/A
N/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:

This field does not report.

MN/AN/A
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 action.MBehaviorResolution.
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.

  1. If the Resolution Type is NOT mapped to Expulsion (EX) or Expulsion with Services (ES):
    1. Report the Duration in School Days.
  2. If Duration is 0 or NULL, do NOT generate a Discipline Actions record from this Resolution.
  3. If the Resolution Type is Expulsion (EX) or Expulsion with Services (ES):
    1. Check if the Resolution End Date is after the Calendar End Date.
    2. Check if Return to School is checked and a Return Date is entered.
    3. If either condition is met, calculate the length. See Appendix A for calculation.

      1. Otherwise, reports the Duration in School Days.
    4. Zero length DOES report for these resolution types.
  4. Reports to one digit beyond the decimal. Decimal may be .0 or .5 only.

Appendix A - WI length Calculation

  1. Calculate the number of Instructional days (inclusive) from the Resolution Start Date to the earliest of:

      • Resolution End Date
      • Calendar End Date
      • Return Date 

    1. This is the initial removal length for the calendar.
  2. If Violated Early Return is not checked, report the initial removal length value.
  3. If Violated Early Return is checked, calculate from Expulsion Reinstatement Date to the earliest of:

      • Resolution End Date
      • Calendar End Date

    1. This is the additional removal length for the calendar.
    2. Add additional removal length to the initial removal length for the calendar and report this value.
MBehaviorResolution.
duration
Behavior > Behavior Management > Resolution> Duration

actualDiscipline
ActionLength

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

Reports the Duration in School Days value.

CBehaviorResolution.
duration

Behavior > Resolution > Duration in School Days, Resolution Start Date, Resolution End Date

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

discipline

An unordered collection of disciplineActionDisciplines. 

  • Report a separate record for each Resolution
  • Report the Ed-Fi Code Value for the Resolution Type selected based on the State Mapped Resolution Code mapped to the Resolution Type
  • Do not Report if the Resolution is not mapped to a State Code
  • If the Resolution is mapped to IS: In-School Suspension, only report if the student has a locked IEP that overlaps the date of the Incident and the SPED Exit Date is NULL or after the date of the incident.
 MBehaviorResolutionType. stateResCodeBehavior Management > Resolution > Resolution Type
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 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
disciplineIncident reference

An unordered collection of disciplineActionDisciplineIncidents. 

Reports the fields that are part of the Natural Key for the Discipline resource for the parent Behavior Incident.

MN/AN/A
modifiedTermType

Identifies if the duration of the expulsion has been modified from the federally required one year of expulsion for a fire arms incident.

  • If the Resolution type is mapped to EX (Expulsion) or ES (Expulsion with Services) report the Ed-Fi Value mapped to the Modification Term and Reason
  • If Modification Term and Reason is blank, report "Firearms Incident Type and not modified OR not a firearms Incident Type'
  • Do not report for resolutions that are not Expulsions
CBehaviorResolution.
modificationReason
Behavior > Resolution > Modification Term and Reason
earlyReinstatement ConditionFollowing an expulsion, the student had early reinstatement condition to return to school prior to the end of the expulsion
  • If the Resolution type is mapped to EX (Expulsion) or ES (Expulsion with Services)
    • AND If Modification Term and Reason is NOT NULL, report TRUE.
    • If Modification Term and Reason is NULL report FALSE.
  • Do not report for resolutions that are not Expulsions.
CBehaviorResolution.
modificationReason
Behavior > Resolution > Modification Term and Reason
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/Descriptors

The highlighted column indicates the reported value.

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

IC CodeIC DescriptionsEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
IS

In-School Suspension

01In School SuspensionAn instance where a student is temporarily removed from his/her regular classroom(s) for disciplinary purposes but remains under the direct supervision of school personnel. Direct supervision means school personnel are physically in the same location as the student under their supervision. \"In-school suspensions\" include both removals in which no IEP services are provided and those in which the student continues to receive services according to his/her IEP. This code is valid only if primary disability is not N as of the removal period start date.
OS

Out-of-School Suspension

02Out of School SuspensionA removal from school grounds imposed by the school administration for noncompliance with school district policies or rules; for threatening to destroy school property; or for endangering the property, health, or safety of those at school. See s. 120.13(1)(b), Wis. Stats.

EX

Expulsion

03ExpulsionA removal from school grounds for purposes of discipline as imposed by the school board for violation of school district rules; threats against school property; or conduct which endangers the property, health, or safety of those at school. Expulsion is a formal school board action pursuant to s. 120.13 (1) and (first-class city school district) s. 119.25.
ESExpulsion with Services04Expulsion with ServicesDefinition for expulsion PLUS the student who was expelled from School A received educational services during the expulsion period during this school term. Educational services may either be provided by another school or by School A at a setting off School A's grounds.
SP

Placement in IAES - School Personnel

05IAES by School PersonnelAn instance in which school personnel (not the IEP team) order the removal of a student with disabilities from his or her current educational placement to an appropriate interim alternative educational setting for not more than 45 school days as the result of drug offenses, dangerous weapon offenses, or causing serious bodily injury. The IEP team is responsible for determining the interim alternative educational setting. This does NOT include decisions by the IEP team to change a student's placement.This code is valid only if primary disability is not N as of the removal period start date.
HO

Placement in IAES - Hearing Officer

06IAES by Hearing OfficerAn instance in which an impartial IDEA hearing officer orders the removal of a student with disabilities from his or her current educational placement to an appropriate alternative educational setting for not more than 45 school days based on the IDEA hearing officer’s determination that maintaining the child’s current placement is substantially likely to result in injury to the child or others. The IEP team is responsible for determining the interim alternative educational setting.This code is valid only if primary disability is not N as of the removal period start date.

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

CodeDescriptionEd-fi CodeShort Description
CIConditional, modified because of IDEAIModified because of IDEA
CMConditional, modified other than IDEAMModified for reasons other than IDEA
NINon-conditional, modified because of IDEAIModified because of IDEA
NMNM: Non-conditional, modified other than IDEAMModified for reasons other than IDEA

Discipline Incidents

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

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 one behavior event associated where the student's role is Perpetrator and a resolution is mapped to an Ed-Fi Value and generates a Discipline Actions record.
  • 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, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school.
  • 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
  • Do not send if the calendar is marked as Summer School.
  • A record is only sent if the Ed-Fi Configuration is Public.
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.

DeleteWhen the student's enrollment is no longer reportable; marked No Show, State Exclude, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school. 

Scope Year Logic

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

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. 

  • Report based on the calendar(s) the students with Resolutions are enrolled in on the date of the Incident.
    • If multiple students with enrollments from different schools are reported, multiple disciplineIncident records are created with a schoolReference for each school.
  • Reports the fields that are part of the Natural Key for the Schools resource
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 offenders.MBehaviorIncident.
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.

This is optional and does not report.

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

This is optional and does not report.

 ON/AN/A
behaviorDescriptor

Report all behavior events that are associated with the incident.

  1. Report the Ed-Fi code value from the mapping for the state code 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, then 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

Grades

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

Object Triggering Logic

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 and  is marked as State Reported.

  • Standards do not report.
  • If a course is marked as Inactive or State Excluded, data does not report.
  • If the Calendar Exclude checkbox is marked or the Summer School calendar is marked, data does not report.
  • If a student's enrollment record is marked as State Exclude, No Show, or WISE Exclude data does not report.
  • If a student's enrollment is in a school marked as Exclude, data does not report.
  • If the student's enrollment is Partial (S) Type, data does not report.
  • Check to see if the student has a Student Section Association in the Ed-FI identity Mapping table before sending:
    • If the student has a Student Section Association record, continue with processing the record to Ed-Fi.
    • If the student does not have a Student Section Association record, the record goes to the Error Log with a message stating: Student (First Name Last Name, Ed-Fi ID) does not have a Student Section Association record for the course (Course Number Course Name). This record must exist before Grades can be sent.
  • A record is only sent if the Ed-Fi Configuration is Public.
  • Data only sends for grade levels 9 - 12.
PutWhen a grade is updated on a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated.
PutWhen a student CTE Program Participation record is created or deleted for a CTE Program in the same cluster as the Course the grade is for.
PutWhen a Student CTE Program Participation record in the same cluster as the course for the grade is updated and status is added, changed, or removed.
DeleteWhen a grade is deleted from a Grading Task that is marked as State Reported and has an Ed-Fi Grade Type populated
Delete

When the Student School Association record is deleted for the school in which the grades are associated.

DeleteWhen the No Show, State Exclude, or WISE Exclude checkboxes are marked..
Delete/InsertWhen any field that is part of the Natural Key is changed.

Scope Year Logic

This table describes scope year logic of this object.

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

Object Data Elements

This table describes data elements sent within the Grades resource.

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

A reference to the related GradingPeriod resource.

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

  • beginCalendarDateReference
  • descriptor
MN/AN/A
studentSection AssociationReference

A reference to the related Student Section Association resource.

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

  • sectionReference
  • studentReference
  • beginDate

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

MN/AN/A
type

The type of grade.

Only reports for Ed-Fi Code values marked as "Final".

M
Grading and Standards > Grading Tasks
performanceBaseConversionType

The performance base conversion assessed for the student. 

  1. Reports the Ed-Fi value mapped to the grade given.
  2. If there is no Ed-Fi value mapped, does not report.

    Pass/ Fail/ Incomplete Indicator is expected to be submitted  for 'CTE' courses and all courses associated to 'CCR' (please review the 'usecases document for details)
MN/AGrading & Standards > Score Groups & Rubrics > (Score Group) > Ed-Fi Grade Type

letterGradeEarned

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

For Resync Only:

  1. Report a value of "NC" if student exits course without a final grade posted to a grading task with state reported checked.
  2. Otherwise,
    1. 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.

GradingScore.scoreGrading and Standards > Score Groups and Rubrics > Score
numericGradeEarned

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

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

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

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

 

This field is optional and does not report.

O

N/AN/A
wiDpiGrade

This field is required only when the student is participating in a 'certifiedCareerEducatonProgram' that is associated to a course

wiDpiGrade {certificatedProgramStatusType (string)
 This status is an indication of student's progress towards earning a 'certificate' within the 'certified Career Education Programs (Program Type)}.

  1. If the course the grade is being reported for has a Cluster/ Career Program Pathway entered
  2. And the course has a Certified Learning Method entered
  3. And the student has a CTE Program record for the same Cluster
  4. Then report the Ed-Fi Value for the Status from the student's CTE record.
    1. If the status is 'a', Student met the requirements, and there are grades posted for multiple grading periods within the database config year for the same Cluster/ CTE program, report 'a' on only the last record by date of the grading period.
  5. If the course does nto qualify or there is no matching CTE record, report blank.
CN/AN/A

This table describes data elements sent within the Grades resource.


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.

2018-2019 Configurations and Later

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

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

  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send if the School is marked as Exclude.
  • Do not send if the Calendar is marked Summer School.
  • If the start date on an existing Grading Period is changed, the "old" record will remain in Ed-Fi and a new record will post with the new date.
PutWhen the Grading Period End Date is updated and saved.
DeleteGrading Periods cannot be deleted due to the dependency of the core Ed-Fi model where it is required for Sessions to report grading periods.

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 to which the calendar is aligned.

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

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 to which  the grading period is aligned.

Reports the Ed-Fi Entity ID.

MSchool.entityIDSystem Administration > Resources > School > Ed-Fi Number
beginDate

The start date of the grading period.

Reports 7/1/XXXX where XXXX is the start year of the School Year.

Medfigradingperiod.startDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endDate

The end date of the grading period.

Reports 6/30/XXXX where XXXX is the end year of the School Year.

Medfigradingperiod.endDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
descriptor

The name of the grading period. Reports the value from the Grading Period Name selected. See the Grading Period Descriptor table in the Type/Descriptor section below.

 Medfigradingperiod.nameSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Counts 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 one calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures.
    • Instructional days do not send an update if changed after original post unless a resync is completed.
N/ASystem Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

 

This element is optional and does not report.

 N/AN/A 
 _etag N/AON/A N/A 

Type/Descriptors

  Click here to expand...

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01End of YearEnd of Year
02Fifth Six WeeksFifth Six Weeks
03First Nine WeeksFirst Nine Weeks
04First SemesterFirst Semester
05First Six WeeksFirst Six Weeks
06First Summer SessionFirst Summer Session
07First TrimesterFirst Trimester
08Fourth Nine WeeksFourth Nine Weeks
09Fourth Six WeeksFourth Six Weeks
10Second Nine WeeksSecond Nine Weeks
11Second SemesterSecond Semester
12Second Six WeeksSecond Six Weeks
13Second Summer SessionSecond Summer Session
14Second TrimesterSecond Trimester
15Sixth Six WeeksSixth Six Weeks
16Summer SemesterSummer Semester
17Third Nine WeeksThird Nine Weeks
18Third Six WeeksThird Six Weeks
19Third Summer SessionThird Summer Session
20Third TrimesterThird Trimester
21Grading Period 1Grading Period 1
22Grading Period 2Grading Period 2
23Grading Period 3Grading Period 3
24Grading Period 4Grading Period 4
25Grading Period 5Grading Period 5
26Grading Period 6Grading Period 6
27Grading Period 7Grading Period 7
28Grading Period 8Grading Period 8
29Grading Period 9Grading Period 9
30Grading Period 10Grading Period 10
31Grading Period 11Grading Period 11
32Grading Period 12Grading Period 12


This table describes logic for triggering syncing of this object.

ActionTrigger
Post

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

  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send if the School is marked as Exclude.
  • Do not send if the Calendar is marked Summer School.
  • If the start date on an existing Grading Period is changed, the "old" record will remain in Ed-Fi and a new record will post with the new date.
PutWhen the Grading Period End Date is updated and saved.
DeleteGrading Periods cannot be deleted due to the dependency of the core Ed-Fi model where it is required for Sessions to report grading periods.

This table describes scope year logic of this object.

Logic

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

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

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 to which  the grading period is aligned.

Reports the Ed-Fi Entity ID.

MSchool.entityIDSystem Administration > Resources > School > Ed-Fi Number
beginDate

The start date of the grading period.

Reports 7/1/XXXX where XXXX is the start year of the School Year.

Medfigradingperiod.startDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Start Date
endDate

The end date of the grading period.

Reports 6/30/XXXX where XXXX is the end year of the School Year.

Medfigradingperiod.endDateSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period End Date
descriptor

The name of the grading period. Reports the value from the Grading Period Name selected. See the Grading Period Descriptor table in the Type/Descriptor section below.

 Medfigradingperiod.nameSystem Administration > Calendar > Calendar > Ed-Fi Grading Periods > Grading Period Name
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Counts 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 one calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures.
    • Instructional days do not send an update if changed after original post unless a resync is completed.
N/ASystem Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

 

This element is optional and does not report.

 N/AN/A 
 _etag N/AON/A N/A 

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01End of YearEnd of Year
02Fifth Six WeeksFifth Six Weeks
03First Nine WeeksFirst Nine Weeks
04First SemesterFirst Semester
05First Six WeeksFirst Six Weeks
06First Summer SessionFirst Summer Session
07First TrimesterFirst Trimester
08Fourth Nine WeeksFourth Nine Weeks
09Fourth Six WeeksFourth Six Weeks
10Second Nine WeeksSecond Nine Weeks
11Second SemesterSecond Semester
12Second Six WeeksSecond Six Weeks
13Second Summer SessionSecond Summer Session
14Second TrimesterSecond Trimester
15Sixth Six WeeksSixth Six Weeks
16Summer SemesterSummer Semester
17Third Nine WeeksThird Nine Weeks
18Third Six WeeksThird Six Weeks
19Third Summer SessionThird Summer Session
20Third TrimesterThird Trimester
21Grading Period 1Grading Period 1
22Grading Period 2Grading Period 2
23Grading Period 3Grading Period 3
24Grading Period 4Grading Period 4
25Grading Period 5Grading Period 5
26Grading Period 6Grading Period 6
27Grading Period 7Grading Period 7
28Grading Period 8Grading Period 8
29Grading Period 9Grading Period 9
30Grading Period 10Grading Period 10
31Grading Period 11Grading Period 11
32Grading Period 12Grading Period 12

2017-2018 Configurations Only

Object Triggering Logic

  Click here to expand...

This table describes logic for triggering syncing of this object.

 

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

ActionTrigger
PostSent as a reference in the Sessions resource.

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 to which the calendar is aligned.

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

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 to which  the grading period is aligned.

Reports the Ed-Fi Entity ID.

MSchool.entityIDSystem Administration > Resources > School > Ed-Fi Number
beginDate

The start date of the grading period.

Reports 7/1/XXXX where XXXX is the start year of the School Year.

MSchool.yearSystem Administration > School > Year
endDate

The end date of the grading period.

Reports 6/30/XXXX where XXXX is the end year of the School Year.

MSchool.yearSystem Administration > School > Year
descriptor

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

  • Reports 01: End of Year.
 MN/A N/A
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Counts 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 one calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures.
    • Instructional days do not send an update if changed after original post unless a resync is completed.
N/ASystem Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

 

This element is optional and does not report.

 N/AN/A 
 _etag N/AON/A N/A 

This table describes logic for triggering syncing of this object.

 

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

ActionTrigger
PostSent as a reference in the Sessions resource.

This table describes scope year logic of this object.

Logic

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

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

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 to which  the grading period is aligned.

Reports the Ed-Fi Entity ID.

MSchool.entityIDSystem Administration > Resources > School > Ed-Fi Number
beginDate

The start date of the grading period.

Reports 7/1/XXXX where XXXX is the start year of the School Year.

MSchool.yearSystem Administration > School > Year
endDate

The end date of the grading period.

Reports 6/30/XXXX where XXXX is the end year of the School Year.

MSchool.yearSystem Administration > School > Year
descriptor

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

  • Reports 01: End of Year.
 MN/A N/A
 totalInstructionalDays

 The total number of instructional days in the grading period.

  • Counts 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 one calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures.
    • Instructional days do not send an update if changed after original post unless a resync is completed.
N/ASystem Administration > Calendar > Calendar >Days
 periodSequence

 The sequence of the grading period.

 

This element is optional and does not report.

 N/AN/A 
 _etag N/AON/A N/A 

Locations

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

Object Triggering Logic

This table describes logic for triggering syncing of this object. If Ed-Fi Configuration Profies is Choise OR Choice + Private Opt In, a record is not sent.

ActionTrigger
Post

When a new Room is created and saved.

Do not send if the School is marked as Exclude.

Delete/PostWhen a Room Name is changed and saved
PutWhen the Maximum Number Of Seats is modified.
Delete

When a Room is deleted.

This fails if there are Section records depending on the room number.

Scope Year Logic

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 only sends 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

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
schoolID

Reports the Entity D entered on the School editor.

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.

Reports the Room Name.

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.

 

This field is not collected or reported.


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

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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section is created and saved.

  • 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 inactive or State Exclude, data is not sent.
  • If the School is marked as Exclude, data is not sent.
  • If the Calendar is marked as Summer School, data is not sent.
PostWhen a section 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 or SCED Seq Number is changed and saved on the Course editor.
  • When the Room or Medium of Instruction is changed and saved on a section.
     1.  Delete the Student Section Association records tied to the previous section.
     2.  Delete the Staff Section Associations records tied to the previous section.
     3.  Delete the Sections record with the 'unknown' location.
     4.  Post the Sections record with the new locationReference.
     5.  Post Student Section Association records tied to the new section.
     6.  Post Staff Section Associations records tied to the new section.
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

This table describes scope year logic of this object.

Logic
Reports Sections in the scope year for the courses to which the calendar is aligned.
Data only sends for the years that have valid configuration.

Future Years data are suppressed until the Active Year is changed:

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

Object Data Elements

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

If Room Number is blank, check to see if a locations record exists with the name "unknown" for this school/year combination.

  • If it does not exist, post a new Locations record for the school.
  • Report the school reference used for this resource and "unknown" for classroomIdentificationCode.
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 > Ed-Fi Number
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 ole part, the value of this section attribute should be 1.

Reports the value selected in the SCED Sequence Part N field. If null, reports 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 is optional and does not report.

ON/AN/A
mediumOf InstructionType

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

  1. Reports first from the Medium of Instruction field on the Section.
  2. If section is NULL, reports from Medium of Instruction on the Course.


O

Scheduling > Course > Section > Medium of Instruction

Scheduling > Course > Medium of Instruction

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
 

This element is optional and does not report.


ON/AN/A
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 is optional and does not report.

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.

Report only 1 program associated per section (from the Course) for each of the subsets:

  1. Subset 1: Report from following fields on the Course:
    1. Bilingual/ESL
    2. Dual Enrollment
    3. World Language
  2. Subset 2: Report from following fields on the Course for the Config years 18-19 and beyond:
    1. Certified Learning Method
    2. Non-Certificated Career Education Program
  3. If multiple programs in each subset are tied to the same course, report only one using the above order.
  4. Report programReference.

See Appendix for logic and reporting values for programType and programName.

C
Scheduling > Course > Custom Data Elements > Bilingual/ESL

Scheduling > Course > Custom Data Elements > Dual Enrollment

Scheduling > Course > Custom Data Elements > World Language

Scheduling > Course > Custom Data Elements > Certified Learning Method

Scheduling > Course > Custom Data Elements > Non-Certificated Learning Method


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

This table describes the Ed-Fi Value mapped and reported for Medium of Instruction Descriptors.

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1Center-based instructionCenter-based instruction
2Correspondence instructionCorrespondence instruction
3Distance Learning (other than online)Distance Learning (other than online)
4Face-to-face instructionFace-to-face instruction
5Independent studyIndependent study
6InternshipInternship
7OtherOther
8Other technology-based instructionOther technology-based instruction
9Technology-based instruction in classroomTechnology-based instruction in classroom
10Telepresence/video conferenceTelepresence/video conference
11TelevisedTelevised
12Videotaped/prerecorded videoVideotaped/prerecorded video
13Virtual/On-line Distance learningVirtual/On-line Distance learning

Appendix

This table describes the logic for reporting Programs - Subset 1.

Program TypeProgram NameLogicUI Path
Language Instruction Education Program - Bilingual ProgramDual language Immersion 
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Dual language Immersion
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - Bilingual ProgramDevelopmental or Late - Transitional Bilingual Program
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Developmental or Late - Transitional Bilingual Program
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - Bilingual ProgramTransitional Bilingual Education 
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Transitional Bilingual Education
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - Bilingual ProgramHeritage language program or Indigenous language program
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Heritage language program or Indigenous language program
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL/BilingualContent-Based ESL-Bilingual
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Content-Based ESL-Bilingual
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL ProgramESL – Sheltered Instruction 
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: ESL – Sheltered Instruction 
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL ProgramESL – Integrated or Co-teaching models
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: ESL – Integrated or Co-teaching models
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL ProgramNo ESL program available
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: No ESL program available
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL/BilingualIntegrated EL-Special Education
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Integrated EL-Special Education
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL/BilingualNewcomer-Bilingual
  1. Report this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Newcomer-Bilingual
Scheduling > Course > Custom Data Elements > Bilingual/ESL
Language Instruction Education Program - ESL/BilingualNewcomer-ESLReport this program type and program name if Bilingual/ ESL value selected is mapped to the Ed-Fi Code: Newcomer-ESLScheduling > Course > Custom Data Elements > Bilingual/ESL
Dual Enrollment ProgramCollege Course with Private College
  1. College Course with Private College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment Program College Course with Technical College
  1.  Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: College Course with Technical College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramCollege Course with Tribal College
  1. Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: College Course with Tribal College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramCollege Course with UW System
  1. Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: College Course with UW System
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramHigh School Course with Private College
  1. Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: High School Course with Private College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramHigh School Course with Technical College
  1. High School Course with Technical College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramHigh School Course with Tribal College
  1. Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: High School Course with Tribal College
Scheduling > Course > Custom Data Elements > Dual Enrollment
Dual Enrollment ProgramHigh School Course with UW System
  1. Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: High School Course with UW System
Scheduling > Course > Custom Data Elements > Dual Enrollment
World Language ProgramForeign Language Exploratory Programs (FLEX)
  1. Report this program type and program name if World Language is mapped to the Ed-Fi Code: Foreign Language Exploratory Programs (FLEX)
Scheduling > Course > Custom Data Elements > World Language
World Language ProgramForeign Language in the Elementary School Programs (FLES)
  1. Report this program type and program name if World Language is mapped to the Ed-Fi Code: Foreign Language in the Elementary School Programs (FLES)
Scheduling > Course > Custom Data Elements > World Language
World Language ProgramImmersion Programs (IMMR)
  1. Report this program type and program name if World Language is mapped to the Ed-Fi Code: Immersion Programs (IMMR)
Scheduling > Course > Custom Data Elements > World Language
World Language ProgramWorld Language (WL)
  1. Report this program type and program name if World Language is mapped to the Ed-Fi Code: World Language (WL)
Scheduling > Course > Custom Data Elements > World Language

This table describes the logic for reporting Programs - Subset 2.

Program TypeProgram NameLogicUI Path
Certified Career Education ProgramIRC - Not State Approved
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC - Not State Approved.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramIRC State Approved Business & Industry
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved Business & Industry.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramIRC State Approved WTCS- Associates
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved WTCS- Associates.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramIRC State Approved WTCS- Embedded Technical Diploma
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved WTCS- Embedded Technical Diploma.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramState Co-op Ed. Skill Standards - DPI Employability Skills
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Employability Skills.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramState Co-op Ed. Skill Standards - DPI Occupational
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Occupational.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramState Co-op Ed. Skill Standards - DPI Youth Leadership
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Youth Leadership.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Certified Career Education ProgramYouth Apprenticeship
  1. Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: Youth Apprenticeship.
Scheduling > Course > Custom Data Elements > Certified Learning Method
Non-Certificated Career Education ProgramInternship
  1. Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Internship.
Scheduling > Course > Custom Data Elements > Non-Certificated Learning Method
Non-Certificated Career Education ProgramLocal Co-op
  1.  Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Local Co-op.
Scheduling > Course > Custom Data Elements > Non-Certificated Learning Method
Non-Certificated Career Education ProgramSimulation
  1. Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Simulation.
Scheduling > Course > Custom Data Elements > Non-Certificated Learning Method
Non-Certificated Career Education ProgramSupervised occupational experience
  1. Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Supervised occupational experience.
Scheduling > Course > Custom Data Elements > Non-Certificated Learning Method

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

This table describes logic for triggering syncing of this object.

 

Data will not report for calendars marked as Exclude or calendars marked as Summer School.

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, terms are grouped together so only one record reports per Term Type.
  • If there are multiple Calendars or Schedule structures in a School with the same Term Types, only one record can report to Ed-Fi. Report the earliest Term Start Date and latest Term End Date.
  • Records are not sent if the Calendar exclude checkbox is marked, if the School is marked as Exclude, or if the calendar is marked as Summer School.
  • If the Ed-Fi Configuration Program is Choice OR Choice + Private Opt In, a record is not sent.
Post

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

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

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

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

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

Scope Year Logic

This table describes scope year logic of this object.

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

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

  • This allows the Schedule Wizard to be used, 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

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
MSchool.entityIDSystem Administration > Resources > School > Ed-Fi Number
schoolYearTypeReference

A reference to the related SchoolYearType resource. This element reports the End year from the calendar term reported. 

MSchool.endYearSystem Administration > Calendar > School Year > End Year
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.

  • When reporting from the Term Descriptors mapping, report the Ed-Fi Code for the value selected.
  • When Ed-Fi Term Type is Null, or when no Ed-Fi code exists, do not report.
  • When reporting from the Term Descriptors Override on Course or Section, 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

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

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

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

  • When reporting from a Term Schedule, report the end date of the term being reported. If more than one term has the same Term Type selected, use the latest end date.
  • When reporting from a Term Type Override on a section. Report the end date from the mapping the course is aligned to.
Term.endDateSystem Administration > Calendar > Calendar > Terms > End Date
totalInstructionalDays

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

  • 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.
    • 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.
    • If more than one term schedule has the same Term Type, count the distinct number of instructional days from all terms for that Term Type.
  • When reporting from Term Type Override, find all section placements that Term Type is associated and count the distinct number of instructional days for each section placement's term.
MN/AN/A
academicWeeks

 An unordered collection of sessionAcademicWeeks.

 

This field is optional and does not report. 


ON/AN/A

gradingPeriods

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

For 2017-18 Configurations Only: The resource is posted if it does not exist for the school.

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

Type/Descriptors

 

The highlighted column indicates the reported value.

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

CodeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
10B10th Block10th Block10th Block
1B1st Block1st Block1st Block
1Q1st Quarter1st Quarter1st Quarter
1S1st Semester1st Semester1st Semester
1T1st Trimester1st Trimester1st Trimester
2B2nd Block2nd Block2nd Block
2Q2nd Quarter2nd Quarter2nd Quarter
2S2nd Semester2nd Semester2nd Semester
2T2nd Trimester2nd Trimester2nd Trimester
3B3rd Block3rd Block3rd Block
3Q3rd Quarter3rd Quarter3rd Quarter
3T3rd Trimester3rd Trimester3rd Trimester
4B4th Block4th Block4th Block
4Q4th Quarter4th Quarter4th Quarter
5B5th Block5th Block5th Block
6B6th Block6th Bock6th Bock
7B7th Block7th Block7th Block
8B8th Block8th Block8th Block
9B9th Block9th Block9th Block
AAnnualAnnualAnnual



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

This table describes logic for triggering syncing of this object.

ActionTrigger
This endpoint will be populated with person data submitted through WISEID . Staff EntityId and LocalPersonId will also be populated in this endpoint. 

Scope Year Logic

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

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 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/Descriptors

 

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
High School DiplomaHigh School DiplomaHigh School Diploma
DoctorateDoctorateDoctorate
Bachelor'sBachelor'sBachelor's
Associate's Degree (two years or more)Associate's Degree (two years or more)Associate's Degree (two years or more)
Some College No DegreeSome College No DegreeSome College No Degree
Did Not Graduate High SchoolDid Not Graduate High SchoolDid Not Graduate High School
Master'sMaster'sMaster's

This table describes the Ed-Fi Value mapped and reported for Staff Identification System Descriptor:

Ed-Fi CodeEd-Fi Short Description Ed-Fi Description
High School DiplomaHigh School DiplomaHigh School Diploma
DoctorateDoctorateDoctorate
Bachelor'sBachelor'sBachelor's
Associate's Degree (two years or more)Associate's Degree (two years or more)Associate's Degree (two years or more)
Some College No DegreeSome College No DegreeSome College No Degree
Did Not Graduate High SchoolDid Not Graduate High SchoolDid Not Graduate High School
Master'sMaster'sMaster's

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

Code in CampusEd-FI Code ValueShort DescriptionDescription
FemaleFemaleFemaleFemale
MaleMaleMaleMale
BlankNot SelectedNot SelectedNot Selected

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

Code in ICRace/Ethnicity in ICEd-Fi Type IDEd-Fi Code ValueEd-FI Short DescriptionEd-Fi Description
3Black or African American3

Black - African American

Black - African American 

Black - African American

1American Indian or Alaska Native 1American Indian - Alaskan NativeAmerican Indian - Alaskan Native American Indian - Alaskan Native
4Native Hawaiian or Other Pacific Islander 4Native Hawaiian - Pacific IslanderNative Hawaiian - Pacific Islanders Native Hawaiian - Pacific Islander
5White 5WhiteWhite White
2Asian 2AsianAsian Asian

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

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

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

ICEd-Fi Type IDEd-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

Staff Section Association

This association indicates the course sections to which a staff is assigned

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a staff person is added to a course section on Staff History.

  • Must have a Staff Type of P: Primary Teacher in the Section Staff History table or have a Staff Type of T: Teacher in the Section Staff History table with a Role of NOT NULL.
  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send a record if the Course is marked Inactive or Exclude.
  • Must have a role mapped to an Ed-Fi code populated to report.
  • Do not report a record if the Staff does not have an Ed-Fi ID.
  • Do not report if the course is in a school marked as exclude.
  • Do not report a record if the Staff's District Assignment record for the reporting school does not overlap the scope year to which the section is aligned.
  • Do not report a record for the unique Section reference if the Section Staff Assignment ends before the section start date for that Section and Term Type combination.

  • Do not report a record if there are 0 students rostered into the section.
PostWhen a Role mapped to an Ed-Fi code is added to an existing teacher on the Staff History Record.
Put

When Start or End dates are modified on the Staff History.


A resync must be completed to have all the records updated.

Post/Delete

If the start or end dates are modified on the District Assignment record or the District Assignment Reocrd is deleted or added, and the staff is still aligned to the section.

Delete

When a staff member is deleted from Staff History.

DeleteWhen a Role is removed from a Teacher on Staff History.
DeleteIf an end date is added on Section Staff History that ends the teacher record before the section reference start date.

Scope Year Logic

This table describes scope year logic of this object.

Logic

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

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 reduces the number of records sent until the final schedule is completed.

A resync must be done after the Active Year is changed to send data.

Object Data Elements

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

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

A reference to the related Section resource.

Reports:

  • Class Period
  • Course Offering
  • Location
  • School
  • Unique Section Code
  • Sequence of Course
MN/AN/A
staffReference

A reference to the related Staff resource.

Reports the Staff Unique ID.

MN/AN/A
classroomPosition Descriptor

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

  • Reports the Ed-Fi Code field from the Role that is selected. Reports default value if selected.
  • If Role is = XX: Not State Reported, do not report a record.
  • If Role is NULL, do not report a record.
MsectionStaffhistory.roleScheduling > Courses > Section > Staff History > Role
beginDate

Month, day and year of a teacher''s assignment to the section. If blank, defaults to the first day of the first grading period for the section. 

For 2017-18 Configurations: Does not report.
For 2018-19 Configurations and later:
  1. Report the Staff History Start date if populated.
    1. If Blank, look at the District Assignment record for the teacher for that School and report Assignment Start Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.
      1. If District Assignment Start Date is prior to the lowest Term Start Date, report the lowest Term Start Date for that section.
  2. If the teacher end date is before the section start date, do not report a record for the teacher.
M

sectionstaffhistory.startdate

or

employmentassignment.startdate

Course > Section > Staff History > Start Date

or

Census > People > District Assignment > Start Date

endDate

Month, day and year of the last day of a teacher's assignment to the section. NEDM: Ending Date. 

For 2017-18 Configurations: Does not report.
For 2018-19 Configurations and later:
  1. Report the Staff History End Date if populated.
    1. If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.
  2. Otherwise, report the Term End Date for that section.
M

sectionstaffhistory.enddate

or

employmentassignment.enddate

Course > Section > Staff History > End Date

or

Census > People > District Assignment > End Date

highlyQulaifiedTeacher

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 this section being taught.

This is optional and does not report.

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

ON/AN/A
percentageContribution

The percentage of time the teacher is responsible for the 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/Descriptors

 

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
03187Administrative staffAdministrative staff is specified as the type of position the staff member holds in the specific course section.
73071Co-teacherCo-teacher is specified as the type of position the staff member holds in the specific course section.
04725CounselorCounselor is specified as the type of position the staff member holds in the specific course section.
73073Course ProctorCourse Proctor is specified as the type of position the staff member holds in the specific course section.
05973Instructor of recordInstructor of record is specified as the type of position the staff member holds in the specific course section.
01234InternIntern is specified as the type of position the staff member holds in the specific course section.
73072Lead Team TeacherLead Team Teacher is specified as the type of position the staff member holds in the specific course section.
00069Non-instructional staffNon-instructional staff is specified as the type of position the staff member holds in the specific course section.
09999OtherOther is specified as the type of position the staff member holds in the specific course section.
00059Paraprofessionals/teacher aidesParaprofessionals/teacher aides is specified as the type of position the staff member holds in the specific course section.
05971Primary instructorPrimary instructor is specified as the type of position the staff member holds in the specific course section.
04735Resource teacherResource teacher is specified as the type of position the staff member holds in the specific course section.
05972Secondary instructorSecondary instructor is specified as the type of position the staff member holds in the specific course section.
73074Special Education ConsultantSpecial Education Consultant is specified as the type of position the staff member holds in the specific course section.
00080Student teachersStudent teachers is specified as the type of position the staff member holds in the specific course section.
01382Volunteer/no contractVolunteer/no contract is specified as the type of position the staff member holds in the specific course section.
XXNot State Reported

Mapping

CodeNameEd-Fi Short Description
MTMultiple TeachersCo-Teacher
STSingle TeacherPrimary instructor
CTCollaborating EducatorOther
MEMonitoring EducatorOther

Student

This association reports student demographic data.

 

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

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person.

  • Data is not sent if the enrollment is marked as No Show or WISE Exclude.
  • Data is not sent if the enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude.
  • Data is not sent if the enrollment service type is Partial (S).
  • If Ed-Fi Configuration Profile is Choice + Opt In, a record reports for all eligible students of Choice is Yes or No on the student's enrollment.
  • If Ed-Fi Configuration Profile is Choice AND Choice is No on the student's enrollment, a record is not reported.
PostWhen one or more disability is added to an IEP and locked. The IEP must overlap with the student's enrollment.
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 the person’s FRAM Eligibility is changed.
  • When the person’s EL record is changed.
  • When the person's Statewide Assessment Type is changed. 
  • When the person's Migrant record is changed.
DeleteStudent records are never deleted because Student records are a shared resource among all districts.

Scope Year Logic

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

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
student UniqueIdA unique alpha-numeric code assigned to a student. This element reports the Ed-Fi ID of the student.Mperson. EdFiIdCensus > People > Demographics > EdFi ID
personal TitlePrefix

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.

C

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 Information > Gender

Census > People > Identity > Gender




maidenName

The person's maiden name, if applicable.

 

This element is currently not reported or collected.

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

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

 

This element is currently not reported or collected.

ON/AN/A
birthState
Abbreviation Type

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

 

This field is optional and does not report.


ON/AN/A
birthCountry
CodeType

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

 

This field is optional and does not report.


ON/AN/A
dateEntered US

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

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

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

 

This element is currently not reported or collected.

ON/AN/A
profile Thumbnail

File name for the ProfileThumbnail photograph.

 

This element is currently not reported or collected.

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

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

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

If = '1' then 'Hispanic'

If  = '2', then 'American Indian Or Alaskan Native'

If = '3' or '5', then 'Asian Or Pacific Islander'

If = '4' then  'Black, Not Of Hispanic Origin'

If = '6', then 'White, Not Of Hispanic Origin'

 

This element is currently not reported or collected.


ON/AN/A
economic
Disadvantaged

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

If the Disadvantaged - Alt Mechanism field on the Enrollment record is marked, reports True.

Use FRAM Eligibility records with a Type of Meal or SES:

  1. Determine if the record is active based on the date:
    1. In previous years, report based on the last day of the calendar if the current date has passed the end of the year.
    2. If the enrollment driving the record has ended, use the enrollment end date for the date calculation.
    3. If the enrollment has not ended, use the current date. If the FRAM record includes the date, use the record.
  2. Reports True if eligibility is Free or Reduced.
  3. Reports False if eligibility is Paid, Non-reimbursable or NULL or if No FRAM records exist.
O

EnrollmentWI. disadvantaged

POSEligibility. eligibility

Student Information > General > Enrollment

 FRAM > Eligibility > Eligibility

schoolFood ServicesEligibility Descriptor

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

  1. Determine if the record is active based on the date:
    1. In previous years, reports based on the last day of the calendar if the current date has passed the end of the year.
    2. If the enrollment driving the record has ended, use the enrollment end date for the date calculation.
    3. If the enrollment has not ended, use the current date. If the FRAM record includes the date, use the record.
  2. Reports the Ed-Fi Code Value from the School Food Services Eligibility Descriptor. See the Type/Descriptor section below.
  3. Reports all students as 01: Free when the Provision status on the current School Record is CEP.

The Effective date used to determine status must overlap the base years to report.

CPOSEligbility. eligibility

FRAM > Eligibility > Eligibility

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

limitedEnglish
Proficiency Descriptor

An indication that the student has sufficient difficulty speaking, reading, writing, or understanding the English language, as to require special English Language services. Logic reports based on the following:

For the current scope year, find the EL record to be used as of today's date.

Find all EL records where the EL Identified Date is before today's date.

  • EL records with an Identified Date after today's are disregarded.
  • Use the record if one of the following are true:
    • Today's date falls between the EL Identified Date and EL Exit Date.
    • Today's date falls after the EL Identified Date and no exit date exists.
    • Program Status must be EL or Exited EL.

If today's date does not fall between the Identified Date and the Exit Date of any EL record, and no record exists without an Identified Date, use the most recent EL record with an Exit Date as the Valid EL Record.

For any previous year's data, find the latest EL record (based on the Assessment Date) within the scope year or before (on or before the last date of the year). If the Assessment Date is NULL, the score is used for any year.

  • Program status must be EL or Exited EL.

From the identified EL record, the reported value is calculated:

  • First, if there is an English Proficiency Override value on the EL record, that value reports.
  • Next, if the student has exited and the Exit Date is prior to the current date/end of year date, a value of 6 reports.
  • Otherwise, find the most recent EL Assessment of Assessment Type LPF or LID.
    • If there are multiple assessments, use the last EL  assessment created.
    • From the identified assessment, the result value (1.0-6.0) is found and the result displays a truncated value of the whole number. For example; the Result on the EL Assessment being considered = 2.8, a '2' is reported
    • Any test with a value outside this range (6.1 or above, or 0-.9) is disregarded and does not report.

If the Home Primary Language is not English, a blank value reports.

If the Home Primary Language is English, a value of 7 reports.

If the student is not EL, a value of 7 reports.

CN/A

Student Information > Program Participation > English Learners (EL) > EL > State Localized Elements > English Proficiency Override

Student Information > Program Participation > English Learners (EL) >  EL Assessments > ACCESS Test Scores

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

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

displacement Status

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

 

This element is currently not reported or collected.

ON/AN/A
loginId

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

 

This element is currently not reported or collected.

ON/AN/A
international ProvinceOfBirth

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

 

This element is currently not reported or collected.

ON/AN/A
citizenship StatusType

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

 

This element is currently not reported or collected.

ON/AN/A
learningStyle

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

 

This element is currently not reported or collected.

ON/AN/A
addresses

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

If there is more than one Primary Address marked as Mailing, report address with most recent Household Membership Start Date

Else, report the address with most recent Address Start Date

 

This element is currently not reported or collected.


O

Household Location.
mailing

Household Member.
startDate

Household location.
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 
streetNumber Name

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

Address. number

Address. street

Address. tag

Address. prefix

Address. dir

Households > Address Info 
apartmentRoom SuiteNumberThe 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.

ON/AN/A
cityThe name of the city in which an address is located.Address.cityHouseholds > Address Info > City
stateAbbreviation TypeThe 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
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    

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

This field reports the Ed-Fi Code Value from the Student Characteristic. See the Type/Descriptor section below. 

  • If the student has more than one enrollment, data reports from the Primary Enrollment. 
  • If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order: (1) S: Ancillary Enrollment, (2) N: Special Education.
  • If the student has multiple enrollments with the same service type, report from earliest enrollment id.
  • If a mapping is not found, data does not report.

This element is an array that reports the following data:

CN/AStudent Information > General > Enrollments > State Reporting
Student Characteristic DescriptorThis entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary education program under the jurisdiction of a school, education agency or other institution or program. Report  each characteristic based on the requirements below.  Student must have a Student School Association in the configured year to report a characteristic.
MN/AN/A
beginDate

The date the characteristic was designated.

 

This field is optional and does not report.

ON/AN/A
endDate

The date the characteristic was removed.

 

This field is optional and does not report.

ON/AN/A
designatedBy

The person, organization or department that designated the characteristic.

 

This field is optional and does not report.

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

ON/AN/A
disabilities



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

If the enrollment determining the record is in a school with an Ed-Fi Configuration Profile = Public, information does not report from this array.

CN/AN/A
disabilityDescriptor

The descriptor defines a student's impairment.

Reports the Ed-Fi Code from the Disabilities for the student being reported.

The student must have a locked IEP which overlaps in the current year with the student's enrollment end date or the current date, or which overlaps in previous scope years, the student's enrollment end date or if null, the last instructional date of the year.

The IEP must overlap with the student's enrollment record.

  • The service type on the enrollment in the active school year is used to determine priority of enrollments to use: Primary, Secondary, Special Education.
  • If the student has multiple enrollments with the same service type in the same school, the highest enrollment id is used.

If the student has a Special Education Exit Date that is on or before today's date:

  • The SPED Exit Date is on or after the enrollment end date, the disabilities continue to report.
  • If the enrollment has not ended or the SPED Exist Date is before the enrollment end date, disabilities do not report.

If the student has more than one disability, each disability up to 3 disabilities reports.

M

PlanState.disability1

PlanState.disability2

PlanState.disability3

Student Information > Special Ed > Documents > IEP > Primary Disability, Secondary Disability, Tertiary Disability
disabilityDiagnosisA description of the disability diagnosis.ON/AN/A
orderOfDisabilityThe order by severity of the student's disabilities: 1 - Primary, 2 - Secondary, 3 - Tertiary.ON/AN/A
disabilityDeterminationSourceTypeKey for Disability Determination Source Type.ON/AN/A
electronic Mails

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

 

This field is optional and does not report.


ON/AN/A
identification Codes

An unordered collection of studentIdentificationCodes. 

This element reports the Local Student Number and Student State ID fields, if populated.

This element is an array that reports the following data:

O

Person.
studentNumber

Person. stateID

Census > People > Demographics > Local Student Number

and/or

Census > People > Demographics > Student State ID

studentIdentification SystemTypeReports the short description from the Student Identification Code mapping. See the Type/Descriptor section below. MN/AN/A
Assigning Organization Identification CodeReports 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 or other agency or entity. Reports the Local Student Number if populated.MN/AN/A
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. 

  • If the Enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked as Choice or Choice + Private Opt In, a blank value reports.
  • If the Enrollment is in a school where Ed-Fi School Population is marked Public, and Native Language is populated, add to the languages.
  • If the Native Language field is not populated, the array is not added.

This element is an array that reports the following data:

CN/AN/A
language DescriptorReport either the Ed-Fi Code or Code from the Native Language saved on the student's current identity record based on the logic below:
  1. If blank, do not report this field.
  2. If a dictionary value is selected, determine the end year for the Students resource being sent
    1. For configurations with an end year of 2018 or greater, report based on the Ed-Fi Code of the dictionary item selected Identity.languageAlt.
    2. For configurations with an end year of 2017 or earlier, report based on the Code value of the dictionary item selected Identity.languageAlt.
  3. If a code does not match an Ed-Fi code, do not report a record.
M

Identity.languageAlt

Census > People > Identities > Native Language

uses

An unordered collection of studentLanguages. If the array reports, this field reports Native Language.


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 not collected or reported.


This element is an array that reports the following data:

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

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

 

This element is not collected or reported.

CN/AN/A
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
generationCode SuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).CIdentity. suffixCensus > People > Identities > Suffix Name
program Participations

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

Identity RaceEthnicity

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

Identity RaceEthnicity

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.

 

This element is optional and does not report.

ON/AN/A
visas

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

  • If the Enrollment determining the record is in a calendar in a school where Ed-Fi School Population is marked Choice or Choice + Private Opt in, this field does not report.
  • If Enrollment is in a school where Ed-Fi School Population is marked Public and If populated on the person, reports the Visa Type.
  • Otherwise, report blank

See the Type/Descriptor section below.

CIdentity.visaTypeCensus > People > Identites > Person Information > Visas
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 

 

The highlighted column indicates the reported value.

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

Campus CodeEd-Fi Code ValueShort DescriptionDescription
F1FemaleFemale
M2MaleMale
NP5NPNP

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

Code in CampusRace/Ethnicity in CampusEd-Fi Type IDEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
3Black or African American3

Black - African American

Black - African American 

Black - African American

1American Indian or Alaska Native 1American Indian - Alaskan NativeAmerican Indian - Alaskan Native American Indian - Alaskan Native
4Native Hawaiian or Other Pacific Islander 4Native Hawaiian - Pacific IslanderNative Hawaiian - Pacific Islanders Native Hawaiian - Pacific Islander
5White 5WhiteWhite White
2Asian 2AsianAsian Asian

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

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

Local Student Number 

      


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

Student State ID 

 
StateStateState
State MigrantState MigrantState Migrant

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

Campus CodeEd-Fi Code ValueEd-Short DescriptionEd-Fi Description
F01FreeFree
S02Full priceFull price
A02Full priceFull price
R03Reduced PriceReduced Price

04UnknownUnknown

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

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

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
1ELL/LEP Beginning PreproductionELL/LEP Beginning Preproduction (WIDA label: Entering)
2ELL/LEP Beginning ProductionELL/LEP Beginning Production (WIDA label: Beginning)
3ELL/LEP IntermediateELL/LEP Intermediate (WIDA label: Developing)
4ELL/LEP Advanced IntermediateELL/LEP Advanced Intermediate (WIDA label: Expanding)
5ELL/LEP AdvancedELL/LEP Advanced (WIDA label: Bridging)
6Formerly ELL/LEP now fully English ProficientFormerly ELL/LEP, now fully English Proficient
7Fully English ProficientFully English Proficient, never ELL/LEP

This calculation describes the Ed-Fi Value mapped and reported for English Proficient Duration Descriptor (additional calculation for Languages element):

For the current scope year (current date is within the start and end date of the year dates)

  1. The student's current EL record to be used as of today's date (EL Identified Date is before the current date. If EL Identified Date is after the current date, it is disregarded).
    1. The record is used if one of the following are true:
      1. The current date falls between the EL Identified Date and EL Exit Date.
      2. The current date falls after Identified Date and No exit date exists.
      3. EL Program Status is EL or Exited EL.
    2. If the current date does not fall between the Identified Date and the Exit Date of any EL record, and no record exists without an Identified Date, the most recent EL record with an Exit Date is used as the Valid EL Record.
  2. For any previous year's data (scope year set to a year with an end date prior to the current date), the latest EL record (based on Assessment Date) within the scope year or before (on or before the last date of the year) is used. If the Assessment date is NULL, the score is used for any year.

    1. EL Program Status must be EL or Exited EL.

  3. From the identified LEP record, calculate the reported value:
    1. If there is an English Proficiency Override value on the EL record used (see above for logic on which record to use), that value reports.
    2. If the student has exited and the Exit date is prior to the current date/end of year date, reports 6.
    3. Otherwise, find most recent EL Assessment of Assessment Type LPF or LID.
      1. If there are multiple assessments, use the last EL assessment created.
      2. For previous year's data, do not use any assessments after the end of the year.
      3. From the identified assessment, pull the result value (1.0-6.0) and display the result truncated to the whole number. For example; the Result on the EL Assessment being considered = 2.8, a '2' is reported
      4. Any test with a value outside of this range (6.1 or above, or 0-.9) does not report.
    4. Otherwise, Else, if Home Primary Language is not English, reports a blank value.
    5. If Home Primary Language is English, reports 7.
    6. If the Student is not EL, reports 7.

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

Ed-Fi Code ValueLogicEd-Fi Short DescriptionEd-Fi Description
Reports when a student has an Alternate Statewide Assessment Type assigned to them on their enrollment record.
SATA

Reports when a student's enrollment has the Statewide Assessment Type set to A: Alternate. Otherwise, it does not report.

Student Information > General > Enrollments > State Reporting Fields > Statewide Assessment Type.

State Assessment Type - AlternateState Assessment Type - Alternate
Homeless

Does not report for students enrolled in a School with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config year is before 2018-19:

  • If the student has a Homeless record at any point during an enrollment in the school year, add Homeless to the array.
  • Otherwise, it does not report.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config Year is 2018-19 or later, it does not report.

Student Information > Program Participation > General  > Homeless

HomelessHomeless
Migrant

Does not report for students enrolled in a School with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public:

  • If a student has a Migrant record at any point during an enrollment in the school year, Migrant is added to the array.
  • Otherwise, it does not report.

Student Information > Program Participation > Migrant

MigrantMigrant
Immigrant

Does not report for students enrolled in a School with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public:

  • If a student is marked as Immigrant = Yes, Immigrant is added to the array.
  • Otherwise, it does not report.

Student Information > General > Enrollment > State Reporting Fields > Immigrant

ImmigrantImmigrant
Parent in Military

Does not report for students enrolled in a School with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config Year is before 2018-19, then it does not report.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config Year is 2018-19 or later: 

  1. If the student has a Qualifying Relationship with a person with an Active Military Connections record, add Parent in Military to the array.
    1. A qualifying relationship is;
      1. active within the school year (not ended prior to the start of the config year)
      2. AND either marked Guardian OR the role is mapped to an Ed-Fi value of Parent/ Guardian
      3. OR the Relationship Type is marked Guardian (System Administration > Census > Relationship Type > Guardian checkbox).
      4. OR the Relationship Type is mapped to an Ed-Fi value with the value of Parent/Guardian indicated on the Attribute Dictionary (System Administration > Census > Relationship Type > Ed-Fi Relation Type - Mapped to value 'Parent/Guardian' in Custom > Attribute/Dictionary > Relationship Type > Ed-Fi Relationship Type > Value column)
    2. An Active Military Connections record is;
      1. has a start date in the school year associated with the Ed-Fi config year OR is not ended prior to the start of the config year
      2. has a Status mapped to an Ed-Fi Value of Active
  2. Otherwise, does not report.

Calculated from: Census > People > Military Connections and Census > People > Relationships

Parent in MilitaryParent in Military
Teen Single Parent

Does not report for students enrolled in a School with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config Year is 2018-19 or later:, then it does not report.

If students are enrolled in a school where the Ed-Fi Reporting Option is Public and the Config Year is 2018-19 or later:

  1. If the student is marked 12. Teen Single Parent, add Teen Single Parent to the array.
  2. Otherwise, does not report.

Student Information > General > CTE

Teen Single ParentTeen Single Parent

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

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
AAutisimAutism
DBDeaf-BlindDeaf-Blind
EBDEmotional Behavioral DisabilityEmotional Behavioral Disability
HHearing ImpairmentHearing Impairment
IDIntellectual DisabilityIntellectual Disability
LDSpecific Learning DisabilitySpecific Learning Disability
OHIOther Health ImpairmentOther Health Impairment
OIOrthopedic ImpairmentOrthopedic Impairment
SDDSignificant Developmental DelaySignificant Development Delay
SLSpeech or Language ImpairmentSpeech or Language Impairment
TBITraumatic Brain InjuryTraumatic Brain Injury
VVisual ImpairmentVisual Impairment

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

Ed-Fi Code ValueCampus NameEd-Fi Short DescriptionEd-Fi Description
F1Foreign Student Visa

F1 - Foreign Student Visa

F1 - Foreign Student Visa

M1Foreign Student pursuing vocational or non-academic studies Visa

M1 - Foreign Student pursuing vocational or non-academic studies Visa

M1 - Foreign Student pursuing vocational or non-academic studies Visa

H1Employment VisaH1 - Employment VisaH1 - Employment Visa
B1Business VisaB1 - Business VisaB1 - Business Visa
B2Tourist VisaB2 - Tourist VisaB2 - Tourist Visa
J1Exchange Scholar VisaJ1 - Exchange Scholar VisaJ1 - Exchange Scholar Visa
OOther VisaOther VisaOther Visa

Student Academic Record

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a student is given a Diploma Type and Diploma Date.

  • If the student has more than one enrollment record, the following logic is used to determine which enrollment record is associated with the academic record:
    • If the Diploma Date overlaps the enrollment start and end dates, report from that enrollment.
      a. If the Enrollment end date is NULL, use the end of the school year as the default date (6/30).
    • If the Diploma Date does not overlap the enrollment(s), look for an enrollment in the same school year as the diploma date. Report based on that enrollment.
      a. If there is no enrollment in that year, do not send a record.
    • If more than one enrollment record qualifies, report based on the enrollment service type (Primary enrollments report before Special Ed enrollments).
    • if enrollment service types are the same:
      a. Report first from an enrollment with an end status of HSC.
      b. Then, report from the most recent end date.
      c. Finally, report by highest enrollment ID.
  • If a Diploma Type is changed, post and overwrite the existing value.
  • If Ed-Fi Configuration Profile is Choice + Opt in report a record for all eligible students if Choice is Yes or No on the student's enrollment.
  • If Ed-Fi Configuration Profile is Choice AND Choice is No on Student enrollment, do not report a record.
  • A record is not sent if the enrollment is in a calendar marked as No Show, State Exclude, or WISE Exclude.
  • A record is not sent if the enrollment has a Service Type of Partial (S).
  • A record is not sent if the School is marked Exclude.
PostWhen a Diploma Type is changed, post and overwrite the existing value.
Post

If a Student School Association record is deleted for one school but the student has another qualifying enrollment in a different school, a new record posts for the new school if Diploma Type and Diploma Date are populated.

PostIf a new Student School Association record is created and that enrollment takes priority over the existing Student School Association record.
PostIf the Ed-Fi Configuration Profile is set to Choice AND Choice is changed from No to Yes on Student enrollment and saved, post a new record.
Delete/PostIf a Diploma Date is modified, delete the first record and post a new record.
DeleteIf Student School Association record for a specific School and Year is deleted.
DeleteIf a new Student School Association record is created and that enrollment takes priority over the existing Student School Association record.
DeleteIf the State Exclude, WISE Exclude, or No Show checkboxes are checked.
 

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

Scope Year Logic

This table describes scope year logic of this object.

Logic
The Student Academic Record will only post to the School Year the associated Student School Association record is posted to.
Data will only send for the years that have valid configuration.

Object Data Elements

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

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

Report the School ID from which the student graduated.

  1. Report the School ID that the student graduated from. First determine the associated enrollment.
    1. If the Diploma Date falls within a student's enrollment report from that enrollment.
    2. If the Diploma Date falls outside of a student's enrollment, report the school from the most recent enrollment.
    3. If the student has more than 1 enrollment in more than 1 school report the school from the primary enrollment.
    4. If enrollment types are the same, report from most recent end date.
  2. If the School Override is set on the associated enrollment, report the school ID from the Override.
  3. Otherwise, report the school ID for the enrollment school.
MN/AN/A
schoolYearType
Reference
A reference to the related SchoolYearType resource. This element reports the end year of the school year being reported.

M

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

  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
termTypeThe term for the session during the school year. This does not report.MN/AN/A
diplomas

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

This element is an array that reports the following data:

CN/AN/A
diplomaTypeThe type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements. See the Type/Descriptor section below.

Reports 'Regular Diploma' when Diploma Type = R: Regular Diploma

Reports ''High school equivalency credential, other than GED' when Diploma Type is = E: High School Equivalency Diploma (HSED)

Reports 'Other' when Diploma Type is = C: Other High School Completion Credentials

MGraduation. diplomaTypeStudent Information > General > Graduation > Diploma Type
diplomaAwardDateThe month, day and year on which the student met graduation requirements and was awarded a diploma.MGraduation. diplomaDateStudent Information > Graduation > Diploma Date
achievementCategory Descriptor

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

Report the Ed-Fi Code from the mapping for this field based on the Diploma Type associated with the student.
 MGraduation. dipomaTypeStudent Information > General > Graduation > Diploma Type 
cumulativeEarned
CreditType

Key for Credit. 

This is optional and does not report.

ON/AN/A
cumulativeEarned
CreditConversion

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

This is optional and does not report. 

ON/AN/A
cumulativeEarned
Credit

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
cumulativeAttempted
CreditType

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
cumulativeAttempted
Credit

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
cumulativeGrade
PointsEarned

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

This is optional and does not report. 

ON/AN/A
cumulativeGrade
PointAverage

A measure of average performance in all courses taken by an individual during his or her school career as determined for record-keeping purposes. This is obtained by dividing the total grade points received by the total number of credits attempted. 

This usually includes grade points received and credits attempted in his or her current school as well as those transferred from schools in which the individual was previously enrolled.  

This 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
projectedGraduation
Date

The month and year the student is projected to graduate.  

This is optional and does not report. 

ON/AN/A
sessionEarned
CreditType

Key for Credit.  

This is optional and does not report. 

ON/AN/A
sessionEarned
CreditConversion

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

This 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
sessionAttempted
CreditType

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
sessionGradePoints
Earned

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

This is optional and does not report. 

ON/AN/A
sessionGrade
PointAverage

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

This 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 Layout

 

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueShort DescriptionDescription
Regular DiplomaRegular DiplomaRegular Diploma
Endorsed/advanced diplomaEndorsed/advanced diplomaEndorsed/advanced diploma
Regents diplomaRegents diplomaRegents diploma
International BaccalaureateInternational BaccalaureateInternational Baccalaureate
Modified diplomaModified diplomaModified diploma
Other diplomaOther diplomaOther diploma
Alternative credentialAlternative credentialAlternative credential
Certificate of attendanceCertificate of attendanceCertificate of attendance
Certificate of completionCertificate of completionCertificate of completion
High school equivalency credential, other than GEDHigh school equivalency credential, other than GEDHigh school equivalency credential, other than GED
General Educational Development (GED) credentialGeneral Educational Development (GED) credentialGeneral Educational Development (GED) credential
Post graduate certificate (grade 13)Post graduate certificate (grade 13)Post graduate certificate (grade 13)
Career and Technical Education certificateCareer and Technical Education certificateCareer and Technical Education certificate
OtherOtherOther
Occupational LicenseOccupational LicenseOccupational License
Industry-recognized CertificationIndustry-recognized CertificationIndustry-recognized Certification
Apprenticeship CertificateApprenticeship CertificateApprenticeship Certificate

Student CTE Program Associations

This resource reports several different sets of distinct data to the state based on the Program set up of a CTE Program and the Student's associated CTE Program record. The object triggering requirements and data elements report differently for each of the three main data sets.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Pre-conditions / All Scenarios

If the Ed-Fi Configuration Profile is Choice + Opt in, does not report any records.

If Ed-Fi Configuration Profile is Choice, does report any records.

A Student must have a valid enrollment in order for a record to Post where:

  • The No Show, State Exclude, or WISE Exclude checkboxes are not marked.
  • The enrollment is not in a calendar marked Calendar Exclude, the Summer School Exclude checkbox is marked in the calendar, or the calendar is in a School marked Exclude.
  • The enrollment is not for a Grade marked Grade Level Exclude.
  •  The enrollment is NOT a Partial (S) Type enrollment.
Career Tech Education Concentrator
Post

When a new CTE Program record is saved for a student where:

  • The CTE Program has a State Code (CIP) and Cluster identified.
  • The CTE Program is marked State Reported.
  • The student CTE Program record associated with the CTE Program is marked Concentrator = Yes.
  • The student Enrollment is in state grade level 11 or 12.
  • If there are multiple enrollments with the same start date in the same school, for unique elements report enrollments P: Primary enrollments first, then N: Special Ed.

  •  When an enrollment with a higher priority is deleted, the enrollment with lower priority posts a new record.

  • If another student CTE Program record exists for a Program meeting all the above criteria with an earlier start date or lower programId, do not report the second record.
    (Only report one program record for a Career Tech Education Concentrator scenario.)

PutWhen an enrollment is updated for a student
PutWhen the student CTE Program record driving the record is updated for a student.
DeleteWhen the student CTE Program record driving the record is marked Concentrator = No.
Non-Course Associated Career Tech Education (or College and Career Ready)
Post

When a new CTE Program Record is saved for a student where:

  • The CTE Program has a Non-Course Program Status identified.
  • The CTE Program is marked State Reported.
  • The student CTE Program record associated with the CTE Program is within the dates of the students enrollment in the current/ config year.
PutWhen the student CTE Program record driving the record is updated for a student.
State Endorsed Regional Pathways
Post

When a new CTE Program Record is saved for a student with a reportable enrollment.

  • The CTE Program has State Endorsed Regional Pathway = Yes.
  • The CTE Program is marked State Reported.
  • The student CTE Program record associated with the CTE Program is within the dates of the students enrollment in the current/ config year.
PutWhen the student CTE Program record driving the record is updated for a student.
All Scenarios
PostWhen an enrollment is updated to be reportable and the student meets the criteria for one of the reporting scenarios.
Delete/PostWhen the start date of an enrollment is changed.
DeleteWhen an enrollment is deleted or one of the checkboxes for No Show, State Exclude, or WISE Exclude are marked.
Delete

When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.

  • When a student has two enrollments in the same school for the same start date, record changes with lower priority will not trigger a delete.
DeleteWhen the student CTE program record driving the record is deleted.

Scope Year Logic

This table describes scope year logic of this object.

Logic
If driven from Enrollment, the record sends to the scope year for the school year in which the enrollment is associated.

If driven from CTE Program, the record sends to the scope year for the school year in which the CTE Program record is associated.

Data only sends for the years that have valid configuration.

Object Data Elements

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.M N/AN/A
educationOrganizationReference

A reference to the related Education Organization Resource.

Reports the Ed-Fi District Number (Agency key) for the enrollment determining the record.


Mdistrict.entityIdSystem Administration > Resources > District Information> Ed-Fi District Number
programReference

A reference to the related Program resource.
programReference {educationOrganizationId (integer) : EducationOrganization Identity Column, type (string): Key for Program, name (string): The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies., link (link, optional): Represents a hyperlink to the related program resource.

MN/AN/A
Career Tech Education Concentrator
  1. For Education Organization ID, reports '48856'.
  2. For Program Name, reports 'Career and Technical Education'.
  3. For Program Type, reports 'Career and Technical Education'.
Non-Course Associated Career Tech Education (or College and Career Ready)
  1. For Education Organization ID, reports '48856'.
  2. For Program Name, reports based on the Non-Course Program Status field on the CTE Program for which the student has an associated CTE record,
    1. If the Status is code 10-14, reports 'Non Certified Career Education Program'.
    2. Otherwise, reports 'Certified Career Education Program'.
  3. For Program Type, reports the description from the Non-Course Program Status field on the CTE Program to which the student is assigned.
State Endorsed Regional Pathways
  1. For Education Organization ID, reports '48856'.
  2. For Program Name, reports 'State Endorsed Regional Career Pathway Program'.
  3. For Program Type, reports 'State Endorsed Regional Career Pathway Program'.
studentReference

A reference to the related Student resource.

Reports the studentUniqueId from the Student Resource.

Midentity.edFiIdCensus > People > Demographics > Ed Fi ID
beginDateThe month, day, and year on which the Student first received servicesM

Career Tech Education ConcentratorReports '07/01/xxxx' where xxxx is the start year of the record config year.
Non-Course Associated Career Tech Education (or College and Career Ready)Reports the start date of the student CTE program record.
State Endorsed Regional PathwaysReport "07/01/xxxx" where xxxx is the start year of the record config year.
endDateThe month, day, and year on which the Student exited the Program or stopped receiving services.C

Career Tech Education ConcentratorReports '06/30/xxxx' where xxxx is the end year of the record config year.
Non-Course Associated Career Tech Education (or College and Career Ready)Reports the end date of the student CTE program record.
State Endorsed Regional PathwaysReports '06/30/xxxx' where xxxx is the end year of the record config year.
ctePrograms

An unordered collection of studentCTEProgramAssociationCTEPrograms. This association represents the career and technical education (CTE) program that a student participates in. The association is an extension of the StudentProgramAssociation particular for CTE programs

studentCTEProgramAssociationCTEProgram {careerPathwayType (string): The career cluster representing the career path of the Vocational/Career Tech concentrator. NEDM: Career Cluster,

wiDpiStudentCTEProgram {iacCodeType (string): Number and description of the CIP Code associated with the student's CTE program.

C

Program Admin > Career Tech > Career Cluster

Program Admin > Career Tech > State (CIP) Code

Student Information > General > CTE

Career Tech Education Concentrator
  1. For Career Pathway Type, reports the ed-fi code from the Career Cluster on the CTE Program in which the student has an associated CTE record.
  2. For iac Code Type, reports the ed-fi code from the CIP Code on the CTE Programin which  the student has an associated CTE record.
  3. For studentCTEProgramAreas, report the Program Area Participations on the student's CTE tab
    1. If (A) Ag & Natural Resource is checked, add 'A' to the array.
    2. If (B) Business & Info Tech is checked, add 'B' to the array.
    3. If (F) Family/Consumer Science Edu is checked, add 'F' to the array.
    4. If (H) Health Science is checked, add 'H' to the array.
    5. If (M) Marketing is checked, add 'M' to the array.
    6. If (T) Technology & Engineering is checked, add 'T' to the array.
    7. Report all values separated by commas in the array.
Non-Course Associated Career Tech Education (or College and Career Ready)Does not report.
State Endorsed Regional PathwaysDoes not report.
wiDpiStudentCTEProgramAssociation

wiDpiStudentCTEProgramAssociation {certificatedProgramsStatusType (string): This status is an indication of student's progress towards earning a 'certificate' within the 'certified Career Education Programs (Program Type)

stateEndorsedRegionalCareerPathwayStatusType (string): HOLD FOR DEFINITION / Additional details on JSON

studentCTEProgramAreas (string): The program area representing the career path of the vocational/career Tech concentrator.}

CN/A

Student Information > Academic Planing > Career Tech > Status

Student Information > Academic Planing > Career Tech > Concentrator

Career Tech Education Concentrator
  1. Does not report wiDpi Certificated Program Status Type.
  2. Does not report State Endorsed Region Career Pathway Status Type.
Non-Course Associated Career Tech Education (or College and Career Ready)
  1. For wiDpi Certificated Program Status Type, reports based on the Non-Course Program Status field on the CTE Program in which the student has an associated CTE record,
    1. If the Status code is 10-14, does not report.
    2. Otherwise, reports the program status from the associated Student CTE record.
  2. Does not report State Endorsed Region Career Pathway Status Type.
State Endorsed Regional Pathways
  1. Does not report wiDpi Certificated Program Status Type.
  2. For State Endorsed Region Career Pathway Status Type, reports from Concentrator field on the CTE Program in which the student has an associated CTE record.
    1. If Concentrator = No, reports 'Participant'.
    2. If Concentrator = Yes, reports 'Completer'.



Student Discipline Incident Associations

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

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 one behavior event associated and the student has a Role of Perpetrator and a resolution that is mapped to an Ed-Fi Value and generates a Discipline Actions record.
  • 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, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school.
  • 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.
  • Only send a record if the Ed-Fi Configuration Profile is Public.
  • Only report records for students who have a Role of Offender.
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.
DeleteWhen all Events and Resolutions that are mapped to a state code are removed from the incident either via the UI or the Delete tool.
Delete

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

Delete

When the linked enrollment is deleted.

Delete/PostIf there is another Ed-Fi reporting enrollment in the district, post a new record with the studentSchoolAssociationReference (SE20) pointing to the next qualifying enrollment.
DeleteWhen the student's enrollment is no longer reportable (marked No Show, State Exclude, WISE Exclude, Parent Placement Pri. School is Yes, or the School Override is set to a different school from the enrollment school). 

Scope Year Logic

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

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

  • If the student has more that one 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

Reports the Ed-Fi value for the Removal Reason on the student's reported resolution. 

The array is only added for resolutions that have a Removal Reason that is mapped to a State Resolution. 

If there are multiple comments in the multiple resolutions for the same student with the same Removal Reason, report only 1 set- from the resolution with the lowest ID.

M

N/A

Behavior Management > Incident > Event > Participant > Resolution > Removal Reason
behaviorDetailed Description

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

  • Report the Firearms Comments from the Behavior resolution.

ON/ABehavior Management > Incident > Event > Participant > Resolution > Details > Firearms Comments
seriousBodilyInjury

seriousBodilyInjury (True or False) should be submitted when discipline code in disciplineActions endpoint is 'IAES removal by School Personnel'. For ALL others Null should be submitted. Please find below additional details
True - Incident resulted in serious bodily injury. Serious Bodily Injury involves a substantial risk of death; extreme physical pain; protracted and obvious disfigurement; or protracted loss or impairment of the function of a bodily member, organ, or faculty (18 USC Section 1365 (3)(h)).
False- Incident did not result in serious bodily injury.
Null - Not required for incident types other than IAES removal by School Personnel.

  1. f the Resolution type is mapped to SP: Placement in IAES - School Personnel
    1. If any participant in the same Event has an Injury that is indicated as 4: Serious Bodily Injury, report TRUE
    2. Otherwise if there are no injuries or no injuries that are Serious Bodily Injury, report FALSE
  2. For Any other Resolution Type, do NOT report.
CN/ABehavior Management > Incident > Event > Participant > Injury

followUp Descriptor

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

  • Report Follow Up from behavior resolution(s).
  • All unique Follow Up codes related to the student should report from the incident resolutions. Resolution must be mapped to an Ed-Fi Code.
ON/AN/A
_etag

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

ON/AN/A

Type/Descriptors

 

The highlighted column indicates the reported value.

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

Campus RoleEd-Fi Short DescriptionEd-Fi Description
OffenderPerpetratorPerpetrator
ParticipantPerpetratorPerpetrator
VictimPerpetratorPerpetrator
WitnessPerpetratorPerpetrator
RecipientPerpetratorPerpetrator

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

IC CodeEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
HG01HandgunAny weapon designed or resdesigned, or made or remade, and intended to be fired while held in one hand and to use the energy of an explosive to expel a projectile through a smooth or rifled bore. s.175.35(1)(b), Wis Stats.
SG02Shotgun or RifleA weapon designed or redesigned, made or remade, and intended to be fired from the shoulder and designed or redesigned and made or remade to use the energy of the explosive in a fixed shotgun shell to fire through a smooth bore either a number of ball shot or a single projectile for each single pull of the trigger. \"Rifle\" means a weapon designed or redesigned, made or remade, and intended to be fired from the shoulder and designed or redesigned and made or remade to use the energy of the explosive in a fixed metallic cartridge to fire only a single projectile through a rifled bore for each single pull of the trigger. USC Title 18, Section 921(a).
OF03Other FirearmOther Firearm
DW04Dangerous Weapon - Not FirearmAny dangerous weapon that is not a firearm. This would include any weapon, device, instrument, or material, or substance, animate or inanimate, that is used for, or is readily capable of causing death or serious bodily injury, except that such a term does NOT include a pocket knife with a blade of less than 2 ½ inches in length (18 U.S.C. Section 930(g)(2)).
AS05AssaultBehavior that causes bodily harm to another person if that behavior was carried out with intent to cause harm, or without the consent of that individual. Assault includes but is not limited to sexual assault of another individual, without that individual's consent. To use this incident type as a reason for removal the behavior must occur while on school grounds or while under the supervision of school authorities.
AE06Endangering BehaviorBehavior causing the threat of or potential for bodily harm to another person, due to circumstances which show utter disregard to the well being of such individuals. To use this incident type as a reason for removal the behavior must occur while on school grounds or while under the supervision of school authorities.
DG07Drug-RelatedRelated to use, possession, sale, or solicitation of drugs identified in 21 USC Section 812(c). These offenses do NOT include use, possession, sale, or solicitation of alcohol or tobacco.
AL08Alcohol-RelatedRelated to alcohol.
SR09Other Violation of School RulesViolation of any other school rules not covered above. This code includes, but is not limited to, tobacco use or possession on school property.



Student Homeless Program Association - EdFi WI

An Ed-Fi Homeless record posts for every Student School Association record that posts for a student that overlaps the dates of the Homeless Program Participation record.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
PostWhen a Homeless record is saved for a student.
Post

When a new Enrollment is created within the duration of the Homeless record.

  • Do not post a record when the Enrollment for the student is marked as No Show, State Exclude, or WISE Exclude.
  • Do not send records if the Calendar Exclude or Summer School Exclude checkbox is marked in the calendar the student is enrolled or the calendar is in a School marked Exclude.
  • Do not send records if the Grade Level Exclude checkbox is marked on the grade the student is enrolled.
  • If there are multiple enrollments with the same start date in the same school, for unique elements report from enrollments as P: Primary first, then N: Special Ed.
  • Exclude Partial (S) Enrollments from triggering a new record and from all calculations.
  • If the Ed-Fi Configuration Profile is Choice + Private Opt In or Ed-Fi Configuration Profile is Choice ONLY, do not report a record.
  • If a Homeless record previously had a Primary Night Time Residence value of '00', and has now been updated to a different value.
PostWhen the start date of a Homeless record is changed.
PostWhen the start date of an enrollment is changed.
Put

When the Homeless record is updated for one of the following fields:

  • Homeless Primary Nighttime Residence Type
  • Homeless Unaccompanied Youth
Delete/PostWhen the enrollment associated with the Homeless record is ended.
DeleteWhen an enrollment is deleted or one of the checkboxes for No Show, State Exclude, or WISE Exclude are marked.
DeleteWhen the start date of a Homeless record is changed
DeleteWhen the start date of an enrollment is changed.
Delete

When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.

  • When a student has two enrollments in the same school for the same start date, record changes with lower priority do not trigger a delete.
DeleteIf a Homeless record's Primary Night Time Residence value is changed to '00: Unknown - do not send record to WISE'.

Scope Year Logic

This table describes scope year logic of this object.

Logic

The record sends to the scope year for the school year in which the enrollment is associated.

  • Data only sends for the years that have valid configuration.
A Homeless record sends in all scope years that are included in the dates for the record, with individual records posting only with dates within the config year.

Object Data Elements

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

Data ElementDescriptionCampus Database FieldCampus GUI Interface
idThe unique identifier of the resource.M

educationOrganizationReference
A reference to the related EducationOrganization resource.
Reports the Ed-Fi District Number (Agency Key) for the enrollment determining the record.  
MDistrict.entityIDSystem Administration > Resources > District Information > Ed-Fi District Number
programReference
A reference to the related Program resource.programReference.
The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.
  • Program reference is always Education for Homeless Children and Youth.
  • Submit SHPA only when the program name is "Education for Homeless Children and Youth"
  • Program Type : Homeless
  • Program Name : Education for Homeless Children and Youth
MN/AN/A
wiDpiSchoolReference

 A reference to the Student School Association Resource.

Reports any enrollment active within the start and end dates of the Homeless record.

School Ed-Fi Number first from the School Override on an Enrollment.

  • If School Override is NULL, reports from the Enrollment school.

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

MN/A

Calculated from:

Student Information > General > Enrollment

and


System Administration > Resources > School > Ed-Fi School Number
studentReference
A reference to the related Student resource.
Reports the studentUniqueId from the Student Resource.
MIdentity.edFiIdCensus > People > Demographics > Ed Fi ID
beginDate
The month, day, and year on which the student is identified as homeless in currently enrolled school or date student enrolls in new school with an identified homeless status. The beginDate should be within the school year.

For the relevant Homeless record, if the Homeless record starts within the config year, report the Homeless record start date.

If the Homeless record starts before the enrollment associated with the record, report the enrollment start date.

If additional enrollments are created after the Homeless record start date, report the enrollment start date on each associated record.

M homeless.startDate

Student Information > Program Participation > Homeless > Start Date

Student Information > General > Enrollment > Start Date

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services. The end Date should be within the school year.

Reports the earliest of:

  1. The end date of the associated enrollment
  2. The end date of the Homeless record.
  3. Otherwise, if the record does not have an end date, reports 6/30/xxxx where xxxx is the end year of the config year to which the record is posting.
C homeless.endDateStudent Information > Program Participation > Homeless > End Date
Homeless Primary Nighttime Residence Type

Identifies homeless children and youth as individuals who lack a fixed, regular and adequate nighttime residence. The type of primary night time residence for homeless students are shelters and transitional housing, doubled up, hotel/motels, and Unsheltered.

Reports the Ed-Fi code for the Homeless Primary Nighttime residence.

If blank or not mapped to an Ed-fF value, does not report.

Mhomeless. primaryNightTimeResidenceStudent Information > Program Participation > Homeless > Primary Night Time Residence
Homeless Unaccompanied Youth

Homeless children or youth not in physical custody of a parent or guardian.

If Unaccompanied Youth = Yes on the Homeless record, reports TRUE.

Otherwise, reports FALSE.

Mhomeless. unaccompaniedYouthStudent Information > Program Participation > Homeless > Unaccompanied Youth

Student Program Association

This association represents the Program(s) that a student participates in or is served by.

A student may have multiple records; one for each program they participate in.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

A record reports based on the student enrollment:

  • If the Ed-Fi Configuration Profile is Choice + Private Opt In or Choice Only, records are not sent.
  • Data reports from any enrollment determining record. If the student has multiple qualifying enrollments in the same school, a record reports for each unique start date.
  • A record is not sent for enrollments marked as State Exclude or No Show, or WISE Exclude.
  • A record is not sent for enrollments in a calendar marked as State Exclude or Summer School.
  • A record is not sent for enrollments in a School marked as Exclude or where the Entity ID is NULL.
  • A record is not sent for enrollments with an enrollment service type of Partial (S).
PostA record reports if a student has an enrollment where the Coord. Early Intervention = Y: Yes.
PostA record reports if a student has an enrollment where a third party Service Provider is NOT NULL or NONE: None.
PostWhen a Section 504 record is created.
Post

When an EL record is created or changed.

  • A record is not sent for an EL Program Status of Pending or Not EL.
  • The ELL Served on the EL Record must be S: Served - No T3 or T: T3 Service
PutWhen an End Date is entered or changed for an existing record.
PutWhen an EL Program Status is changed to Exited EL.
PutWhen a Section 504 record is updated with a change in end date.
Delete

When an enrollment change is made or saved.

  • When a Coord. Early Intervention is set to N: No or Null
  • When a third party Service Provider is changed.
  • If set to None or Null
  • If changed from CESA: Cooperative Education Service Agency to another value
  • When the enrollment is marked as State Exlcude or No Show or WISE Exclude.
  • When the enrollment determining the record is deleted.
  • When the service type for the enrollment determining the record is changes to Partial (S).
Post/DeleteWhen a School Override is set on Enrollment.
DeleteWhen a start date changes.
DeleteWhen a Section 504 record is deleted or start date is changed.
DeleteWhen an EL record is deleted or EL Program Status is changed to Pending or Not EL.

Scope Year Logic

This table describes scope year logic of this object.

Logic

A record reports when an enrollment is created and saved that is aligned to a scoped year and the student has a qualifying enrollment or EL record.

  • The enrollment must overlap with the scope year to report.
  • Data only sends for the years that have valid configuration.

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

  • Current Year: Records are 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 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 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.

When using data in Campus that have start and end dates, the following logic applies  to deermine the scope year(s) to which report the data:

  • Current Year: The record's start date must be on or before today's date and the record's end date must be on or after today's date.
  • For an EL program, if the record is Exited and the end date is prior to the calendar start date, no record is reported.
  • 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

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

Data ElementDescriptionCampus Database FieldCampus GUI Interface
idThe unique identifier of the resource.M

educationOrganizationReference
A reference to the related EducationOrganization resource.
Reports the Ed-Fi District Number (Agency Key) for the enrollment determining the record.  
MDistrict.entityIDSystem Administration > Resources > District Information > Ed-Fi District Number
programReference
A reference to the related Program resource.programReference.
The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.
  • Reports 48856 for educationOrganizationId for all programs.
  • If the trigger posting the record is for an EL record, reports Cocurricular Programs" for program type.
  • Reports ELL Served for program name.
  • If the trigger posting the record is for a Section 504 record:
    • Reports Section 504 placement for the program type
    • Reports Section 504 Placement for program name
  • If the trigger posting the record is for based on enrollment:
    • If Coord. Early Intervention = Y: Yes
      • Reports Cocurricular Programs for program type
      • Reports Coordinated Early Intervening Services for program name
    • If 3rd party Service Provider = CESA: Cooperative Educational Service Agency
      • Reports Regular Education for program type
      • Reports Third Party - CESA for program name
    • Otherwise if 3rd party Service Provider is NOT NULL
      • Reports Regular Education for program type
      • Reports Third Party - Other for program name
MN/A

Student Information > Special Ed > General > Documents > IEP > Enrollment Editor

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

Student Information > Program Participation > English Learners (EL) > EL > ELL Served

Student Information > General > Enrollment > Coord. Early Intervention

Student Information > General > Enrollment > 3rd party Service Provider

Student Information > Program Participation > Section 504

wiDpiSchoolReference

Schoolid to match it up to the enrollment that the Program record is associated with. A reference to the Student School Association Resource.

Reports from the enrollment active on the beginDate of the Program record.

  • Reports first from the School Override.
  • Otherwise report from the Enrollment School.

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

CN/AN/A
studentReference
A reference to the related Student resource.
Reports the studentUniqueId from the Student Resource.
MIdentity.edFiIdCensus > People > Demographics > Ed Fi ID
beginDate
A reference to the related Student resource.
  • If the record is for the EL program, report the Identified Date from the EL record determining the record if it is within the config year (7/1/xx - 6-30/xx).
    a. Otherwise, if the EL Identified date is in a previous year, report the start date from the earliest enrollment that sends a Student School Association record.
  • If the record is for the Coordinated Early Intervening Services program, reports the start date of the enrollment determining the record.
  • If the record is for the Third Party - CESA program, reports the start date of the enrollment determining the record.
  • If the record is for the Third Party - Other program, reports the start date of the enrollment determining the record.
  • If the record is for the Section 504 program, report the latest of the Section 504 Start Date or the Enrollment Start Date.
M

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

Student Information > General > Enrollment > Start Date

Student Information > Program Participation > Section 504

endDate

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

If the record is for the ELL program, report the Program Exit Date from the EL record determining the record. If no exit date exists, report blank.

If the record is for a Section 504 program, report the earliest of the Section 504 End Date or the Enrollment End Date. If no exit date exists, reports blank.

If the record is triggered from an enrollment for the following programs:

  •  Coordinated Early Intervening Services program
  • Third Party - CESA program
  •  Third Party - Other program

Then, report the end date of the enrollment determining the record: 

  • If no end date exists, reports blank. 
  • If the program is marked on multiple enrollments with the same start date, populate end date only if all enrollments are ended, use the latest enrollment end date.
C

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

Student Information > General > Enrollment > End Date

Student Information > Program Participation > Section 504


Student School Association

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student or the No Show, State Exclude, or WISE Exclude checkbox is unchecked.

  • Do not post a record when the No Show, State Exclude or WISE Exclude checkbox is checked before initial save.
  • When a student has two enrollments in the same school for the same start date, reports from the enrollment service type in the following order:
    • P: Primary Enrollment
    • N: Special Ed Services
  • When a student has two enrollments in the same school for the same start date, S: Partial/Ancillary enrollments are excluded.
  • When an enrollment with a higher priority is deleted, the enrollment with the lower priority posts a new record.
  • Records are not sent if the Calendar Exclude or Summer School Exclude checkbox is marked in the calendar in which the student is enrolled or if the calendar is in a School marked Exclude.
  • If the Ed-Fi Configuration Profile is Choice + Opt In, a record reports for all eligible students if Choice is Yes or No on the student's enrollment.
  • If the Ed-Fi Configuration Profile is Choice AND Choice is No on the student's enrollment, a record is not reported.
Post

When an enrollment record Start Date is modified.

When an enrollment with a lower priority is changed, data is not sent.

PutWhen an enrollment is updated for a student.
Delete

When an enrollment is deleted or the No Show, State Exclude, or WISE Exclude checkbox is checked on an existing enrollment.

When a student has two enrollments in the same school for the same start date, records with lower priority do not trigger a delete.

DeleteWhen the start date of an enrollment is changed.
Delete

When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.

When a student has two enrollments in the same school for the same start date, record changes with lower priority will not trigger a delete.

Scope Year Logic

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

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

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

A reference to the related GraduationPlan resource.

 

This is optional and does not report.

ON/AN/A
schoolReference

Information reports the School Ed-Fi Number from the School Override field on the enrollment record. If School Override is null, this reports from the Enrollment School. 

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

  • schoolReference
  • studentReference
  • entryDate
MN/A

Student Information > General > Enrollments > State Reporting Fields > School Override

Student Information > General > Enrollments > General Enrollment Fields > Calendar

System Administration > Resources > School > Entity ID

classOfSchool
YearTypeReference

The year the student is expected to graduate.

 

This is optional and does not report.

ON/AN/A
schoolYearType
Reference

The school year the student is being reported in.

 

This is optional and does not report.

ON/AN/A
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.MEnrollment. gradeStudent Information > General > Enrollments > Grade
entryGradeLevel
ReasonType

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

 

This is optional and does not report.

ON/AN/A
entryTypeDescriptor

Reports the enrollment entry status for a student. The Ed-Fi code value from the Start Status selected in the enrollment reports. If blank, data does not report. See the Type/Descriptor section below.

OEnrollment.
startStatus
Student Information > General > Enrollments > Start Status
repeatGradeIndicator

An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.

  • This field does not report for students enrolled in a school with an Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. 
  • If students are enrolled in a school with an Ed-Fi Reporting Option of Public:
    • Reports TRUE if the End Action = Retain on the enrollment determining the reporting.
    • Otherwise, reports FALSE.
CEnrollment.endActionStudent Information > General > Enrollments > End Action
schoolChoiceTransfer

An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116.

 

This is optional and does not report.

ON/AN/A
exitWithdrawDateThe month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.
OEnrollment. endDateStudent Information > General > Enrollments > End Date
exitWithdrawType
Descriptor

Reports the enrollment exit status for the student. Reports the Ed-Fi Code Value from the End Status selected in the enrollment record. If blank, data does not report. See the Type/Descriptor section below.

OEnrollment. endStatusStudent Informaton > General > Enrollments > End Status
residencyStatus
Descriptor

Defines the indications of the location of a person's legal residence relative to (within or outside of) the boundaries of the public school attendance and its administrative unit. 

If a Choice Student (Yes is selected on the Enrollment Record), data does not report. 

If a non-Choice Student (No is selected on the Enrollment Record), data does not report at this time (requirements have not yet been written for this item).

OEnrollment. stateAidStudent Information > General > Enrollments > Choice Student
primarySchool

Indicates 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 for all records.

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

 

The highlighted column indicates the reported value.

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

Campus CodeCampus NameEd-Fi Code ValueEd- Fi Short DescriptionEd-Fi Description
00Last year, public school, same district02Re-entryRe-entry
01Las year, WI nonpublic school01TransferTransfer
02Last year, another state01TransferTransfer
03Last year, another country01TransferTransfer
04Last year, WI public school, other district01TransferTransfer
05Age 5 or younger as of 9/1, never before in school04New to education systemNew to education system
06Age 6 or older as if 9/1, never before in school04New to education systemNew to education system
07Last enrolled before last year03Next year school Next year school
11Midyear transfer form WI nonpublic school01TransferTransfer
12Midyear transfer from other state01TransferTransfer
13Midyear transfer from other country01TransferTransfer
14Midyear transfer from other WI school district01TransferTransfer
21Midyear transfer from school in this district01TransferTransfer
22Midyear grade level change05OtherOther
23Midyear change in district of resident05OtherOther
24Midyear re-enrollment after drop02Re-entryRe-entry

This table describes the Ed-Fi Value mapped and reported for Exit Withdraw:

Campus CodeCampus DescriptionEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
BCABelow Compulsory AgeBCABelow Compulsory AgeBelow Compulsory Age
INMInternational move, not known to be continuingINMInternational moveInternational move. Not known to be continuing.
ISMInterstate move, not known to be continuingISMInterstate move. Move to another state within the country.Interstate move. Move to another state within the country. Not known to be continuing.
PCCPrior Completion CredentialPCCPrior Completion CredentialPrior Completion Credential
CCSContinuing in Current SchoolTCContinuing in Current SchoolContinuing in Current School
TCTransfer to another WI school covered by WSLSTCTransfer to Another WI SchoolTransfer to Another WI School. Known to be continuing.
TNCTransfer to a WI school not covered by WSLSTNCTransfer to a school not covered by WSLSTransfer to a school not covered by WSLS. Known to be continuing.
TOSTransfer out-of-stateTOSTransfer out-of-stateTransfer out-of-state. Known to be continuing.
ETCExpected transfer/promotion to school covered by WSLSETCExpected transfer to another school covered by WSLSExpected Transfer to Another School Covered WSLS; Not known to be continuing.
HSCHigh school completionHSCHigh School CompletionHigh School Completion
DEDeathDEDeathDeath
MAMaximum AgeMAReached Maximum Age for ServicesReached Maximum Age for Services
ODOOther dropout or possible dropoutODOOther dropout or possible dropoutOther dropout or possible dropout

This table describes the Ed-Fi Value mapped and reported for Residency Status:

Ed-Fi Code ValueEd-Fi Short Description Ed-Fi Description
01Resident of administrative unit and usual school attendance areaResident of administrative unit and usual school attendance area
02Resident of administrative unit, but of other school attendance areaResident of administrative unit, but of other school attendance area
03Resident of an administrative unit that crosses state boundariesResident of an administrative unit that crosses state boundaries
04Resident of another stateResident of another state
05Resident of this state, but not of this administrative unitResident of this state, but not of this administrative unit

Student School Association Wisconsin Extension

This association represents the school in which a student is enrolled. 

 

Additional logic is associated with this resource. See the Ed-Fi District and School Agency Codes and Keys article for more information.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a new enrollment is saved for a student or the No Show, State Exclude, or WISE Exlcude checkbox is unchecked.

  • Do not post a record when the No Show, State Exclude, or WISE Exlcude checkbox is checked before initial save.
  • Do not send records if the Calendar Exclude or Summer School Exclude checkbox is marked in the calendar in which the student is enrolled or the calendar is in a School marked Exclude. 
  • Do not send records if the Grade Level Exclude checkbox is marked on the grade in which the student is enrolled. 
  •  When a student has two enrollments in the same school for the same start date, reports from the enrollment service type in the following order:
    • P: Primary Enrollment
    • N: Special Ed Services
  • When a student has two enrollments in the same school for the same start date, S: Partial/Ancillary enrollments are excluded.
  • When an enrollment with a higher priority is deleted, the enrollment with the lower priority posts a new record.
  • If the Ed-Fi Configuration Profile is Choice + Opt In, a record reports for all eligible students if Choice is Yes or No on the student's enrollment
  • If the Ed-Fi Configuration Profile is Choice AND Choice is No on the student's enrollment, a record is not reported. 
Post

When an enrollment record Start Date is modified.

PutWhen an IEP or ISP is locked or unlocked.
PutWhen an enrollment is updated for a student.
Delete

When an enrollment is deleted or the No Show, State Exclude, or WISE checkbox is checked on an existing enrollment.

DeleteWhen the start date of an enrollment is changed.
Delete

 When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.

When a student has two enrollments in the same school for the same start date, record changes with lower priority do not trigger a delete.

Scope Year Logic

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

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
expectedTransfer EducationOrganization Reference

A reference to the related EducationOrganization resource. If the Transfer District field is not null on the most recent enrollment in the school, the code value of the Transfer District reports.

Otherwise, reports blank.

OEnrollmentWI. transferDistrictStudent Information > General > Enrollment > State Reporting Fields > Transfer District
expectedTransfer SchoolReference

A reference to the related School resource. If the Ed-Fi Transfer School ID is not null on the most recent enrollment in the school, that value reports.

See the Additional Logic and Considerations section for more information.

OEnrollmentWI. edfi TransferSchoolStudent Information > General > Enrollment > State Reporting Fields > Ed-Fi Transfer School ID
schoolID

Information reports the School Ed-Fi Number from the School Override field on the enrollment record. If School Override is null, this reports from the Enrollment School. 

Reports the school Ed-Fi School Number.

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

  • schoolReference
  • studentReference
  • entryDate




M

N/A

Student Information > General > Enrollments > State Reporting Fields > School Override

Student Information > General > Enrollments > General Enrollment Fields > Calendar

System Administration > Resources > School > Entity ID

studentUniqueIDReports the student's Ed-Fi ID.MIdentity.edFiIDCensus > People > Identities > Ed-Fi ID
entryDateThe month, day, and year on which an individual enters and begins to receive instructional services in a campus. MEnrollment. startDateStudent Information > General > Enrollments > General Enrollment Information > Start Date
completedSchoolTerm

Indicates whether a student completed the school term during the school enrollment period. It is collected for every student enrollment record and is not related to graduation. A student could have more than one enrollment record for a school year.

For the enrollment that determines the entry date:

  • Report first the value in the Completed Term Override field on the Enrollments tab.
  • If the Completed Term Override field is null, then calculate the value.
  • If the enrollment is ended prior to the last day of the school year and the enrollment end status is HSC: High School Completed, TRUE reports.
  • If the enrollment is ended prior to the last day of the school year and the enrollment end status is any other end status, FALSE reports.
  • If the enrollment end date is equal to the last day of the school year, TRUE reports.
  • If the enrollment end date is blank or after the last day of the school year, TRUE reports.
OEnrollment. endDateStudent Information > General > Enrollments > General Enrollment Information > End Date
actualDaysAttendance

Aggregate value that captures the actual days in attendance for a student.

  1. This element reports for only one active record per school based on the highest order or enrollments.
    a. All other records report blank.
    b. If there are multiple enrollments and the determining enrollment is ended, the next most recent record (by start date) reports.

  2. An aggregate reports from all enrollments in the school that have the same start date.

  3. Report first from the Attendance Override field on the Enrollments tab if entered on any of the enrollments fitting the requirements in 1. and 1.b.

  4. Otherwise if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation.

  5. This reports using a calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade:
    a. If a student's enrollment determining the record has a grade level where the Standard Day is .5, the student is considered a Partially Scheduled student and the Partially Scheduled Student's calculation is used to determine their attendance (see below).
    b. If the Grade Level does not have Standard day = 0.5, determine which calculation to use based on the student's Percent Enrolled.

  6. This reports using a calculation based on the student's Percent Enrolled:
    a.  If a student's enrollment determining the record has a Percent Enrolled of 51-100 or NULL, the student is considered a Full Schedule Student.b.  If a student's enrollment determining the record has a Percent Enrolled of 50 or less, the student is considered a Partially Scheduled Student.

  7. Full Schedule Students Calculation
    For each instructional, attendance, school date where the student has a schedule, attendance is determined as follows:

    • If the student has no attendance marks, add 1 to the actual days of attendance for that date.
    • If the student has attendance marked of Absent Excused or Absent Unexcused, the total number of scheduled minutes t and the total minutes present for the student on that day is calculated:
      • If the student's present minutes are 66% or more of the calculated minutes schedyukled, add 1 to the actual days of attendance for that date.
      • If the student's present minutes are 33% or more but less than 66% time present, add a half day (0.5) to the actual days of attendance for that date).
      • If the student's present minutes are less than 33% time present, no days are added to the actual days of attendance for that date.

  8. Partially Scheduled Students Calculation

    For each instructional, attendance, school date where the student has a schedule, the student's attendance is determined:

    • If the student has no attendance marks, add 0.5 to actual days of attendance for that date.
    • If the student has attendance marks of Absent Excused or Absent Unexcused but is present 1 or more minutes, add 0.5 to actual days of attendance for that date.
    • If the student has attendance marks of Absent Excused or Absent Unexcused for the entire day with 0 minutes present, do not add any days (0) to the actual days of attendance for that date.

  9. The total of all actual days of attendance from the beginning of the enrollment to the current date reports.

OCalculated Value

Student Information > General > Enrollment > Attendance Override

OR Calculated from:

System Administration > Calendar > Calendar > Grade Level > Standard Day

System Administration > Calendar > Calendar > Days

System Administration > Calendar > Calendar > Periods

Student Information > General > Schedule

Student Information > General > Attendance

possibleDaysAttendance

Aggregate value that captures the possible days in attendance for a student.

  1. This element reports for only one active record per school based on the highest order or enrollments.
    a.  All other records report blank.
    b.  If there are multiple enrollments and the determining enrollment is ended, the next most recent record (by start date) reports.

  2. An aggregate reports from all enrollments in the school that have the same start date.

  3. Report first from the Membership Override field on the Enrollments tab if entered on any of the enrollments fitting the requirements in 1. and 1.b.

  4. Otherwise if Membership Override is NULL/ blank on all reporting Enrollments, continue on to the calculation.

  5. This reports using a calculation based on the Grade Level, Standard Day setting for the reporting enrollment's grade:
    a.  If a student's enrollment determining the record has a grade level where the Standard Day is .5, the student is considered a Partially Scheduled student and the Partially Scheduled Student's calculation is used to determine their attendance (see below).
    b.  If the Grade Level does not have a Standard day that is 0.5, determine which calculation to use based on the student's Percent Enrolled.

  6. This reports using a calculation based on the student's Percent Enrolled:
    a.  If a student's enrollment determining the record has a Percent Enrolled of 51-100 or NULL, the student is considered a Full Schedule Student.
    b.  If a student's enrollment determining the record has a Percent Enrolled of 50 or less, the student is considered a Partially Scheduled Student.

  7. Full Schedule Students Calculation

    For each enrollment included in the record, the calculation calculates from the enrollment start date to the current date all of the unique days of enrollment in each calendar for the days marked as Instruction, School, and Attendance.

    • If the student is not scheduled on that date, no possible days of attendance are added for that date.
    • If the student is scheduled into attendance taking course,s add 1 to the possible days of attendance.

  8. Partially Scheduled Students Calculation

    For each instructional, attendance, school date where the student has a schedule, the student's attendance is determined:

    • If the student is not scheduled on that date, possible days of attendance are not added for that date.
    • If the student is scheduled into attendance-taking courses, 0.5 is added to the possible days of attendance.

  9. The total of all possible days of attendance from the beginning of the enrollment to the current date reports.
OCalculated Value

Student Information > General > Enrollment > Membership Override

OR Calculated from:

Student Information > General > Schedule

System Administration > Calendar > Calendar > Grade Level > Standard Day

System Administration > Calendar > Calendar > Days

System Administration > Calendar > Calendar > Periods

privateSchoolChoice ProgramParticipant

Indicates whether a student is a Choice Student.

Reports from the enrollment generating the record if the enrollment generating reocrd is in a school where the Ed-Fi School Population is marked as Choice or Choice + Private Opt In.

If Choice Student = YES, reports TRUE; otherwise, reports FALSE.

OEnrollmentWI. choiceStudentStudent Information > General > Enrollments > State Reporting Fields > Choice Student
receivingServices

An unordered collection of student School Association Wisconsin Ext Receiving Services.

This element is an array that reports the following data:

ON/AN/A
countDateNameType

If the date is on or after the third Friday in September, the Ed-Fi value from the Count Date Name Type for Third Friday in September is added to the array if the student meets the following criteria:

  • The enrollment determining the record is in a calendar in a school where Ed-Fi School Population is Public and the student's enrollment is active on the third Friday in September (not just the effective date for determining attendance, the physical #3 Friday in September on the real calendar), and the student enrollment corresponding to the record has Parent Placement Pri. School set to No or is blank/null, 
    OR
  • The enrollment determining the record is in a calendar in a school where Ed-Fi School Population is Choice or Choice + Private Opt In, and the student's enrollment is active on the third Friday in September (not just the effective date for determining attendance, the physical #3 Friday in September on the real calendar).
  • Otherwise, values are not added to the array.

If the date is on or after October 1, the Ed-Fi value is added from the Count Date Name Type for the October First is added to the array if the student meets the following criteria:

  • The enrollment determining record is in a calendar in a school where Ed-Fi School Population is Public
  • The student's enrollment is active on October 1 (10/01/XX)
  • Otherwise, values are not added to the array.

See the Type/Descriptor section below.

ON/AN/A
countDateReceiving ServiceType

Reports only for the record report attendance in actualDaysAttendance and possibleDaysAttendance.

If the date is on or after the third Friday in September:

  • If is an instructional, school and attendance day, that date is used for the calculation.
  • Otherwise, the closest instructional, school and attendance day PRIOR to the third Friday in September is used for the calculation.

See the Type/Descriptor section below.

The student's attendance is determined for that date:

  • If the student is not enrolled on that date, the array is not added.
  • If the enrollment determining the record is in a calendar in a school where Ed-Fi School Population is Public and the student's enrollment sending the record is marked Parent Placed Private is Yes, the array is not added.
  • Reports first from the 3rd Friday Count Date Overrde field. If this field is not null, the Ed-Fi value for the value saved in the field is added to the array.
  • If the student does not have a schedule in the enrollment calendar or their schedule was ended prior to the count date in all calendars, report 'N' and add the value for count Date Receiving Service Type to the array.
  • If the student has a schedule in the calendar, but their schedule does not meet on the count date, the closest instructional, school attendance day prior to the count date where the student's schedule meets is used.
  • If the student has a schedule and has no attendance marks, report 'P' and add the value for count Date Receiving Service Type to the array.
  • If the student has a schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student.
    • If the student is present 33% of their schedule minutes or more minutes present, add 'P' and add the value for count Date Receiving Service Type to the array.
    • Otherwise, if the student has less than 33% of their schedule minutes present but at least 1 minute of attendance on the count date, report 'A' and add the value for count Date Receiving Service Type to the array.
  • If the student has a partial schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student).
    • If the student is present one or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
  • If the student is absent with zero minutes present on the count date, check the student's previous attendance in the current calender:
    • If the student has zero minutes of present attendance on all prior days in the calendar, report 'N' and add the value to the array.
    • If the current date is the count date and the student has at least one minute of present attendance on any date prior to the count date, report 'N' and add the value to the array.
    • If the current date is after the count date, the student has at least one minute of present attendance on any date prior to the count date and the student has at least at least one minute of present attendance on any date after the count date, report 'A' and add the value to the array.

If the date is on after October 1st:

  • If October 1 is an Instructional school attendance date, use that date for the calculation. Otherwise, use the closest Instructional school attendance day PRIOR to 10/1 for the attendance calculation only.

The student's attendance is determined for that date:

  • If the enrollment determining the record is in a calendar in a school where the Ed-Fi School Population is marked Choice or Choice + Private Opt In, a value is not added to the array.
  • If the student does not have a locked IEP or ISP that overlaps the enrollment reporting, or if the locked plan has a Sepcial Ed Status of No, the value is not added to the array.
  • If the Student has a locked IEP that overlaps Oct 1 but has a SPED exit date before Oct 1, the value is not added to the array.
  • If the student is not enrolled on Oct. 1, a value is not added to the array.
  • Reports first from the Oct. 1 Count Date Override field. If this field is not null, the Ed-Fi value for the value saved in the field is added to the array.
  • If the Oct. 1 Count Date Override field is blank, determine if the student is Parentally Placed Private. If the student's enrollment sending record is marked Parent Placed Private = Yes, reports a value of P and is added to the array.
  • Otherwise, the student's schedule is used to determine the value to report.
  • If the student does not have a schedule in the enrollment calendar, their schedule was ended prior to the count date in all calendars, or their schedule starts after the Count Date, report 'N' and the value for count Date Receiving Service Type is added to the array
  • If the student has a schedule in the calendar, but their schedule does not meet on the count date, the closest Instructional, School, Attendance day PRIOR to the count date where the student’s schedule meets is used.    
  • If the student has a schedule and has no attendance marks, reports 'P' and the value for count Date Receiving Service Type to the array reports.
  • If the student has a regular schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student. If a student's enrollment determining the record has Percent Enrolled of 51 -100, or NULL the student is considered a Full Schedule student.
    • If the student is present 33% of their schedule minutes or more minutes, report 'P' and add the value for count Date Receiving Service Type is added to the array.
    • Otherwise, if the student has less than 33% minutes present but at least one minute of attendance on the count date, report 'A' and add the value for count Date Receiving Service Type is added to the array  
  • If the student has a partial schedule and has attendance marks of Absent Excused or Absent Unexcused, calculate the total number of minutes present for the student (If a student's enrollment determining the record has Percent Enrolled of 50 or less the student is considered a Partially Scheduled student).
    • If the student is present one or more minutes, add 'P' and add the value for count Date Receiving Service Type to the array.
    • Otherwise, add 'A' and add the value for count Date Receiving Service Type to the array.
  • If the student is absent with zero minutes present on the count date, check the student's previous attendance in the current calender:
    • If the student has zero minutes of present attendance on all prior days in the calendar, report 'N' and add the value to the array.
    • If the current date is the count date and the student has at least one minute of present attendance on any date prior to the count date, report 'N' and add the value to the array.
    • If the current date is after the count date, the student has at least one minute of present attendance on any date prior to the count date and the student has at least at least one minute of present attendance on any date after the count date, report 'A' and add the value to the array.
ON/AN/A
etagA unique system-generated value that identifies the version of the resource. ON/AN/A

Type/Description Layout

 

The highlighted column indicates the reported value.

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

Ed-Fi Code ValueEd- Fi Short DescriptionEd-Fi Description
3FS3rd Friday of September3rd Fri Sept
O1October 1stOct 1st

This table describes the Ed-Fi Value mapped and reported for Count Date Receiving Services:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
PPresent, receiving services on the count datePresent
AAbsent, receiving services on the count dateAbsent
NNot receiving servicesNot Receiving Services

 


Student Section Association

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a student is scheduled into a course section.

  • A record reports for each Section record that is reported based on the Sections logic.
  • 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 scheduled and is not marked as No Show, State Exclude, WISE Exclude or the School Override is set to a different school from the enrollment school.
  • Only send records if the student's enrollment associatated with the roster is one of the following service types: Primary (P), Special Ed (N)
  • Do not send records if the Calendar Exclude checkbox is marked.
  • Do not send records if the School Exclude checkbox is marked.
  • Do  not send records if the Course is marked as Inactive or Exclude.
  • Do not send records if the Calendar is marked as Summary School.
PostSend a new record if a student's roster start date is changed.
Post

Send a new record if a new student enrollment is created.

  • A new record is created with a new StudentSchoolAssociation Reference only if the new enrollment dates are not contained in the prevous enrollment.
Put

When section information is updated for a student or section.

  • Update when the course or section's homeroom field is changed.
DeleteWhen a student is deleted from a course section.
Delete

Delete any future records if the student is given a roster end date for the course.

Roster End Date must be before the Term Start date of future records.

DeleteDelete the record if a student's roster start date is changed.
DeleteDelete the record if the student's enrollment is no longer reportable, marked as No Show, State Exclude, WISE Exclude or the School Override is set to a different school from the enrollment school.

Scope Year Logic

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 reduces the number of records sent until the final schedule is completed.
  • A resync must be done after the Active Year is changed to send data.

Object Data Elements

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

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

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

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

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

  • studentUniqueId
MN/AN/A
beginDate

Month, day and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period. Logic reports based on the following:

  • Reports the latest date from the following: 
    • The enrollment start date from the associated enrollment reported in the studentSchoolAssociationReference.
    • The roster start date for the term record in which the start date occurs.
    • The term start date,
    • 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 section schedule placement.
M

Enrollment.startDate

Terms.startDate

Roster.startDate

Student Information > General > Enrollments > Start Date

OR

System Administration > Calendar > Calendar > Terms

OR

Student Information > General > Schedule > Roster Start Date

endDate

Month, day, and year of the withdrawal or exit of the student from the section. Logic reports based on the following:

  • Report the roster end date for the student.
    • If a roster end date is entered, delete any records for future terms for that section.
  • If NULL, report the latest term start date associated with the term descriptor selected for this section based on the section schedule placement.
O

Roster.endDate

Terms.endDate

Student Information > General > Schedule > Roster End Date

OR

System Administration > Calendar > Calendar > Terms

homeroomIndicator

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

 

This element is currently not reported or collected.


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

A reference to the related studentSectionAssociation resource.

  • studentUniqueID
  • SchoolID
  • entryDate
MN/AN/A
etagA unique system-generated value that identifies the version of the resource. ON/AN/A

Student Special Education Program Association

This resource reports the Special Education data for a student.

Object Triggering Data

ActionTrigger
Post

When an IEP is created and locked.

  • The IEP must overlap the enrollment.
  • A record reports based on the student's enrollment type. If the student has multiple enrollments in the same district, and they overlap in any way, information reports based on the Enrollment Service Type:
    • P: Primary
    • N: Special Ed
  •  If the student only has one enrollment, a record reports for either Primary or Special Ed enrollment. Records do not report if only a Partial (S) enrollment exists.
  • If the Ed-Fi Configuration Profile is Choice or Choice + Private Opt In, a record is not sent.
  • A record is not sent for an enrollment that is marked as State Exclude, No Show, or WISE Exclude.
  • If a higher ordered enrollment is excluded, information reports from the next in order of Service Type.
  • A record is not sent if the enrollment is in a calendar marked as State Exclude or Summer School or if the calendar is in a School marked Exclude.
  • A record is not sent if the Special Ed Status is No in the IEP.
  • A record posts for each unique, locked IEP with all data fields reporting from the same IEP.
  • Do not send a record if the student is under 3 years old until their 3rd birth date has passed.
  • Do not send additional records after the SSEPA is ended by a SPED Exit Date. The Sped Exit Date must be within the IEP start and end dates to suppress further records driven around that IEP.
Post

When a new enrollment record is created based on the following:

  • When an IEP overlaps multiple school years, a new SSEPA record should be created in the second year with the Begin Date being the enrollment start date.
  • When the enrollment sending the record is ended and a new enrollment is added and the same IEP is being used, the student received a new record with the begin date being the enrollment start date.
  • When Multiple IEPs overlap school years, only one record reports with a unique set of primary keys and all fields are populated from the most recent IEP by start date.
Post

A new SSEPA record has to be submitted when an IEP is amended based on any of the following fields:

  1. beginDate (DE60)
  2. endDate (DE70)
  3. iepBeginDate (DE90)
  4. iepEndDate (DE100)
  5. specialEducationSettingDescriptor (DE110)
  6. wiDpiStudentSpecialEducationProgramAssociationDisabilities (DE120)
  7. wiDpiParentPlacedPrivate (DE130)

The start date of the new record will be the start date from when the IEP was amended.

PostUpdate the wiDpiFapeResponsibleSchoolReference (DE50) if FAPE Responsible field on the enrollment associated with the SSEPA is changed and saved.
PutSend an end date when the student receives a SPED exit date on enrollment.
Post/PutA new SSEPA record is submitted when a new Special Education Setting record is created within the dates of the locked IEP. The existing record is updated with a new endDate (DE70).
Post/DeleteWhen an IEP is edited and relocked with a change to any of the fields not part of the natural key.
Post/DeleteWhen a School Override is set on Enrollment.
Post/DeleteWhen an IEP or Enrollment Start Date are changed that resulted in the posting of a new record.
DeleteWhen an IEP is deleted for a student.
DeleteWhen an IEP is edited and relocked where Special Ed status is set to No.
DeleteWhen an enrollment is deleted that triggered a SSEPA record or the enrollment is marked State Exclude, No Show, or WISE Exclude.
DeleteIf the IEP Start or End Dates or the enrollment start or end dates have been updated so the IEP and Enrollment no longer overlaps, the record is deleted if one was created.
Delete

When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.

When a student has two enrollments in the same school for the same start date, record changes with lower priority do not trigger a delete.

Scope Year Logic

This table describes the scope year logic of this object.

Logic

When a new IEP is created, the record reports in the Scope Year with the overlapping IEP Start Date.

The begin date must be on or after the School Year Start Date AND on or before the School Year End Date. If School Year End Date is NULL, 6/30/XXXX is used as the default date.

When the record is triggered from enrollments, the record sends to the scope year for the school year the enrollment is associated.

Data is only sent for the years that have a valid configuration.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi

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

A reference to the related EducationOrganization resource.,The education organization where the student is participating in or receiving the program services.

Reports the Ed-Fi District Number (agency key) for the enrollment determining the record.

 
MDistrict.entityIDSystem Administration > Resources > District Information> Ed-Fi District Number
programReference

A reference to the related Program resource.

  • Reports 48856 for educationOrganizationId
  • Report Special Education for type
  • Report Special Education for name
 
MN/AN/A
studentReferenceA unique alpha-numeric code assigned to a student. Reports the student's Ed-Fi ID.MIdentity.edFiIdCensus > People > Demographics > Ed Fi ID
wiDpiSchoolReference

A reference to the Student School Association Resource.

This reports from the enrollment active on the beginDate of the SSEPA record

Reports the School Ed-Fi Number first from the School Override on Enrollment. If School Override is NULL, report from the Enrollment school.

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

CN/AN/A
wiDpiFapeResponsibleSchoolReference

A reference to the related School resource. School in LEA Responsible for FAPE is a school level Agency Key. School which holds FAPE Accountability per the IEP or the ISP.

  • If FAPE Responsible School is populated in the Enrollment corresponding to the loicked IEP or ISP,  reports the Ed-Fi Value.
  • Otherwise, if FAPE Responsible School is blank, reports the Ed-Fi Agency key for the school tied to the enrollment that corresponds to the SSEPA record.
 M

EnrollmentWI.FAPESchool

School.entityId

Student Information > General > Enrollments > State Reporting Fields > FAPE Responsible School

System Administration > Resources > School > Entity ID

beginDateThe month, day, and year on which the Student first received services. Reports the latest of:
  • The IEP start date from the locked IEP
  • The enrollment start date for the enrollment that corresponds to the SSEPA record
  • The start date of the amended, locked IEP
  • The student's third birthdate
  • The start date of the Special Education Setting status.
M

Plan.startDate

Enrollment.startDate

Student Information > Special Ed > General > Documents > Plan > Education Plan Editor > Start Date

Student Information > General > Enrollment > Start Date

endDate

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


If the student record being sent is for configuration years prior to 2018-19 (not including 2018-19):

  1. If the SSEPA record is active as of the current date with no future amendments or plans, is active as of the end date of the student's enrollment, or is active on the last date of the calendar, then leave the endDate blank.
  2. Otherwise, reports the earliest of:
  • The Special Ed Exit Date if populated on the student's enrollment that corresponds to the record dates. This reports only for records where the Exit Date is included in the IEP date range 
  • The end date of the student enrollment that corresponds to the record dates.
  • The IEP end Date that corresponds to the SSEPA record. 
  • The end date from the Special Education Setting Status.


If the student record being sent is for the 2018-19 configuration year or later:

  1. If the SSEPA record is active as of the current date with no future amendments or plans or  is active as of the end date of the student's enrollment, then leave the endDate blank.
  2. Otherwise, reports the earliest of:
  • The Special Ed Exit Date if populated on the student's enrollment that corresponds to the record dates. This reports only for records where the Exit Date is included in the IEP date range.
  • The end date of the student enrollment that corresponds to the record dates. 
  • The IEP end Date that corresponds to the SSEPA record. 
  • The end date from the Special Education Setting Status.
  • 6/30/xx where xx is the end year of the configuration year. Report only when the current date has passed the calendar end date.
C

Enrollment.spedExitDate

Plan.endDate

Enrollment.endDate

Student Information > General > Enrollment > Special Ed Exit Date

Student Information > Special Ed > General > Documents > Plan > Education Plan Editor > End Date

Student Information > General > Enrollment > End Date

System Administration > Calendar > Calendar > Days

Student Information > Special Education > Special Education Setting > End Date

ideaEligibility

Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).

  • Reports based on the Primary Disability
  • If Primary Disability is NULL, reports BLANK
  • If Primary Disability = N: Not IDEA Eligible or No Disability, reports FALSE
  • Otherwise if Primary Disability is any other value, reports TRUE
 M PlanState.disability1Student Information > Special Ed > General > Documents > Plan >  Primary Disability
iepBeginDateThe effective date of the most recent IEP or ISP. Reports the start date of the locked IEP.MPlan.startDateStudent Information > Special Ed > General > Documents > Plan > Education Plan Editor > Start Date
iepEndDateThe end date of the most recent IEP. Reports the end date of the locked IEP.CPlan.endDateStudent Information > Special Ed > General > Documents > Plan > Education Plan Editor > End Date
lastEvaluationDate

The date of the last special education evaluation.

Report the Last Evaluation in the IEP

CPlan.evalDateStudent Information > Special Ed > General > Documents > IEP > Eval Date
specialEducationSettingDescriptor

This descriptor defines the major instructional setting (more than 50 percent of a student's special education program).

Report the Ed Fi Short Description mapped to the Campus value set for the Environmental Ed code from the Special Education Setting record active for the SSEPA record.

MspecialEdState.
specialEdSetting
Student Information > Special Education > General > Setting
wiDpiStudentSpecialEducation ProgramAssociationDisabilities  

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

Reports the Ed-Fi Code Value from the Disability Descriptor page below under Type/Descriptors WI based on the Ed-Fi code value for each disability the student meets.

See the Array section above for Disabilities for full reporting requirements

C

planstate.disability1

planstate.disability2

planstate.disability3

planstate.disability4

planstate.disability5

Student Information > Special Ed > General > Documents > Plan > Primary Disability, Secondary Disability, Third Disability, Fourth Disability, Fifth Disability

disabilityDescriptor

This descriptor defines a student's impairment.

  • Reports the Ed-Fi code for the Disabilities from the locked IEP for the student being reported.
  • If the student has more than 1 disability, report each disability up to 5 disabilities.
M
Reporting

As defined by the U.S. Office of Special Education Programs (OSEP), primary disability is the disability condition that best describes an IDEA-eligible student's impairment; the impairment that is most disabling.

  • Reports "True" when reporting the Primary disability
  • Reports "False" for all other disabilities
M
wiDpiParentPlacedPrivate

Identifies if a student is receiving Primary education services from a Private school and Special education services from a public school Indication of a student placed by a parent or guardian in private school, Parentally Placed Private, who receives special education or related services from the submitting district that meet state standards under a service plan.

Reports from the Parent Placement Private School field on the enrollment record that corresponds to the SSEPA record dates.

  • If Parent Placement Private School is set to Yes, reports TRUE
  • Otherwise, reports FALSE
CEnrollment. parentPlacePriSchStudent Information >  General > Enrollments > Special Ed Fields > Parent Placement Private School
reasonExitedDescriptor

Identifies the reason a student's special education record (SSEPA) has an end date. Districts must submit a reason when a special education student's enrollment or special education program association (SSEPA) record ends.

If there's an end date for a special education student, there must also be a reason for exiting, even if the end date is a typical end of the school year exit date, TC Exit Type, and the reason is still Continuing in Special Education.

Reports the following:

  1. If there is a Special Ed Exit Reason entered on the associated enrollment and the SSEPA record endDate is the Special Ed Exit Date, reports the Ed-Fi Value mapped to the Special Ed Exit Reason.
  2. If there is no Special Ed Exit Reason entered on the associated enrollment and the associated enrollment is not ended, report 'Continuing'.
    1. Note: This is used when the SSEPA record is ended due to end of the year and no other SPED action.
  3. If there is no Special Ed Exit Reason entered on the associated enrollment and the associated enrollment has an end date, then report based on the End Status:
    1. Reports 'Exited' If the End Status is mapped to State code of:

           1. PCC
           2. BCA
           3. TOS
           4. HSC
           5. DE
           6. MA
           7. ODO
           8. ISM
           9. INM

      b. Reports 'Continuing' If the End Status is mapped to State code of:

           1. CCS
           2. ETC
           3. TC
           4. TNC
          

4. If there is no Special Ed Exit Reason, no Enrollment End Status entered, and no Enrollment End Date, but there is a SSEPA End Date, report 'Continuing'.

5. Otherwise, reports Blank.
Note: This is only expected in scenarios where the SSEPA end date is also blank.

O

Student Information > General > Enrollment > Special Exit Reason

Student Information > General > Enrollment > Enrollment End Status

Type/Descriptor Layout

 

The highlighted column indicates the reported valued.

Disability Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Emotional DistrubanceEmotional Distrubance
02Deaf-BlindnessDeaf-Blindness
03Hearing ImpairedHearing Impaired
07Multiple ImpairmentMultiple Impairment
08Orthopedic ImpairmentOrthopedic Impairment
09Other Health ImpairmentOther Health Impairment
10Specific Learning DisabilitySpecific Learning Disability
11Speech Language ImpairmentSpeech Language Impairment
12Visual ImpairmentVisual Impairment
13AutismAutism
14Traumatic Brain InjuryTraumatic Brain Injury
15Developmental DelayDevelopmental Delay
16Intellectual DisabilityIntellectual Disability

Special Education Setting Descriptor

Campus DescriptionEd-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description

Ages 6-21: correctional facilities

SCorrectional FacilitiesStudent receives special education and related services in short-term detention facilities (community-based or residential) or correctional facilities. Students reported under this category were, prior to 2007-08, reported under environment codes A, B, or C.

Ages 6-21: hospital

IHospitalStudent is placed in and receiving special education and related services in a medical treatment facility on an in-patient basis.

Ages 6-21: homebound

JHomeboundStudent receives ALL special education and related services in a homebound program.

Ages 6-21: inside the regular classroom with nondisabled peers 80% or more of the time

ARegular Class at Least 80%Student is inside the regular classroom with nondisabled peers 80% or more of the time.

Ages 6-21: inside the regular classroom with nondisabled peers less than 40% of the time

CRegular Class Less Than 40%Student is inside the regular class room with nondisabled peers less than 40% of the time

Ages 6-21: inside the regular classroom with nondisabled peers 40 to 79% of time

BRegular Class 40 - 79%Student is inside the regular classroom with nondisabled peers 40 to 79% of the time

Ages 6-21: parentally placed private

TParentally Placed in Private SchoolsStudent is enrolled in a private school by their parents and their basic education (e.g., tuition) is paid for through private resources. Use this category to report students who receive special education and related services at public expense from a local educational agency under an individual service plan. Include children whose parents choose to home-school them, but who receive special education and related services at public expense.

Ages 3-5: in residential facility

B3Residential FacilityStudent attends a special education early childhood program in publicly or privately operated residential schools or residential medical facilities on an inpatient basis.

Ages 6-21: public residential facility

FPublic Residential FacilityStudent receives special education and related services at public expense for greater than 50% of the school day in a public residential facility AND lives there during the school week. Do not include students who receive educational programs at the facility, but do not live there. This category may include students placed in: public residential schools for students with disabilities (3+ days/week living at WSD/WCBVI, etc) or public residential schools for students with disabilities for a portion of the school day (greater than 50 percent) and in separate day schools or regular school buildings for the remainder of the school day.

Ages 6-21:  private residential facility

GPrivate Residential FacilityStudent receives special education and related services at public expense for greater than 50% of the school day in a private residential facility AND lives there during the school week. Do not include students who received educational programs at the facility, but do not live there. This category may include students placed in: private residential schools for students with disabilities (living at Kradwell) or private residential schools for students with disabilities for a portion of the school day (greater than 50 percent) and in separate day schools or regular school buildings for the remainder of the school day.

Ages 3-5: separate school

B2Separate SchoolStudent attends a special education early childhood program in a public or private day school designed specifically for children with disabilities.

Ages 6-21:  public separate day school

DPublic Separate SchoolStudent receives special education and related services at public expense for greater than 50% of the school day in a public facility that is designed only for students with disabilities. This may include students placed in: separate school buildings for students with disabilities within a district, or public day schools for students with disabilities (day students at WSD or WCBVI, Sybl Hopp, Lakeland School, etc.), or public day schools for students with disabilities for a portion of the school day (greater than 50 percent) and in regular school buildings for the remainder of the school day, or public residential facilities for students with disabilities IF the student does NOT LIVE at the facility.

Ages 6-21: private separate day school

EPrivate Separate SchoolStudent receives special education and related services at public expense for greater than 50% of the school day in a private facility that is designed only for students with disabilities. This may include students placed in: private day schools for students with disabilities (day students at Kradwell), or private day schools for students with disabilities for a portion of the school day (greater than 50 percent) and in regular school buildings for the remainder of the school day, or Private residential facilities for students with disabilities IF the student does NOT LIVE at the facility.

Ages 6-21: homebound

09HomeboundHomebound

Ages 3-5: home

09HomeStudent receives special education/related services in the principle residence of the child's family or caregivers (includes babysitters). Report children who receive special education both at home and in a service provider location in this category

Ages 3-5: special education classroom

B1Separate Special Education ClassroomStudent attends a special education early childhood program in a class with less than 50% nondisabled peers.

Age 3-5 in regular EC at least 10 hrs/wk & majority of hrs of SPED & related services in EC program

R1Regular Class At Least 10 Hours Majority Sp Ed in Regular ClassStudent attends a regular early childhood program at least 10 hours per week and receives the majority of hours of special education and related services in the regular early childhood program.

Age 3-5 in reg EC at least 10 hrs/wk & majority of hrs of SPED & related services in other location

R2Regular Class At Least 10 Hours Majority Sp Ed in Other LocationStudent attends a regular early childhood program at least 10 hours per week and receives the majority of hours of special education and related services in some other location.

Age 3-5 in regular EC < 10 hrs/wk & majority of hrs of SPED & related services in EC program

R3Regular Class Less Than 10 Hours Majority Sp Ed in Regular ClassStudent attends a regular early childhood program less than 10 hours per week and receives the majority of hours of special education and related services in the regular early childhood program.

Age 3-5 in regular EC < 10 hrs/wk & majority of hrs of SPED and related services in other location

R4Regular Class Less Than 10 Hours Majority Sp Ed in Other LocationStudent attends a regular early childhood program less than 10 hours per week and receives the majority of hours of special education and related services in some other location.
Ages 3-5: service provider locationB5Service ProviderStudent receives special education/related services only from a service provider or in some other location that is not in any other category. This educational environment code is only used when no other educational environment code can be used. For example, a child who receives only speech and language services in a speech pathologist's office located in a school building.



Additional Logic and Considerations

The following describes additional logic and considerations to be aware of when working with Ed-Fi.

Ed-Fi Transfer School ID
This field needs to be populated in order for the expectedTransferSchoolReference value to report on the Student School Association Wisconsin Extension. Enter the School Agency Key in the Ed-Fi Transfer School ID field on the Enrollment editor. If this field is not null on the most recent enrollment in the school, the Ed-Fi Code for the value entered reports; otherwise, the field reports blank.

Also see the Ed-Fi District and School Agency Codes and Keys article for a list of School Agency Keys to populate this field.

No Show/Excludes

If State Exclude, No Show, or WISE Exclude 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.