Student Demographics
This category captures the core student demographic record and contains identifying information as published in the student resource. The Student Demographics category includes the following data views and resources:
Each student must first have an assigned Unique Person Identifier (Wisconsin State Number/WISEid) in order for the student record to be published. In turn, the publishing of all other student-related Ed-Fi data is dependent on the successful publishing of the student record; as needed, use the "Publishing Errors" data view to identify and resolve any issues.
Student Demographics
This view captures the core student demographic record and contains identifying information as published in the Student resource. For each student enrolled in the district in the current year, the published view layout provides the School Name, Student Number, Student Name, Gender, Grade Level, Wisconsin Student Number, Last Publish Date, and the Publishing ID.
student
This resource 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.
Primary PowerSchool Source Data
- [Students]
- [S_WI_STU_X]
Selection Criteria
Records are published if the following criteria are met:
- The studentUniqueId (Wisconsin Student Number/WISEid) must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student's school of enrollment must not be excluded from state reporting.
- The student must have at least one school enrollment with an Entry Date that falls within the date range defined by [Terms]FirstDay and [Terms]LastDay for the year of the Term selected in the PowerSchool UI.
- The enrollment exit date is greater than the entry date.
Resource Output
- A student record is published for each student who meets the selection criteria, and who is enrolled in the district in the year for the Term selected in the PowerSchool UI.
- The student resource is not dependent on the prior publishing of other Ed-Fi resources.
Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in Student Enrollments category has been uploaded for the same student.
- This establishes a relationship between the school, the associated LEA, and the student.
- The LEA then has permission to modify the previously uploaded student record.
- LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | String | [StudentCoreFields]PS_Core_Legal_First_Name if populated Otherwise: [Students]First_Name | R |
lastSurname | The name borne in common by members of a family. | String | [StudentCoreFields]PS_Core_Legal_Last_Name if populated Otherwise: [Students]Last_Name | R |
sexType | A person’s gender: Female or Male. | String | [StudentCoreFields]PS_Core_Legal_Gender if populated Otherwise: [Students]Gender
| R |
birthDate | The month, day, and year on which an individual was born. | Date-time | [Students]DOB | R |
dateEnteredUS | For students born outside of the US, the date the student entered the US. *If applicable to the student, this element is required. | Date-time | [Students]DateOfEntryIntoUSA | O* |
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." | Boolean | [Students]FedEthnicity If blank, derived from: [StudentRace]RaceCD [Gen]Name where cat=’federalrace’ If Federal Ethnicity = 1 or Race Code = HI, ‘true’ is published; else, ‘false’ | R |
economicDisadvantaged | 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. | Boolean | [S_WI_STU_X]Economic_Status If blank, derived from: [Students]LunchStatus
| R |
schoolFoodServicesEligibilityDescriptor | An indication of a student's level of eligibility for school food programs. *This element is required if economicDisadvantage = ‘True’; otherwise, it is excluded from publishing. | String | [S_WI_STU_X] Economic_Status If blank, derived from: [Students]LunchStatus
| R* |
limitedEnglishProficiencyDescriptor | An indication that the student has been identified as limited English proficient. | String | [S_WI_STU_X]EnglishProfCode PowerSchool codes 1-7 are mapped to the corresponding descriptor short code numeric value. | R |
characteristics – studentCharacteristics array (0-many) Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth, etc. | O | |||
/studentCharacteristicDescriptor | Characteristics of the student’s home situation, for example, Displaced Homemaker, Immigrant, Migratory, Military Parent. If a specific Characteristic does not apply to the student, no value is published. Note: For Choice Students, the only current valid value is ‘SATA’, which is required if applicable to the student. If the student is flagged as taking an alternate assessment (code ‘TA’), ‘SATA’ is published; otherwise, this element is excluded from publishing. | String | [S_WI_STU_X]State_Assessment_Type_SATA = 1: ‘SATA’ [S_WI_REN_X]State_Assessment_Type_SATA = 1: ‘SATA’ Public Schools:
Note: Homeless is only reported for school year 2017-18 and earlier. Parent in Military and Single Parent is only reported for school year 2018-19 and later. | O |
disabilities – studentDisability array (0-many) This type represents an impairment of body structure or function, a limitation in activities, or a restriction in participation, as ordered by severity of impairment. Note: Disability is only published for Choice schools. Public schools include disabilities in SPED Program data. *Disability is required if applicable to the student; otherwise, the array is excluded from publishing. | O* | |||
/disabilityDescriptor | This descriptor defines a student’s impairment. | Descriptor | [Students]DisabilityCode [S_WI_STU_X]SecondaryDisability Primary Disability is published only if DisabilityCode is not ‘N’ or blank. Secondary Disability is published if value is not ‘N’ or blank, as long as Primary Disability is not ‘N’, ‘SDD’, or blank. SecondaryDisability may include multiple codes separated by comma or colon. | R |
/orderOfDisability | An indication if the disability is Primary, Secondary, Tertiary, etc. | Integer | ‘1’ (Primary) ‘2’ (Secondary) ‘3’ (Tertiary) | R |
language (1-many) Defines the language(s) that are spoken or written. Note: Language is only reported for public schools. | O | |||
/language | The language(s) the individual uses to communicate. | Descriptor | [Students]PrimaryLanguage | O |
/languageUse (0-many) | How the language is used, for example, Home Language, Native Language, Spoken Language. | Enumerated List | Derived based on the language field used. | O |
races array (1-many) Defines the student's racial categories. | R | |||
/studentRace | The racial categories which most clearly reflect the individual’s recognition of his or her community or with which the individual most identifies. | String | Derived from: [StudentRace]RaceCD
| R |
visaType | An indicator of a non-US citizen's visa type. | String | [S_WI_STU_X]Visa_Type [S_WI_REN_X]Visa_Type | O |
wiDpiStudentResidentEducation | A reference to the releated educationOrganizationReference. This is the LEA ID. Required for non-district 2R charter schools. For other districts, if not provided, the resident district will be identified as the reporting district. | Reference | If [Students]DistrictOfResidence matches the value in [Cst_PubOrganization]EduOrgId or [Cst_PubOrganization]AlternateId AND [Cst_PubOrganization]InstitutionType = 'LEA' Then [Cst_PubOrganization]EduOrgId | O |