HB3 Student Funding Reports

1.OnDataSuite Introduction #

OnDataSuite comprised of 4  data warehouse solutions gives LEAs tools to securely view LEA data and create custom research queries based on their uploaded TSDS PEIMS, State Student Assessment, ACT, AP, PSAT, TSI, SAT files and more.
  • OnPoint enables users to pull data from files across years, test administrations and collections, to provide unprecedented access to multiple data sets in one system. It features PEIMS and Assessment data, but crosses over into Accountability, Federal Programs, CCMR and PBM/RDA.
  • OnPar provides is a powerful multiyear trend analysis and projection tool that allows you to compare your district or campus assessment and financial data side by side with other Texas districts or campuses. It provides over 1,000+ reports using the well-known public released Texas Academic Performance (TAPR) reports as its data source.
  • OnView provides a link for districts to display their TAPR data on their websites in an interactive graphical form.
  • OnBoard provides a dashboard view of key performance indicators for board members, including the HB3 Board Goal progress monitoring.
    This overview of the HB3 Funding resources will be focused on OnPoint and LEA PEIMS reporting for monitoring and analyzing student data as it relates to the HB3 Student Funding requirements beginning with the 2019-2020 school year.

2.Data Sources #

The HB3 Funding reports are based upon TSDS PEIMS files. These reports were initially released in January 2020 and provide a one year back view to 2018-2019 year where applicable.  In order to maximize the potential of these reports for Summary of Finance template updates and projections, the files noted under Data Sources are required.  If any of these files are missing, the reports will still generate but have incomplete, inaccurate or no data.

  • Data Sources
    • The Required TSDS – PEIMS data uploads are:
      • 2018-2019 Fall PEIMS (should be the Final file as submitted to TEA TSDS)
      • 2018-2019 Summer PEIMS  (should be the Final file as submitted to TEA TSDS)
      • 2019-2020 Fall PEIMS (should be the Final file as submitted to TEA TSDS)
      • 2019-2020 Summer PEIMS (this file may be a preliminary file or final file, calculations will update with each file upload).
        • Sample screenshot:

 

3. HB3 Student Funding Reports #

There are HB3 Funding reports aligned to the the HB3 Student Data Funding Elements by type of data (ADA, FTE, Counts, etc) to aid in use of the Summary of Finance templates provided by various sources.

Fall PEIMS 2019-2020 includes initial reporting to TEA of new indicators for changes required by new HB3 funding statutes beginning with 19-20 school year.

Reports developed based upon TEA HB3 guidance and resources available at  https://tea.texas.gov/About_TEA/Government_Relations_and_Legal/Government_Relations/House_Bill_3

As clarifications or updates are released, these reports are being updated.

Additional reports will be developed and released as data and requirements are finalized to support Student Funding Data inputs into the Summary of Finance templates.

 


 

  • Student – Student Custom Reports – HB3 Funding

New Reports released for 19-20.  One year look back is available (18-19 filter) if data is available for comparison purposes.

  • HB3 Compensatory Education – Eco Dis/Census Tiers is based upon new data reported in 2019-2020 Fall PEIMS.
  • HB3 Student ADA report and HB3 Student FTE report require Fall and Summer PEIMS data files to populate all sections of each report.
  • HB3 Student Count – Dyslexia Services Report is based upon new data reported in 2019-2020 Summer PEIMS.

Best Practice recommendation is to use these reports to monitor data submissions routinely throughout the year.

 

 

 

 


 

3.1.HB3 Compensatory Education - Eco Dis/Census Tiers #

HB3 Student Compensatory Education – Eco Dis/Census Tiers   (Fall PEIMS file required)

