Programs

studentProgramAssociation

 Primary PowerSchool Source Data

Tables: GEN, SPENROLLMENTS (sp), STUDENTS (s), S_SEN_X (xt)

Selection Criteria

  One record published for each SpEnrollments record where:

• Program in Gen table mapped to Ed-Fi Program type in Code Set Mappings

• Student is not excluded

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from sp.studentid

Y

State-assigned number for student  (s.state_studentnumber)

beginDate

E3010

SPEnrollments.Enter_Date

Y

endDate

E3020

SPEnrollments.Exit_Date

TX

TX Special Programs model:  Exit Date is the day after the last date of participation, which is the first date of non-participation.
Webinar 4-01-22 - TEA clarified that all published end dates should be the first date of non-participation, which corresponds to SpEnrollments.Exit_Date.
Publish sp.exit_date or s/r.exitdate as entered.

educationOrganizationId

Students.School or ReEnrollments.School

Y

SchoolID column in SPEnrollments is inaccurate & cannot be used - School must be derived from the student's school of enrollment on the Program Entry Date

district view only

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

gen.name

Y

programTypeDescriptor

E1337

PROGRAM-TYPE

mapped program type

Y

CST_PUBWORKFLOW_LIB.getCodeSetValue(p_profileid, 'programTypes', gen.name)

additional fields for display only

sch.school_name

SchoolID column in SPEnrollments is inaccurate & cannot be used - School must be derived from the student's school of enrollment on the Program Entry Date
district view only - from sp.schoolid

s.student_number

s.lastfirst

s/r.grade_level

grade level from most recent enrollment in selected year

studentCTEProgramAssociations

Primary PowerSchool Source Data

Tables: GEN, , STUDENTS (s), S_SEN_X (xt)

Selection Criteria

• S_TX_SEN_CTE_X exists for student with entry date in current school year

• Student not otherwise excluded from reporting

• FYI ignore E0031 CTE Indicator

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

Y

State-assigned number for student  (s.state_studentnumber)

beginDate

E3010

SPEnrollments.Enter_Date

Y

TEA: May be in prior year

Student -> Special Programs -> Career and Tech -> Entry Date

endDate

E3020

SPEnrollments.Exit_Date

TX

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

Student -> Special Programs -> Career and Tech -> Exit Date

educationOrganizationId

Y

programReference

educatonOrganizationId

district id

Y

format district id

programName

E3049

'Career and Technical Education'

Y

TX Program Short Description for CTE programs

programTypeDescriptor

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

S_TX_SEN_CTE_X.E0829_SINGLEPAR_PREGTEEN

Publish selected service if '2' or '7'

Student -> Special Programs -> Career and Tech -> Single Parent Pregnant Woman (E0829)

     8 - Out Of Workforce Individual

E1039

OUT-OF-WORKFORCE-INDIVIDUAL

S_TX_SEN_CTE_X.E1039_DISPLACED_HOMEMAKER

Publish '8' if '1' selected (receiving service)

Student -> Special Programs -> Career and Tech -> Displaced Homemaker (E1039) (Will be changed to Out Of  Workforce Individual)

     9 - Transportation CTE Support Services

E0917

TRANSPORTATION-CTE-SUPPORT-SERVICE

S_TX_SEN_CTE_X.E0917_CTE_TRANS

Publish '9' if '1' selected (receiving service)

Student -> Special Programs -> Career and Tech -> Transportation CTE Support Service (E0917)

cipCode

N

primaryIndicator

N

serviceBeginDate

E3055

SPEnrollments.Enter_Date

TX

TEA: Must be in current year

serviceEndDate

E3056

SPEnrollments.Exit_Date

TX

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

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

s/r.grade_level

grade level from most recent enrollment in selected year

studentLanguageInstructionProgramAssociations

Primary PowerSchool Source Data

Tables: GEN, STUDENTS (s), S_SEN_X (xt)

Selection Criteria

• S_TX_SEN_ESL_X exists for student with entry date in current school year

• E0790 LEP/EL Indicator > 0

• Student not otherwise excluded from reporting

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

Y

