SASID Testing Demographics Record Layout Report

Introduction

This report can be run at the school or district level. Values submitted reflect the student's status as of the testing date.

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.

Student Selection

The report selects records from the [Students] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

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.
Select 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. Notes: If running the report for a single student, or group of students, select the students prior to running report. If All Students is selected but only the current school is selected, the report extracts date for only active students in that school
Display Headers?	Choose Yes or No to indicate whether or not to display headers on the output file.
Include identifying information with each record for troubleshooting	Select Yes to include the following identifying information at the beginning of each record to help troubleshoot problems. Student Name (last, first) Student Number Current School Grade Level Current Entry Date
Extract Format	Choose the format for the extract.

Back to Top

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.

Item #	Data Element	Description	[Table]Field	Field Length
1	Reporting District	The district to which the school belongs.	[Prefs]Value (where [Prefs]Name=districtnumber)	3
2	State Assigned Student ID (SASID)	The student's state-assigned student ID.	[S_CT_STU_X]State_Student_ID	10
3	Date of Birth	The student's date of birth.	[Students]DOB	8
4	EL/ML Status	Indicates if the student is an English Learner. Valid values: Y - Yes N - No	[S_CT_STU_Language_X]ELLIndicator	1
5	Special Education	Indicates if the student qualifies as a special education student. Valid values: Y - Yes N - No	[S_CT_STU_SPED_X]SpecialEducation	1
6	Eligible for free/reduced-price meals	Indicates if the student is eligible for free/reduced-price meals. Valid values: F - Free R - Reduced N - No	[S_CT_STU_X]Lunch_Certification, if populated. If [S_CT_STU_X]Lunch_Certification equals FS, AF, OT, or FM, a value of 'F' is reported. If [S_CT_STU_X]Lunch_Certification equals RM, a value of 'R' is reported. Otherwise: [Students]LunchStatus	1
7	Section 504 Status	Indicates if the student qualifies for section 504 programs. Valid values: Y - Yes N - No	[S_STU_CRDC_X]Section504_YN	1
8	Recently Arrived English Learner/Multilingual Learner (EL/ML)	Indicates if the student is an English Learner and if the student has resided in the United States for 24 months or fewer. Valid values: Y - Yes N - No	[StudentCoreFields]DateOfEntryIntoUSA [S_CT_STU_Language_X]ELLIndicator	1
9	Military Family	Indicates if the student is military-connected. Valid values: Y - Yes N - No	[S_CT_STU_X]MilitaryFamily	1
11	Homeless	Indicates the student's homeless status. For valid values, see Homeless Codes.	[S_CT_STU_Demographics_X]Homeless	2
12	End of Record Marker	Blank value.	N/A	1

Back to Top