Skip to main content
Skip table of contents

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_CT_STU_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

JavaScript errors detected

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

If this problem persists, please contact our support.