Student Census Block Group reported in Fall PEIMS is crosswalked to the TEA published 2017 Census Block Tier Mapping for 2020 State Funding and a new element Census Block Tier (Geoid) is populated in OnDataSuite.  *Note:  Latest update from TEA as of 2/27/20 (reference TEA Finance and Grants – State Funding website for latest TEA worksheet.  Per HB3 rules, the census block groups and funding tiers must be analyzed annually and updated as necessary. 

OnDataSuite has also added new element Census Block Tier (CDCN) using the TEA published Campus Census Block Group  to crosswalk the student’s Campus of enrollment to a census tier. *Note: the Campus Census Block Group worksheet TEA released was in July 2019.    This data was utilized by TEA for the preliminary 2019-2020 SOF projections prior to Fall PEIMS 2019-2020 reporting of Student Census Block Groups.

Fall PEIMS edits control the reporting of Student Census Block Group information with fatal edits 40100-0190 and 40100-0191.   Students eligible to generate state compensatory education (SCE) funding report a Student Census Block Group based upon the students home residence.

A SCE student to be funded at Census Block Tiers (Geoid) is defined as: ADA Eligible, Economic Disadvantaged, NOT Homeless and NOT a Residential Placement Facility student whose parents do not reside in the district.

All Homeless students are assigned Census Block Tier (CDCN) based upon their Campus of enrollment.

Residential Placement Facility students whose parents do not reside in the district (Student Attribution = 21 or 23) are SCE funded based upon Economic Disadvantaged status.  *Note the student that are Economic Disadvantaged will be funded at Tier 5 and it varies between the different templates as to how this data is entered.

Census Block (Geoid) Reported – No Tier Assigned  column is assigned Tier 1 (lowest funded).  Any students in this column are those whose home residence Student Census Block Group reported in PEIMS is not identified in the published TEA Census Tier by County worksheet.  * Note: Verify census block group information to ensure student is funded at appropriate tier. If no census tier is identified, TEA will fund at Tier 1.

 

The Census Block Tier Campus (CDCN) columns are not included in the Tier Total at the bottom of the report.  This is just informational for comparison to where students were initially funded based upon campus of enrollment for 2019-2020.  TEA used Fall PEIMS 2018 data to generate the tier funding projections.   *Note: Use year filter to generate 2018-2019 report for reconciliation with TEA initial projections.

Use this report to verify all students are accounted for and reported accurately and updates to your  Summary of Finance.

 

** RELEASE 11.12 ( May 8, 2020) – Redesign of HB3 Student Compensatory Education report in beta testing as a Pre-Release. 

To access the Pre-Release :  Support – Pre-Release – HB3 Compensatory Education – Eco Dis/Census Tiers (Revision).

Please note these reports are still under review and may contain errors.  Once the report is vetted and approved, it will replace the prior version under the Student – Student Custom Reports – HB3 Funding section noted above.

  • Redesign removes the Census Block Campus Tier (CDCN) columns (only used for TEA preliminary 19-20 projections prior to 2019-2020 Fall PEIMS Submission).
  • Reorganizes and provides filter options for grade level (default view)  OR campus level details to align to TEA Summary of Finance for reconciliation.

** Coming Soon:  TEA released this week the 2018 Census Block Tier Mapping for 2021 State Funding.  We will be working with the Pre-Release version of this report to provide an estimator for 20-21 using the newly released mapping until Fall 20-21 PEIMS files are accepted in ODS.

 

Default View will be  will display “Campus Summary label on filter row.

 

Toggle to Campus Summary and this is the view.

3.2.HB3 Student ADA - Refined, HS, SPED Mainstrm, Bil, Early Ed, PEG #

HB3 ADA Summary (Summer PEIMS required)

This report compiles the individual Student Custom ADA reports by funding area as well as incorporates the new rules and reporting for Bilingual/ESL and Early Education.


 * 19-20 COVID-19 ADA Adjusted Refined Total released 6/1/2020

2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1. – Steps 1 – Steps 2 applied on this report. Step 3 is outside the scope of this report at this time.

REQUIRED: 2018-2019 Summer PEIMS files and 2019-2020 Summer PEIMS files uploaded for this calculation to accurately compute.

  • 2018-2019 Historical Ratio =2018-2019 Refined ADA (1-6 six weeks) divided by 2018-2019 Refined ADA (1-4 six weeks).
    • Reference Step 1 in TEA’s guidance.
    • This ratio will display at the top of the HB3 Student ADA report on the 2019-2020 year ONLY.
    • It will be used in the Covid-19 Adjusted Refined Total calculation for all ADA sections of the report.
    • If the 2018-2019 Historical ADA Ratio is blank or 0.00, a 2018-2019 Summer PEIMS has not been uploaded into ODS.  Please confirm your final TEA accepted 18-19 Summer PEIMS file is loaded. 
  • 2019-2020 5th and 6th six weeks data will display N/A per TEA guidance that it will be ignored for 19-20 calculations.
  • 2019-2020 Covid-19 Adjusted Refined Total = 1st – 4th six weeks ADA ((Sum of 1st – 4th six weeks)/4)) multiplied by the 2018-2019 Historical Ratio.

  • Sections included are:
    • Refined ADA – District Summary
    • High School (Grades 9-12) ADA Summary reported with grade level detail
    • Special Education Mainstream Refined ADA – District Summary

 

  • Sections updated by HB3 rules: (scroll the report)


    • Bilingual/ESL Refined ADA – District Summary: New HB3 funding requirements and reporting of new Bilingual/ESL Funding Code in 19-20 Summer PEIMS. “Reference TEA TEDS Section 2.4 pg 144

      • Bilingual/ESL ADA – Not in Dual Language Program – LEP:  Bilingual/ESL Attendance reported with Bilingual/ESL Funding Code = BE and LEP Indicator = 1
      • Bilingual/ESL ADA – Dual Language One way & Two Way Pgrm – LEP: Bilingual/ESL Attendanced reported with Bilingual/ESL Funding Code = D1 or D2 AND LEP Indicator = 1.
      • Bilingual – Dual Language Two Way Pgrm – Non LEP: Bilingual/ESL Attendance reported with Bilingual/ESL Funding Code = D2 AND LEP Indicator = 0, F, S, 3, 4 or 5.

