Student Identification

A basic unit in the Ed-Fi system is the Student table. It simply holds the State Student ID and with that, a surrogate key called the Student USI. The Student USI is the key used when data is loaded into other Ed-Fi-related tables such as enrollment, demographics, and programs. The Student table also requires the name, birthdate, and gender of the student. However, these are only used to validate the State Student Identifier in the record. The State Student Identifier must match one in the eScholar system with an identical name, birthdate, and gender.

Selection Criteria

The student must not be excluded from state reporting.
The students who are enrolled in school are not excluded from state reporting.

Data Review

Field	Selection
Choose Dashboard	Student Identification
Choose Category	Student ID info Summary Student ID info Published Student ID info Dependencies Student ID info Errors
Choose Data view	Statistical Summary Student ID

Resource Output

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.
See the Data Publishing > Published Resource > Resource Details to view the data elements that are not available in the Data View Column.

Ed-Fi Data Element	Description	Data View Column	Submission	[Table] Field Name	Business Rules
StudentUniqueId	A unique identifier assigned to each student within the education system.	State Identifier	Required	[Students]State_StudentNumber	Not applicable.
LastSurname	The student's last name or surname.	Student Legal Name Note: concatenated (Last Name, First Name Middle)	Required	[S_KS_STU_Demographic_X]Legal_Last_Name	Not applicable.
FirstName	The student's first name	Student Legal Name Note: concatenated(Last Name, First Name Middle)	Required	[S_KS_STU_Demographic_X]Legal_First_Name	Not applicable.
MiddleName	The student's middle name, if applicable.	Student Legal Name Note: concatenated((Last Name, First Name Middle)	Optional	[S_KS_STU_Demographic_X]Legal_MiddleName	Not applicable.
GenerationCodeSuffix	A suffix used to distinguish between individuals with the same name, such as "Jr." or "III"	Generation Code	Optional	[S_KS_STU_Demographic_X]Generation_Code	Not applicable.
BirthSexDescriptor (SexDescriptor)	A code or label that describes the student's sex at birth, such as "Male" or "Female	Gender	Optional	[Students]Gender	Not applicable.
BirthDate	The student's date of birth	DOB	Required	[Students]DOB	Not applicable.
BirthCountryDescriptor (CountryDescriptor)	A code or label that describes the country where the student was born	Country of Birth	Optional	[S_KS_STU_Demographic_X]Country_Of_Birth	Not applicable.