Wisconsin Ed-Fi Data v3.3 - Student

Tool Search: Ed-Fi

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

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

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When an enrollment is created and saved for a person and the enrollment overlaps a configured year.

  • Do not send a student record for an enrollment that is marked as State Exclude, No Show, or WISE Exclude.
  • Do not send a record if enrollment is in a calendar marked as State Exclude, Summer School, or in a School marked Exclude.'
  • If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment.
  • If Ed-Fi Configuration Profile = Choice AND Choice = No on Student enrollment, do not report a record
Put

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

  • When the person’s identity record is changed in one of the following fields: Birth Country, Birth Date, Date Entered US, First Name, Last Name, visas, multiple Birth Status
Delete

Student records are never deleted because Student records are a shared resource among all districts.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

ActionBusiness Rule
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf an Ed-Fi Code mapping is changed to a new code or made NULL, a resync must be performed for the data to be updated in the ODS.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionBusiness Rule
Post

Natural Key change:  Ed-Fi ID

  • If an Ed-Fi ID is changed for a student, all data for the previous number will be deleted and resent under the new number.
Delete

Cascading Deletes:  The following resources will be deleted and resent if the Ed-Fi ID is changed.

  • Student Parent Associations, Student Education Organization Associations, Student School Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student Scool Attendance Events, Student Section Attendance Events

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

  • The enrollment must overlap with the configured 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 will be applied to determine the scope year(s) in which to report data:

  • Current Year: The record must overlap the current year.
  • 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) iin which to report data:

  • Current Year: The record must overlap the current year.
  • 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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Database field
birthCountryDescriptorBirth Country Overrideidentity.birthcountry
birthStateDescriptorBirth State Overrideidentity.birthstate
visaDescriptorVisa Type Descriptoridentity.visatype

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType

Object Key Data Source

PersonpersonID
 
  1. If a Student and Student School Association record has been sent for a student, a Student and Student School Association record will be logged in the Ed-Fi Identity Mapping table.   If the student's enrollment is deleted or their Ed-Fi ID is changed while the Student and/or Student School Association Resource Preference is turned off, the old record and resource id will remain in the table until the resource is turned back on and a resync is performed on either Students or Student School Associations.

  2. The Students and Student School Associations records will be deleted from the identity mapping table if all enrollments that were sent to Ed-Fi are deleted.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

enrollmentPost/Put/DeleteThe primary table used for sending data for this resource.
identityPutbirthCity, birthCountryDescriptor, birthDate, birthSexDescriptor, birthStateAbbreviationDescriptor, dateEnteredUS, firstName, lastSurname,  generationCodeSuffix, middleName, otherNames
personPost/DeletestudentUniqueID

Object Data Elements

This table describes data elements sent within the Student resource.

Data Element LabelBusiness RequirementBusiness RulesM, C, or O

Data Source 

GUI Path

Database 
Field
idThe unique identifier of the resource.
M

studentUniqueIdA unique alpha-numeric code assigned to a student. Reports the Ed-Fi ID.
  1. Report Ed-Fi ID.
MCensus>People>
Demographics> EdFi ID
person.edfiid
birthCityThe city the student was born in.
  1.  Report the Birth City if populated on the Demographics tab.
OCensus > People > Demographics > Birth Cityidentity.
birthcity
birthCountryDescriptorThe country in which an individual is born. It is strongly recommended that entries use only ISO 3166 2-letter country codes.
  1. Report the Country from the Birth Country saved on the student's current identity record.
    • Look for a mapping saved to the Birth Country Descriptor Override section in preferences. If there is a mapped value, report that mapping.
    • If  an override is not there, look to see if the Code matches an Ed-Fi code, if yes report that value.
    • Report default value if saved on the Attribute and the code matches an Ed-Fi code.
  2. Otherwise, report NULL.
OCensus > People > Identities > Birth Countryidentity.
birthcountry
birthDateThe month, day, and year on which an individual was born.
  1. Report the Birth Date from the student's current identity record.
MCensus >People > Identities > Birth Dateidentity.
birthdate
birthInternationalProvinceFor students born outside of the U.S., the Province or jurisdiction in which an individual is born.
  1.  This is optional, does not report.
