Students
This category captures the core student demographic record and contains identifying information as published in the students resource. The Student Demographics category includes the following data views and resources.
A student is a person who has been enrolled in a school or other educational institution. Each student must first have an assigned Unique Person Identifier (Indiana State Number) to publish the student record. The publishing of all other student-related Ed-Fi data is dependent on the successful publishing of the student record.
Districts can publish Student Resources on the basis of the current selection by selecting PUBLISH SELECTION - Publish records for current student selection. This option does not work if it is scheduled to run at a later time.
Student Identification
students
Primary PowerSchool Source Data
- [Students]
- [S_IN_STU_X]
- [S_STU_X]
- [STUDENTCOREFIELDS]
- [S_IN_REN_X]
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- The studentUniqueID (Indiana Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
- 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.
- The student must not have one-day mobility records.
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.
- Only the student records after the school calendar's first day are included.
- 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 | [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]PSCore_Legal_First_Name, if unavailable [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, if unavailable [Students]Middle_Name | O |
LastSurname | The name borne in common by members of a family. | String | [StudentCoreFields]PSCore_Legal_Last_Name, if unavailable [Students]Last_Name | R |
| generationCodeSuffix | The suffix of the student's legal name. For example, Senior - Sr., Junior - Jr., etc. | String | [S_IN_STU_X]Student_Name_Suffix [StudentCoreFields]PSCore_Legal_Suffix, if unavailable | O |
birthCountryDescriptor | The unique code for the country in which an individual is born. | Descriptor | [S_IN_STU_X]Country_Of_Origin [S_IN_STU_X]non_us_origin_tf | O |
birthDate | The month, day, and year in which an individual was born. | Date | [Students]DOB Format: 'YYYY-MM-DD' | R |
| birthSexDescriptor | A person’s gender: Female or Male. Valid values:
| Type | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender | R |
additional fields for display only | ||||
/schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level | |
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. For each student enrolled in the district in the current year, the published view layout provides the School Name, Student Number, Student Name, STN Number, Gender, Grade Level, Enroll Status (indicates whether the student is active or inactive), Last Publish Date, Publishing ID, and Resource ID.
StudentEducationOrganizationAssociation
Primary PowerSchool Source Data
[Students]
- [S_IN_STU_X]
- [S_STU_X]
- [STUDENTCOREFIELDS]
- [S_IN_REN_X]
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- The studentUniqueID (Indiana Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
- 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.
- The student must not have one-day mobility records.
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.
- Only the student records after the school calendar's first day are included.
- The students 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 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
| educationOrganizationId | The Education Organization associated with the program. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
studentUniqueID | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
addresses An unordered collection of studentAddresses. The set of elements that describes an address, including the street address, city, state, and zip code. | ||||
/addressTypeDescriptor | The type of address listed for an individual or organization, for example, Physical Address or Mailing Address. | String | 'Physical' 'Mailing' | R |
| /apartmentRoomSuiteNumber | The apartment number. | String | [Students]Street [Students]Mailing_Street | |
/streetNumberName | The street number and street name or post office box number of an address. | String | [Students]Street [Students]Mailing_Street | R |
/city | The name of the city in which an address is located. | String | [Students]City [Students]Mailing_City | R |
/stateAbbreviationDescriptor | The 2-character abbreviation for the state (within the United States) or outlying area in which an address is located. | Type | [Students]State [Students]Mailing_State | R |
/postalCode | The five- or nine-digit zip code portion of an address. | String | [Students]Zip [Students]Mailing_Zip | R |
| /NameOfCounty | The county where the residence is located. | String | [S_IN_STU_X]county_residence | O |
| /periods | ||||
| /beginDate | The entry date of the current enrollment. | date | ||
| /endDate | The exit date of the current enrollment. | date | ||
electronicMails | O | |||
/electronicMailType | The type of email listed for an individual. | Type | 'Home/Personal' | R |
/electonicMailAddress | The electronic mail (e-mail) address listed for an individual or organization. | String | [PSM_StudentContact]Email where [PSM_StudentContactType] = ‘Self’ | R |
limitedEnglishProficiency | An indication that the student has been identified as limited English proficient. | Descriptor | [S_IN_STU_X]LMS
| 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." | [STUDENTS]fedethnicity | R | |
| languages | ||||
| /languageDescriptorid | The language(s) the individual uses to communicate. | Descriptor | [S_IN_STU_X]native_language_code | R |
//languageUseType | How the language is used, for example, Home Language, Native Language, Spoken Language. | Type | 'Home Language' | R |
races An unordered collection of studentRaces. The general racial category that 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. | O | |||
/raceDescriptor | The racial categories that most clearly reflect the individual’s recognition of his or her community or with which the individual most identifies. | String | [STUDENTS]fedethnicity, [StudentRace]RaceCD
| R |
| sexDescriptor | A person’s gender: Female or Male. Valid values:
| Type | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender | R |
| IDOE extensions | ||||
| /ellInstrumentUsedDescriptor | The instrument used for English Proficiency Level. | [s_in_stu_lm_c]instrument_used | ||
| /usInitialSchoolEntry | Entry date of a migrant student to a school. | Date | [S_STU_X]entrydateintoUSschool | |
| additional fields for display only | ||||
schoolname | The name of the school | String | [sch]school_name | |
/studentnumber | The student associated with the program. | Integer | [Students]student_number | |
/studentname | The student's name. | String | [Students]lastfirst | |
/gradelevel | Grade level of the most recent enrollment in the selected year. | Integer | [ReEnrollments]grade_level | |