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.

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	Data View Column	Submission	[Table] Field Name	Business Rules
StudentUniqueId	State Identifier	Required	[Students]State_StudentNumber	Not applicable.
LastSurname	Student Legal Name Note: concatenated (Last Name, First Name Middle)	Required	[S_KS_STU_Demographic_X]Legal_Last_Name	Not applicable.
FirstName	Student Legal Name Note: concatenated(Last Name, First Name Middle)	Required	[S_KS_STU_Demographic_X]Legal_First_Name	Not applicable.
MiddleName	Student Legal Name Note: concatenated((Last Name, First Name Middle)	Optional	[S_KS_STU_Demographic_X]Legal_MiddleName	Not applicable.
GenerationCodeSuffix	Generation Code	Optional	[S_KS_STU_Demographic_X]Generation_Code	Not applicable.
BirthSexDescriptor (SexDescriptor)	Gender	Optional	[Students]Gender	Not applicable.
BirthDate	DOB	Required	[Students]DOB	Not applicable.
BirthCountryDescriptor (CountryDescriptor)	Country of Birth	Optional	[S_KS_STU_Demographic_X]Country_Of_Birth	Not applicable.