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 (SC 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.
No show records will be published for students that have the same entry and exit date, except for studentSchoolAssociations and studentAssessmentRegistrations.
Student Demographics
This data view represents an individual for whom instruction, services, and/or care are provided in early childhood, an 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_STU_X ]
[STUDENTCOREFIELDS]
Selection Criteria
Records are published if the following criteria are met:
StudentUniqueId (SC 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.
The student must have an active enrollment.
Noshow and Summer graduates are published.
Summer graduates are published in the subsequent year.
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 |
|---|---|---|---|---|
Name | ||||
/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_SC_STU_X]StudentGeneration | O |
educationOrganizationReference | ||||
educationOrganizationId | The state-assigned school ID. | [STUDENTS]schoolid [STUDENTS]enrollment_schoolid [REENROLLMENTS]schoolid | ||
studentReference | ||||
studentUniqueId | A unique code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
addresses | ||||
addressTypeDescriptor | Indicates whether home or mailing address. | Home, Mailing | ||
apartmentRoomSuiteNumber | The apartment rumber. | [Students]street [Students]mailing_street | ||
streetNumberName | The name and number of the street. | [Students]street [Students]mailing_street | ||
city | The name of the city. | [Students]city [Students]mailing_city | ||
stateAbbreviationDescriptor | The two-letter state abbreviation. | [Students]state [Students]mailing_state [Students]mail_zip | ||
postalCode | The five digit zip code. | [pa]postalcode | ||
nameOfCounty | The name of the county. | [S_SC_STU_X]County | ||
cohortYears | ||||
cohortYearTypeDescriptor | Ninth Grades | |||
schoolYearTypeReference | yearpart(sysdate,1,2)) concated with [S_SC_STU_X]ninthGradeCode | |||
disabilities | ||||
disabilityDescriptor | Description of the type of disability: HR - Hearing Impairment THK - Mental impairment WK - Motor impairment IWO, OTH, or CFO - Other BH, ET, LT, PMT, or WOK - Physical Disability SK - Speech or Language Impairment LN - Specific Learning Disability' SE - Visual Impairment, including Blindness | [S_SC_STU_X]Plan504Code | ||
designations | ||||
/disabilityDesignationDescriptor | [S_SC_STU_X]Plan504Code =* then disabilityDesignationDescriptor='Section 504 | |||
disabilityDiagnosis | [S_SC_STU_X]Plan504Code | |||
electronicMails | ||||
/electronicMailTypeDescriptor | [PSM_STUDENTCONTACT]email | |||
/electronicMailTypeDescriptor | [PSM_STUDENTCONTACT]email | |||
/electronicMailAddress | [PSM_STUDENTCONTACT]email | |||
/electronicMailAddress | [U_SCDE_STU_X]Postgrad_Stu_Email | |||
hispanicLatinoEthnicity | [Students]fedethnicity | |||
languages | ||||
/languageDescriptor | [S_SC_STU_X]First_Lang_Spoken | |||
/uses | If [S_SC_STU_X]First_Lang_Spoken hen languageUseDescriptor= Native Language If [S_SC_STU_X]Written_Commun_Lang then languageUseDescriptor= Correspondence Language | |||
/races | [STUDENTRACE]racecd | |||
sexDescriptor | [Students]Gender | |||
studentCharacteristics | [S_SC_STU_X]Foster_Screener | |||
studentCharacteristics | [S_SC_STU_X]Foster_Home | |||
studentIdentificationCodes | ||||
/studentIdentificationSystemDescriptor | [Students]State_StudentNumber = State [Students]Student_Number = District | |||
/studentIdentificationSystemDescriptor | [Students]DCID if not null | |||
/studentIdentificationSystemDescriptor | [Students]ID if not null | |||
/identificationCode | [Students]DCID | |||
/identificationCode | [Students]ID | |||
assigningOrganizationIdentificationCode | 1 followed by the state-assigned number for district | |||
IndicatorName | The list of Indicator names. | |||
BirthData | ||||
/birthCity | The city in which the individual was born. This is required if the student is an immigrant. | String | [S_STU_X ]birthcity | O |
/countryDescriptor | The unique code for the country in which an individual is born. | [S_SC_STU_X]Student_BirthCntry | ||
/birthDate | The month, day, and year on which an individual was born. | Date | [Students]DOB | |
/birthSexDescriptor | Student's gender. Valid values:
| Type | [STUDENTCOREFIELDS]pscore_legal_gender | R |
multiplebirthstatus | Indicates whether the student was born with other siblings, for example, twins, triplets, etc. | S_SC_STU_X.multiple_birth | ||
sexDescriptor | ||||
studentCharacteristics |
| [S_SC_STU_X]Foster_Screener | ||
telephones | ||||
/telephoneNumberTypeDescriptor | Indicates whether home or emergency number. | Home, Emergency 1, Emergency 2 | ||
/telephoneNumber | The phone and emergency phone numbers. | [Students]home_phone | ||
internetAccessInResidence | Indicates whether the residence has internet access | [s_stu_learningpref_c]internetinresidence 1 - true 2,3, or 4 False | ||
/internetPerformanceInResidenceDescriptor | [s_stu_learningpref_c]internetperformance | |||
/internetPerformanceInResidenceDescriptor | The type of internet connection. | If s_stu_learningpref_c.internetaccess is "1" then internetAccessTypeInResidenceDescriptor = "Residential Broadband (e.g., DSL, Cable, Fiber)", | ||
/primaryLearningDeviceAccessDescriptor | The student’s access to a device with internet access. | If s_stu_learningpref_c.deviceaccess is "1" then PrimaryLearningDeviceAwayFromSchoolDescriptor = "Personal - Dedicated (one person per machine)"; | ||
/primaryLearningDeviceAwayFromSchoolDescriptor | The type of device the student accesses the internet. | If s_stu_learningpref_c.devicetype is "1" then primaryLearningDeviceAwayFromSchoolDescriptor = "Desktop/Laptop", | ||
OtherName | ||||
/OtherNameTypeDescriptor | ||||
/FirstName | Student's legal first name. | [STUDENTCOREFIELDS]pscore_legal_first_name | ||
/MiddleName | Student's legal middle name. | [STUDENTCOREFIELDS]pscore_legal_middle_name | ||
/LastName | Student's legal last name. | [STUDENTCOREFIELDS]pscore_legal_last_name | ||
/generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III in the legal name suffix field. | [STUDENTCOREFIELDS]pscore_legal_suffix | ||