Skip to main content
Skip table of contents

Student Programs

studentProgramAssociations

eSP Source Data

Tables: REG_PROGRAM_SETUP, REG_PROGRAM_COLUMN (rpc), REG_PROGRAMS (rps)

  • Programs defined in Reg_Program_Setup

  • Program fields defined in Reg_Program_Column

  • Student data in Reg_Programs
    -- one row in Reg_Programs for each timeframe of each field in each program
    -- rows are associated together on program_id, student_id, field_number, and start_date
    For Ed-Fi publishing, the primary field used as key for a student program record is the lowest field_order with field_level = 1

Selection Criteria

Generic Student Programs Resource, not collected by TEA.
May opt to allow districts to publish local programs as studentProgramAssociations using mapping per Base Profile as follows:

  • Mapping usagequery should exclude program types used by TEA:

    • Career and Technical Education

    • English as a Second Language (ELS)

    • Special Education

    • Title I Part A

  • Publish to studentProgramAssociations only
    BASE uses core eSP student program tables

  • Requires mapping Reg_Program_Setup.Program_Id to Ed-Fi Program type in Code Set Mappings.
    Selection Criteria: Publish all mapped programs for students enrolled in district during school school year

  • Records included where primary field date range is in selected year

  • Programs continue across school years until exited

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

studentProgramAssociations

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

rps.student_id

Y

State-assigned number for student

beginDate

E3010

rps.start_date if in current school year, otherwise schoolyear first day (Jul 1)

Y

format date

endDate

E3020

rps.end_date if before end of current school year otherwise blank

TX

TEA: ExitDate is the day after the last date of participation, which is the first date of non-participation
Publish end_date as entered

educationOrganizationId

rps.district

Y

State-assigned number for school

programReference

educatonOrganizationId

reg_program_setup.district

Y

format district id

programName

E3049

reg_program_setup.description

Y

programTypeDescriptor

E1337

PROGRAM-TYPE

derived from reg_program_setup.program_id

Y

additional fields for display only

district view only - from sp.schoolid

grade level from most recent enrollment in selected year

studentCTEProgramAssociations

eSP Source Data

Tables: REG_USER (ru), REG_PROGRAMS (rps), REG_ENTRY_WITH (rew), REG_DISTRICT (rd)

Selection Criteria

  • TX CTE program record exists for student in current school year

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

studentCTEProgramAssociations

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

ru.field_value where ru.screen_number = 10165, ru.field_number = 1

Y

State-assigned number for student

beginDate

E3010

rps.start_date where rps.program_id = '149' and rps.field_number = '1'

Y

endDate

E3020

rps.end_date where rps.program_id = '149' and rps.field_number = '1'

TX

First day of non-participation - see comment in Row 6

educationOrganizationId

rd.state_code_equiv where rd.building = current rew.building for student

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

'Career and Technical Education'

Y

TX Program Short Description for CTE programs

programType

E1337

PROGRAM-TYPE

'05'

Y

TX Program code for CTE programs

cteProgramServices

[Array]

TX

cteProgramServiceDescriptor

TX

     2 - Single Parent
     7 - Pregnant Woman

E0829

SGL-PARENT-SGL-PREG-WOMAN-CODE

E0829 Single parent Single Pregnant Woman - rps.program_value where rps.program_id = '149', rps.field_number = 2

Publish selected service if '2' or '7'

     8 - Out Of Workforce Individual

E1039

OUT-OF-WORKFORCE-INDIVIDUAL

E1039 Out of Workforce Student - rps.program_value where rps.program_id = '149', rps.field_number = 8

Publish '8' if receiving service

     9 - Transportation CTE Support Services

E0917

TRANSPORTATION-CTE-SUPPORT-SERVICE

E0917 Transportation CTE Support Services - rps.program_value where rps.program_id = '149', rps.field_number = 5

Publish '9' if receiving service

cipCode

N

primaryIndicator

N

serviceBeginDate

E3055

