Wisconsin Ed-Fi Data v3.5 - Student Education Organization Associations

Last Modified on 03/19/2024 8:48 am CDT

Tool Search: Ed-Fi

This association represents student information that is specific to a student’s relationship with an Education Organization.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
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. If School Override is populated on enrollment, report an additional record with the associated Ed-Fi School Number. Send only one record per unique School/Student combination based on primacy if there are overlapping records: State Enrollment Type = Primary Enrollment Type = Primary Enrollment Type = Special Ed other enrollment types or state enrollment types
Put	When one of the person’s household locations is updated/changed. Mailing, Private, Physical
Put	When one of the person’s household memberships is added/deleted/changed. Start Date, End Date, Private
Put	When any data in the address the student is associated with changes . PO Box, Number, Prefix, Street, Tag, Direction, City, State, Zip
Put	When the Immigrant indicator on the enrollment driving the SEOA record is updated and saved.
Put	When the Resident District field on the enrollment driving the SEOA record is updated and saved.
Put	When a Migrant record is created that has dates falling within the enrollment dates driving the SEOA reco.
Delete	When the State Exclude, WISE Exclude, or No Show check boxes are checked.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

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

Action	Business Rule
Post/Delete	Natural Key Change: If the District Number/Ed-Fi District Number changes, a delete/post will occur with the cascading deletes from the LEA ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete	Cascading Deletes: N/A - no dependent resources

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

Logic

The record will send to the scope year for the school year the enrollment is associated with.

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

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Person	personID - schoolID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete Put	The primary table used for sending data for this resource. Reports Disabilities
identity	Put	Reports Hispanic or Latino, Gender, Home Primary Language, US Entry Type.
person	Put	Reports the Ed-FI ID.
contact	Put	Reports the Telephone and Email information.
raceethnicity	Put	Reports Races.
plantype	Put	Reports Indicators.
plan	Put	Reports Disabilities, Indicators.
planstate	Put	Reports Disabilities.
programs	Put	Reports any Characteristic created in Programs.
programparticipation	Put	Reports any Characteristic created in Programs.
ImpactAidEmployment	Put	Reports Parent in Military.
relatedpair	Put	Guardian checkbox for contact information and Parent in Military.
section504	Put	Reports Section 504 Handicapped.
homeless	Put	Reports Homeless, Unaccompanied Youth, Runaway.

