Student Identification

students

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.

eSP Source Data

Tables: REG (r), REG_PERSONAL (rp), REG_ENTRY_WITH (rew), REG_BUILDING (rb), REG_USER (ru), REG_PROGRAMS (rps)

Selection Criteria

Includes any student with an enrollment entryDate in the current school year for a published school:

One record for each student with at least one studentSchoolAssociation in the current school year at a published school
Student must have ADA value (reg_programs.program_value, program_id 146, field_number 4) for current school year
Excluded if student marked for exclude from reporting or from Ed-Fi

Students who attended the previous year but not this year (Status A Leavers) are not published here

Published in AsOfStatusALeavers, which includes the identifying info normally included in Students

Charter school waitlisted students are not published here

Published in StudentApplications, which includes the identifying info normally included in Students
Does not include a StudentUniqueId reference
See waitlisted students selection criteria in StudentApplications resource

ChildFind students are all published here

Those who are not enrolled are not published in StudentSchoolAssociations
- Non-enrolled must be published in studentEdcationOrganizationResponsibilityAssociations
- Responsibility = 'Evaluation'
- Not required for ChildFind students who are enrolled
All ChildFind students are published in studentSpecialEducationProgramEligibilityAssociations
- Resource doe not have name and DOB
- It does have a StudentUniqueId reference
See ChildFind selection criteria in studentSpecialEducationProgramEligibilityAssociations resource

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
students
	studentUniqueId		E1523	TX-UNIQUE-STUDENT-ID	ru.field_value where ru.screen_number = 10165, ru.field_number = 1	Y	publish state-assigned number for student If student doesn't have uniqueid defined, attempt publishing and get dependency error
	firstName		E0703	FIRST-NAME	r.first_name	Y
	middleName		E0704	MIDDLE-NAME	r.middle_name	N	only if middle name is defined
	LastSurname		E0705	LAST-NAME	r.last_name	Y
	birthDate		E0006	DATE-OF-BIRTH	r.birthdate	Y
	birthSexDescriptor				r.gender	N	Mar 2022: values changed from '01', '02' to 'M', 'F'
	birthCity				rp.birth_city	N
	birthStateAbbreviationDescriptor				rp.birth_state	N
	birthCountryDescriptor				rp.birth_country	N
	TX extensions
		generationCodeDescriptor	E1303 E0706	GENERATION-CODE-SUFFIX GENERATION-CODE	r.generation single-char code, don't left-zero-pad to 2 chars	N	only if value is defined - changed to descriptor Oct 1 spec C012 vlaidation table REGTB_GENERATION, use state_code_equiv
		localStudentId	E0923	LOCAL-STUDENT-ID	reg.studentid	TX
		studentId	E0001	STUDENT-ID	rp.state_report_id	TX	dependency if missing
		asOfStatusLastFridayOctoberDescriptor	E3007		TX_101.As_Of_Status where submission_type = 1	TX	added Feb 7, 2022 webinar
		asOfStatusLastDayEnrollmentDescriptor	E3006		TX_101.As_Of_Status where submission_type = 3	TX	added Feb 7, 2022 webinar
		studentDoNotReportTSDS	E3009		Not available in eSP	TX	Default to false
		censusBlockGroupSets			[Array]	TX
		studentCensusBlockGroup	E1648	STUDENT-CENSUS-BLOCK-GROUP	ru.field_value where ru.screen_number = 10195, ru.field_number = 1	TX	This is the correct field number for Census Block
		beginDate	E3010		based on physical address, use school year start	TX	Not currently stored in eSP
		endDate	E3020		Day after last day of school year	TX	Not currently stored in eSP
		crisisEvents			[Array]	TX
		crisisEventDescriptor	E1054	CRISIS-CODE	rps.program_value where rps.program_id = '146', rps.field_number = 27	TX	Descriptor values (Dec 1, 2021): '00' - Student Was Not Affected By A Health Or Weather Related Crisis '10A' - Student Enrolled Not In Membership Virtual Learning On January 14, 2022 '10B' - Student Enrolled Not In Membership Virtual Learning On May 13, 2022
		beginDate	E3010		rps.start_date where rps.program_id = '146', rps.field_number = 27	TX
		endDate	E3020		rps.end_date where rps.program_id = '146', rps.field_number = 27	TX	TEA: Day after last day of applicability Publish date as entered by user
	additional fields for display only
					reg_building.name		district view only - most recent enrolled school in selected year
							grade level from most recent enrollment in selected year

studentApplications

eSP Source Data

Tables: REG, REG_USER (ru), REG_BUILDING (rb), REG_PROGRAMS (rps)

Selection Criteria

Student has pre-reg enrollment in the current school year at a published school
Student has student-level charter waitlist indicator (date tracked)
- E1726 program has waitlist indicator and school, can have multiple records
One record published for each waitlisted school where
- entry date on or before count date
- no exit date or exit date is after count date (last Friday in September)
- Waitlist Effective Date is on or before count date

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
studentApplications
	applicationIdentifier		LZ			Y
	educationOrganizationId		New		rps.program_value where rps.program_id = '146', rps.field_number = 505	Y
	schoolYear		E1093	SCHOOL-YEAR	rew.school_year	Y
	studentUid		E1523	TX-UNIQUE-STUDENT-ID	ru.field_value where ru.screen_number = 10165, ru.field_number = 1	Y	publish state-assigned number for student If student doesn't have uniqueid defined, attempt publishing and get dependency error
	name
		firstName	E0703	FIRST-NAME	r.first_name	Y
		middleName	E0704	MIDDLE-NAME	r.middle_name	N	only if middle name is defined
		LastSurname	E0705	LAST-NAME	r.last_name	Y
	birthData
		birthDate	E0006	DATE-OF-BIRTH	r.birthdate	Y
	sexDescriptor		E1325 E0004	SEX SEX-CODE	reg.gender	Y	Mar 2022: TEA values changed from '01', '02' to 'M', 'F'
	entryGradeLevelDescriptor		E1517	ENTRY-GRADE-LEVEL-TYPE	reg_grade.state_code_equiv	Y
	generationCodeDescriptor		E1303 E0706	GENERATION-CODE-SUFFIX GENERATION-CODE	r.generation single-char code, don't left-zero-pad to 2 chars	N	only if value is defined - changed to descriptor Oct 1 spec C012 vlaidation table REGTB_GENERATION, use state_code_equiv
	studentId		E0001	STUDENT-ID	rp.state_report_id	TX	dependency if missing
	applicationTypeDescriptor		E3005		'01' Charter School Waitlist - hard-coded	Y
	applicationDate		E3004		reg_program.start_date, program id 146, field 501	Y