rps.start_date where rps.program_id = '149' and rps.field_number = '8' for E1039, '5' for E0917, '2' for E0829

TX

TEA: Must be in current year

serviceEndDate

E3056

rps.end_date where rps.program_id = '149' and rps.field_number = '8' for E1039, '5' for E0917, '2' for E0829

TX

First day of non-participation - see comment in Row 6

additional fields for display only

district view only - from sp.schoolid

grade level from most recent enrollment in selected year

studentLanguageInstructionProgramAssociations

eSP Source Data

Tables: REG_USER (ru), REG_PROGRAM S(rps), REG_ENTRY_WITH (rew), REG_DISTRICT (rd)

Selection Criteria

  • TX ELL record exists for student in the current year.

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

studentLanguageInstructionProgramAssociations

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

ru.field_value where ru.screen_number = 10165, ru.field_number = 1

Y

State-assigned number for student

beginDate

E3010

rps.start_date where rps.program_id = '146' and rps.field_number = '5'

Y

Fred, is this correct? Jim: I believe it is correct. This start date is associated to the EB Indicator which I think is the flag for Language Instruction. If there is an actual element number associated I can verify. A: Jim, This is correct -7/21/2023

endDate

E3020

rps.end_date where rps.program_id = '146' and rps.field_number = '5'

TX

First day of non-participation - see comment in Row 6

educationOrganizationId

rd.state_code_equiv where rd.building = current rew.building for student

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

'English as a Second Language (ESL)'

Y

TX Program Short Description for Language Instruction programs

programType

E1337

PROGRAM-TYPE

'12' (also '04'?)

Y

TX Program code for Language Instruction programs

languageInstructionProgramServices

[Array]

TX

languageInstructionProgramServiceDescriptor

TX

New record each time the Program changes

E1042

BILINGUAL-PROGRAM-TYPE-CODE

E1042 Bilingual Program Type - rps.program_value where rps.program_id = '146', rps.field_number = 24

selected values 2-5, mapping to descriptors:
2 - '042' - Transitional Bilingual/Early Exit
3 - '043' - Transitional Bilingual/Late Exit
4 - '044' - Dual Language Immersion/Two-Way
5 - '045' - Dual Language Immersion/One-Way

E1043

ESL-PROGRAM-TYPE-CODE

E1043 ESP Program Type - rps.program_value where rps.program_id = '146', rps.field_number = 25

selected values 2-3, mapping to descriptors:
2 - '002' - English As a Second Language/Content-Based
3 - '003' - English As A Second Language/Pull-Out

E1642

ALTERNATIVE-LANGUAGE-PROGRAM-CODE

E1642 Alternate Language Program Type - rps.program_value where rps.program_id = '146', rps.field_number = 121

selected values 01-02, mapping to descriptors:
01 - '046' - Alternative Bilingual Language Program
02 - '004' - Alternative ESL Language Program

serviceBeginDate

E3055

rps.start_date where rps.program_id = '146' and rps.field_number = '24' for E1042, '24' for E1043, '121' for E1642

TX

TEA: May be in prior year

serviceEndDate

E3056

rps.end_date where rps.program_id = '146' and rps.field_number = '24' for E1042, '24' for E1043, '121' for E1642

TX

First day of non-participation - see comment in Row 6

TX Extensions

[Array]

TX

parentalPermissionSets

[Array]

     parentalPermissionDescriptor

E0896

PARENTAL-PERMISSION-CODE

E0896 Parental Permission - rps.program_value where rps.program_id = '146', rps.field_number = 6

TX

     parentalPermissionSetBeginDate

E3042

rps.start_date where rps.program_id = '146' and rps.field_number = '6'

TX

TEA: May be in prior year

     parentalPermissionSetEndDate

E3043

rps.end_date where rps.program_id = '146' and rps.field_number = '6'

TX

First day parentalPermission descriptor no longer applies (first day of non-applicability) - see comment in Row 6

additional fields for display only

