Students
This category captures the core student demographic records and contains identifying student information. The Students category includes the following data views and resources:
Each student must first have an assigned Unique Person Identifier (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.
LEAs and Schools can also review pending and published Ed-Fi reporting data for individual students from the student Ed-Fi Publishing page.
Student Identification
This view captures a detailed list of student identification data successfully published to the NDE. For each student enrolled in the district in the current year, the published view layout provides the School Name, Student Number, Student Name, State Identifier (State Student Number), State Gender, Grade Level, Last Publish Date, and the Publishing ID.
students
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]
Selection Criteria
Records are published if the following criteria are met:
- The studentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student must have an active school enrollment.
- 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 student's crisis event must have a start date within the current school year.
Resource Output
- A student record is published for each student 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 the Student Enrollment category 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 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. | Integer | [Students]State_StudentNumber | R |
firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | String | [StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name | R |
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | String | [StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name | O |
lastSurname | The name borne in common by members of a family. | String | [StudentCoreFields]PSCore_Legal_Last_Name [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 | [StudentCoreFields]PSCore_Legal_Suffix | O |
sexType | A person's gender: Female or Male. | String | [Students]Gender Default = 'Male' | R |
birthDate | The month, day, and year on which an individual was born. | Date | [Students]DOB | R |
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 If RaceCD = 'HI', 'true' is published; else, 'False' | R |
addresses (1-many) | R | |||
/addressType | The type of address listed for an individual or organization, for example, Physical Address, Mailing Address, Home Address. | String | 'Physical' or 'Mailing' | R |
/streetNumberName | The street number and street name or post office box number of an address. | String | Physical: [Students]Street Mailing: [Students]Mailing_Street | R |
/city | The name of the city in which an address is located. | String | Physical: [Students]City Mailing: [Students]Mailing_City | R |
/stateAbbreviation | The 2-char abbreviation for the state (within the United States) or outlying area in which an address is located. | String | Physical: [Students]State Mailing: [Students]Mailing_State | R |
/postalCode | The five- or nine-digit zip code portion of an address. | String | Physical: [Students]Zip Mailing: [Students]Mailing_Zip | R |
electronicMails (1-many) | R | |||
/electronicMailType | The type of email listed for an individual or organization, for example, Home/Personal, Work. | String | 'Home/Personal' | R |
/electronicMailAddress | The electronic mail (e-mail) address listed for an individual or organization. | String | [PSM_StudentContact]email where [PSM_StudentContactType] = 'Self' | R |
identificationCodes (0-many) | R | |||
/assigningOrganizationIdentificationCode | The organization code or name assigning the student Identification Code. | String | District: LEA Id if Local Number State: '1' | R |
/studentIdentificationSystemDescriptor | A coding scheme used for identification and record-keeping purposes by schools, social services, or other agencies. | String | State: 'District' if Local Number State: 'State' if State Number | R |
/identificationCode | A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity. | String | District: [Students]Student_Number State: [Students]State_StudentNumber | R |
telephones (1-many) | R | |||
/telephoneNumber | The 10-digit telephone number, including the area code, for the person. Note: Only the first 24 characters are published. | String | [Students]Home_Phone [Students]Emerg_Phone_1 [Students]Emerg_Phone_2 [Students]Doctor_Phone | R |
/telephoneNumberType | The type of communication number listed for an individual. | String | 'Home' 'Emergency 1' 'Emergency 2' If Doctor_Phone: 'Other' | R |
/orderOfPriority | The order of priority assigned to telephone numbers to define which number to attempt first, second, etc. | Integer | '1' '2' '3' | O |
Student Demographics
This view captures a detailed list of student demographic data successfully published to the NDE. For each student enrolled in the district in the current year, the published view layout provides the School Name, Student Number, Student Name, State Student Number, Gender, Grade Level, LEP Code, Language Code, Last Publish Date, and the Publishing ID.
studentEducationOrganizationDemographic
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]
Selection Criteria
Records are published if the following criteria are met:
- The studentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student must have an active school enrollment.
- 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.
Resource Output
- A student record is published for each student enrolled in the district in the year for the Term selected in the PowerSchool UI.
- The studentEducationOrganizationDemographic resource is dependent on the prior publishing of the following resources: students, studentSchoolAssociation
- 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 | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
educationOrganizationReference A reference to the educationOrganization resource. | R | |||
/educationOrganizationID | The education organization where the student is enrolled. | Integer | LEAID downloaded from State | R |
studentReference A reference to the students resource. | ||||
/studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | Integer | [Students]State_StudentNumber | R |
sexType | A person's gender: Female or Male. | String | [Students]Gender Default = 'Male' | R |
birthDate | The month, day, and year on which an individual was born. | Date | [Students]DOB | R |
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 If RaceCD = 'HI', 'true' is published; else, 'False' | R |
schoolFoodServicesEligibilityDescriptor | An indication of a student's level of eligibility for school food programs. | String | [S_NE_STU_X]Stud_Lunch_3 If blank, derived from: [Students]LunchStatus If value = F, FDC, or T, '1' is published If value = R or RDC, '2' is published Else, '0' | R |
limitedEnglishProficiencyDescriptor | An indication that the student has been identified as limited English proficient. | String | [S_NE_STU_LEP_X]EnglishProf | O |
highAbilityLearnerEligibility | Indication of whether the student has been identified as High Ability Learner. | Boolean | [S_NE_STU_X]GAT 1: 'True'; else 'False' | R |
highAbilityLearnerParticipant | Indication of whether the student is a High Ability Learner participant. | Boolean | [S_NE_STU_X]HAL_Participate1: 'True'; else 'False' | R |
honorsOrAdvancedPlacement | Indication of whether a student in grades 9 through 12 participated in an honors program or advanced placement classes in accordance with local school board policy. | Boolean | [S_NE_STU_X]Advance_Placement1: 'True'; else 'False' | R |
immigrantIndicatorDescriptor | The description that best reflects the student's immigrant status. | String | [S_NE_STU_LEP_X]Immigrant_Status Values of '1', '2' or '3' are published if populated Default: '0' (Not an immigrant) | R |
cohortYears (0-many) *Required for grades 9-12. | O* | |||
/schoolYearTypeReference A reference to the school year. | ||||
/cohortYear | The school year of the cohort. | Integer | [S_NE_STU_X]Expected_Grad_Year | R |
/cohortYearType | Enumeration items for the set of cohort years, for example, ninth grade, twelfth grade. | String | 'Ninth grade' | R |
languages Defines the language(s) that are spoken or written. | R | |||
/languageDescriptor | The language(s) the individual uses to communicate. | String | [S_NE_STU_LEP_X]Home_Language Default = '1290' (English) | R |
/languageUseType | How the language is used, for example, Home Language, Native Language, Spoken Language. | String | 'Dominant Language' | R |
| 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. | String | [StudentRace]RaceCD Leading and trailing spaces are stripped before converting to Ed-Fi descriptors.
| R |
studentCharacteristics (1-many) Reflects important characteristics of the student's home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth. | R | |||
/beginDate | The date the characteristic was designated. | Date | If characteristic is 'Homeless' then [SpEnrollments]Enter_Date All other characteristics use the most recent entry date at the published school in the selected school year. [Students]EntryDate | R |
/descriptor | 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. | String | [S_NE_STU_X]Military_Family_Ind: 'Parent in Military' [S_NE_STU_X]Single_Parent: 'Single Parent' [Students]Ward_of_State: 'Ward of the State' [Students]Foreign_Exchange: 'Foreign Exchange' [S_NE_STU_X]Dir_Info_Optout: 'Directory Information Opt Out' If [Students]Grade_Level is less than 0 or a reenrollment record exists where [ReEnrollments]Grade_Level is less than 0: 'Attended Preschool' | R |
studentCrisisEvent Reflects the crisis events that have affected the student. | ||||
/crisisEventDescriptor | The specific event that affected the student. | String | [S_STU_CrisisEvent_C]EventDescriptor | R |
/displacedStudentIndicator | An indication that the student was displaced from their home due to the crisis. The student may or may not be considered homeless due to the displacement. | Boolean | [S_STU_CrisisEvent_C]DisplacedIndicator | R |