Object Data Elements

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

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
educationOrganizationId	The identifier assigned to an education organization.	Report the Ed-Fi school number for the student's enrollment record from the School Override field on the enrollment record if it is populated. If the school override is the same as the school for the enrollment record, only report 1 record. Otherwise, report the Ed-Fi school Number (System Administration > Resources > School) associated with the student's enrollment record.	M
studentReference	A unique alphanumeric code assigned to a student.	Reports the natural key of the Students resource.	M
addresses	The set of elements that describes an address, including the street address, city, state, and ZIP code.	Note: All leading and trailing white spaces will be removed when this data is sent. If No is selected for LEA "Opt-in" under Ed-Fi Configuration > Resource Preferences > Student Education Organization Associations > Addresses, report Null. If Yes is selected for LEA "Opt-in", report the most current Primary addresses that are marked as marked as "Mailing" or "Physical'. If more than 1 Primary Address marked as Mailing, report address with most recent Household Membership Start Date. Else, report the address with most recent Address Start Date. Do not report if the Address Location Detail or Household Membership is marked as "Private" or "Secondary". If multiple primary addresses exist and 1 is marked Physical, report a second address with an addressTypeDescriptor of "Home". Note: Only 1 of each address type may be reported. If only 1 address exists and only Mailing or Physical are checked, report 2 records - 1 with an addressType = Home and the 2nd record with same address with addressType = Mailing. If "Secondary" is checked, do not report address. See Business Rules in Scope Year logic to determine the eligibility of records. See Array section below for data logic for each field.	O	Household Addresses> Mailing Household Membership> Start Date Household Addresses> Start Date	HouseholdLocation.mailing HouseholdMember.startDate Householdlocation.StartDate
cohortYears	The type and year of a cohort (e.g., 9th grade) the student belongs to as determined by the year that student entered a specific grade.	This is optional, does not report.	O
disabilities	The disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization.	If the enrollment determining the record is in a School with Ed-Fi Configuration Profile = Public, do not report this array. Otherwise, report the Ed-Fi Code Value from the Disability Descriptor page linked 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	O
electronicMails	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.	electronicMailType has a specific url path = WI_URI_PATH('uri://dpi.wi.gov/ElectronicMailTypeDescriptor#Org')	O	Census> People> Demographics > Email	contact.email
hispanicLatinoEthnicity	An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."	Report "Is the individual Hispanic/Latino?" from the student's current identity: If droplist is = Yes, report "true". If droplist is = No, report "false".	O	Census>People >Identities> Is the Individual Hispanic or Latino?	identity.hispanicEthnicity
internationalAddresses	The set of elements that describes an international address.	This is optional, does not report.	O
languages	The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.	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, report blank. If Enrollment is in a school where Ed-Fi School Population is marked Public and Native Language is not NULL, add to the languages. Otherwise, do not add to the array. See the Languages Array elements for logic.	C	Census > People > Identity > Native Language	Identity.languageAlt
limitedEnglishProficiency Descriptor	An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.	See Appendix A for calculation.	O	Student Information> Program Participation> English Learners (EL)	lep.programStatus lep.identifieddate lep.exitDate lep.parentDeclined
loginId	The login ID for the user; used for security access control interface.	Reports the app username.	O		app.username
oldEthnicityDescriptor	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 is optional, does not report.	O	N/A	N/A
profileThumbnail	File name for the ProfileThumbnail photograph.	This is optional, does not report.	O	N/A	N/A
programParticipations	Key programs the student is participating in or receives services from.	This is optional, does not report.	O
races	The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races.	See Array section below for data logic for each field.	O	Census > People > Identities > Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid
sexDescriptor	A person's gender.	Report the Gender from the student's current identity record. Check to see if the "Report Legal Identifies when provided" checkbox is selected on the Students resource preferences editor. If yes, check to see if Legal Gender is populated. If yes, report the value from Legal Gender If no, report the Gender value based on the value selected in the droplist: Female, report 'F' Male, report 'M' Non-binary, report 'X' If no, report the Gender value based on the value selected in the droplist: Female, report 'F' Male, report 'M' Non-binary, report 'X'	M	Census>People >Identities> Gender	identity.gender
characteristics	Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth.	See Array below for logic.	O
identificationCodes	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.	See Array section for reporting logic.	O
indicators	Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.	See Array section for reporting logic.	O
telephones	The 10-digit telephone number, including the area code, for the person.	This is optional, does not report.	O
languages	An unordered collection of studentLanguages. Language(s) the individual uses to communicate.	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, report blank If Enrollment is in a school where Ed-Fi School Population is marked Public and Native Language is not NULL, add to the languages. Otherwise, do not add to the array. See the Languages Array elements for logic.	C	Census > People > Identity > Native Language	Identity.languageAlt
tribalAffiliations	An American Indian tribe with which the student is affiliated.	Report the Ed-Fi code(s) mapped in resource preferences for any and all values saved in the multi-select tool where standard code value = AIAN. Otherwise, do not report.	C	Census > People > Race > Detailed Ancestry/Tribal Codes	raceSubcategory. subcategory
ancestryEthnicOrigin Descriptor	An unordered collection of student Education Organization Association Ancestry Ethnic Origins. The ancestry ethnic origins that pertain to the general racial categories with which the individual identifies.	Report the associated Ed-Fi code value.		Census > People > Race > Race/Ethnicity Determination
_ext wi_studentEducationOrganization AssociationsExtension (residentLocalEducationAgency Reference)	The district in which the student resides. In WISE data, Resident District is not expected for students who live in the district and receive their primary K-12 educational services from the district submitting the data. The Resident District is assumed to be the submitting district unless otherwise noted by inclusion of data in the Resident District field.	Report the value selected in Resident District if different than the reporting district (when only 1 credential exists for the configuration). If multiple credentials exist for the configuration for the config year and Resident District on enrollment is populated with a value that is different from the District Number in the Configuration > Credentials, report the entityID for the Resident District value on enrollment. If the Resident District on enrollment is null, report the District Number from the Credentials area of the configuration. If both Resident District and District Number on configuration are null, do not report the extended element.		Student Information > General > Enrollments > State Reporting Fields > Resident District
_etag	A unique system-generated value that identifies the version of the resource.		O

