Skip to main content
Skip table of contents

SASID Testing Demographics Record Layout Report


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. 



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.


  • 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 FormatChoose 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 ElementDescription[Table]FieldField Length
1Reporting District The district to which the school belongs.[Prefs]Value (where [Prefs]Name=districtnumber)3
2State Assigned Student ID (SASID)The student's state-assigned student ID.[S_CT_STU_X]State_Student_ID10
3Date of BirthThe student's date of birth.[Students]DOB8

EL/ML Status

Indicates if the student is an English Learner.

Valid values:

  • Y - Yes
  • N - No
5Special Education

Indicates if the student qualifies as a special education student.

Valid values:

  • Y - Yes
  • N - No
6Eligible 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

7Section 504 Status

Indicates if the student qualifies for section 504 programs.

Valid values:

  • Y - Yes
  • N - No
8Recently 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



9Military Family

Indicates if the student is military-connected.

Valid values:

  • Y - Yes
  • N - No

Indicates the student's homeless status.

For valid values, see Homeless Codes.

12End of Record MarkerBlank value.N/A1

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.