Student Program Indicator Roster

Contents

Introduction

The Student Program Indicator Roster report provides a list of students by school with basic identifying information, along with key program indicators to support participant verification by district and school personnel. School totals for each indicator are provided, along with a grand total for the district when run for multiple schools. Students who are actively enrolled on the specified Effective Date are included.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Students

The student must not be marked as Exclude from State Reporting.
The student's school must not be marked as Exclude from State Reporting.
The student's school must not be marked as a Non-Reportable Campus.
The student must be actively enrolled at the selected school on the Effective Date assigned at runtime.

Report Input

For help with report navigation and generation, see Generate Reports.

Each of the available run options and data fields for the report are described below.

Field	Description
Select Schools	Choose which school(s) to include in the report by selecting one of the following options: At the school level: The currently selected school is the default. At the district level: Select a Single School – Click the school for which you want to run the extract. Select Multiple Schools – Use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Effective Date	Select the date to use for determining the student’s program status.
Sort Order	Choose a field by which to sort the report.
Run Now	Select this option to run the report immediately.
Schedule	Select this option to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once Start Date and Start Time to run the report. Repeat Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report. If Daily is selected, check the Weekdays only box to limit to weekdays. If Weekly is selected, check which weekday to run the report. If Monthly is selected, check the month to run the report. If Yearly is selected, select either the date or the weekday to run the report. Date Range – Select No End Date or a date that the re-occurrence should end

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

The report outputs a zip file containing a CSV file and a PDF of the report.

Data Element	Description	[Table]Field
School Name	The name of the school responsible for the potential dropouts.	[Schools]Name
ID	The student’s local identification number.	[Students]Number
Name	The student's last, first, and middle names.	[S_TX_STU_X]E0705 or [Students]Last_Name [S_TX_STU_X]E0703 or [Students]First_Name [S_TX_STU_X]E0704 or [Students]Middle_Name
GR	The student's grade level.	[S_TX_STU_X]State_Grade_Level [Students]Grade_Level
GEN	The student's gender.	[Students]Gender
HISP	The student's ethnicity. 'Y' if Hispanic 'N' if Non-Hispanic	[Students]FedEthnicity
RACE	The student's race. This is output as a string of one-character race codes.	[StudentRace]RaceCD
SPED	Indicates if the student was actively enrolled in a Special Education or speech therapy program on the Effective Date.	[S_TX_SEN_SPD_X]E0173_Instr_Setting [S_TX_SEN_SPD_X]E0857_Speech
SPEECH	Indicates if the student was actively enrolled in a speech therapy program on the Effective Date.	[S_TX_SEN_SPD_X]E0857_Speech
SELA	Indicates if the student was actively enrolled in SELA special program.	[S_TX_SEN_SPD_X]SELA
504	Indicates if the student was actively enrolled in a 504 program on the Effective Date.	[S_TX_SEN_504_X]E1603_Indicator
DYS	Indicates if the student was actively enrolled in a program for dyslexia on the Effective Date.	[S_TX_STU_STATE_GEN_C]E1530_Dyslexia
INTER	Indicates if the student was actively enrolled in an Intervention Strategy program on the Effective Date.	[S_TX_SEN_INTERV_X]E1530_Dylsexia
EB/EL	Indicates if the student was actively enrolled in an EB/EL program on the Effective Date. Note: Previously, this column displayed as “Y” for students with a EB/EL Indicator of 1. The model is now revised to output the specific codes of 1, F, S, 3, 4, or 5 to identify monitored and reclassified students.	[S_TX_SEN_ESL_X]E0790_LEP_Indicator
BIL/ESL	Indicates if the student was actively enrolled in a Bilingual or ESL program on the Effective Date.	If [S_TX_SEN_ESL_X]E1042_Bilingual_Program = 00 or is not blank, then 'BIL' is reported. If [S_TX_SEN_ESL_X]E1043_ESL_Program = 00 or is not blank, then 'ESL' is reported. Note: Students cannot be enrolled in both a Bilingual program and an ESL program at the same time.
TITLE I	Indicates if the student was actively enrolled in a Title I program on the Effective Date.	If [S_TX_SCH_SCHOOLS_X]E0894 = 6, then a 'Y' is reported If [S_TX_SEN_TITLE1_X]E0894_Title1_IND = A, 7, or 9, then a 'Y' is reported.
AT RISK	Indicates if the student was actively enrolled in an At Risk program on the Effective Date.	[S_TX_SEN_ATRISK_X]E0919_AtRisk_IND
Homeless	Indicates if the student student is Homeless	[S_TX_STU_X]Homeless
GT	Indicates if the student was actively enrolled in a Gifted and Talented program on the Effective Date.	[S_TX_SEN_GT_X]E0034_GT
MIG	Indicates if the student was actively enrolled in an Migrant program on the Effective Date.	[S_TX_SEN_MIG_X]E0984_Migrant_IND
IMM	Indicates if the student was actively enrolled in an Immigrant program on the Effective Date.	[S_TX_SEN_IMM_X]E0797_Immigrant_Indicator
T-STEM	Indicates if the student was actively enrolled in an T-STEM program on the Effective Date.	If [S_TX_SCH_SCHOOLS_X]E1559 = 1, then a 'Y' is reported. If [S_TX_STU_STATE_GEN_C]E1559_TSTEM = 1, then a 'Y' is reported. [S_TX_STU_STATE_GEN_C]Enter_Date [S_TX_STU_STATE_GEN_C]Exit_Date
ECHS	Indicates if the student was actively enrolled in an ECHS program on the Effective Date.	If [S_TX_SCH_SCHOOLS_X]E1560 = 1, then a 'Y' is reported. If [S_TX_STU_STATE_GEN_C]E1560_ECHS = 1, then a 'Y' is reported. [S_TX_STU_STATE_GEN_C]Enter_Date [S_TX_STU_STATE_GEN_C]Exit_Date
P-TECH	Indicates if the student was actively enrolled in an P-TECH program on the Effective Date.	[S_TX_STU_STATE_GEN_C]E1612_PTECH [S_TX_STU_STATE_GEN_C]Enter_Date [S_TX_STU_STATE_GEN_C]Exit_Date
School Total	The total number of students in each school enrolled in each program on the Effective Date. Notes: School Total is only displayed on the PDF file. The total number of students is displayed under the Grade column. No totals are provided for Gender and Race.	Calculated
Grand Total	The total number of students enrolled in each program on the Effective Date. Notes: Grand Total is only displayed on the PDF file. The total number of students is displayed under the Grade column. No totals are provided for Gender and Race. This field is suppressed when the report is run for a single school.	Calculated