Array Data Elements

Click here to expand...

Disabilities

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
disabilityDescriptor	This descriptor defines a student's impairment.	Report the Ed-Fi code from the Disabilities mapping for the student being reported. Only report the distinct disabilities from the first 5 disability fields. If the student has a locked IEP that overlaps the configured year, report the disabilities entered on the IEP if mapped to an Ed-Fi Code. If the student does not have an eligible IEP but has 1 or more disabilities on their enrollment, report the disabilities if mapped to an Ed-Fi Code. The enrollment must overlap the configured year. If the student has more than 1 enrollment, report all distinct disabilities. If the student does not have an eligible IEP or disabilities on enrollment, report disabilities from the Special Ed State Reporting tab. State Reporting record must overlap the configured year. if the student has more than 1 State Reporting record, report all distinct disabilities.	M	Special Ed> Documents> Plan> IEP> Primary Disability, Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability OR Enrollments> Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability OR Student Information> Special Ed> General> State Reporting> Primary Disability	planstate.disability1 planstate.disability2 planstate.disability3 planstate.disability4 planstate.disability5 or enrollment.disability1 enrollment.disability2 enrollment.disability3 enrollment.disability4 enrollment.disability5 or specialEdState.primary Disability
disabilityDeterminationSource TypeDescriptor	The source that provided the disability determination.	This is optional, does not report.	O
disabilityDiagnosis	A description of the disability diagnosis.	This is optional, does not report.	O
orderOfDisability	The order by severity of student's disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc.,	Report the order of disability based on the disability being reported from above. If Primary Disability, report '1'. if Secondary Disability, report '2'. if Tertiary Disability, report '3'. if Fourth Disability, report '4'. if Fifth Disability, report '5'. If the student has the same disability in multiple records from the same source (IEP, Enrollment, State Reporting) and the order is not the same, report the order from the record with the most recent start date. If the start dates are the same, the system will pick a record to send.	O
designations	Whether the disability is IDEA, Section 504, or other disability designation.	This is optional, do not report.

Electronic Mail

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
electronicMailTypeDescriptor	The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.).	The Primary Email address will report as "Home/Personal" Do not report Secondary Email for students.	M
doNotPublishIndicator	An indication that the electronic email address should not be published.	This is optional, does not report.	O
electronicMailAddress	The electronic mail (e-mail) address listed for an individual or organization.	Reports the email address entered for that person.	M	Census> People> Demographics> Email	contact.email
primaryEmailAddressIndicator	An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.	This is optional, does not report.	O

Student Language

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
languageDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table	Report the Language from the Native Language saved on the student's current identity record. Look for a mapping saved to the Language 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 language 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. Otherwise, report NULL.	M	Census > People > Identities > Native Language	Identity.languageAlt
uses	A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	If the array is being reported, report "Native language".	O	N/A	N/A

Races

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
raceDescriptor	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.	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. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity. Report all races if the student has more than 1 selected. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

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.
Report the Ed-Fi Code mapped to the corresponding Race Ethnicity.
- Report all races if the student has more than 1 selected.
Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Student Characteristics

