SB3 PowerSchool SIS Texas
Breadcrumbs

Texas Truancy Status Report

On this page:

Introduction

The Truancy Status Report identifies students with unexcused days absent according to TEA guidelines. Each time the report is run, unexcused absences and truancy status are recalculated and refreshed based on the most current PowerSchool data. Unexcused Absence Filters allow the user to specify the students who will be reported:

  • Students meeting PEIMS Truancy Extension criteria (10 days unexcused in 6 months or Truancy Prevention Measure assigned)

  • Students with at least 3 unexcused in 4 weeks

  • Students with at least 10 unexcused in 6 months

  • Students with at least X days unexcused

Note: A new nightly process to update Student Truancy Tracking records is now available to support future Ed-Fi reporting. The truancy calculations will be generated every year beginning on September 1 and ending on July 31.

Report Input

Field

Description

Select Schools

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.

  • All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students*

  • The Selected

    Students Only

  • All Students   

School Year*

Select the school year for which you want to run the report. 

Unexcused Absence Filters*

Select one of the following unexcused absence filters:

  •  Students meeting PEIMS Truancy Extension criteria 

  •  Students with 3 unexcused in 4 weeks 

  •  Students with 10 unexcused in 6 months 

     

  •  All Students with at least X days unexcused 

Unexcused Calculation Preference*

 Select unexcused calculation preference:

  • Refresh Records Based on Current Attendance 

     

  •  Use Existing Records 

Select Run Now and click Submit

Report Output

Data Element

Description

[Table]Field Name

Data Type

Current School

The school ID for the class.

[S_TX_STU_TRUANCY_DETAILS_C]SCHOOLID

Number(9)

Student Number

The student number

[Student]StudentNumber

Number(9)

Unique ID (UID)

The student's state unique identifier.

[Students]State_StudentNumber

Number(10)

Last Name

The student's last name. 

[Students]Last_Name

Varcha(60)

First Name

The student's first name. 

[Students]First_Name

Varcha(60)

Grade Level

The grade level of the student.

[S_TX_STU_X]State_Grade_Level

[Students]Grade_Level

[S_TX_REN_X]State_Grade_Level

[Reenrollments]Grade_Level

Number(2)

Enroll Status

Student's enrollment status.



YTD Days UnEx

Number of unexcused absences. 



Threshold

Indicates the truancy threshold met by the student. Calculated element.

[S_TX_STU_TRUANCY_C]TRUANCY_THRESHOLD_TYPE

Varchar2(30)

Threshold Date

The date the student met one of the truancy thresholds: 3 unexcused absences in four weeks or 10 unexcused absences in six months. Calculated element.

[S_TX_STU_TRUANCY_C]TRUANCY_THRESHOLD_DATE

Date

Truancy Campus

The student's campus of enrollment when the student met the TEA truancy threshold. Calculated element.

[S_TX_STU_TRUANCY_C]E0782_TRUANCY_CAMPUS_ID

Varchar2(9)

Truancy Grade Level

The student's grade level in the current year when the student first met the TEA truancy threshold of 10 unexcused absences in a six month period. Calculated element.

[S_TX_STU_TRUANCY_C]E0017_TRUANCY_GRADE_LEVEL

Number(11,0)

Excessive Ind

Excessive Indicator.

[S_TX_STU_TRUANCY_C]Excessive_Ind


Excessive Ind Ovr

Excessive Indicator Override.

[S_TX_STU_TRUANCY_C]Excessive_Ind_Ovr


Truancy Prev Ind

Truancy Prevention Indicator.

[S_TX_STU_TRUANCY_C]Truancy_Prev_Ind


Truancy Prev Campus

The student's campus of enrollment where a Truancy Prevention Measure was initiated, if the student has not yet met the TEA truancy threshold. Manually entered element.

[S_TX_STU_TRUANCY_C]E0782_TRU_PREV_CAMPUS_ID

Varchar2(9)

Complaint

PEIMS Truancy Complaint Indicator.  

[S_TX_STU_TRUANCY_C]E1659_TRUANCY_COMPLAINT_IND

Number(1,0)

Comments

Optional comments entered by the user for the truancy record.

[S_TX_STU_TRUANCY_C]TRUANCY_COMMENTS

Varchar2(500)