O

birthSexDescriptorA person''s gender at birth.
  1. This is optional, does not report.
OCensus > People  > Identities > Genderidentity.
Gender
birthStateAbbreviation
Descriptor
The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.,Report the State from the Birth State saved on the student's current identity record.
  1. Look for a mapping saved to the Birth State Abbreviation Type Override section in preferences. If there is a mapped value, report that mapping.
  2. If  an override is not there, look to see if the Code matches an Ed-Fi code, if yes report that value.
  3. Report default value if saved on the Attribute and the code matches an Ed-Fi code.
  4. Else, report NULL.
OCensus > People > Demographics > Birth Stateidentity.
birthstate
citizenshipStatus
Descriptor
An indicator of whether or not the person is a U.S. citizen.
  1.  This is optional, does not report.
O

dateEnteredUSFor students born outside of the US, the date the student entered the US.
  1. Report the Date Entered US if date is entered.
  2. Do not report if date is blank.
OCensus > People > Identities > Date Entered USidentity.
dateEntered
US
firstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
  1. Report from the current identity record,
    • Report first from the legal name fields, report legal first name.
    • If Legal First and Last name fields are blank, report First Name.
M

Census > People > Identities > Legal First Name

OR

Census > People > Identities > First Name

identity.

legalFirstName

OR

identity.

firstName

generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III)
  1. Report from the current identity record.
    • Report first from the legal name fields, report Legal Suffix.
      • If Legal First Name and Legal Last Name are populated and Legal Suffix is blank, report blank.
    • If Legal First and Last name fields are blank, report Suffix (if available).
      1. Otherwise, report blank.
O

Census > People > Identities > Legal Suffix

OR

Census > People > Identities > Suffix

identity.

legalSuffix

OR

identity.suffix

identificationDocumentsDescribe the documentation of citizenship.
  1.  This is optional, does not report.
O

lastSurnameThe name borne in common by members of a family.
  1. Report from the current identity record,
    • Report first from the legal name fields, report last name.
    • If Legal First and Last name fields are blank, report Last Name.
M

Census > People > Identities > Legal Last Name

OR

Census > People > Identities > Last Name

identity.

legalLastName

OR

identity.

lastName

maidenNameThe person''s maiden name.
  1.  This is optional, does not report.
ON/AN/A
middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony.
  1. Report from the current identity record.
  2. Report first from the legal name fields, report legal middle name.
    • If Legal First Name and Legal Last Name are populated and Middle Name is blank, report blank.
  3. If all legal name fields are blank, report from middle name.
    • Otherwise, report blank.
O

Census > People > Identities > Legal Middle Name


OR


Census > People > Identities > Middle Name

identity.

legalMiddle

Name


OR


identity.

middleName

multipleBirthStatusIndicator of whether the student was born with other siblings (i.e., twins, triplets, etc.)Report from the current identity record,
  1. Reports true or false
OCensus > People > Identitiesidentity.
multipleBirth
otherNamesOther names (e.g., alias, nickname, previous legal name) associated with a person.
  1.  This is optional, does not report.
OCensus > People > Identities
personalIdentification
Documents
The documents presented as evident to verify one’s personal identity; for example: drivers license, passport, birth certificate, etc.
  1.  This is optional, does not report.
O

personalTitlePrefixA prefix used to denote the title, degree, position or seniority of the person.
  1.  This is optional, does not report.
ON/AN/A
visasAn indicator of a non-US citizen’s Visa type. Only required when a Student has a 'Visa' Required for foreign exchange students.

Pass visaDescriptor(string) in the array.
  1. 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, do not report this field.
  2. If Enrollment is in a school where Ed-Fi School Population is marked Public and If populated on the person, report Visa Type.
    • Otherwise, report blank.
  3. See Visas Array elements for logic.
C Census > People > Identity > Visa Type identity.
visaType
_etagA unique system-generated value that identifies the version of the resource.
O

Array Data Elements

This table describes the array data elements for the Visas element:

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

visaTypeIndicates the visa type.
  1. Report the Ed-Fi value for the cisa type.

Census > People > Identity identity.visaType