Characteristic	Logic	UI Path	Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
SATA	Does not report for any students for school years 2022-2023 and later.	Student Information> General> Enrollment > State Assessment Type	SATA	State Assessment Type - Alternate	State Assessment Type - Alternate
Economic Disadvantaged	If Disadvantaged - Alt Mechanism (Student Information > General > Enrollment) is checked, report 'ED' for student characteristic descriptor. If Disadvantaged - Alt Mechanism (Student Information > General > Enrollment) is not checked, then do the following: Report 'ED' If an active FRAM eligibility record exists with a Type = Meal or SES for the current/reporting school year and eligibility is = Free or Reduced. If the active record is in the previous school year (carryover eligibility), do not report ED. Exclude enrollments that are on a calendar marked as Summer School when determining if FRAM record is active. A record is considered active when the FRAM end date is greater than or equal to the last instructional date on the calendar. If the last instructional date on the calendar is after 6/30, then the FRAM end date should be compared to 6/30 instead. Report 'Not ED' if: Eligibility is = Paid Eligibility is = Non-reimbursable Eligibility is NULL No FRAM records exist all FRAM records are ended Active FRAM record is a "carryover" record from the previous school year.	Student Information > General > Enrollment > Disadvantaged - Alt Mechanism FRAM > Eligibility > Eligibility	Economically Disadvantaged	Economically Disadvantaged	Economically Disadvantaged
Not Economically Disadvantaged	If the student does not report Economically Disadvantaged, report Not Economically Disadvantaged.	Student Information > General > Enrollment > Disadvantaged - Alt Mechanism FRAM > Eligibility > Eligibility	Not Economically Disadvantaged	Not Economically Disadvantaged	Not Economically Disadvantaged
Migrant Note: This reports for 2019-20 and 2020-21 School years, but not the 20221-22 school year.	Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: Find any Migrant records for the student. If the student has a Migrant record at any point during an enrollment in the school year, add Migrant to the array. Otherwise do not report.	Student Information > General > Program Participation > Migrant	Migrant	Migrant
Immigrant	Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: If student is marked Immigrant = Yes, add Immigrant to the array. Otherwise do not report.	Student Information > General > Enrollment > Immigrant	Immigrant	Immigrant	Immigrant
Parent in Military	Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: If the student has a Qualifying Relationship with a person with an Active Military Connections record, add Parent in Military to the array. A qualifying relationship is; Active within the school year (not ended prior to the start of the config year). AND either marked Guardian OR the role is mapped to an Ed-Fi value of Parent/ Guardian. An Active Military Connections record: 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. has a Status mapped to an Ed-Fi Value of Active. Otherwise do not report.	Calculated from: Census > People > Military Connections AND Census > People > Relationships	Parent in Military	Parent in Military	Parent in Military
Teen Single Parent	Do not report for students Enrolled in a School with Ed-Fi Reporting Option of Choice ONLY or Choice + Private Opt In. If students are enrolled in a school with Ed-Fi Reporting Option = Public: AND If student is enrolled in grades 11 or 12, AND if the student has a State Reported CTE Participant (Student Information > Academic Planning > Academic Program > Career Tech Program - Participation Detail) record with Teen Single Parent checked OR the Teen Single Parent box is checked in Student Information > General > Enrollment > State Reporting, report 'SP'. Otherwise do not report.	Student Information > General > Enrollments	Teen Single Parent	Teen Single Parent	Teen Single Parent

Student Identification Codes

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
studentIdentificationSystem Descriptor	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.	Report 'L' for the Local Student Number. Report 'SIS' for the SIS Internal ID (personID).	M	Census> People> Demographics> Local Student Number and/or Student State ID	person. studentnumber person.stateID
AssigningOrganization IdentificationCode	The organization code or name assigning the StudentIdentificationCode.	Report 'Local' for the Local Student Number. Report 'SIS Internal' for the personID.	M	Student Information > General> Resource > District Information> Number	district.number
IdentificationCode	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	Report the Local Student Number for 'Local'. Report the personID for 'SIS Internal'.	M	Census>People> Demographics> Local Student Number	person. studentNumber

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source

GUI Path

Database Field

studentIdentificationSystem

Descriptor

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.

Report 'L' for the Local Student Number.
Report 'SIS' for the SIS Internal ID (personID).

Census> People> Demographics> Local
Student Number
and/or Student State ID

person.

studentnumber

person.stateID

AssigningOrganization
IdentificationCode

The organization code or name assigning the StudentIdentificationCode.

Report 'Local' for the Local Student Number.
Report 'SIS Internal' for the personID.

Student Information > General> Resource > District Information> Number