*NOTE – if this section is displaying “n/d” then the 19-20 Summer PEIMS file does not contain the respective Bilingual/ESL Funding Code as indicated on the chart above.  There may be Bilingual/ESL Attendance reported but without the new required Bilingual/ESL Funding Code the report is not calculating any funding per the reference above.


    • Early Education Refined ADA – District Summary : New HB3 funding requirements

Early Education Allotment (TEA HB3 in 30 :  Early Childhood Education Impacts)
• Funds are allocated to improve student performance in early elementary reading and mathematics, which include
supporting full-day prekindergarten.
• Funds total: 0.1 x the Basic Allotment for each economically disadvantaged student and each limited English proficiency
student in K-3.
o Students who are both economically disadvantaged and limited English proficiency draw 0.2 x the Basic Allotment

      • K-3 Eco Dis: Basic Attendance on students in grades K-3 with Economic Disadvantaged indicator = 01, 02 or 99.
      • K-3 LEP:  Basic Attendance on students in grades K-3 and LEP indicator = 1
      • Total: sum of K-3 Eco Dis and K-3 LEP rows for total student funding count.  *Note: students may be duplicate counted in both rows.

    • Public Ed Grant (PEG) ADA – District Summary:  Calculated based upon Student Attribution code =03 (Public Education Grant program)

*New Section to be added for Residential Placement Facility funding in HB3 based upon new reporting for 19-20 Summer PEIMS on the 11.13 release (mid June, 2020)

 

The report may be run for 2018-2019 as well.  Data will populate where it is available and is a good comparison to monitor current year progress as Summer PEIMS files are updated and loaded into OnDataSuite.

 

3.3.HB3 Student Count - Dyslexia Services Report #

**RELEASE 11.12 ( May 8, 2020) – New report:  HB3 Student Count – Dyslexia Services 

Per HB3 in 30 TEA guidance, reference slides 29, 32 and 36.

  • New Summer PEIMS element (Dyslexia Services Code)
    • Unduplicated Student count (students may report more than one Dyslexia Service Code).
  • This report is only available beginning with 19-20.

  • 01-Receiving Services for Dyslexia and related disorder:  count of students reported only with code 01.
  • 02 – Receiving instruction that meets applicable dyslexia program criteria: count of students reported only with code 02.
  • 03 – The student is permitted, on basis of having dyslexia or related disorder, to use modifications: count of students reported only with code 03.
  • Students with two or more Dyslexia Service Codes (01, 02, 03):  count of students reported with more than one Dyslexia Service Code during the year.
  • Total: Unduplicated count of students reported as receiving Dyslexia or Related Order Services.  This is the final count for the HB3 funding.

3.4.HB3 Student FTE - Spec Ed, CTE, Adv CTE, PRS #

HB3  Student FTE Report (Fall and Summer PEIMS files required)

This report compiles the individual Student Custom FTE Reports for each of the program areas funded – Special Education, Career and Technical Education and incorporates the new rules for Advanced Career and Technology Incentive reporting and P-Tech and New Tech campuses and Pregnancy Related Services.


 * 19-20 COVID-19 Adjusted Refined Total released 6/1/2020

