Enrollment Census Core (Rhode Island)

Classic View: RI State Reporting > Enrollment Census > Enrollment Census Core 

Search Terms: Enrollment Census

Information collected in the Enrollment Census Core extract is used to generate roster labels for various state assessments and supply detailed student demographic and program information for analysis of state test results, AYP determinations, state aid and other mandates for state and federal reporting.

Enrollment Census Core Report

Report Logic

Report all students with a primary enrollment with at least one day of attendance in the selected calendar. Students with an Enrollment Status of W (Summer Withdrawal) are not reported.

SQL Query

EXECUTE dbo.get_RI_EnrollmentCensus @calendarList =  '1, 2, 3, 4, 5', @effectiveDate = '09/01/2011'

Generate the Enrollment Census Core Extract

  1. Select tEnrollment Census Core from the Extract Type dropdown list. 
  2. Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. 
  3. Select the Format in which the report should generate. Options are CSV and HTML.
  4. If the student's legal name and gender information should report from the Protected Identity Information area, mark the Report Legal Identities checkbox.
  5. Click Generate Extract to generate the report.

Enrollment Census Core Report - CSV Format

Enrollment Census Core Report - HTML Format

Enrollment Census Core Extract Layout

Element Name

Description

Location

SASID

The student's unique state assigned student ID.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID

LASID

The student's unique locally assigned student ID.


Numeric, 16 digits

Census > People > Demographics > Person Identifiers > Local Student Number


Person.studentNumber

DIST CODE

The reporting district code. 


Numeric, 2 digits

Student Information > General > Enrollments > State Reporting Fields > Resident District Code


Enrollment.servingDistrict

DIST CODE RES

The reporting resident code.


Alphanumeric, 2 characters

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


Enrollment.residentDistrict

SCH CODE

Identifies the school code.

If Enrollment Status is H or S, then report XX190 where XX is the first two digits of the current state school number.


Numeric, 5 digits

System Administration > Resources > School > School Detail > State School Number


School.number

SCH CODE OUT

Identifies the school code if the student is enrolled in a school out of district.

Reports the value selected in the Out Placement School field, if provided. 


When the Enrollment Status value is O: Enrolled in Outplacement Program, the School Code Out value reports from the Out of District School field.  


When the Enrollment Status value is one of the following, the School Code Out field reports from the Out Placement School field: 

  • H: Home Schooled
  • S: Privately Enrolled with IEP and/or Service Plan
  • A: Enrolled in an Alternative Learning Program
  • G: Enrolled in a GED Program
  • N: Enrolled in a Transition Program

When the Enrollment Status field is another option not listed, no value reports.


Alphanumeric, 5 characters

Student Information > General > Enrollments > State Reporting Fields > Out of District School


Enrollment.outOfDistrictSchool


Student Information > General > Enrollments > State Reporting Fields > Out Placement School


Enrollment.residentSchool

CTECHCTR

Identifies the code of the Career and technical center the student is enrolled in.


Numeric, 5 digits

Student Information > General > Enrollments > State Reporting Fields > Career/Tech Center


Enrollment.facilityCode

GRADE

Indicates the student's grade level.


Alphanumeric, 2 characters

Student Information > General > Enrollments > General Enrollment Information > Grade


Enrollment.grade

ENROLL DATE

Identifies the student's enrollment start date when the start date is after the first instructional date of the calendar. If the Enrollment Date is before the Calendar Start Date, the Calendar Start Date reports.


Date Field, 10 characters


MM/DD/YYYY

System Administration > Calendar > Calendar > Days > First Instructional Day


Calendar.startDate


Student Information > General > Enrollments > Enrollment Editor > Start Date


Enrollment.startDate

ENROLL TYPE

Identifies the student's type of enrollment in the school district. 


Alphanumeric, 1 character

Student Information > General > Enrollments > State Reporting Fields > Enrollment Status


Enrollment.stateFundingCode

EXIT DATE

Identifies the student's exit or withdrawal date.


Date Field, 10 characters (MM/DD/YYYY)

Student Information > General > Enrollments > End Date


Enrollment.endDate

EXIT TYPE

Identifies the student's reason for exiting or withdrawing.


Numeric, 2 digits

Student Information > General > Enrollments > General Enrollment Information > Exit/Withdrawal Type


Enrollment.endStatus

SCHOOL DAYS

Identifies the total number of instructional days for students.

The total number of instructional days for the calendar reports. If Enrollment Status is O, 230 reports.


Numeric, 3 digits

System Administration > Calendar > Calendar > Days


Calendar.studentDay

LAST NAME

The student's last name.

When the Report Student Legal Identities checkbox is marked, the student's Legal Last Name reports if a Legal Last Name is entered for that student.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Last Name


Identity.lastName


Census > People > Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

FIRST NAME

The student's first name.


When the Report Student Legal Identities checkbox is marked, the student's Legal First Name reports if a Legal First Name is entered for that student.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName


Census > People > Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

LAST NAME PREFERREDThe student's preferred last name.

Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Last Name


Identity.lastName

FIRST NAME PREFERREDThe student's preferred first name.

Alphanumeric, 50 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName

MIDDLE NAME

The student's middle name.


When the Report Student Legal Identities checkbox is marked, the student's Legal Middle Name reports if a Legal Middle Name is entered for that student.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Middle Name


Identity.middleName


Census > People > Identities > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName

SEX

The student's gender.


When the Report Student Legal Identities checkbox is marked, the student's Legal Gender reports if a Legal Gender is entered for that student.