district view only - from sp.schoolid

grade level from most recent enrollment in selected year

studentSpecialEducationProgramAssociations

eSP Source Data

Tables: REG_USER (ru), REG_PROGRAMS (rps), REG_ENTRY_WITH (rew),
REG_BUILDING (rb), REG_DISTRICT (rd)

Selection Criteria

Published for any student receiving Special Education services during the school year:

  • TX SPED record exists for student in the current year

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

studentSpecialEducationProgramAssociations

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

ru.field_value where ru.screen_number = 10165, ru.field_number = 1

Y

State-assigned number for student

beginDate

E3010

rps.start_date where rps.program_id = '148' and rps.field_number = 4

Y

endDate

E3020

rps.end_date where rps.program_id = '148' and rps.field_number = 4

TX

First day of non-eligibility - see comment in Row 6

educationOrganizationId

rd.state_code_equiv where rd.building = current rew.building for student

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

'Special Education'

Y

TX Program Short Description for Special Education programs

programType

E1337

PROGRAM-TYPE

'33'

Y

TX Program code for Special Education programs

disabilities

E3015

[Array]

TX

disabilityDescriptor

E0041

E0834

E0835

PRIMARY-DISABILITY-CODE

SECONDARY-DISABILITY-CODE

TERTIARY-DISABILITY-CODE

E0041 Primary Disability - rps.program_value where rps.program_id = '148', rps.field_number = 1
E0834 Secondary Disability - rps.program_value where rps.program_id = '148', rps.field_number = 2
E0835 Terciary Disability - rps.program_value where rps.program_id = '148', rps.field_number = 3   

TX

links to disabilityDescriptor in extension: disabilitySets

sets

[Array]

TX

TX extension on disability

     orderOfDisability

E3039

TX

'1' for primary, '2' for secondary, '3' for tertiary

     eligibilityDateDisabilities

E1723

ELIGIBILITY-DATE

REG_USER.field_value where screen_number = '148' and field_number = '503'

TX

Date Student who is deaf or hard of hearing is eligible for services.  Fred: Updated 07/21/2023
Current field applies to any disability, not just deaf/hard of hearing

     disabilitySetBeginDate

E3016

Not available in eSP

TX

Initial record for Disability; additional record each time disability changes
TEA: May be in prior year

     disabilitySetEndDate

E3017

Not available in eSP

TX

First day of non-applicability - see comment in Row 6

specialEducationProgramServices

[Array]

TX

specialEducationProgramServiceDescriptor

E3058

[Multiple]

TX

Published value mappings:

E0833

REG-DAY-SCH-PROG-DEAF-CODE

E0833 Regular Day School Program for the Deaf - rps.program_value where rps.program_id = '148', rps.field_number = 7

 '22' - Receiving Instructional Services from RDSPD

E0838

AUDIOLOGICAL-SERV-IND-CODE

E0838 Audiological Services - rps.program_value where rps.program_id = '148', rps.field_number = 12

 '18' - Audiological Services

E0840

COUNSELING-SERVICES-IND-CODE

E0840 Counseling Service - rps.program_value where rps.program_id = '148', rps.field_number = 13   

 '13' - Counseling Services

E0841

MEDICAL-DIAGNOSTIC-SERV-IND-CODE

E0841 Medical Diagnostic Service - rps.program_value where rps.program_id = '148', rps.field_number = 14

 '15' - Medical Services

E0843

OCCUPATIONAL-THERAPY-IND-CODE

E0843 Occupational Therapy - rps.program_value where rps.program_id = '148', rps.field_number = 15

 '21' - Occupational And Physical Therapy

E0844

ORIENT-MOBILITY-TRNG-IND-CODE

E0844 Orientation Mobility Training - rps.program_value where rps.program_id = '148', rps.field_number = 16

 '14' - Orientation and Mobility

E0845

PHYSICAL-THERAPY-IND-CODE

