OnDataSuite can be used as a proactive tool to ensure that both the Fall PEIMS leaver data AND the SPPI-14 data is “clean” before it goes to TEA via the TSDS system. The following will be covered in this handout:

• What data is used for SPPI-14?
• Where are the TSDS Business Rules ( Edits) located?
• How to review the SPPI-14 data.
• Support/Questions

Navigate to the File Center/Data Sources to upload the TSDS PEIMS Summer / Fall and SPPI – 14 files or to upload data.

• PEIMS TSDS (blue tab)
  • Summer PEIMS ( Prior Year) – to locate SPED coding
    • Student Attendance/Special Programs Reporting Period
    •  Student Enrollment/Student School Association
    • Student Program/Student Special Ed Program
  • Fall PEIMS– Leaver records ( Current Year) —To locate graduates
    • Student Enrollment/School Leaver

Scroll down to locate the Submissions, and click on “Info” to ensure the Interchanges/Extensions listed above are uploaded.

 

• SPPI-14 (Current Year)
  • Education Organization
  • Student Parent

• NOTE: Click on the Blue “Attention” link to go to the manual for specific instructions.

TSDS Business Rules (aka Edits) located on blue menu bar.

Select 21-22 SPPI-14 to review Fatals/Warnings/Specials before the SPPI-14 files goes through the TSDS process.

• Click on any of the edits ( F/W/S) that have a “numerator” other than “0” to see business rules that have been triggered.
• Then click on the Business rule link to see details/names for each edit.

The Student tab will enable a detailed review of the SPPI-14 data using a “Custom Report” and/or the “Report Center”.

 

• Student Custom Reports

 

 

• Student Report Center– Create adhoc reports to validate/review data.
  • Build an SPPI-14 List from Summer/Fall PEIMS files
    • Step 1 -Locate “Summer Enrollment” – filter = 2019-20
      • Criteria 1 = Special Ed Summer – filter =1
      • Create Report
        • Click on count of students
        • Create Focus List
    • Step 2 -Locate Leaver – filter for 2019-20
      • Criteria 1 = Leaver Reason – filter=01, 24, 88, 90 and 98
      • Use Focus List drop down to apply the Focus list just created in step 1, above.

• • • Create Report
      • Note total count of students
      • Click on total count of students
      • Compare to the SPPI-14 Custom Report (below)

 

• • Build SPPI-14 reports to review elements
    • Locate SPPI-14 ( Student report -left)

• • • Use the “Criteria” drop down and select any element(s) for review.

• • • NOTE: More than 1 criteria may be added

• • See the “filter” options for Year/Criteria at the top right.

• •  “Create Report”

• • Add visualization-graphs/heatmaps (report options on left)

• • Report Options – left side (black box) – also offers Excel, Bookmark/Sharing, Percent’s, etc..

 

• Student Custom Report  – SPPI-14 Student Detail

• • • • • 

Help ensure accurate reporting of SPPI-14 students and Fall PEIMS Leaver data prior to TSDS due date(s).

• Note the Total Count of students  at the bottom of the report
• Look for rows with NO PEIMS Data ( ie… Leaver info) -blanks/holes

• Submit Ticket – icon located top right
• Manual –  icon / top right