SASID Testing Demographics (Connecticut)

Classic View: CT State Reporting > SASID Testing Demographics

Search Term: SASID Testing Demographics

The SASID Testing Demographics Record extracts data for completing the CT State-defined SASID Testing Demographics Record.

Example SASID Testing Demographics Editor

Report Logic

  • Reports all enrolled students, sorted by SASID, as of the extract Effective date.
  • Reports one record per student when the student's
    • Enrollment Start Date is <= extract Effective Date
    • Enrollment End Date is Null or > = extract Effective Date
  • To report, the student must be enrolled into a calendar selected on the extract editor
  • Only one record per student may report. If more than one enrollment is eligible, the enrollment with the highest enrollment ID reports.
  • All enrollment types report.
  •  Students are NOT included if

    • their enrollment record is marked as State Exclude;

    • their enrollment record is marked as No Show; or

    • their Calendar of enrollment is marked as State Exclude.

  • Students with a null SASID (Student State ID) will be reported so that the User is alerted that a student who is eligible for testing has not yet been “registered” and the student won’t fall through the cracks.

Report Editor Fields

Field

Description
Effective Date To report, students must have an enrollment that is active as of the Effective Date selected here. The default value is today’s date.
Format
  • State Format (Fixed Width)
  • CSV
  • HTML
Ad Hoc Filter Ad Hoc filters are available for narrowing report results.
Grades Select the Grades to include in the report.
Select Calendars Select the schools to include in the report.
Generate Report
Submit to Batch
Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Report. This process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Layout

# Element Logic Format and Length Campus Location
1 Reporting District

The State District Number for the selected calendar.

3 Characters

System Administration > District Info > State District Number

2 SASID

The student's State ID.

10 Characters

Census > People > Demographics > Student State ID

3 Birthdate

The student's date of birth.

Date field, 8 characters

MMDDYYYY

Census > People > Demographics > Birth Date

4 EL Status

The student's EL status.

Y reports when the student has an EL record where

  • EL Program Status is EL or Exited EL
  • Identified Date is <= extract Effective Date
  • Exited Date is NULL or >= extract Effective Date 

Otherwise, N reports.

1 Character

Student Information > General > Program Participation > English Learners (EL) > EL > Program Status

5 Special Ed Status

Indicates whether the student has a current IEP and is receiving services.

Y reports when all of the following are true.

  • The student has an active enrollment on the extract Effective Date.
  • Special Ed Status = Y
  • Nexus District Entry Date is NULL or <= extract Effective Date
  • Special Ed Exit Date is NULL or >= extract Effective Date
    OR
  • ALL of the following are true:
    • The student has an active enrollment on the extract Effective Date.
    • Special Ed Status = N (considers attribute Default Value)
    • Nexus District Entry Date is NULL or <= extract Effective Date
    • Special Ed Exit Date is NOT = Null and >= extract Effective Date

Otherwise, N reports.

1 Character

Student Information > General > Enrollments > Special Education > Special Ed Status

Student Information > General > Enrollment > State Reporting Fields > Nexus District Entry Date

Student Information > General > Enrollment > Special Ed Fields > Special Ed Exit Date

6 Meal Status

Identifies whether the student participates in the National School Lunch Program (NSLP).

F reports when

  • State Eligibility Code = F
  • Record start date <= extract Effective Date
  • Record end date = NULL or >= extract Effective Date

R reports when

  • State Eligibility Code = R
  • Record start date <= extract Effective Date
  • Record end date = NULL or >= extract Effective Date

Otherwise, N reports.

1 Character

FRAM > Eligibility

7 Section 504

Indicates whether the student qualifies as an individual with disabilities under Section 504 of the Rehabilitation Act.

Y reports when a flag is assigned to the student with the following

  • Code containing "504"
  • Start Date <= extract Effective Date
  • End Date = Null or >= extract Effective Date
  • State Reported = Checked

Otherwise, N reports.

1 Character

Student Information > General > Flags

8 Recent EL

Identifies whether the student has recently received EL services.

To report Y, the student must have an EL record where

  • the EL Program Status is EL or Exited EL,
  • the Identified Date must be before or on the extract Effective Date, and
  • the Exited Date must be null, before OR on the extract Effective Date.

The Date Entered US School on the student's Demographics tab must also be 24 months prior to the extract Effective Date.

Otherwise, N reports.

1 Character

Y or N

Student Information > Program Participation > English Learners (EL) > EL > Program Status

Census > People > Demographics > Date Entered US School

9 Military Family

The military status of the student's family.

Y reports when the Student has an active (Start Date = Null or <= Effective Date, and End Date = Null or >= Effective Date) Guardian relationship (Guardian = Checked) with a Military Connections record that has:

  • Start Date <= the extract Effective Date or is Null
  • End Date >= the extract Effective Date or is Null
  • Status is one of the following:
    • Active Duty, Deployed
    • Active Duty, Not Deployed

Otherwise, N reports.

1 Character

Census > People > Military Connections

10 Homeless

Identifies a student who fits the McKinney-Vento definition of homeless and who is without a parent or guardian to advocate for them and exercise parental rights.

The code selected in the Homeless field reports; otherwise, 00 reports.

2 Characters

Student Information > General > Enrollments > State Reporting Fields > Homeless

11 End of Record Marker

Reports X for all report types.

1 Character N/A