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 | ||
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 | GENERATION-CODE-SUFFIX | r.generation | N | only if value is defined - changed to descriptor Oct 1 spec | ||
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):
| ||
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 | |||
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 | ||
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 | SEX | 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 | GENERATION-CODE-SUFFIX | r.generation | N | only if value is defined - changed to descriptor Oct 1 spec | ||
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 |