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 ReportRead - 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 | Demographics > Person Identifiers > Student State ID Person.stateID |
LASID | The student's unique locally assigned student ID. Numeric, 16 digits | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
DIST CODE | The reporting district code. Numeric, 2 digits | Enrollments > State Reporting Fields > Resident District Code Enrollment.servingDistrict |
DIST CODE RES | The reporting resident code. Alphanumeric, 2 characters | Enrollments > State Reporting Fields > Residency Enrollment.residentDistrict |
SCH CODE | Identifies the school code. Numeric, 5 digits | School Information > 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 | Enrollments > State Reporting Fields > Out of District School Enrollment.outOfDistrictSchool 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 | Enrollments > State Reporting Fields > Career/Tech Center Enrollment.facilityCode |
GRADE | Indicates the student's grade level. Alphanumeric, 2 characters | 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 | Day Setup > First Instructional Day Calendar.startDate Enrollments > Enrollment Editor > Start Date Enrollment.startDate |
ENROLL TYPE | Identifies the student's type of enrollment in the school district. Alphanumeric, 1 character | 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) | Enrollments > General Enrollment Information > End Date Enrollment.endDate |
EXIT TYPE | Identifies the student's reason for exiting or withdrawing. Numeric, 2 digits | Enrollments > General Enrollment Information > Exit/Withdrawal Type Enrollment.endStatus |
SCHOOL DAYS | Identifies the total number of instructional days for students. Numeric, 3 digits | Day Setup 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 | Demographics > Person Information > Last Name Identity.lastName 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 | Demographics > Person Information > First Name Identity.firstName Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
| LAST NAME PREFERRED | The student's preferred last name. Alphanumeric, 50 characters | Demographics > Person Information > Last Name Identity.lastName |
| FIRST NAME PREFERRED | The student's preferred first name. Alphanumeric, 50 characters | 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 | Demographics > Person Information > Middle Name Identity.middleName 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) | Demographics > Person Information > Gender Identity.gender Identities > Protected Identity Information > Legal Gender Name Identity.legalGender |
DATE OF BIRTH | The student's birth date. Date Field 10 characters (MM/DD/YYYY) | Demographics > Person Information > Birth Date Identity.birthDate |
HISPANIC | Indicates whether the student is Hispanic or Latino. Alphanumeric, 1 character (Y or N) | 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) | Demographics > Person Information > Race/Ethnicity > Race(s) RaceEthnicity.code |
ASIAN | Indicates whether the student is Asian. Alphanumeric, 1 character (Y or N) | 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) | 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) | Demographics > Person Information > Race/Ethnicity > Race(s) RaceEthnicity.code |
WHITE | Indicates whether the student is White. Alphanumeric, 1 character (Y or N) | 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) | 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 | 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 | Eligibility POSeligibility.stateCode |
IEP | Indicates the student's IEP status.
POSeligibility.stateCode | 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) | Enrollments > State Reporting Fields > Section 504 Enrollment.section504 |
LEP | Indicates the student's English Learners status. Alphanumeric, 1 character (Y or N) | 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) | Enrollments > State Reporting Fields > Immigrant Enrollment.immigrant |
MIGRANT | Indicates the student's migrant status. Alphanumeric, 1 character (Y or N) | Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
TITLE 1 | Indicates the student's Title 1 status. Alphanumeric, 1 character (Y or N) | 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) | Enrollments > State Reporting Fields > Homeless Status Enrollment.homeless |
VOCED | Indicates the students VoC Ed participation level. Alphanumeric, 1 character (Y or N) | 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) | 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) | 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) | Military Connections > 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) | 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:
| Enrollment > State Reporting Fields > Out Placement School Enrollment.outPlacedProgram |
