School Attending Children Extract (Massachusetts)

Tool Search: Extracts

The Massachusetts School Attending Children Extract reports counts of students based on the type of school they are attending on the Effective Date entered.

Screenshot of School Attending Children Extract.School Attending Children Extract

Report Logic

The following report logic determines the data included in this extract:

  • Only primary enrollments active on the Effective Date will report.
  • Students marked as State Exclude or No Show will not be included in the extract.
  • Grade Levels and Calendar marked as State Exclude ARE included.
  • Students will only be included in the report if both the Resident Town and Attending School Type are populated. 
  • Records are sorted by Resident Town then grouped by Grade Level.

Generating the Extract

  1. Select School Attending Children Extract as the Extract Type.
  2. Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. The extract will generate based on that date. This field will default to the current date.
  3. Select the Format in which the extract should generate. Select State Format (CSV) for state submission or HTML, XML, or PDF for data review and verification.
  4. Select an Ad hoc Filter to limit records reported.
  5. Indicate which Calendar(s) should be included in the report.
  6. Click Generate Extract to view the report in the selected format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting a SIMS report request to the batch queue by clicking Submit to Batch instead of Generate Extract. 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.

Screenshot of School Attending Children  in State Format (CSV). School Attending Children  - State Format (CSV) 
 

Screenshot of School Attending Children in HTML Format.School Attending Children  - HTML Format 

Screenshot of School Attending Children in XML Format .School Attending Children  - XML Format 

  School Attending Children in PDF Format.School Attending Children - PDF Format.  

Extract Layout

Element Name

Description

Type, Format and Length

Campus Database

Campus Location

Resident Town

The name of the town in which the students live.

Alphanumeric

Enrollment.fiscalTown

Enrollments > State Reporting Fields > City/Town of Residence

Resident Town Code

The code identifying the town in which the students live.

Numeric, 3 digits

Enrollment.fiscalTown

Enrollments > State Reporting Fields > City/Town of Residence

Grade Level

The grade level of the students.

Alphanumeric, 2 characters

Enrollment.grade

Enrollments > State Reporting Fields > Grade Level

Local Public School

The aggregate number of students who have a enrolled in a school with an Attending School Type of 1: Local Public Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Academic Regional Schools

The aggregate number of students who have a enrolled in a school with an Attending School Type of 2: Academic Regional Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Vocational Technical Regional Schools

The aggregate number of students who have a enrolled in a school with an Attending School Type of 3: Vocational - Technical Regional Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Collaboratives

The aggregate number of students who have a enrolled in a school with an Attending School Type of 4: Collaboratives.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Charter School

The aggregate number of students who have a enrolled in a school with an Attending School Type of 5: Charter Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Out of District Public Schools

The aggregate number of students who have a enrolled in a school with an Attending School Type of 6: Out of District Public Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Home Schooled

The aggregate number of students who have a enrolled in a school with an Attending School Type of 7: Home Schooled.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

In State Private and Parochial Schools

The aggregate number of students who have a enrolled in a school with an Attending School Type of 8: In State Private and Parochial Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Out of State Private and Parochial Schools

The aggregate number of students who have a enrolled in a school with an Attending School Type of 9: Out of State Private and Parochial Schools.

Numeric

Enrollment.attending SchoolType

Enrollments > State Reporting Fields > Attending School Type

Total Full Time Resident Students

The total number of students reported for the grade level.

Numeric

Calculated, not dynamically stored

Calculated, not dynamically stored