Alphanumeric, 1 character (M, F or O)


Census > People > Demographics > Person Information > Gender


Identity.gender


Census > People > Identities > Protected Identity Information > Legal Gender Name


Identity.legalGender

DATE OF BIRTH

The student's birth date.


Date Field 10 characters (MM/DD/YYYY)

Census > People > Demographics > Person Information > Birth Date


Identity.birthDate

HISPANIC

Indicates if the student is Hispanic or Latino. 


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino


Identity.hispanicEthnicity

NATIVE

Indicates if the student is American Indian or Alaska Native.


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Race(s)


RaceEthnicity.code

ASIAN

Indicates if the student is Asian.


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Race(s)


RaceEthnicity.code

BLACK

Indicates if the student is Black or African American. 


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Race(s)


RaceEthnicity.code

PACIFIC

Indicates if the student is Native Hawaiian or other Pacific Islander.


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Race(s)


RaceEthnicity.code

WHITE

Indicates if the student is White.


Alphanumeric, 1 character (Y or N)

Census > People > Demographics > Person Information > Race/Ethnicity > Race(s)


RaceEthnicity.code

COHORT

Identifies the year the student was first enrolled in 9th grade. 


Date Field, 4 characters (YYYY)

Student Information > General > Graduation > State Reporting > Graduation Fields > Cohort Year


Graduation.gradYear

LANGUAGE HOME

Identifies the language used in the home and reports the selected code.


Numeric, 4 digits

Census > People > Identities > Home Primary Language


Identity.homePrimaryLanguage


LUNCH

Indicates the student's eligibility for free and reduced meals. The following codes report:

  • F: Free
  • N: None
  • R: Reduced

This is based on the Start and End Date of the student's eligibility. A 30-day carry over into the new school year is allowed when no new application has been received.


Alphanumeric, 1 character

FRAM > Eligibility


POSeligibility.stateCode

IEP

Indicates the student's IEP status.

  • If IEP Status is Yes, report Y.
  • If IEP Status is No, report N.
  • If Service Type is N: Special Ed Services AND IEP Status is No, report S.

POSeligibility.stateCode

Student Information > General > Enrollments > Special Ed Fields > IEP Status


Enrollment.specialEdStatus

SEC 504

Indicates the student's eligibility for Section 504 programs.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > Section 504


Enrollment.section504

LEP

Indicates the student's English Learners status.
The EL record must have been active during the date parameters of the report to report Y: Yes.


Alphanumeric, 1 character (Y or N)

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


lep.programStatus

IMMIGRANT

Indicates the student's immigrant status. Defined in section 3301(6) of Title III, refers to individuals who: (A) are aged 3 through 21; (B) were not born in any State; and (C) have not been attending one or more schools in any one or more States for more than 3 full academic years.


Alphanumeric, 1 character (Y or N)

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


Enrollment.immigrant

MIGRANT

Indicates the student's migrant status. 


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments Tab > State Reporting Fields > Migrant


Enrollment.migrant

TITLE 1

Indicates the student's Title 1 status. 


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > Title 1


Enrollment.title1

HOMELESS

Indicates the student lacks a fixed, regular, and adequate nighttime residence and has a primary nighttime residence that is:

  1. A supervised, publicly or privately operated shelter designed to provide temporary living accommodations (including welfare hotels, congregate shelters, and transitional housing for the mentally ill);
  2. An institution that provides a temporary residence for individuals intended to be institutionalized;
  3. A public or private place not designed for, or ordinarily used as, a regular sleeping accommodation for human beings.

Students who have a homeless record on or before the entered Effective Date are included.


Alphanumeric, 1 character (Y or N)

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


Enrollment.homeless

VOCED

Indicates the students VoC Ed participation level.

If VoCEd Participation Level is 1, 2 or 3, report Y; otherwise, report N. 


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > VocEd Participation Level


Enrollments.vocationalCode

SINGLEPARENT

Indicates if the student is a single parent or not.

If Yes, than this field reports as Y; otherwise this field reports N.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > Single Parent

Enrollments.singleParent
DISPHOMEMAKER

Indicates if the student is a displaced homemaker or not.

If Yes, than this field reports as Y; otherwise this field reports N.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollments > State Reporting Fields > Displaced Homemaker

Enrollments.displacedHomemaker
AF ACTIVE DUTY PARENT

Indicates the student's parent/guardian is on active duty in the Armed Forces, including the National Guard.

Reports a Y value for students who have a Military Connections Record for their parent/guardian.


Alphanumeric, 1 character (Y or N)

Census > People > Military Connection Status

ImpactAidEmployment.militaryStatus
ALT ASSESSMENT

Indicates the student's alternate assessment status.

Reports a value of N if the student's IEP Status is Y; reports a value of Y if the student's IEP Status is Y AND the Sped Assessment Accommodations field is set to 3: Alternate Assessment.


Alphanumeric, 1 character (Y or N)

Student Information > General > Enrollment > Special Ed Fields > Sped Assessment Accommodations

Enrollment.assessmentAccommodation
SCH CODE HOMEReports the assigned School Code when the student is enrolled out-of-district.

This field only reports when the Enrollment Status field value is one of the following:
  • G: Enrollments in a GED Program
  • N: Enrollment in a Transition Program
  • O: Enrolled in Outplacement Program
Alphanumeric, 5 characters
Student Information > General > Enrollment > State Reporting Fields > Home School Out Placed

Enrollment.outPlacedProgram