Classic View: VT State Reporting > Fall Census

Search Term: Fall Census

The Fall Census is collection of student data as of October 1st. The Fall Census allows the Vermont Department of Education to create several federal and state reports from this data.

Fall Census Report

Report Logic

The most recent student enrollments before the selected Effective Date report.
Only one enrollment per student reports.
The report is sorted by Student State ID number.

Report Editor

Field	Description
Effective Date	The date from which data is pulled for the report.
Format	CSV HTML XML
Report Legal Identities	When this checkbox is marked, Campus reports the legal name entered on the Census > People > Identities tab. If only one part of the Protected Identity Information is entered, that part reports and the other name fields report blank. For example, if the Legal First Name is entered but the middle and last name fields are empty, then only the first name reports and the middle and last names report blank.
Select Calendars	The calendar(s) from which data is pulled for the report.
Generate Extract	Click to generate the report in the selected format.

Report Examples

Fall Census Report Example - HTML Format

Fall Census Report Example - CSV Format

Fall Census Report Example - XML Format

Report Layout

Element	Description	Type, Format, and Length	Campus Database	Campus Interface
Student ID	The local student identification number.	Alphanumeric, 7 characters	Person.stateID	Census > People > Demographics > Person Identifiers > Student State ID
First Name	The student's first name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab.	Alphanumeric, 20 characters	Identity.firstName OR Identity.legalFirstName	Census > People > Demographics > Person Information > First Name OR Census > People > Identities > Protected Identity Information > Legal First Name
Middle Name	The student's middle name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab.	Alphanumeric, 20 characters	Identity.middleName OR Identity.legalMiddletName	Census > People > Demographics > Person Information > Middle Name OR Census > People > Identities > Protected Identity Information > Legal Middle Name
Last Name	The student's last name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab.	Alphanumeric, 36 characters	Identity.lastName OR Identity.legalLastName	Census > People > Demographics > Person Information > Last Name OR Census > People > Identities > Protected Identity Information > Legal Last Name
Suffix	The additional identifier following the student's last name. Campus reports the legal name entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the name reports from the Demographics tab.	Alphanumeric, 3 characters	Identity.suffix OR Identity.legalSuffix	Census > People > Demographics > Person Information > Suffix OR Census > People > Identities > Protected Identity Information > Legal Suffix
Date of Birth	The student's birthday.	Date, 10 characters MM/DD/YYYY	Identity.birthDate	Census > People > Demographics > Person Information > Birth Date
Gender	The student's gender. Campus reports the gender entered on the Identities tab when the Report Legal Identities checkbox is marked on the report editor. Otherwise, the gender reports from the Demographics tab.	Alphanumeric, 1 character	Identity.gender OR Identity.legalGender	Census > People > Demographics > Person Information > Gender OR Census > People > Identities > Protected Identity Information > Legal Gender
Race_American Indian	The student's identified race as American Indian.	Alphanumeric, 1 character Y or N	Identity.raceEthnicity	Census > People > Demographics > Race/Ethnicity > Is the individual from one or more of these races? > American Indian or Alaska Native (checkbox) OR Race Ethnicity > American Indian/Alaska Native (dropdown list)
Race_Asian	The student's identified race as Asian.	Alphanumeric, 1 character Y or N	Identity. raceEthnicity	Census > People > Demographics > Race/Ethnicity > Is the individual from one or more of these races? > Asian (checkbox) OR Race Ethnicity > Asian (dropdown list)
Race_Black	The student's identified race as Black.	Alphanumeric, 1 character Y or N	Identity. raceEthnicity	Census > People > Demographics > Race/Ethnicity > Is the individual from one or more of these races? > Black or African American (checkbox) OR Race Ethnicity > Black or African American (dropdown list)
Race_Native Hawaiian	The student's identified race as Native Hawaiian.	Alphanumeric, 1 character Y or N	Identity. raceEthnicity	Census > People > Demographics > Person Information > Race/Ethnicity Is the individual from one or more of these races? > Native Hawaiian or Other Pacific Islander (checkbox) OR Race Ethnicity > Native Hawaiian or Other Pacific Islander (dropdown list)
Race_White	The student's identified race as White.	Alphanumeric, 1 character Y or N	Identity. raceEthnicity	Census > People > Demographics > Person Information > Race/Ethnicity Is the individual from one or more of these races? > White (checkbox) OR Race Ethnicity > White (dropdown list)
Ethnicity	The student's identified ethnicity. This reports Y if the student's ethnicity is set to Hispanic/Latino. Otherwise, this reports N.	Alphanumeric, 1 character	Identity. hispanicEthnicity	Census > People > Demographics > Person Information > Race/Ethnicity
Last Grade	The last grade reported for the student's prior enrollment.	Numeric, 2 digits	Enrollment.grade	Student Information > General > Enrollments Tab > General Enrollment Information > Grade
Last Grade Begin Date	The start date of the student's prior enrollment.	Date, 10 characters MM/DD/YYYY	Enrollment.startDate	Student Information > General > Enrollments Tab > General Enrollment Information > Start Date
Last Grade End Date	The last date the student last received instructional services for the prior enrollment.	Date, 10 characters MM/DD/YYYY	Enrollment.endDate	Student Information > General > Enrollments Tab > General Enrollment Information > End Date
Next Grade	The current grade level, if different since the last reported grade.	Numeric, 2 digits	Enrollment.nextGrade	Student Information > General > Enrollments Tab > General Enrollment Information > Future Enrollment > Next Grade
Next Grade Begin Date	The start date that is tied to the current grade.	Date, 10 characters MM/DD/YYYY	Enrollment. nextCalendar	Student Information > General > Enrollments Tab > General Enrollment Information > Future Enrollment > Next Calendar
Next Grade End Date	The end date that is tied to the current grade.	Date, 10 characters MM/DD/YYYY	Enrollment. nextCalendar	Student Information > General > Enrollments Tab > Future Enrollment > Next Calendar
First Year Entered 9th Grade	The year the student entered 9th grade for the first time.	Date, 10 chracters YYYY	Graduation. cohortYearNGA	Student Information > General > Enrollments Tab > Graduation > Cohort Year
Resident District	The student's current district of residence.	Alphanumeric, 5 characters	Enrollment. residentDistrict	Student Information > General > Enrollments Tab > State Reporting Fields > Resident District
Enrollment Begin Date	The start date of the most recent enrollment for the student.	Date, 10 characters MM/DD/YYYY	Enrollment.startDate	Student Information > General > Enrollments Tab > General Enrollment Information > Start Date
Admission Status	The 2-digit admission status code.	Numeric, 2 digits	Enrollment.startStatus	Student Information > General > Enrollments Tab > State Reporting Fields > Admission Status
Entry Type	The 2-digit entry type code.	Numeric, 2 digits	Enrollment.entryType	Student Information > General > Enrollments Tab > General Enrollment Information > Entry/Reentry Type
Funding Source	The 2-digit funding source code.	Numeric, 2 digits	Enrollment. stateFundingCode	Student Information > General > Enrollments Tab > State Reporting Fields > Funding Source
Tech Center	The identification number of the tech center where the student attends.	Numeric, 5 digits	Enrollment.techCenter	Student Information > General > Enrollments Tab > State Reporting Fields > Tech Center
Enrollment End Date	The end date of the student's most recent enrollment.	Date, 10 characters MM/DD/YYYY	Enrollment. endStatus	Student Information > General > Enrollments Tab > General Enrollment Information > End Date
Exit Type	The 2-digit exit type code.	Numeric, 2 digits	Enrollment.exitType	Student Information > General > Enrollments Tab > General Enrollment Information > Exit/Withdrawal Type
New Place of Enrollment	The new place of enrollment for the student.	Alphanumeric, 6 characters	Enrollment. nextSchoolNumber	Student Information > General > Enrollments Tab > State Reporting Fields > New Place of Enrollment
School Lunch Eligibility	The 2-digit eligibility code for this student's lunch services. Options include: 01: Free Breakfast, Lunch, or Milk 02: Reduced Price Breakfast or Lunch 07: Schoolwide Eligibility 08: School Does Not Participate 09: Declined 96: Not Eligible	Numeric, 2 digits	Enrollment.mealStatus	Student Information > General > Enrollments Tab > State Reporting Fields > School Lunch Eligibility
Direct Certification	The student's direct certification. If Direct Certification is marked, Y reports. Otherwise, this field reports N.	Alphanumeric, 1 character	Enrollment. directCertification	FRAM > Eligibility > Eligibility Detail > Direct
Migrant	The student's migrant status. If the student is a migrant, Y reports. Otherwise, this field reports N.	Alphanumeric, 1 character	Enrollment.migrant	Student Information > General > Enrollments Tab > State Reporting Fields > Migrant
LEP	The student's EL Program status. If student has an active EL status, Y reports. Otherwise, this field reports N.	Alphanumeric, 1 character	Enrollment.lep	Student Information > Program Participation > English Learners (EL) > EL > Program Status
Current Grade	The grade level the student is currently enrolled in as of the selected calendar year.	Numeric, 2 digits	Enrollment.grade	Student Information > General > Enrollments Tab > General Enrollment Information > Grade
CurrTag	The student's current enrollment status. If student is currently enrolled as of the Effective Date of the selected calendar, 1 reports. If student is not currently enrolled as of the Effective Date of the selected calendar, 0 reports.	Numeric, 1 digit	Enrollment.active	VT State Reporting > Fall Census > Effective Date
Oct1Tag	The student's enrollment status as of October 1st of the selected calendar year. Options include: 1: Student is currently enrolled as of the Effective Date of the selected calendar. 7: Student's enrollment ended before the Effective Date of the selected calendar. 9: Student is not currently enrolled as of the Effective Date of the selected calendar and has an admin status of 00, 04, 05, or 07.	Numeric, 1 digit	Enrollment.active	VT State Reporting > Fall Census > Effective Date
Oct1Grade	The student's grade level as of October 1st of the selected calendar year.	Numeric, 2 digits	Enrollment.grade	Student Information > General > Enrollments Tab > General Enrollment Information > Grade
Section 504	The student's Section 504 status. If the student's Section 504 is checked, Y reports. Otherwise, this field reports N.	Alphanumeric, 1 character	Enrollment.section504	Student Information > General > Enrollments Tab > State Reporting Fields > Section 504
Student Number	The student's identification number assigned by the school.	Alphanumeric, 20 characters	Identity. localStudentNumber	Census > People > Demographics > Person Identifiers > Local Student Number

Fall Census (Vermont)

Report Logic

Report Editor

Report Examples

Report Layout

Related Articles