E0845 Physical Therapy - rps.program_value where rps.program_id = '148', rps.field_number = 17

 '11' - Physical Therapy Services

E0846

PSYCHOLOGICAL-SERVICES-IND-CODE

E0846 Psychological Service - rps.program_value where rps.program_id = '148', rps.field_number = 18

 '10' - Psychological Services

E0847

RECREATION-IND-CODE

E0847 Recreational Therapy - rps.program_value where rps.program_id = '148', rps.field_number = 19

 '12' - Recreation Including Therapeutic Recreation

E0848

SCHOOL-HEALTH-SERVICES-IND-CODE

E0848 School Heath Service - rps.program_value where rps.program_id = '148', rps.field_number = 20

 '16' - School Health And/Or School Nurse Services

E0849

SOCIAL-WORK-SERVICES-IND-CODE

E0849 Social Work Service - rps.program_value where rps.program_id = '148', rps.field_number = 21

 '01' Social Work Services

E0851

TRANSPORTATION-INDICATOR-CODE

E0851 Transportation Service - rps.program_value where rps.program_id = '148', rps.field_number = 22

 '26' - Special Education Transportation Services

E0857

SPEECH-THERAPY-INDICATOR-CODE

E0857 Speech Therapy Service - rps.program_value where rps.program_id = '148', rps.field_number = 11

0 - '23' - Does Not Receive Speech Therapy
1 - '24' - Speech Therapy Only
2 - '25' - Speech Therapy and Other SPED Instr Setting

E0899

PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD

E0899 PS Program Children with Disability - rps.program_value where rps.program_id = '148', rps.field_number = 9

 '19' - Preschool Student with Disabilities Services

E0900

EARLY-CHILDHOOD-INTERV-IND-CODE

E0900 Early Childhood Intervention - rps.program_value where rps.program_id = '148', rps.field_number = 8

 '20' - Early Childhood Intervention Services

E0997

ASSISTIVE-TECH-INDICATOR-CODE

E0997 Assistive Tech Service - rps.program_value where rps.program_id = '148', rps.field_number = 23

 '17' - Assistive Technology Device or Related Services

E1040

INTERPRETING-SERVICES-TYPE-CODE

E1040 Interpreting Service - rps.program_value where rps.program_id = '148', rps.field_number = 26

01 - '02' - Oral Transliteration Services
02 - '03' - CUED Language Transliteration Services
03 - '04' - Sign Language Transliteration Services
04 - '05' - Sign Language Interpreting Services
05 - '06' - Communication Access Realtime Translation (CART) Services
06 - '07' - C-Print Services
07 - '08' - Type Well Services
08 - '09' - Deaf-Blind Interpreting Services

serviceBegindDate

E3055

rps.start_date where rps.program_id = '148' and rps.field_number as listed above

TX

TEA: May be in prior year

serviceEndDate

E3056

rps.end_date where rps.program_id = '148' and rps.field_number as listed above

TX

First day of non-participation - see comment in Row 6

TX extensions

TX

preferredHomeCommunicationMethodDescriptor

E1661

PREFERRED-HOME-COMMUNICATION-METHOD

rps.program_value where rps.program_id = '148', rps.field_number = 501

TX

Database values are descriptor codeValues

assessments

[Array]

TX

     toolOrAssessmentUsedDescriptor

E1668

TOOL-OR-ASSESSMENT-USED

ru.field_value where ru.screen_number = 10210, ru.field_number = 1

TX

     assessmentResultsObtainedDescriptor

E1669

ASSESSMENT-RESULTS-OBTAINED

ru.field_value where ru.screen_number = 10210, ru.field_number = 2

TX

hearingAmplifications

[Array]

TX

     hearingAmplicficationTypeDescriptor

E1665

HEARING-AMPLIFICATION-TYPE

ru.field_value where ru.screen_number = 10205, ru.field_number = 1

TX

Database values are descriptor codeValues

     hearingAmplificationAccessDescriptor

E1666

