Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.