Student Demographic Data
This category/view captures the core student demographic record and contains identifying information as published in the Student resource within the Student category. 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, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
Each student must first have an assigned Unique Person Identifier (State Number) in order for the student record to be published; the Ed-Fi publishing process automatically requests a Unique ID when needed. 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
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_TN_STU_X]
- [S_TN_STU_StuClassification_C]
Selection Criteria
Records are published if the following criteria are met:
- StudentUniqueId 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.
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.
- Beyond StudentUniqueId, additional student identifiers including local student ID, PIN and Previous PIN are also output in the StudentIdentificationCode complex type.
- 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. | [CST_PubUniqueIdStudent]UniqueId Derived from: [Students]DCID | M | |
studentIdentificationCode (0-many) | R | |||
/identificationCode | A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or resource. SSN/PIN: If TN_ReportSSN = ‘Y’ and the student’s SSN is populated, then the student’s SSN is published. If the student’s SSN is not populated, then the student’s PIN is published, if it exists. If the student’s SSN and PIN are both blank, then the entire student record is not published and is marked with a dependency of “Missing SSN/PIN.” If TN_ReportSSN = ‘N’ and the student’s PIN is populated, then the student’s PIN is published. If the student’s PIN is not populated, then the entire student record is not published and is marked with a dependency of “Missing SSN/PIN.” | Varchar(60) | State: [Students]State_StudentNumber Local: [Students]ID PIN: [S_TN_STU_X]StudentPIN Previous PIN: [S_TN_STU_X]PrevStudentID SSN: [Students]SSN Previous SSN: [S_TN_STU_X]PrevSSN | M |
/studentIdentification | A coding scheme used for identification and record-keeping purposes by schools, social services, or other agencies. | Enumerated Type | ‘State’ if assigned by State ‘District’ if assigned by District (Local Student ID) ‘PIN’ if Student PIN ‘Prev PIN’ if Previous Student PIN ’SSN’ if Student SSN ‘Prev SSN’ if Previous Student SSN | M |
/assigningOrganization | The organization code or name assigning the student Identification Code. | Varchar(60) | SEAId for State Student Number, PIN, Previous PIN, SSN, and Previous SSN: ‘47’ LEA Id for Local Student ID | R |
name | R | |||
/firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | Varchar(75) | [Students]First_Name | R |
/middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | Varchar(75) | [Students]Middle_Name | O |
/lastSurname | The name borne in common by members of a family. | Varchar(75) | [Students]Last_Name | R |
/generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., or III. Valid Values: Sr, Jr, I, II, III, IV | Varchar(75) | [S_TN_STU_X]NameSuffix | O |
otherName (0-many) Other names associated with a person, for example, alias, nickname, or previous legal name. Note: When “Previous Legal Name” is published, at least one of PrevFirstName or PrevLastName must not be blank; if either (but not both) is blank, the student’s current FirstName or LastName will be used for the blank field. | O | |||
/firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | Varchar(75) | [S_TN_STU_X]PrevFirstName | R |
/middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | Varchar(75) | [S_TN_STU_X]PrevMiddleName | O |
/lastSurname | The name borne in common by members of a family. | Varchar(75) | [S_TN_STU_X]PrevLastName | R |
/generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., or III. Valid Values: Sr, Jr, I, II, III, IV | Varchar(75) | [S_TN_STU_X]NameSuffix | O |
/otherNameType | The types of alternate names for a person. | Enumerated List | ‘Previous Legal Name’ | M |
sex | A person’s gender: Female or Male. | Enumerated List | [Students]Gender Default = ‘Male’ | R |
birthData The set of elements that capture relevant data regarding a person’s birth, including birth date and place of birth. | R | |||
/birthDate | The month, day, and year on which an individual was born. | Date | [Students]DOB | R |
address (1-many) | R | |||
/streetNumberName | The street number and street name or post office box number of an address. | Varchar(150) | Physical: [Students]Street Mailing: [Students]Mailing_Street | R |
/city | The name of the city in which an address is located. | Varchar(30) | 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. | Enumerated List | Physical: [Students]State Mailing: [Students]Mailing_State | R |
/postalCode | The five- or nine-digit zip code portion of an address. | Varchar(17) | Physical: [Students]Zip Mailing: [Students]Mailing_Zip | R |
/addressType | The type of address listed for an individual or organization, for example, Physical Address, Mailing Address, Home Address. | Enumerated Type | ‘Physical’ or ‘Mailing’ | M |
telephone (1-many) | R | |||
/telephoneNumber | The 10-digit telephone number, including the area code, for the person. | Varchar(24) | [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. | Enumerated List | ‘Home’ ‘Emergency 1’ ‘Emergency 2’ If Doctor_Phone: ‘Other’ | M |
electronicMail (1-many) | R | |||
/electronicMailAddress | The electronic mail (e-mail) address listed for an individual or organization. | Varchar(128) | [PSM_StudentContact]email where [PSM_StudentContactType] = ‘Self’ [Sync_StudentMap] | R |
/electronicMailType | The type of email listed for an individual or organization, for example, Home/Personal, Work. | Enumerated List | 'Home/Personal' | M |
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 | R |
oldEthnicity | Previous definition of Ethnicity combining Hispanic/Latino and race. | Enumerated List | [Students]Ethnicity [Gen]Value where cat=’ethnicity’ | O |
race (1-many) | The racial categories which most clearly reflect the individual’s recognition of his or her community or with which the individual most identifies. | Enumerated List | [StudentRace]RaceCD [Gen]Name where cat=’federalrace’ | R |
economicDisadvantaged | An indication of inadequate financial condition of a student'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_TN_STU_StuClassification_C]ClassificationType L: ‘True’; else ‘False’ | R |
schoolFoodServicesEligibility | SchoolFoodServicesEligibilityDescriptor - An indication of a student's level of eligibility for school food programs. | Descriptor | [S_TN_STU_LunchClassification_C]ClassificationType X: 'Free’ Z: ‘Full Price’ Y: ‘Reduced’ Default: ‘Unknown’ | R |
studentCharacteristic (1-many) Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth. For Tennessee, the expanded set of student characteristics includes Student Classifications such as Regular, Alternative, Fee-Based P3-P4, and Adult. For more information, refer to the Student Characteristic Types Descriptor on the Ed-Fi Reporting page. | R | |||
/characteristic | Characteristics of the student’s home situation and other Tennessee student classifications. | Descriptor | Immigrant: [S_TN_STU_X]ImmigrantStudent Other Characteristics: [S_TN_STU_StuClassification_C]ClassificationType Each classification code is mapped to the appropriate Ed-fi Descriptor | M |
/beginDate | The date the characteristic was designated. | Date | [S_TN_STU_StuClassification_C]BeginDate | O |
/endDate | The date the characteristic was removed. | Date | [S_TN_STU_StuClassification_C]EndDate | O |
limitedEnglishProficiency | An indication that the student has been identified as limited English proficient. | Descriptor | [S_TN_STU_X]ELB [S_TN_REN_X]ELB | O |
language Defines the language(s) that are spoken or written. | R | |||
/language | The language(s) the individual uses to communicate. | Descriptor | [S_TN_STU_X]NativeLanguage If ‘spa’: ‘01’ (Spanish) If ‘eng’: ‘02’ (English) Default: ‘03’ (Other) | M |
cohortYear | C | |||
/cohortYearType | Enumeration items for the set of cohort years, for example, ninth grade, twelfth grade. | Enumerated Type | ‘Ninth Grade’ | M |
/schoolYear | The school year of the cohort. | Enumerated Type | [S_TN_STU_X]YearEnteredNinthGrade | M |
firstSchoolEnrollmentDate | The date on which the student was first enrolled in a school in the US. | Date | [S_TN_STU_X]DateFirstEnrolledInUsSchool | C |
birthCountyFIPSCode | The student’s county of birth, if applicable | Integer | [S_TN_STU_X]CountyBirthCode | C |
homelessResidence | HomelessResidenceDescriptor - The primary nighttime residence for a Homeless student. This is only published if student is homeless. | Descriptor | [S_TN_STU_X]HomelessPrimaryNightTimeRes [S_TN_REN_X]HomelessPrimaryNightTimeRes | C |
eisEnrollmentYear | Confirmation of the student’s enrollment in SIS/EIS | Integer | The current school year (e.g. 2016 for the 2015-16 school year) | R |