HEARING-AMPLIFICATION-ACCESS

ru.field_value where ru.screen_number = 10205, ru.field_number = 2

TX

Database values are descriptor codeValues

     hearingAmplifAvgDailyUseDescriptor

E1667

HEARING-AMPLIFICATION-AVERAGE-DAILY-USE

ru.field_value where ru.screen_number = 10205, ru.field_number = 3

TX

Database values are descriptor codeValues

languageAcquisitions

[Array]

TX

     langAcqServicesProvidedDescriptor

E1662

LANG-ACQ-SERVICES-PROVIDED

ru.field_value where ru.screen_number = 10200, ru.field_number = 1

TX

Database values are descriptor codeValues

     frequencyOfServicesDescriptor

E1663

FREQUENCY-OF-SERVICES

ru.field_value where ru.screen_number = 10200, ru.field_number = 2

TX

Database values are descriptor codeValues

     hoursSpentReceivingServicesDescriptor

E1664

HOURS-SPENT-RECEIVING-SERVICES

ru.field_value where ru.screen_number = 10200, ru.field_number = 3

TX

Database values are descriptor codeValues

instructionalSettingSets

[Array]

TX

Added 4-22, replaces specialEducationSettingSets
On any given day, a student can have a maximum of two Instructional Settings.
If two instructional settings are reported, the second is always 00 for Speech Therapy.
New record each time the main Instructional Setting changes, and/or each time the student's Speech Therapy code changes

     instructionalSettingDescriptor

E0173

INSTRUCTIONAL-SETTING-CODE

rps.program_value where rps.program_id = '148', rps.field_number = 10

TX

Database values are descriptor codeValues

     instructionalSettingBeginDate

E3025

rps.start_date where rps.program_id = '148' and rps.field_number = 10

TX

Initial record w/Instructional setting; additional records each time the Instructional Setting changes
TEA: May be in prior year.
BeginDate is the only Set identity element - if more than one on same date (2 max, second will be setting = '00'), increment beginDate of second one by one day to avoid API error.

     instructionalSettingEndDate

E3026

rps.end_date where rps.program_id = '148' and rps.field_number = 10

TX

First day of non-participation - see comment in Row 6

studentResidentialFacilityAssociations

[Array]

TX

     residentialFacilityId

E1627

RESIDENTIAL-FACILITY-ID

ru.field_value where ru.screen_number = 10190, ru.field_number = 5

TX

     dateEnteredRF

E1630

DATE-ENTERED-RF

ru.field_value where ru.screen_number = 10190, ru.field_number = 2

TX

     dateExitedRF

E1631

DATE-EXITED-RF

ru.field_value where ru.screen_number = 10190, ru.field_number = 3

TX

First day of non-participation - see comment in Row 6

     studentResFacAssocSets

[Array]

TX

modified 8-22, same elements in time-bound set

          attendanceZoneCampus

E1633

ATTENDANCE-ZONE-CAMPUS

ru.field_value where ru.screen_number = 10190, ru.field_number = 7

TX

          educatedAtResidentialFacility

E1634

EDUCATED-AT-RESIDENTIAL-FACILITY

ru.field_value where ru.screen_number = 10190, ru.field_number = 8

TX

          surrogateParentAssigned

E1635

SURROGATE-PARENT-ASSIGNED

ru.field_value where ru.screen_number = 10190, ru.field_number = 9

TX

          numberOtherStudentsAssignedSameSurrogateParent

E1636

NUMBER-OTHER-STUDENTS-ASSIGNED-SAME-SURROGATE-PARENT

ru.field_value where ru.screen_number = 10190, ru.field_number = 10

          residentialFacilityStudentSchoolDayLength

E1637

RESIDENTIAL-FACILITY-STUDENT-SCHOOL-DAY-LENGTH

ru.field_value where ru.screen_number = 10190, ru.field_number = 11

TX

          campusIdOfEnrollmentSchoolDayLength

E1638