district.number

IdentificationCode

A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.

Report the Local Student Number for 'Local'.
Report the personID for 'SIS Internal'.

Census>People>
Demographics> Local Student Number

person.
studentNumber

Student Indicators

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
indicatorName	The name of the indicator or metric: InternetAccessInResidence InternetAccessTypeInResidence InternetPerformance DigitalDevice DeviceAccess Wisconsin Digital Equity	If a Digital Equity record exists for the student that falls within the config year, report the following: "InternetAccessInResidence" as the Indicator Name for the first record in the array. Report "InternetAccessTypeInResidence" for the 2nd record. Report "InternetPerformance" for the 3rd record. Report "DigitalDevice" for the 4th record. Report "DigitalAccess" for the 5th record. If multiple Digital Equity records exist for the student, report the most recent record. If no record exists, do not report.	M	Student Information > Program Participation > State Programs > Digital Equity
indicator	The value of the indicator or metric. Wisconsin Digital Equity	If a Digital Equity record exists for the student that falls within the config year, report the name for the value selected for each indicatorName.	M	Student Information > Program Participation > State Programs > Digital Equity
indicatorGroup	The name for a group of indicators. Wisconsin Digital Equity	If a Digital Equity record exists for the student that falls within the config year, report "DigitalEquity" for each indicatorName.	M	Student Information > Program Participation > State Programs > Digital Equity

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

indicatorName

The name of the indicator or metric:

InternetAccessInResidence
InternetAccessTypeInResidence
InternetPerformance
DigitalDevice
DeviceAccess

Wisconsin Digital Equity

If a Digital Equity record exists for the student that falls within the config year, report the following:
- "InternetAccessInResidence" as the Indicator Name for the first record in the array.
- Report "InternetAccessTypeInResidence" for the 2nd record.
- Report "InternetPerformance" for the 3rd record.
- Report "DigitalDevice" for the 4th record.
- Report "DigitalAccess" for the 5th record.
If multiple Digital Equity records exist for the student, report the most recent record.
If no record exists, do not report.

Student Information > Program Participation > State Programs > Digital Equity

indicator

The value of the indicator or metric.
Wisconsin Digital Equity

If a Digital Equity record exists for the student that falls within the config year, report the name for the value selected for each indicatorName.

Student Information > Program Participation > State Programs > Digital Equity

indicatorGroup

The name for a group of indicators.
Wisconsin Digital Equity

If a Digital Equity record exists for the student that falls within the config year, report "DigitalEquity" for each indicatorName.

Student Information > Program Participation > State Programs > Digital Equity

Addresses

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
addressTypeDescriptor	The type of address listed for an individual or organization. For example, Mailing Address, Home Address, etc.	Report Mailing for the address being reported if "Mailing" is checked. If "Physical" is checked for the address being reported, report "Home". If only 1 primary address exists, report 2 records with the same address, 1 for Home and 1 for Mailing.	M
stateAbbreviationDescriptor	The abbreviation for the state (within the United States) or outlying area in which an address is located.	Reports the State for the address being reported.	M	Households> Address Info> State	address.state
apartmentRoomSuiteNumber	The apartment number of the student.	Reports from apartment number on the address being reported.	C	Households>address>info> APT	address.apartment
city	The name of the city in which an address is located.	Reports the City for the address being reported.	M	Households> Address Info> City	address.city
postalCode	The five or nine digit zip code portion of an address.	Reports the Zip Code for the address being reported.	M	Households> Address Info> Zip Code	address.zip
streetNumberName	The street number and street name or post office box number of an address.	Reports Address PO Box + Number + Street + Tag + Prefix + Dir	M	Households>Address Info	address.postOfficeBox address.number address.street address.tag address.prefix address.dir

Types/Descriptors

Click here to expand...

Student Characteristic Descriptors - Immigrant

Ed-Fi Code Value	Short Description
I: Immigrant	Immigrant

Student Characteristic Descriptors - Migrant

Ed-Fi Code Value	Short Description
Mig: Migrant	Migrant

Student Characteristic Descriptors - Parent in Military