State-assigned number for student  (s.state_studentnumber)

beginDate

E3010

SPEnrollments.Enter_Date

Y

TEA: May be in prior year

Student -> Special Programs -> LEP/EL -> Entry Date

endDate

E3020

SPEnrollments.Exit_Date

TX

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

Student -> Special Programs -> LEP/EL -> Exit Date

educationOrganizationId

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

programTypeDescriptor

E1337

PROGRAM-TYPE

'12' (also '04'?  Appears not)

Y

TX Program code for Language Instruction programs

Based on record structure, appears that all Language Instruction programs are published as type 12, 'English as a Second Language (ESL)', and that type 04 is not used.

languageInstructionProgramServices

[Array]

TX

languageInstructionProgramServiceDescriptor

TX

New record each time the Program changes

E1042

BILINGUAL-PROGRAM-TYPE-CODE

S_TX_SEN_ESL_X.E1042_Bilingual_Program

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

Student -> Special Programs -> LEP/EL -> Bilingual Program Type (E1042)

E1043

ESL-PROGRAM-TYPE-CODE

S_TX_SEN_ESL_X.E1043_ESL_Program

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

Student -> Special Programs -> LEP/EL -> ESL Program Type (E1043)

E1642

ALTERNATIVE-LANGUAGE-PROGRAM-CODE

S_TX_SEN_ESL_X.E1642_Alt_Language_Program

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

Student -> Special Programs -> LEP/EL -> Alternative Language Program (E1642)

serviceBeginDate

E3055

SPEnrollments.Enter_Date

TX

TEA: May be in prior year

serviceEndDate

E3056

SPEnrollments.Exit_Date

TX

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

TX Extensions

TX

parentalPermissionSets

[Array]

     parentalPermissionDescriptor

E0896

PARENTAL-PERMISSION-CODE

S_TX_SEN_ESL_X.E0896_Parental_Permission

TX

New record each time Parental Permission changes; database values are descriptor codeValues.

Student -> Special Programs -> LEP/EL -> Parental Permission (E0896)

     parentalPermissionSetBeginDate

E3042

SPEnrollments.Enter_Date

TX

TEA: May be in prior year

     parentalPermissionSetEndDate

E3043

SPEnrollments.Exit_Date

TX

First day parentalPermission descriptor no longer applies (first day of non-applicability)

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

s/r.grade_level

grade level from most recent enrollment in selected year

studentSpecialEducationProgramAssociations

 Primary PowerSchool Source Data

Tables:

• S_TX_SEN_SPD_X

• S_TX_SEN_SELA_X

• S_TX_SEN_RFT_X

• SPENROLLMENTS

Selection Criteria

• One of the following exists for student with entry date in current school year

• S_TX_SEN_SPD_X with E0041 Primary Disability > '00'

• S_TX_SEN_SELA_X - UI requires concurrent valid S_TN_SEN_SPD_X record

• S_TX_SEN_RFT_X - only if concurrent S_TN_SEN_SPD_X record exists

• SPENROLLMENTS

• Student not otherwise excluded from reporting

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

Y

State-assigned number for student  (s.state_studentnumber)

beginDate

E3010

SPEnrollments.Enter_Date

Y

TEA: May be in prior year

Student -> Special Programs -> Special Education -> Entry Date

endDate

E3020

SPEnrollments.Exit_Date

TX

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

Student -> Special Programs -> Special Education -> Exit Date

educationOrganizationId

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

disabilities

E3015

[Array]

TX

disabilityDescriptor

E0041
E0834
E0835

PRIMARY-DISABILITY-CODE
SECONDARY-DISABILITY-CODE
TERTIARY-DISABILITY-CODE

S_TX_SEN_SPD_X.E0041_DIS1
S_TX_SEN_SPD_X.E0834_DIS2
S_TX_SEN_SPD_X.E0835_DIS3

TX

Primary, Secondary and Tertiary Disability; database values are descriptor codeValues.

Student -> Special Programs -> Special Education -> Primary Disability (E0041)
Student -> Special Programs -> Special Education -> Secondary Disability (E0834)
Student -> Special Programs -> Special Education -> Tertiary Disability (E0835)

