Tool Search: September 30th
The September 30th Attendance and Enrollment extract reports information about all primary enrollment records in regular day school, evening high school, and part-time programs.
September 30th Attendance and Enrollment Extract Editor
Report Logic
|
|
|
|
Report Editor
| Field | Description |
|---|---|
| Start Date | Enrollment records on and after this date are eligible for reporting. Dates can be entered in mmddyy format or use the calendar icon to select a date. |
| End Date | Last date used to return data. Dates can be entered in mmddyy format or use the calendar icon to select a date. |
| Run Date | Populates the Submission date field and special education status. It is used for calculation in the State Eligibility field in the extract (default value is the current date). |
| Special Services Date | Used to determine a student’s FRAM, migrant, or foreign exchange status date. |
| EL Exempt Date | Date used to determine what reports in the EL Exempt field. To report Y in the EL Exempt field, the student's most recent EL Identified date must be after the EL Exempt Date entered here. |
| Non-Public End Date | Date used for populating data on extract for some students. |
| First Day of School Date | Used for Pre-K Tier Status and Federal Poverty Level calculations. |
| Non-Public End Status | Used to help calculate the Exit Status and Exit Code fields. |
| Ad Hoc Filter | Select an Ad Hoc filter to limit report results to those students that meet the filter requirements. |
| Format | Determines how the report display:
|
| Select Calendars | Select the calendar of enrollment from which to pull student data. |
| Report Generation | The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance. |
Example Report
Report Layout
Reports the home school number from the student’s enrollment. If the school number is null, the school number on the school tied to the enrollment reports. Numeric, 4 digits Alphanumeric, 15 characters Date field, 8 characters, YYYYMMDD The student's grade level. Numeric, 2 digits The student's gender. M: Male F: Female X: Non-Binary Alphanumeric, 1 character An indication that the person traces their origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. If Is the individual Hispanic/Latino = Yes, Y reports. Otherwise, N reports. Alphanumeric, 1 character American Indian or Alaska Native Indicates the person has origins with any of the original peoples of North and South America (including Central America) and maintains cultural identification through tribal affiliation or community attachment. Numeric, 1 digit Asian Indicates the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam. Numeric, 1 digit Black or African American Indicates the person has origins in any of the black racial groups of Africa. Numeric, 1 digit Native Hawaiian or Other Pacific Islander Indicates the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. Numeric, 1 digit White Indicates the person has origins in any of the original peoples of Europe, Middle East, or North Africa. Numeric, 1 digit Indicates whether the student lacks a fixed, regular, and adequate nighttime residence. Numeric, 1 digit Indicates if the student participated in a Title 1 program. This field reports Y if: The student has a value in the home school field on their enrollment AND there is a school in the district with that state school code. Campus finds the school record that falls as of the end date in the extract editor and reports the value from the Title 1 field on that school. Code in School Description Reports TGELGBNOPROG Targeted Assistance Eligible - No Program N TGELGBTGPROG Targeted Assistance Program If the student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the report end date, Y reports. Otherwise, N reports. SWELIGTGPROG Schoolwide Eligible - Targeted Assistance If the student has an active Title1 Flag with a state code of T1 and is marked as state reported as of the report end date, Y reports. Otherwise, N reports. SWELIGNOPROG Schoolwide Eligible- No Program N SWELIGSWPROG Schoolwide Program Y NOTTITLE1ELIG Not a Title I School N Otherwise, N reports. Alphanumeric, 1 character System Administration > Resources > School > Title 1 and Student Information > General > Enrollments > State Reporting Fields > Title 1 System Administration > Resources > School >Title 1 = School wide program Student Information > General > Enrollment > State Reporting > Home School Indicates if the student receives free/reduced price meals. If the Migrant element reports Y, then this field reports F. Otherwise, the value reports from the FRAM record as of the end date entered on the extract editor. If the eligibility status is N, the value as of the Special Services Date reports. Eligibility Reports Free F Reduced R Non-Reimbursable N Paid N Indicates if the student is a migrant as of the End Date on the extract editor. If the Migrant record is N, then the status as of the Special Services Date reports. Alphanumeric, 1 character Indicates whether the student is a foreign exchange student. Alphanumeric, 1 character Indicates the students special education status. The hierarchy for reporting status is Y, E, 3, 2, N. Y reports when the most recent IEP has a Special Ed Start Date that is prior to or equal to report extract editor End Date and the latest IEP Closed Date is less than or equal to the extract editor Run Date AND meets one of the following: E reports when 3 reports when 2 reports when the student has an active 504 record with a start date before the extract editor End Date and meets one of the following requirements: Student Information > General > Enrollment > Special Ed Fields > Special Ed Status Student Information > Special Ed>Documents > IEP > Print Format is MD SPED Date > Detail Editor > Start Date, IEP Closed Date, Exit Code Student Information > General > Flags > Flag (with a state code of 504 and marked as state reported) When the Special Education Services field is E or 3, this field reports the special education Exit Date as of the Effective Date on the extract editor. Date field, 8 characters YYYYMMDD Indicates whether the student is on track to receive a MD High School Certificate of Completion. This is required if Special Education Services = Y. Y reports when Otherwise, N reports. Alphanumeric, 1 character Indicates whether the student has a primary or home language other than English and has been assessed as having limited or no ability to understand, speak or read English. EL Status Reports EL Y Exited EL Y - (When the EL Exited Date is after the Report End Date) Exited EL E - (When EL Exited Date is before the Report End Date) Not EL N Pending N No Record N Student Information > Program Participation > English Learners (EL) > EL > Program Status Date field, 8 characters, YYYYMMDD Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date The date when the student began EL services or entered the U.S. for the first time. This field is required if EL Indicator = Y or E OR Immigrant = Y. Date field, 8 characters, YYYYMMDD Census > People > Demographics > Date Entered US School Student Information > Program Participation > English Learners (EL) > EL > Identified Date Date when EL services ended for a student. The EL End Date reports blank when the EL Status is Y. The Program End Date reports when EL Status is E; otherwise this field reports blank. Date field, 8 characters, YYYYMMDD Student Information > Program Participation > English Learners (EL) > EL > Program Exit Date Indicates that the student receiving ESOL services in their first year of enrollment in a U.S. school is exempt from the PARCC English/Language Arts assessment and may substitute the required state assessment with the English Language Proficiency Assessment (ACCESS for ELs 2.0). Alphanumeric, 1 character Student Information > Program Participation > English Learners (EL) > EL > Program Status Census > People > Demographics > Date Entered US School Alphanumeric, 1 character Indicates the student has a parent or guardian in the military. Alphanumeric, 1 character Indicates whether the student is identified as gifted/talented. Alphanumeric, 1 character Y or N Date field, 8 characters YYYYMMDD The student's entry status. Summer transaction; Entry Status not applicable Also reports when the student's start date and end date are before the first instructional and attendance day of the calendar. Student Information > General > Enrollments > Start Status > Standard Code System Administration > Calendar > Calendar > Days The student's entry code that best describes their last school affiliation prior to entry into the current school. Alphanumeric, 2 characters Student Information > General > Enrollments > Start Status > Standard Code System Administration > Calendar > Calendar > Days Date field, 8 characters YYYYMMDD Student Information > General > Enrollments > Start Date; End Date System Administration > Calendar > Calendar > Days The aggregate number of days the student was in attendance during the current school year, rounded to the nearest half-day. Example 10 days = 0100 See the Report Logic for more information. Numeric, 4 digits The aggregate number of days the student was absent during the current school year, rounded to the nearest half-day. See the Report Logic for more information. Numeric, 4 digits The student's exit status. If the enrollment is tied to a school with a school type of 99:Non -public, the value reports from the Non-public End Status selected on the extract editor, using the following logic: Otherwise, 0 reports. Numeric, 1 digit The reason the student is exiting. If a student has multiple exits, a record reports for each exit code. Numeric, 2 digit The date the student exited. Date field, 8 characters YYYYMMDD Indicates if the student is in Pre-Kindergarten. Alphanumeric, 1 character Indicates the student's eligibility for State Financial Assistance under the Foundation Program. Numeric, 2 digits Indicates whether the student is attending an evening high school program. Course > Section > Class Type is E:Evening The number of courses the Evening High school student is enrolled in as of September 30th. If Part Time+ College Course Count Evening Course Count Reports 3 1 or more 1 2 2 or more 2 2 1 1 1 3 or more 3 1 1 or 2 Total number of courses Indicates whether the student (state grades 09-12) is considered a part-time student (excluding evening high school students). Reports 'N' for all other state grades. The number of courses the part time student is enrolled in. College Courses Courses Rostered into Reports 3 1 or above 1 2 2 or above 2 2 Fewer than 2 The number of part time courses in which the student is enrolled. 1 3 or above 3 1 Below 3 The number of part time courses in which the student is enrolled. 0 4 or above 4 0 3 or below The number of part time courses in which the student is enrolled. Course > Level Course > Type > Evening Alphanumeric, 1 character Y or N The sum of unique courses into which the student is enrolled as of the extract editor End Date when the student is scheduled into a course marked as college (DE is selected in SCED Course Level) in the selected calendars). Numeric, 1 digit Scheduling > Courses > Course > SCED Course Level Indicates whether the student is taking both high school and college level courses and receiving credit in both. Alphanumeric, 1 character, Y or N Indicates whether the student’s eligibility for the National School Lunch Program was determined through direct certification. Alphanumeric, 1 character, Y or N Reports blank when Student is neither in State Grade Level 92-96 nor State Aid Eligibility 03 as of the report effective date. For grades 92 and 93: Reports blank when the Student is neither in State Grade Level 92-96 nor has State Aid Eligibility 03 as of the report effective date. For grades 92 and 93
Data Element Description Location LEA Number The two-digit state designation of the local education agency (LEA).
Numeric, 2 digitsSystem Administration > Resources > District Information > State District Number School Number System Administration > Resources > School > State School Number State Assigned Student ID (SASID) The student's state-assigned ID number.
Numeric, 10 digitsCensus > People > Demographics > Student State ID Local Student ID Number (LASID) The student's LEA-assigned ID number.
Numeric, 10 digitsCensus > People > Demographics > Student Number Last Name The student's last name.
Alphanumeric, 25 charactersCensus > People > Identities > Current Identity > Legal Last Name or Last Name First Name The student's first name. Census > People > Identities > Current Identity >Legal First Name or First Name Middle Name The student's middle name.
Alphanumeric, 15 charactersCensus > People > Identities > Current Identity > Legal Middle Name or Middle Name Generational Suffix The suffix tied to the student's name.
Alphanumeric, 3 charactersCensus > People > Identities > Current Identity > Legal Suffix or Suffix Preferred Name An alternative first name preferred by the student.
Alphanumeric, 15 charactersCensus > People > Identities > Current Identity > Preferred Name Date of Birth The student's date of birth. Census > People > Identities > Current Identity > Date of Birth Grade Student Information> General > Enrollments > Grade Gender Census > People > Identities > Current Identity > Legal Gender and Gender Hispanic or Latino Ethnicity Census > People > Demographics > Race Ethnicity > Is the individual Hispanic/Latino Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native Census > People > Demographics > Race/Ethnicity > Asian Census > People > Demographics > Race/Ethnicity > Black or African American Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander Census > People > Demographics > Race Ethnicity > White Homelessness Status Student Information > General > Enrollments > State Reporting Fields > Homeless Title 1 Indicator
ORFree/Reduced Price Meals
Alphanumeric, 1 characterFRAM > Eligibility > Eligibility Migrant Student Information > General > Enrollment > State Reporting Fields > Migrant Foreign Exchange Student Student Information > General > Enrollment > State Reporting Fields > Foreign Exchange Special Education Services Code Status Description Y Yes, student has an IEP and is receiving special education services E Exited the program, not currently receiving SE services. 3 Exited Special Education and placed in Code 504 2 Code 504 N No, student does NOT have an IEP and is not receiving services. N reports when the student does not meet any of the above values of Y, E, 3 , or 2.
Alphanumeric, 1 characterSpecial Ed End Date Student Information > General > Enrollment > Special Ed Fields > Exit Date Special Ed Certificate Student Information > Special Ed > Documents > IEP > (Print Format is MD SPED Date) > Detail Editor > Start Date, IEP Closed Date, Exit Reason, Certificate English Learner (EL) Status
Alphanumeric, 1 characterEL Begin Date The eight-digit date for when EL services started for a student. English Learner Entry into the US Date EL End Date English Learner ELA Assessment Exempt Status Foster Care Status Indicates whether the student is in foster care. Student Information > Program Participation > English Learners (EL) > EL Services > Foster Care Military Connected Indicator Student Information > Enrollments > Military Connected Status Gifted and Talented Student Indicator Student Information > Program Participation > Gifted & Talented Filler N/A N/A Submission Date The date the file was submitted to the MSDE. Not dynamically stored Entry Status Value Description R First time entries in the current school year E Enter by transfer from another school in the current school year N Re-entry following a withdrawal in the current school year 0
Alphanumeric, 1 characterEntry Code Entry Date The enrollment start date. Days Attending Calculated Days Absent Calculated based on System Administration > Calendar > Calendar > Student Whole Day Absence, Student Half Day Absence Filler N/A N/A Exit Status Student Information > General > Enrollments > End Status > Standard Code Exit Code , the value reports from the Non-public End Status selected on the extract editor, using the following logic:Student Information > General > Enrollments > End Status Exit Date Student Information > General > Enrollments > End Date Pre-K Full-Time Status Student Information > General > Enrollments > Grade State Aid Eligibility Student Information > General > Enrollment > State Reporting Fields > State Aid Eligibility Evening High School Student Reports... When... Y N
Alphanumeric, 1 characterEH Number of Courses
Numeric, 1 digitCalculated Part Time Student Reports... When... OR When... Y Y N
Alphanumeric, 1 characterStudent Information > General > Enrollment > State Reporting > FTE PT Number of Courses
Any remaining courses are considered part time.
not flagged as evening
Numeric, 1 digitOpt-Out Indicates the student's legal guardian has chosen to opt-out of the release of directory information. Student Information > General > Enrollments > State Reporting Fields > Opt-Out Number of College Courses Dual Enrollment Course > SCED Level > DE Direct Certification FRAM > Eligibility > Eligibility > Source Pre-K Tier Status Federal Poverty Level Indicates the percentage of Federal Poverty Level (FPL).
Calculated value:Household Members 100% FPL 1 $13,590 2 $18,310 3 $23,030 4 $27,750 5 $32,470 6 $37,190 7 $41,910 8 $46,630 Each additional member +$4,720 Geolocation ID Identifies the census block.
Reports the concatenation of the information documented in the 'Tract' and 'Block' fields on a student's household address information screen.Census > Addresses > Address Information > Tract + Block
Absence Calculation
| If the student has.... | Then Campus... | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| a value in the FTE override field on the enrollment |
| ||||||||||||
an FTE value of 1 or the FTE field is null | Calculates the total number of absences for the reporting period based on the values found in System Administration > Calendar > Whole Day (absence) and half day (absence).
|
Reporting Data for AOP Students
The following enrollment data elements report from the most recent enrollment in the calendar(s) selected in the extract editor.
Data Element Number | Data Element Name |
|---|---|
DE 100 | Grade Level |
DE 180 | Migrant |
DE 190 | Foreign Exchange Student |
DE 280 | Entry Status |
DE 290 | Entry Code |
DE 300 | Entry Date |
DE 340 | Exit Status |
DE 350 | Exit Code |
DE 360 | Exit Date |
The following attendance data elements are calculated for each enrollment then summed for a total and reported as a single record.
Data Element Number | Data Element Name |
|---|---|
DE 310 | Days Attending |
DE 320 | Days Absent |