CAMPUS-ID-OF-ENROLLMENT-SCHOOL-DAY-LENGTH

ru.field_value where ru.screen_number = 10190, ru.field_number = 12

TX

          studentResFacAssocSetBeginDate

E3064

ru.field_value where ru.screen_number = 10190, ru.field_number = 2

added 8-22

          studentResFacAssocSetEndDate

E3065

ru.field_value where ru.screen_number = 10190, ru.field_number = 3

added 8-22
First day of non-participation - see comment in Row 6

studentSPEDProgramAssociationSet

[Array]

TX

Group data by rps.student_id and rps.start_date - most studentSPEDProgramAssociaionSets will have only one of the five data elements.

     childCountFundingDescriptor

E0832

CHILD-COUNT-FUNDING-TYPE-CODE

 rps.program_value where rps.program_id = '148', rps.field_number = 6

TX

     ppcdServiceLocationDescriptor

E1077

PPCD-SERVICE-LOCATION-CODE

 rps.program_value where rps.program_id = '148', rps.field_number = 27

TX

Mar 2022 - 4 new values added: '5' - '8'

     leaOfRDSPDService

E1527

DISTRICT-OF-RDSPD-SERVICE

 rps.program_value where rps.program_id = '148', rps.field_number = 28

TX

     medicallyFragile

E0999

MEDICALLY-FRAGILE-IND-CODE

 rps.program_value where rps.program_id = '148', rps.field_number = 25

TX

     multiplyDisabled

E0882

MULTIPLY-DISABLED-INDICATOR-CODE

 rps.program_value where rps.program_id = '148', rps.field_number = 5

TX

     programBeginDate

E3047

rps.start_date where rps.program_id = '148' 

TX

     programEndDate

E3048

rps.end_date where rps.program_id = '148' 

TX

First day of non-applicability - see comment in Row 6

additional fields for display only

district view only - most recent enrolled school in selected year

grade level from most recent enrollment in selected year

studentSpecialEducationProgramEligibilityAssociations

eSP Source Data

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

Elements moved from StudentSpecialEducationProgramAssociations

Selection Criteria

Publish ChildFind data for each student where:

  • ChildFind record for current year exists: reg_user.screen_number 10220

    • reg_user.screen_number = 10220, ru.field_number = 1 not null

    • reg_user.screen_number = 10220, ru.field_number = 5 in current school year

  • Used for age 0-3 students only

Includes two groups of students:

  1. Students with ChildFind record who are not enrolled:

  • non-enrolled student will have reg_entry_with record at evaluation school where entry_date = withdrawal_date
    and no later enrollment at the same school

  • StudentSchoolAssociation is not published, Evaluation StudentEdOrgResponsibility record is published

  1. Regular enrolled students with ChildFind record:

  • withdrawal_date may be updated on same reg_entry_with record

  • new reg_entry_with record may be created

  • StudentSchoolAssociation is published, Evaluation StudentEdOrgResponsibility record is not published

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

studentSpecialEducationProgramEligibilityAssociations

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

educationOrganizationId

E1710

CAMPUS-ID-OF-EVALUATION

rb.state_code_equiv where rb.building = current rew.building for student

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

Special Education'

Y

TX Program Short Description for Special Education programs

programTypeDescriptor

E1337

PROGRAM-TYPE

'33'

Y

TX Program code for Special Education programs

transitionNotificationDate

E1712

ECI-NOTIFICATION-DATE

ru.field_value where ru.screen_number = 10220, ru.field_number = 1

TX

transitionConferenceDate

E1713

ECI-TRANSITION-CONFERENCE-DATE

ru.field_value where ru.screen_number = 10220, ru.field_number = 2  

TX

consentToEvaluationReceivedDate

E1714

PARENTAL-CONSENT-DATE

ru.field_value where ru.screen_number = 10220, ru.field_number = 3

TX

eligibilityEvaluationDate

E1715

INITIAL-EVALUATION-DATE