Ed-Fi Code Value	Short Description
M: Parent in Military	1: Active Duty, Deployed
M: Parent in Military	2: Active Duty, Not Deployed
M: Parent in Military	3: Discharged
M: Parent in Military	4: Inactive
M: Parent in Military	5: Injured
M: Parent in Military	6: Killed In Action
M: Parent in Military	7: Retired
M: Parent in Military	8: Student Military Identifier Only
M: Parent in Military	9: Transitioning Out of Active Duty
M: Parent in Military	10: AGR Title 10 or NG Title 32

Student Characteristic Descriptors - SATA

Ed-Fi Code Value	Short Description
SATA: State Assessment Type - Alternate	A: Alternate
SATA: State Assessment Type - Alternate	G: Generic

Student Characteristic Descriptors - Single Parent

Ed-Fi Code Value	Short Description
SP:Single Parent	Single Parent

Race Descriptors

Ed-Fi Code Value	Short Description
I: American Indian or Alaska Native	American Indian or Alaska Native
A: Asian	Asian
B: Black or African American	Black or African American
P: Native Hawaiian or Other Pacific Islander	Native Hawaiian or Other Pacific Islander
W: White	White

Digital Access

Ed-Fi Code	Ed-Fi Short Description
Personal - Dedicated	PD: Personal - Dedicated
Personal - Shared	PS: Personal - Shared
School Provided - Dedicated	SP: School Provided - Dedicated
School Provided - Shared	SS: School Provided - Shared
None	NA: None
Other	OT: Other

Digital Device

Ed-Fi Code	Ed-Fi Short Description
Desktop/Laptop	DL: Desktop/Laptop
Tablet	TA: Tablet
Chromebook	CB: Chromebook
SmartPhone	SP: SmartPhone
None	NA: None
Other	OT: Other

Internet Access in Residence

Ed-Fi Code	Ed-Fi Short Description
Yes	Yes: Yes - Internet Access in Residence
No - Not Available	NA: No - Not Available
No - Not Affordable	NO: No - Not Affordable
No - Other	OT: No - Other

Internet Access Type in Residence

Ed-Fi Code	Ed-Fi Short Description
ResidentialBroadband	RB: ResidentialBroadband (DSL,Cable, Fiber)
CellularNetwork	CN: CellularNetwork
SchoolProvidedHotSpot	HS: SchoolProvidedHotSpot
Satellite	SA: Satellite
Dial-up	DU: Dial-up
Other	OT: Other
None	NA: None

Internet Performance

Ed-Fi Code	Ed-Fi Short Description
Yes - No Issues	Yes: Yes - No Issues
Yes - But not consistent	NC: Yes - But not consistent
No	NO: No

Appendix A: Additional Logic

Click here to expand...

Field	Logic
limitedEnglishProficiencyDescriptor	Determine which EL Record to use: For the current scope year, as defined on the configuration (current date is within the start and end date of the year dates): 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 date are disregarded. Use the record if one of the following is true: If today's date does not fall between the Identified Date and the Exit Date of any LEP record,AND no record exists without an Identified Date, then Find the most recently exited record . EL second year monitoring date must fall after or within the current configuration. Example- 20-21 configuration dates: 07/01/2020-06/30/2021 (each year after follows same pattern) EL exit date is 08/25/20202- this is reportable through the 2022-2023 school year because 2nd year monitoring is 08/25/2023. If today's date does not fall between the Identified Date and the Exit Date of any LEP record, and no record exists without an Identified Date, use the most recent LEP record with an Exit Date as the Valid EL Record. For any previous year's data (scope year set to a year with an end date prior to the current date): Find the latest EL record within the configuration or before (on or before the last date of the year) Program Status must be "EL" or "Exited EL". Follow below to determine what value to report. Logic for reporting from EL Record From the identified EL record, calculate the reported value: If there is an English Proficiency Override value on the EL record used (see above for logic on which record to use), report that value. If no English Proficiency Override exists AND the student has an exited EL Status and the Exit date is prior to the current date/end of year date, report '6'. Otherwise find an EL Assessment of Assessment Type 'LPF' or 'LID'. If the student's EL Identified date is prior to the start date of the school year, use the most recent assessment score in the prior year. Score must be on the parent assessment. This score must report through the end date on index>system admin> calendar>school years> end date If Null, report this through 6/30/current year. Else find an EL Assessment of Assessment Type 'LPF' or 'LID'. If the student's EL Identified Date is prior to the start date of the school year, use the most recent assessment score in the prior year. Score must be on the parent assessment. If the student is a new EL student or they have no assessments in the prior year, use this year's assessment score. The student's EL Identified Date must be on or after the start of the scope year and on or before today's date. Score is on the parent test. 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. For the current year, any test with a value outside this range (6.1 or above, or 0-.9) is disregarded and does not report. For previous years, if Test Result is not numeric, disregard the value and do not report. If Home Primary Language is equal to eng (English), report 7. If the Student has an EL record but does not meet the above, report 7.

