Tool Search: 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
Read - Access and generate the Enrollment Census Reports.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
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
- Select tEnrollment Census Core from the Extract Type dropdown list.
- Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Select the Format in which the report should generate. Options are CSV and HTML.
- When the student's legal name and gender information should report from the Protected Identity Information area, mark the Report Legal Identities checkbox.
- 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. Numeric, 5 digits | System Administration > Resources > School > School Detail > State School Number School.number |
SCH CODE OUT | Identifies the school code when the student is enrolled in a school out of district. 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:
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. When the Enrollment Date is before the Calendar Start Date, the Calendar Start Date reports. Date Field, 10 characters | 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. 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 when 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 when 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 PREFERRED | The student's preferred last name. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName |
| FIRST NAME PREFERRED | The 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 when 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 when 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 whether 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 whether 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 whether the student is Asian. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity > Race(s) RaceEthnicity.code |
BLACK | Indicates whether 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 whether 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 whether 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:
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.
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. 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 > 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:
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. Alphanumeric, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > VocEd Participation Level Enrollments.vocationalCode |
| SINGLEPARENT | Indicates whether the student is a single parent or not. When 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 whether the student is a displaced homemaker or not. When 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 when the student's IEP Status is Y; reports a value of Y when 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 HOME | Reports 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:
| Student Information > General > Enrollment > State Reporting Fields > Home School Out Placed Enrollment.outPlacedProgram |