ru.field_value where ru.screen_number = 10220, ru.field_number = 4

TX

evaluationDelayReasonDescriptor

E1718

EVALUATION-DELAY-REASON

ru.field_value where ru.screen_number = 10220, ru.field_number = 7

TX

Database values are descriptor codeValues

eligibilityDeterminationDate

E1716

SPED-ELIGIBILITY-DETERMINATION-DATE

ru.field_value where ru.screen_number = 10220, ru.field_number = 5

TX

added Oct 22 spec

ideaIndicator

E1717

SPED-ELIGIBILITY-DETERMINATION-CODE

ru.field_value where ru.screen_number = 10220, ru.field_number = 6

TX

added Oct 22 spec

evaluationDelayDays

E1711

STUDENT-ABSENCES-WITHIN-TIMEFRAME

TX_STUDENT_CHILD_FIND_ABSENCES_E1711

TX

added Oct 22 spec, using field for StudentAbsencesWithinTimeframe

eligibilityDelayReasonDescriptor

E1731

ELIGIBILITY-DELAY-REASON

ru.field_value where ru.screen_number = 10220, ru.field_number = 8

TX

originalECIServicesDate

E0900
E1632

EARLY-CHILDHOOD-INTERV-IND-CODE; EFFECTIVE-DATE

REG_USER.field_value, screen_number 10220, field_number 9
if blank then rps.program_value where rps.program_id = '148', rps.field_number = 8

Added Mar 2022, may be in prior year (typically is); Original ECI Services Date: REG_USER.field_value, screen 10220 field 9.
Current: rps.start_date where rps.program_id = '148' and rps.field_number = 8

studentTitleIPartAProgramAssociations

eSP Source Data

Tables: REG_USER (ru), REG_PROGRAMS (rps), REG_ENTRY_WITH (rew), REG_DISTRICT (rd)

Selection Criteria

Published for all enrolled students where:

  • TX Title I Part A record exists for student in the current year

  • Default record if above criteria not met

  • Exclude student if:

    • Students ADA code = 0 or 9

      • students are not eligible for Title I

    • or Student is otherwise excluded from reporting
      Separate record for each participation type in each enrolled school for a student
      Note: TX Title I Part A record is only stored at the student level. eSP does not maintain a building wide Title I Part A program setting.

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

studentTitleIPartAProgramAssociations

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

ru.field_value where ru.screen_number = 10165, ru.field_number = 1

Y

State-assigned number for student

beginDate

E3010

rps.start_date where rps.program_id = '147' and rps.field_number = '1'

Y

endDate

E3020

rps.end_date where rps.program_id = '147' and rps.field_number = '1'

TX

blank if future
First day of non-participation - see comment in Row 6

educationOrganizationId

rd.state_code_equiv where rd.building = current rew.building for student

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

'Title I Part A'

Y

TX Program Short Description for Title I Part A programs

programType

E1337

PROGRAM-TYPE

'38'

Y

TX Program code for Title I Part A programs

titleIPartAParticipantTypeDescriptor

E0894

TITLE-I-PART-A-INDICATOR-CODE

 rps.program_value where rps.program_id = '147', rps.field_number = 1

TX

TX extensions

TX

studentTitleIPartAProgramAssociationSets

[Array]

TX

     titleIPartAParticipantTypeDescriptor

E0894

TITLE-I-PART-A-INDICATOR-CODE

rps.program_value where rps.program_id = '147', rps.field_number = 1

TX

     studentTitleIPartAProgramAssociationSetBeginDate

E3066

rps.start_date where rps.program_id = '147' and rps.field_number = '1'

TEA: Must be in current year

     studentTitleIPartAProgramAssociationSetEndDate

E3067

rps.end_date where rps.program_id = '147' and rps.field_number = '1'

First day of non-participation - see comment in Row 6

additional fields for display only

district view only - from sp.schoolid

grade level from most recent enrollment in selected year

JavaScript errors detected

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

If this problem persists, please contact our support.