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 (Michigan State Number) 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 data view 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. 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, and UIC (Unique Person Identifier).
students
Primary PowerSchool Source Data
- [Students]
- [S_MI_STU_GC_X]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId (Michigan Student Number) 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 ExitDate is greater than the EntryDate.
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 has also 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 Ed-Fi 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 | 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 | [Students]First_Name | R |
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | String | [Students]Middle_Name | O |
lastSurname | The name borne in common by members of a family. | String | [Students]Last_Name | R |
generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III. | String | [S_MI_STU_GC_X]stuNameSuffix | O |
sexType | A person's gender: Female or Male. | Type | [Students]Gender
| R |
birthDate | The month, day, and year on which an individual was born. | Date | [Students]DOB | R |
birthCity | The city in which the individual was born. | String | [S_MI_STU_GC_X]immPlaceOfBirth | O |
multipleBirthStatus | Indicator of whether the student was born with other siblings, for example, twins, triplets, etc. | Boolean | [S_MI_STU_GC_X]multipleBirth | 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 | [S_MI_STU_GC_X]ethnicHispanic | R |
oldEthnicityType | Previous definition of Ethnicity combining Hispanic/Latino and race. | Type | [Students]Ethnicity | O |
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 | [Students]LunchStatus
| O |
schoolFoodServicesEligibilityDescriptor | An indication of a student's level of eligibility for school food programs. | Descriptor | [Students]LunchStatus
Otherwise,
| O* |
limitedEnglishProficiencyDescriptor | An indication that the student has been identified as limited English proficient. | Descriptor | [S_MI_STU_GC_X]lepStatus
| O |
birthCountryDescriptor | The unique code for the country in which an individual is born. | Descriptor | [S_MI_STU_GC_X]immCountryOfBirth | O |
yearOfEntry | For students born outside of the US, the date the student entered the US. | Integer | [S_MI_STU_GC_X]immEntryYear | O* |
homelessDescriptor | The unique code for the student's homeless status. | Descriptor | [S_MI_STU_GC_X]homelessStatus
| O |
Address (0-many) | O | |||
/addressType | The type of address listed for an individual or organization, for example, Physical Address or Mailing Address. | Type | 'Physical' or 'Mailing' | R |
/streetNumberName | The street number and street name or post office box number of an address. | String | Physical: [Students]Street | R |
/city | The name of the city in which an address is located. | String | Physical: [Students]City | R |
/stateAbbreviationType | The 2-char abbreviation for the state (within the United States) or outlying area in which an address is located. | Type | Physical: [Students]State | R |
/postalCode | The five- or nine-digit zip code portion of an address. | String | Physical: [Students]Zip | R |
/county | nameOfCounty - The name of the county in which an address is located. |
| [S_MI_STU_GC_X]residentCounty | O |
StudentCharacteristic (0-many)
| O* | |||
/descriptor | studentCharacteristicDescriptor - Characteristics of the student's home situation, for example, Homeless, Unaccompanied Youth, Immigrant, and/or Migrant. | Descriptor | [S_MI_STU_GC_X]homelessStatus < 0
|
|
cohortYears | O | |||
/schoolYearTypeReference | R | |||
//schoolYearType | The school year of the cohort. | Type | [Students]ClassOf | R |
/cohortYearType | Enumeration items for the set of cohort years, for example, ninth grade, twelfth grade. | Type | Default = 'Twelfth grade' | O |
disabilities – studentDisability array (0-many) | O* | |||
/disabilityDescriptor | This descriptor defines a student's impairment. | Descriptor | [S_MI_STU_GC_X]sePriDisability |
|
/orderOfDisability | An indication if the disability is Primary, Secondary, Tertiary, etc. | Integer | [S_MI_STU_GC_X]seAddDisability
|
|
electronicMails | O | |||
/electronicMailType | The type of email listed for an individual. | Type | 'Home/Personal' |
|
/electonicMailAddress | The electronic mail (e-mail) address listed for an individual or organization. | String | PSM_StudentContact]Email |
|
identificationCodes (1-many) | O | |||
/studentIdentificationSystemDescriptor | A coding scheme used for identification and record-keeping purposes by schools, social services, or other agencies. | Descriptor | 'State' if assigned by State UIC |
|
/assigningOrganizationIdentificationCode | IdentificationCode - The organization code or name assigning the student Identification Code. | String | State: '84000' |
|
/identificationCode | A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity. | string | State: [Students]State_StudentNumber (UIC) |
|
languages (1-many) | O | |||
/languageDescriptor | The language(s) the individual uses to communicate. | Descriptor | [S_MI_STU_GC_X]lepLangPrimary |
|
/languageUseType | How the language is used, for example, Home Language, Native Language, Spoken Language. | Type | Derived based on the language field used
|
|
programParticipations (0-many) | O | |||
/programType | The program the student is associated with or receiving services from. | Type | All students: 'Regular Education' |
|
/enrollmentPercentage | The full-time equivalency (FTE) that the participant spends in the program reported. | Number | Regular Education: [S_MI_STU_GC_X]FTE Special Education: [S_MI_STU_GC_X]FTE52 Or |
|
/programParticipationStatusDescriptor | The status of the student's participation in the program. | Descriptor | English as a Second Language (ESL):
Neglected and Delinquent Program:
|
|
races (1-many) | RaceType - The racial categories which most clearly reflect the individual's recognition of his or her community or with which the individual most identifies. | Type | [S_MI_STU_GC_X]ethnicAsian | O |
telephones (0-many) | O | |||
/telephoneNumberType | The type of communication number listed for an individual. | Type | 'Home', 'Emergency 1', or 'Emergency 2', based on the value in telephoneNumber |
|
/telephoneNumber | The 10-digit telephone number, including the area code, for the person. | String | [Students]Home_Phone |
|