Tool Search: WDE600
WDE-600 collects statistics on student attendance, membership, and unexcused absences. This data is used in the Wyoming education resource block grant model. The report can be generated in a Summary format or a Detail format. The attendance data returned on both report types is the same. Additional student demographic data is reported on the Detail format. The Summary file is submitted to the state while the Detail file is typically used for auditing.
WDE-600 Attendance and Membership Extract Editor
Report Logic
|
|
|
|
|
|
|
|
|
Report Editor
The following defines the options available on the WDE-600 Attendance and Membership Report editor.
| Field | Description |
| Report Type | Drop list options:
WDE-600 does not collect the start and end enrollment dates or FTE. However, an audit report has been created to help auditors in Wyoming determine if the Summary (State) report is correct. All enrollments are calculated so that start and end dates along with the FTE value determine the consolidated ADA, ADM, and Unexcused values are correct. |
| Start Date | The first date of attendance data. Enter dates in mmddyy format or use the calendar icon to select a date. |
| End Date | The last date of attendance data. Enter dates in mmddyy format or use the calendar icon to select a date. |
| Calculation Method | Drop list options:
|
| FTE Calculation | Drop list options:
|
| Include School Name | Displays the school name before all other data elements when checked. |
| Display ADA / ADM | Includes the three Aggregate Attendance fields at the end of the extract to report the total divided by the number of attendance days when checked. See field logic below for more information. |
| Ignore Enrollment FTE Override When 100% Is Entered | Enrollment FTE Override is not consider when 100% is entered and the checkbox is marked. |
| Report Student Legal Identities | Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information when the checkbox is marked. |
| Report Format | Selection determines how the report generates.
|
| Ad Hoc Filter | Select an Ad hoc filter to limit report results to students that meet filter requirements. |
| Select Calendars | Selection indicates from which school and school year data is reported. |
| 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. |
Generating the WDE-600 Report
- Select the Report Type from the dropdown list.
- Enter the Start Date of the report.
- Enter an End Date for the report.
Leave the start and end date fields blank on this report editor to return data for the entire year.
- Select a Calculation Method to determine whether attendance calculations use Minutes or Periods.
- Select an FTE Calculation.
- Mark Include School Name to report School Name as the first field of the report.
- Mark Display ADA/ADM to include the average daily attendance and average daily membership fields.
- Mark the Ignore Enrollment FTE Override when 100% is Entered checkbox if students with a School Membership FTE Override value of 100 entered on their enrollment should be calculated as null.
- Mark if Demographics fields should Report Student Legal Identities.
- Select the Report Format.
- Select an Ad hoc Filter to limit results to a pre-defined filter.
- Select the Calendar(s) to include on the report.
- Click Generate Report to view the report in the selected format or Submit to Batch to schedule when the report will generate.
Example WDE-600 Reports
WDE-600 Detail Report - State Format (CSV)
WDE-600 Summary Report - HTML Format
WDE-600 Detail Report - XML Format
Report Layout
Detail Format
Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information if the Report Student Legal Identities checkbox is marked.
Element Name | Description and Format | Location |
|---|---|---|
| School Name | The name of the school Displays before all other data elements when the 'Include School Name' box is checked on the report editor. Alphanumeric | System Administration > Resources > School > Name school.name |
District ID | The WDE 7-digits ID for the district submitting the student's data Reports from the Resident District field on enrollments if entered. Otherwise reports State District Number. Numeric, 7 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District System Administration > Resources > District Information > State District Number Enrollment.residentDistrict district.ncesDistrictID |
School ID | The WDE 7-digit ID for the school of the student's enrollment Reports from the Resident School field on enrollments if entered. Otherwise, reports State School Number. Numeric, 7 digits | Student Information > General > Enrollments > State Reporting Fields > Resident School System Administration > Resources > School > State School Number Enrollment.residentDistrict School.ncesSchoolID |
Student WISER ID | The WDE 8-digit state-assigned student record identifier. Numeric, 8 digits | Census > People > Demographics > Person Identifiers > Student State ID person.studentNumber |
Student Last Name | Student's last name. Alphanumeric, 40 characters | Census > People > Demographics > Person Information > Last Name identity.lastName |
Student First Name | Student's first name. Alphanumeric, 35 characters | Census > People > Demographics > Person Information > First Name identity.firstName |
Student Middle Name | Student's middle name. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Middle Name identity.middleName |
Student Grade Level | The grade level of the student's current enrollment. Alphanumeric, 4 characters | Student Information > General > Enrollment > Grade enrollment.grade |
| Asian Race | Federal race/ethnicity determination of student being considered as Asian. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| Black Race | Federal race/ethnicity determination of student being considered as Black. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| Indian Race | Federal race/ethnicity determination of student being considered as Indian. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| Pacific Islander Race | Federal race/ethnicity determination of student being considered as Pacific Islander. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| White Race | Federal race/ethnicity determination of student being considered as White. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| Hispanic Ethnicity | Federal race/ethnicity determination of student being considered as Hispanic. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
| FTE Start Date | The start date of the FTE calculation. Displays when the 'Per Day' option is selected under FTE Calculation on the report editor. Date field, 8 characters MMDDYYYY | |
| FTE End Date | The end date of the FTE calculation. Displays when the 'Per Day' option is selected under FTE Calculation on the report editor. When FTE Override NOT = Null, reports the earliest of the following:
Date field, 8 characters MMDDYYYY | |
Enrollment Start | Start date of every enrollment record in the calendar year. Date field, 8 characters MMDDYYYY | Student Information > General > Enrollment > Start Date enrollment.startDate |
Enrollment End | End date of every enrollment record in the calendar year. Date field, 8 characters MMDDYYYY | Student Information > General > Enrollment > End Date enrollment.endDate |
FTE Value | Percentage of time the student is enrolled in the school.
Course period / minutes are not included when the course enrolled has any of the following:
Per Day:
Per Enrollment:
When FTEValue is 80.000 or higher, it rounds to 100.000. The combined FTE from across all enrollments active in the extract editor date range may not exceed 1.000 (100%).
Numeric, 9 digits | Student Information > General > Enrollments > State Reporting > Membership FTE Override enrollment.FTE |
| Actual FTE | The actual FTE of the student. A student may only report a maximum of 100 FTE from across an enrollment date range (including 1 or more enrollment records).
| |
Student Aggregate Attendance | Aggregate number of days the student was present during the days of operation. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor. For Per Day and Per Enrollment FTE Calculations:
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar >Days / Periods Student Information >General > Attendance |
Student Aggregate Membership | Aggregate number of days the student was present for the days of operation plus the aggregate number of days the student was absent for the days of operation. When a student is absent more than ten consecutive calendar days, all those days beyond ten are deleted. A student who withdraws is dropped from membership the day after withdrawal. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor.
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar > Days / Periods Student Information > General > Attendance |
Student Aggregate Unexcused Absences | Aggregate number of days the student was absent, as defined by the local board of trustees, of any student required to attend school when such absence is not excused to the satisfaction of the board of trustees by the parent, guardian, or other person having control of such student. The format change is to accommodate for the Unexcused Absences for > 99 days. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor. For Per Day and Per Enrollment FTE Calculations:
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar >Days / Periods Student Information > General > Attendance |
| Student Aggregate Attendance Offsite | This field aggregates student attendance recorded for remote learning. Attendance calculates to the nearest thousandth. Only days that fall on or between the Start and End Dates entered in the extract editor are reported. Attendance events are counted if one of the following applies:
| Scheduling > Blended Learning Student Information > General > Blended Learning Group Assignments |
Summary Format
Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information if the Report Student Legal Identities checkbox is marked.
Element Name | Description and Format | Location |
|---|---|---|
| School Name | The name of the school. | System Administration > Resources > School > Name school.name |
District ID | The WDE 7-digits ID for the district submitting the student's data Reports from the Resident District field on enrollments if entered. Otherwise reports State District Number. Numeric, 7 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District System Administration > Resources > District Information > State District Number Enrollment.residentDistrict district.ncesDistrictID |
School ID | The WDE 7-digit ID for the school of the student's enrollment Reports from the Resident School field on enrollments if entered. Otherwise, reports State School Number. Numeric, 7 digits | Student Information > General > Enrollments > State Reporting Fields > Resident School System Administration > Resources > School > State School Number Enrollment.residentDistrict School.ncesSchoolID |
Student WISER ID | The WDE 8-digit state-assigned student record identifier. Numeric, 8 digits | Census > People > Demographics > Person Identifiers > Student State ID person.studentNumber |
Student Last Name | Student's last name. Alphanumeric, 40 characters | Census > People > Demographics > Person Information > Last Name identity.lastName |
Student First Name | Student's first name Alphanumeric, 35 characters | Census > People > Demographics > Person Information > First Name identity.firstName |
Student Middle Name | Student's middle name. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Middle Name identity.middleName |
Student Name Suffix | Indication of the student being a Sr., Jr., III, IV, etc. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Suffix identity.suffix |
Student Grade Level | The grade level of the student's current enrollment Alphanumeric, 4 characters | Student Information > General > Enrollment > Grade enrollment.grade |
Student Date of Birth | Student's date of birth Date field, 8 characters, MMDDYYYY | Census > People > Demographics > Person Information > Birth Date identity.birthdate |
Student Gender | Student's gender Alphanumeric, 1 character M or F | Census > People > Demographics > Person Information > Gender identity.gender |
Asian Race | Federal race/ethnicity determination of student being considered as Asian. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
Black Race | Federal race/ethnicity determination of student being considered as Black. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
Indian Race | Federal race/ethnicity determination of student being considered as Indian. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
Pacific Islander Race | Federal race/ethnicity determination of student being considered as Pacific Islander. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
White Race | Federal race/ethnicity determination of student being considered as White. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.raceEthnicity |
Hispanic Ethnicity | Federal race/ethnicity determination of student being considered as Hispanic. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Race/Ethnicity identity.hispanicEthnicity |
Student Aggregate Attendance | Aggregate number of days the student was present during the days of operation. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor. For Per Day and Per Enrollment FTE Calculations:
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar >Days / Periods Student Information >General > Attendance |
Student Aggregate Membership | Aggregate number of days the student was present for the days of operation plus the aggregate number of days the student was absent for the days of operation. When a student is absent more than ten consecutive calendar days, all those days beyond ten are deleted. A student who withdraws is dropped from membership the day after withdrawal. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor.
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar >Days / Periods Student Information >General > Attendance |
Student Unexcused Absences | Aggregate number of days the student was absent, as defined by the local board of trustees, of any student required to attend school when such absence is not excused to the satisfaction of the board of trustees by the parent, guardian, or other person having control of such student. The format change is to accommodate for the Unexcused Absences for > 99 days. Calculates by Minutes or by Periods based on the Calculation Method selected in the extract editor. For Per Day and Per Enrollment FTE Calculations:
Half day determination
Decimal, 6 characters | System Administration > Calendar > Calendar > Days / Periods Student Information > General > Attendance |
| Student Aggregate Attendance Offsite | This field aggregates student attendance recorded for remote learning. Attendance calculates to the nearest thousandth. Only days that fall on or between the Start and End Dates entered in the extract editor are reported. Attendance events are counted if one of the following applies:
Numeric, 3 digits | Calculated from: Scheduling > Blended Learning System Administration > Calendar > Calendar > Days System Administration > Attendance > Attendance Codes > State Code |