Field

Logic

limitedEnglishProficiencyDescriptor

Determine which EL Record to use:

For the current scope year, as defined on the configuration (current date is within the start and end date of the year dates):
1. 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 date are disregarded.
  - Use the record if one of the following is true:
    - If today's date does not fall between the Identified Date and the Exit Date of any LEP record,AND no record exists without an Identified Date, then
      1. Find the most recently exited record .
      2. EL second year monitoring date must fall after or within the current configuration.
        Example- 20-21 configuration dates: 07/01/2020-06/30/2021 (each year after follows same pattern)
        EL exit date is 08/25/20202- this is reportable through the 2022-2023 school year because 2nd year monitoring is 08/25/2023.
  - If today's date does not fall between the Identified Date and the Exit Date of any LEP record, and no record exists without an Identified Date, use the most recent LEP record with an Exit Date as the Valid EL Record.
For any previous year's data (scope year set to a year with an end date prior to the current date):
- Find the latest EL record within the configuration or before (on or before the last date of the year)
- Program Status must be "EL" or "Exited EL".
- Follow below to determine what value to report.

Logic for reporting from EL Record

From the identified EL record, calculate the reported value:
- If there is an English Proficiency Override value on the EL record used (see above for logic on which record to use), report that value.
- If no English Proficiency Override exists AND the student has an exited EL Status and the Exit date is prior to the current date/end of year date, report '6'.
- Otherwise find an EL Assessment of Assessment Type 'LPF' or 'LID'.
  - If the student's EL Identified date is prior to the start date of the school year, use the most recent assessment score in the prior year.
    - Score must be on the parent assessment.
    - This score must report through the end date on index>system admin> calendar>school years> end date
      1. If Null, report this through 6/30/current year.
- Else find an EL Assessment of Assessment Type 'LPF' or 'LID'.
  - If the student's EL Identified Date is prior to the start date of the school year, use the most recent assessment score in the prior year.
    - Score must be on the parent assessment.
  - If the student is a new EL student or they have no assessments in the prior year, use this year's assessment score.
    - The student's EL Identified Date must be on or after the start of the scope year and on or before today's date.
    - Score is on the parent test.
  - 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.
  - For the current year, any test with a value outside this range (6.1 or above, or 0-.9) is disregarded and does not report.
  - For previous years, if Test Result is not numeric, disregard the value and do not report.
If Home Primary Language is equal to eng (English), report 7.
If the Student has an EL record but does not meet the above, report 7.

Was this helpful?

Wisconsin Ed-Fi Data v3.5 - Student Education Organization Associations

Object Triggering Logic

Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Array Data Elements

Disabilities

Electronic Mail

Student Language

Races

Student Characteristics

Student Identification Codes

Student Indicators

Addresses

Types/Descriptors

Student Characteristic Descriptors - Immigrant

Student Characteristic Descriptors - Migrant

Student Characteristic Descriptors - Parent in Military

Student Characteristic Descriptors - SATA

Student Characteristic Descriptors - Single Parent

Race Descriptors

Digital Access

Digital Device

Internet Access in Residence

Internet Access Type in Residence

Internet Performance

Appendix A: Additional Logic

Related Articles