sets

[Array]

TX

TX extension on disability

     orderOfDisability

E3039

TX

     eligibilityDateDisabilities

E1723

ELIGIBILITY-DATE

SPEnrollments.Enter_Date

TX

For SELA collection only:  ELIGIBILITY-DATE indicates the date upon which a student who is deaf or hard of hearing is eligible for services
E1723 ELIGIBILITY-DATE is currently only used by the Special Education Language Acquisition collection, which is for students who are age 8 or younger on September 1 of the school year and who have one of the following values for DISABILITY (E1220):
        Deaf-Blindness (Deaf-Blind)
        Hearing/Auditory Impairment (Auditory Impairment)

     disabilitySetBeginDate

E3016

SPEnrollments.Enter_Date

TX

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

     disabilitySetEndDate

E3017

SPEnrollments.Exit_Date

TX

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

specialEducationProgramServices

[Array]

TX

specialEducationProgramServiceDescriptor

E3058

[Multiple]

TX

Database value mappings:

Student -> Special Programs -> Special Education

E0833

REG-DAY-SCH-PROG-DEAF-CODE

S_TX_SEN_SPD_X.E0833_RDSPD

3 - '22' - Receiving Instructional Services from RDSPD

Regional Day School Program Deaf (E0833)

E0838

AUDIOLOGICAL-SERV-IND-CODE

S_TX_SEN_SPD_X.E0838_AUDIOLOGICAL

1 - '18' - Audiological Services

Audiological Services (E0838)

E0840

COUNSELING-SERVICES-IND-CODE

S_TX_SEN_SPD_X.E0840_COUNSELING

1 - '13' - Counseling Services

Counseling Services (E0840)

E0841

MEDICAL-DIAGNOSTIC-SERV-IND-CODE

S_TX_SEN_SPD_X.E0841_MEDICAL_DIAG

1 - '15' - Medical Services

Medical Diagnostic Services (E0841)

E0843

OCCUPATIONAL-THERAPY-IND-CODE

S_TX_SEN_SPD_X.E0843_OT

1 - '21' - Occupational And Physical Therapy

Occupational Therapy Indicator (E0843)

E0844

ORIENT-MOBILITY-TRNG-IND-CODE

S_TX_SEN_SPD_X.E0844_ORIENT_MOBILITY

1 - '14' - Orientation and Mobility

Orient Mobility Training Indicator (E0844)

E0845

PHYSICAL-THERAPY-IND-CODE

S_TX_SEN_SPD_X.E0845_PT

1 - '11' - Physical Therapy Services

Physical Therapy Indicator (E0845)

E0846

PSYCHOLOGICAL-SERVICES-IND-CODE

S_TX_SEN_SPD_X.E0846_PSYCHOLOGICAL

1 - '10' - Psychological Services

Psychological Services (E0846)

E0847

RECREATION-IND-CODE

S_TX_SEN_SPD_X.E0847_RECREATION

1 - '12' - Recreation Including Therapeutic Recreation

Recreation Therapy (E0847)

E0848

SCHOOL-HEALTH-SERVICES-IND-CODE

S_TX_SEN_SPD_X.E0848_SCHOOL_HEALTH

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

School Health Services (E0848)

E0849

SOCIAL-WORK-SERVICES-IND-CODE

S_TX_SEN_SPD_X.E0849_SOCIAL_WORK

1 - '01' Social Work Services

Social Work Services (E0849)

E0851

TRANSPORTATION-INDICATOR-CODE

S_TX_SEN_SPD_X.E0851_TRANSPORTATION

1 - '26' - Special Education Transportation Services

Transportation Indicator (E0851)

E0857

SPEECH-THERAPY-INDICATOR-CODE

S_TX_SEN_SPD_X.E0857_SPEECH

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

Speech Therapy (E0857)

E0899

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

S_TX_SEN_SPD_X.E0899_PPCD

1 - '19' - Preschool Student with Disabilities Services

Pre-School Prog Children w Disabilities (E0899)

E0900

EARLY-CHILDHOOD-INTERV-IND-CODE