2019-2020 COVID-19 ADA Adjustments per TEA Guidance: General Funding Question 1. – Steps 1 – Steps 2 applied on this report. Step 3 is outside the scope of this report at this time.

REQUIRED: 2018-2019 Summer PEIMS files and 2019-2020 Summer PEIMS files uploaded for this calculation to accurately compute.

  • 2018-2019 Historical Ratio =2018-2019 Refined ADA (1-6 six weeks) divided by 2018-2019 Refined ADA (1-4 six weeks).
    • Reference Step 1 in TEA’s guidance.
    • This ratio will display at the top of the HB3 Student FTE report on the 2019-2020 year ONLY.
    • It will be used in the Covid-19 Adjusted Refined Total calculation for all FTE sections of the report.
    • If the 2018-2019 Historical ADA Ratio is blank or 0.00, a 2018-2019 Summer PEIMS has not been uploaded into ODS.  Please confirm your final TEA accepted 18-19 Summer PEIMS file is loaded. 
  • 2019-2020 5th and 6th six weeks data will display N/A per TEA guidance that it will be ignored for 19-20 calculations.
  • 2019-2020 Covid-19 Adjusted Refined Total = 1st – 4th six weeks FTE ((Sum of 1st – 4th six weeks)/4)) multiplied by the 2018-2019 Historical Ratio.

  • The Special Education FTE by Instructional Setting section has been rearranged and grouped to match the data elements entry tab on SOF template.
  • The Career and Technical Education FTE section incorporates the funding changes to include grades 7 and 8 as well as the Technology Applications courses. *Note : report provides grade level detail as well as summary for entry into SOF template. 
    • Verify 7th and 8th grade eligible courses and students are generating CTE contact hours and extracting in the 19-20 Summer PEIMS (new reporting).
  • The Advanced Career and Technology Incentive section reports the $50 per FTE/student allotments on three student groups:
    • Students in 2 or more advanced CTE courses for 3 or more credits (Reference TEA’s Career and Technical Education Allotment for Advanced Course Lists and corresponding credits)
    • Students enrolled in a P-Tech Campus (Fall PEIMS Snapshot count)
    • Student enrolled in a New Tech Campus (Fall PEIMS Snapshot count)   This is new Fall PEIMS data reported.  *Note: Verify all students enrolled at the designated P-Tech and/or New Tech campus are accounted for.
  • Pregnancy Related FTE section as defined for funding.  

The report may be run for 2018-2019 as well.  Data will populate where it is available and is a good comparison to monitor current year progress as Summer PEIMS files are updated and loaded into OnDataSuite.

4.General Report Features #

All Custom Reports have a Tool menu (upper right)

Two important functions to note are:

  • The Export to Excel functionality will export the data into an Excel report and maintains the report format.
  • Report Info will provide a pop-up with details on the use, data sources, calculations and special features of the respective report.  * Note: Anytime you print the report, the Report Info will print at the end of the report. 

 

 

To Print reports there is a Print option on the far left of the top black menu bar:

 

Filters will vary by report.

They will at a minimum contain a year filter.  The report will generate to the latest year of data loaded when initially selected.

 

To filter the report, select the desired filter options and Submit to generate the report.

Once the report is generated, the filtered results will be noted on the report either in a title or column.

In this instance, see the campus name is indicated in the section heading:

5.Support/Training #

 

  • Ticket System – Submit/track
  • Pre-Release Reports – reports in Beta
  • Release History – What’s new in the update(s)
  • Training – Register for upcoming session; View previous recorded sessions; Access Handouts; Training videos clips

 


   Please use the ticket system for questions, issues, errors, new report requests, etc.

NOTE:  Please describe specific details including the URL and/or a screen shot to enable the support team to respond efficiently.


 


Training

 

  • Left menu – Previous Webinars (typically one year back, recordings posted and link to handouts available.  Scroll or use the “Go to” quick menu.
  • Right menu – Schedule Webinars available for registration.  They are in date order.

 

  • Short video clips of new functionality or features.

 


– provides user with searchable resource     ( Located top right on the blue menu bar)

Use to locate “how to” step, system/functionality instructions and training guides.

Help Guide Powered by Documentor
Suggest Edit