Tool Search: SLDS
The Average Daily Membership extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Example 6 PS ADM Extract EditorReport Logic
All students with an Enrollment on or prior to the Effective Date selected on the extract editor report.
- Students are NOT included if their enrollment is marked as State Exclude.
To report, the student must be assigned one of the following ADM Types (Student Information > General > Enrollments > State Reporting Fields > ADM Type). Otherwise, the student does not report.
R: Resident Student
S: State Place Student
O: Other
Multiple records report if the student has two or more ENORGIDs in a Supervisory Union or District.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 6 PS ADM |
| Effective Date | The date from which data is pulled for the report. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when you select HTML for the File Format and can assist you with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the 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. |
Report Layout
| Element | Logic | Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. | Alphanumeric, 6 characters | District.number | School & District Settings > District Information > District Detail > State District Number |
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. | Alphanumeric, 6 characters | School.number | School & District Settings > School > School Detail > State School Number |
| PERNUMBER | The VT AOE assigned unique student identifier. This number is distinct for each student over time. | Alphanumeric, 10 characters | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
| FUNDSOURCE | The person, group, or organizational entity paying for a student's educational expenditure. | Alphanumeric, 2 characters | Enrollment.stateFundingCode | Enrollments > State Reporting Fields > Funding Source |
| ADMTDIST | The VT AOE assigned unique identifier for the town district of residence. | Alphanumeric, 6 characters | Enrollment.residentDistrict | Enrollments > State Reporting Fields > Resident District |
| ADMTYP | The ADM Type (Resident/State Placed). | Alphanumeric, 1 character | EnrollmentVT.admType | Enrollments > State Reporting Fields > ADM Type |
| ADMFPSTAT | A student's full/part time status as determined by the Vermont State Board of Education Rule. | Alphanumeric, 1 character | EnrollmentVT.fullPartTimeStatus | Enrollments > State Reporting Fields > Full-Part Time Status |
| ADMHOURS | The number of school hours the part-time student is expected to attend each week. | Numeric NN.NN | EnrollmentVT.partTimeHours | Enrollments > State Reporting Fields > Part Time Hours |
| ADMBEG | The month, day, and year marking the student's first instructional day in the calendar year. | Date Field MM/DD/YYYY | Enrollment.startDate | Enrollments > State Reporting Fields > Start Date |
| HS_ACTIVTDISTID | The VT AOE assigned unique identifier for the student's town district of residence. The town district of residence should reflect the home study student's activity period. To report, the Admission Status must be one of the following.
Otherwise, this element reports NULL. | Alphanumeric, 6 characters | EnrollmentVT.admissionStatus Enrollment.residentDistrict | Enrollments > State Reporting Fields > Resident District. |
| HS_ACTIVADM | The summation of ADM values corresponding to all eligible activities where a home study student may be credited a proportional Average Daily Membership (ADM). To report, the Admission Status must be one of the following.
Otherwise, this element reports NULL. | Numeric N.NN | EnrollmentVT.admissionStatus EnrollmentVT.partTimeHours | Enrollments > State Reporting Fields > Part Time Hours |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | N/A | N/A |