S_TX_SEN_SPD_X.E0900_EARLY_CHILD

1 - '20' - Early Childhood Intervention Services

Early Childhood Intervention (E0900)

E0997

ASSISTIVE-TECH-INDICATOR-CODE

S_TX_SEN_SPD_X.E0997_ASSISTIVE_TECH

1 - '17' - Assistive Technology Device or Related Services

Assistive Tech Indicator (E0997)

E1040

INTERPRETING-SERVICES-TYPE-CODE

S_TX_SEN_SPD_X.E1040_INTERPRETING_SERV

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

Interpreting Services Type (E1040)

serviceBegindDate

E3055

SPEnrollments.Enter_Date

TX

Initial record:  Enter_Date; subsequent records:  only if the Services change.
Customers should create a new record each time one or more of the Services change.
TEA: May be in prior year.

serviceEndDate

E3056

SPEnrollments.Exit_Date

TX

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

TX extensions

preferredHomeCommunicationMethodDescriptor

E1661

PREFERRED-HOME-COMMUNICATION-METHOD

S_TX_SEN_SELA_X.E1661_Pref_Home_Comm

TX

Database values are descriptor codeValues

Student -> Special Programs -> SELA -> Preferred Home Communication (E1661)

assessments

[Array]

TX

current UI includes only Diag, Prof, Ach

     toolOrAssessmentUsedDescriptor

E1668

TOOL-OR-ASSESSMENT-USED

S_TX_SEN_SELA_X.E1668_Assessment_Used_NA
S_TX_SEN_SELA_X.E1668_Assessment_Used_OWLS
S_TX_SEN_SELA_X.E1668_Assessment_Used_CASLLS
S_TX_SEN_SELA_X.E1668_Assessment_Used_COMM
S_TX_SEN_SELA_X.E1668_Assessment_Used_ASLA
S_TX_SEN_SELA_X.E1668_Assessment_Used_VCSL

TX

1 - '00' - Not Assessed
1 - 'OW'
1 - 'CA'
1 - 'CM'
1 - 'AS'
1 - 'VC'

Student -> Special Programs -> SELA -> Tool or Assessment Used (E1668)

     assessmentResultsObtainedDescriptor

E1669

ASSESSMENT-RESULTS-OBTAINED

S_TX_SEN_SELA_X.E1669_Assessment_Rslts_OWLS
S_TX_SEN_SELA_X.E1669_Assessment_Rslts_CASLLS
S_TX_SEN_SELA_X.E1669_Assessment_Rslts_COMM
S_TX_SEN_SELA_X.E1669_Assessment_Rslts_ASLA
S_TX_SEN_SELA_X.E1669_Assessment_Rslts_VCSL

TX

Database values are descriptor codeValues

Student -> Special Programs -> SELA -> Assessment Results Obtained (E1669) 

hearingAmplifications

[Array]

TX

Reported in SELA Collection only: students who are 8 years old or younger as of Sept 1 of the current school year, and who have a SELA Special Program Record (S_TX_SEN_SELA_X) with an Entry Date in the current year.

     hearingAmplicficationTypeDescriptor

E1665

HEARING-AMPLIFICATION-TYPE

S_TX_SEN_SELA_X.E1665_Amp_NA
S_TX_SEN_SELA_X.E1665_Amp_Hear_Aids
S_TX_SEN_SELA_X.E1665_Amp_BAHA
S_TX_SEN_SELA_X.E1665_Amp_Implants
S_TX_SEN_SELA_X.E1665_Amp_Supp

TX

1 - '00' - Not Applicable (hearingAmplifications would not be reported)
1 - '01' - Hearing Aids
1 - '02' - Bone Anchored Hearing Aids (BAHA_
1 - '03' - Implants (Includes Cochlear and Middle Ear Implants)
1 - '04' - Supplementals (includes examples such as FM systems, Infrared systems, Induction Loop systems)

Student -> Special Programs -> SELA -> Hearing Amplification Type (E1665)

     hearingAmplificationAccessDescriptor

E1666

HEARING-AMPLIFICATION-ACCESS

S_TX_SEN_SELA_X.E1666_Amp_Accs_Hear_Aids
S_TX_SEN_SELA_X.E1666_Amp_Accs_BAHA
S_TX_SEN_SELA_X.E1666_Amp_Accs_Implants
S_TX_SEN_SELA_X.E1666_Amp_Accs_Supp

TX

Database values are descriptor codeValues:
01 Full Day
02 Partial Day

Student -> Special Programs -> SELA -> Hearing Amplification Access (E1666)

     hearingAmplifAvgDailyUseDescriptor

E1667

HEARING-AMPLIFICATION-AVERAGE-DAILY-USE

S_TX_SEN_SELA_X.E1667_Amp_Avg_Hear_Aids
S_TX_SEN_SELA_X.E1667_Amp_Avg_BAHA
S_TX_SEN_SELA_X.E1667_Amp_Avg_Implants
S_TX_SEN_SELA_X.E1667_Amp_Avg_Supp

TX

Database values are descriptor codeValues:
01 Less Than 1 Hour
02 1 to 3 Hours
03 More Than 3 Hours

Student -> Special Programs -> SELA -> Hearing Amplification Average Daily Use (E1667)

languageAcquisitions

[Array]

TX

     langAcqServicesProvidedDescriptor

E1662

LANG-ACQ-SERVICES-PROVIDED

S_TX_SEN_SELA_X.E1662_Lang_Acq_Srvcs_NA
S_TX_SEN_SELA_X.E1662_Lang_Acq_Srvcs_Dir
S_TX_SEN_SELA_X.E1662_Lang_Acq_Srvcs_Indir
S_TX_SEN_SELA_X.E1662_Lang_Acq_Srvcs_Cons

TX

1 - '00' - Services not Provided (langAcqServicesProvided would not be reported)
1 - '01' - Direct
1 - '02' - Indirect/Consultative
1 - not published (obsolete)

Student -> Special Programs -> SELA -> Language Acquisition Services Provided (E1662)

     frequencyOfServicesDescriptor

E1663

FREQUENCY-OF-SERVICES

S_TX_SEN_SELA_X.E1663_Freq_Srvcs_Dir
S_TX_SEN_SELA_X.E1663_Freq_Srvcs_Indir
S_TX_SEN_SELA_X.E1663_Freq_Srvcs_Cons

TX

Database values are descriptor codeValues:
01 Daily
02 Weekly
03 Monthly
04 Less Than Monthly

Student -> Special Programs -> SELA -> Frequency of Services (E1663)

     hoursSpentReceivingServicesDescriptor

E1664

HOURS-SPENT-RECEIVING-SERVICES

S_TX_SEN_SELA_X.E1664_Hrs_Rcvng_Srvcs_Dir
S_TX_SEN_SELA_X.E1664_Hrs_Rcvng_Srvcs_Indir
S_TX_SEN_SELA_X.E1664_Hrs_Rcvng_Srvcs_Cons

TX

Database values are descriptor codeValues:
01 Less Than 1 Hour
02 1 to 3 Hours
03 More Than 3 Hours up to 5 Hours
04 More Than 5 Hours

Student -> Special Programs -> SELA -> Hours Spent Receiving Services (E1664)

instructionalSettingSets

[Array]

TX

Added 3-23, replaces specialEducationEnvironmentSets
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

Student -> Special Programs -> Special Education -> Instructional Setting (E0173)

     instructionalSettingDescriptor

E0173

INSTRUCTIONAL-SETTING-CODE

S_TX_SEN_SPD_X.E0173_INSTR_SETTING
S_TX_SEN_SPD_X.E0857_SPEECH

TX

Valid values '00' (No instructional setting) through '98' (Off Home Campus)
Speech Therapy Codes and Instructional Setting
0 - Student Does Not Receive Speech Therapy

• student has a single Instructional Setting, E0173_INSRT_SETTING not = '00'

1 - Student Receives Speech Therapy Only

• student has a single Instructional Setting, E0173_INSRT_SETTING = '00'

2 - Student Receives Speech Therapy Along With Service Through Another Special Education Instructional Setting

• student has 2 Instr. Settings, the first is from E0173_INSRT_SETTING, not = '00'

• publish a second Instr. Setting,= '00'

• only case where more than one Instr. Setting at same time

     instructionalSettingBeginDate

E3025

SPEnrollments.Enter_Date

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

SPEnrollments.Exit_Date

TX

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

studentResidentialFacilityAssociation

[Array]

TX

Residential Facility Collection:  reported for SPED students only that have at least one RFT special Program record in the current year (beginning 07/01/yyyy) that overlaps the Entry Date in a SPED special program record. 

• Also note that when a student who is already enrolled in the district and in SPED enters a Residential Facility, the user should create a new SPED special program record to change the Instructional Setting to one of the options for Residential Care.

• In some cases, the student was enrolled in a different district and then sent to an RFT within the geographic boundaries of another district.  In this case, the sending district withdraws the student & the receiving district enrolls the student in the zoned campus where the RFT is located.

     residentialFacilityId

E1627

RESIDENTIAL-FACILITY-ID

S_TX_SEN_RFT_X.E1627_SEN_RF_ID

TX

Student -> Special Program -> RFT -> Residential Facility ID (E1627)

     dateEnteredRF

E1630

DATE-ENTERED-RF

SPEnrollments.Enter_Date

TX

TEA: Must be in current year

     dateExitedRF

E1631

DATE-EXITED-RF

SPEnrollments.Exit_Date

TX

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

     studentResFacAssocSets

[Array]

TX

modified 8-22, same elements in time-bound set, only 1 in PS

          attendanceZoneCampus

E1633

ATTENDANCE-ZONE-CAMPUS

S_TX_SEN_RFT_X.E1633_Attend_Zone_Campus

TX

UI to be modified to dropdown (currenly unchecked text entry)

Student -> Special Program -> RFT -> Attendance Zone Campus (E1633)

          educatedAtResidentialFacility

E1634

EDUCATED-AT-RESIDENTIAL-FACILITY

S_TX_SEN_RFT_X.E1634_Educated_At_RF

TX

Student -> Special Program -> RFT -> Educated at Residential Facility (E1634)

          surrogateParentAssigned

E1635

SURROGATE-PARENT-ASSIGNED

S_TX_SEN_RFT_X.E1635_Surrogate_Assigned

TX

Student -> Special Program -> RFT -> Surrogate Parent Assigned (E1635)

          numberOtherStudentsAssignedSameSurrogateParent

E1636

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

S_TX_SEN_RFT_X.E1636_Std_Assig_Same_Surrog

only reported if "E1635_Surrogate_Assigned" = 1

Student -> Special Program -> RFT -> Number Other Students Assigned Same Surrogate Parent (E1636)

          residentialFacilityStudentSchoolDayLength

E1637

RESIDENTIAL-FACILITY-STUDENT-SCHOOL-DAY-LENGTH

S_TX_SEN_RFT_X.E1637_RF_School_Day_Length

Student -> Special Program -> RFT -> Residential Facility Student School Day Length (E1637)

          campusIdOfEnrollmentSchoolDayLength

E1638

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

derived based on S_TX_SCH_SCHOOLS_X.Default_Day_Minutes for the school reported as E0782 Campus ID of Enrollment.

          studentResFacAssocSetBeginDate

E3064

SPEnrollments.Enter_Date

added 8-22

          studentResFacAssocSetEndDate

E3065

SPEnrollments.Exit_Date

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

studentSPEDProgramAssociationSet

[Array]

TX

     childCountFundingDescriptor

E0832

CHILD-COUNT-FUNDING-TYPE-CODE

S_TX_SEN_SPD_X.E0832_CHILD_COUNT_FUND
No default, publish only if value > '0'

TX

New record when any of the elements in this set changes

Student -> Special Programs -> Special Education -> Child Count Funding Type (E0832)

     ppcdServiceLocationDescriptor

E1077

PPCD-SERVICE-LOCATION-CODE

S_TX_SEN_SPD_X.E1077_PPCD_SERVICE
No default, publish only if value > '0'

TX

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

Student -> Special Programs -> Special Education -> PPCD Service Location (E1077)

     leaOfRDSPDService

E1527

DISTRICT-OF-RDSPD-SERVICE

S_TX_SEN_SPD_X.E1527_DIST_RDSPD

TX

Student -> Special Programs -> Special Education -> District of RDSPD Service (E1527)

     medicallyFragile

E0999

MEDICALLY-FRAGILE-IND-CODE

S_TX_SEN_SPD_X.E0999_MEDICALLY_FRAG

TX

Student -> Special Programs -> Special Education -> Medically Fragile (E0999)

     multiplyDisabled

E0882

MULTIPLY-DISABLED-INDICATOR-CODE

S_TX_SEN_SPD_X.E0882_MULTI_DIS

TX

Student -> Special Programs -> Special Education -> Multiply Disabled (E0882)

     programBeginDate

E3047

SPEnrollments.Enter_Date

TX

TEA: May be in prior year

     programEndDate

E3048

SPEnrollments.Exit_Date

TX

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

additional fields for display only

sch.school_name

district view only - most recent enrolled school in selected year

s.student_number

s.lastfirst

s/r.grade_level

grade level from most recent enrollment in selected year

studentSpecialEducationProgramEligibilityAssociations

Primary PowerSchool Source Data

Tables: STUDENTS (s), SPENROLLMENTS (sen), S_TX_SEN_CHILDFIND_X (cfxt),
S_TN_SEN_SPD_X

Selection Criteria

 
Publish for each ChildFind record in S_TX_SEN_CHILDFIND_X where:

• E1716 SPED Eligibility Date is in current school year (7/1 - 6/30)

Two general groups have ChildFind records:

1. Students enrolled in ChildFind placeholder school

• S_TX_SCH_X.ChildFind_Placeholder

• Excluded from state reporting (similar to Waitlist school)

• Used for age 0-3 schools

• These students also need a studentEdOrgResponsibilityAssociation

• Dependency check on studentEdOrgResponsibilityAssociation

2. Regular enrolled students with ChildFind record

• These students have a studentSchoolAssociation

• Dependency check on studentSchoolAssociation

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

Students.State_StudentNumber
State-assigned number for student

Y

educationOrganizationId

E0212

DISTRICT-ID

State-assigned number for district

Y

Organization is district, not school (previously cfxt.E1710_CAMPUS_ID_OF_EVAL)

programReference

educationOrganizationId

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

cfxt.E1712_ECI_NOTIF_DAT

TX

transitionConferenceDate

E1713

ECI-TRANSITION-CONFERENCE-DATE

cfxt.E1713_ECI_TRANS_CONF_DATE

TX

consentToEvaluationReceivedDate

E1714

PARENTAL-CONSENT-DATE

cfxt.E1714_PRNTL_CONSENT_CALC
cfxt.E1714_PRNTL_CONSENT_DATE

TX

Calculated value E1714_PRNTL_CONSENT_CALC is when countdown starts, E1714_PRNTL_CONSENT_DATE is actual consent date.
Publish actual value if calculated value is in next school year or is blank, otherwise publish calculated value

eligibilityEvaluationDate

E1715

INITIAL-EVALUATION-DATE

cfxt.E1715_INIT_EVAL_DATE

TX

evaluationDelayReasonDescriptor

E1718

EVALUATION-DELAY-REASON

cfxt.E1718_EVAL_DELAY_RSN

TX

eligibilityDeterminationDate

E1716

SPED-ELIGIBILITY-DETERMINATION-DATE

cfxt.E1716_SPED_ELIG_DETERM_DATE

TX

added Oct 22 spec

ideaIndicator

E1717

SPED-ELIGIBILITY-DETERMINATION-CODE

cfxt.E1717_SPED_DETERM_CODE

TX

added Oct 22 spec

evaluationDelayDays

E1711

STUDENT-ABSENCES-WITHIN-TIMEFRAME

cfxt.E1711_ABS_OVR or cfxt.E1711_ABS_CALC if blank

TX

added Oct 22 spec, using field for StudentAbsencesWithinTimeframe

eligibilityDelayReasonDescriptor

E1731

ELIGIBILITY-DELAY-REASON

cfxt.E1731_Elig_Delay_Reason

TX

added 2022-23

originalECIServicesDate

E0900
E1737

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

cfxt.ECI_EffectiveDate_Ovr
cfxt.ECI_EffectiveDate_Calc

TX

Publish override if non-null, otherwise calculated value.
May be in prior year (typically is)
FYI Calculated value will normally match SpEnrollments.Enter_Date where S_TX_SEN_SPD_X.E0900_EARLY_CHILD = 1

Early Childhood Intervention (E0900)

studentTitleIPartAProgramAssociations

Primary PowerSchool Source Data

Tables: S_TX_SEN_TITLE1_X, STUDENTS (s),
REENROLLMENTS (r) + other refs below

Selection Criteria

Published per enrollment for all enrolled students where:

• Student is enrolled in school with Title I Schoolwide program

• or active S_TX_SEN_TITLEI_X record exists if student enrolled at non-Title I school

• enter_date in current school year, before end of enrollment

• exit_date 0 or after start of enrollment

• Exclude student if:

• Students ADA code = 0 or 9

• or Student's participation type = '0'

• or Student is otherwise excluded from reporting
  Separate record for each participation type in each enrolled school for a student
  For Ed-Fi, students will have more records than legacy if there are multiple periods of enrollment/participation in the same school.

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool UI Navigation

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

Y

State-assigned number for student  (s.state_studentnumber)

beginDate

E3010

Title I Code 6 - special handling based on S_TX_SCH_SCHOOLS_X.E0894 = 6 and Students.EntryDate and ReEnrollments.EntryDate
Non-Title-1 Schools - later of SPEnrollments.Enter_Date, enrollment entrydate
Default records - calculated, usually enrollment entry date

Y

TEA: May be in prior school year

Title I Special Program records for Title I Code 6 (Schoolwide) are optional.  These are created if the district has enabled the Title I Schoolwide Automation in District.  Records are opened & closed and the School ID's are synched as students transfer in & out of schools.  Otherwise, the Enter & Exit Dates are calculated based on the student enrollment entries & exits and the school's Title I setting in Schools/School Info.
For Title I codes other than 6, all records are extracted based on the SP Enrollment Records

Student -> Special Program -> Title I -> Entry Date

endDate

E3020

Title I Code 6 - special handling based on S_TX_SCH_SCHOOLS_X.E0894 = 6 and Students.ExitDate and ReEnrollments.ExitDate
Non-Title-1 Schools - earlier of SPEnrollments.Exit_Date, enrollment end date, not published if both null
Default records - begin date of subsequent record or not published if none

TX

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

Student -> Special Program -> Title I -> Exit Date

educationOrganizationId

Y

Calculated based on student school enrollment & exit dates

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

programTypeDescriptor

E1337

PROGRAM-TYPE

'38'

Y

TX Program code for Title I Part A programs

titleIPartAParticipantTypeDescriptor

E0894

TITLE-I-PART-A-INDICATOR-CODE

Either derived for Title I Code 6 or extracted from Title I Code 6 records per comments above; otherwise:
S_TX_SEN_TITLE1_X.E0894_TITLE1_IND
No default records, include only if value > '0'

TX

Repeated in TX extensions below

District Setup -> Schools/School Info -> Edit School / Other Information/PEIMS Information
Student -> Special Program -> Title I -> Title I Part A (E0894)

TX extensions

TX

sets

[Array]

TX

     titleIPartAParticipantTypeDescriptor

E0894

TITLE-I-PART-A-INDICATOR-CODE

S_TX_SEN_TITLE1_X.E0894_TITLE1_IND
No default records, include only if value > '0'

TX

Same as E0894 above

     studentTitleIPartAProgramAssociationSetBeginDate

E3066

See above for Title I Code 6 logic; otherwise SPEnrollments.Enter_Date

TEA: Must be in current year

     studentTitleIPartAProgramAssociationSetEndDate

E3067

SPEnrollments.Exit_Date

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

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

s/r.grade_level

grade level from most recent enrollment in selected year