1. School_number = match to the field that contains your school’s state assigned number OR enter the default value
2. Student test number = match to the field that contains your students’ state testing number (STN)
3. Grade level = already matched to the grade year field from demographics table (unless you use the year of graduation for this & then use your grade level field)
4. Corp Number of Legal Settlement = match to your demographics field that contains your corporation number OR pull from the district id number found in the district information area
5. Referral = add a new field to one of the *demographics_supplemental_# tables
6. Circumstances relevant to timeline = add a new field to one of the *demographic_supplemental_# tables (like above)
7. Case conference = add a new field to one of the *demographics_supplemental_# tables
8. Student eligibility = add a new field to one of the *demographics_supplemental_# tables
9. Services beginning for first steps transition students = add a new field to one of the *demographics_supplemental_# tables
10. Reason for missed deadline = add a new field to one of the *demographics_supplemental_# tables
* There are 5 of the demographics supplemental tables available for use in web school office. Use one of these tables to set up the fields for data entry for this report. Next create a view for data entry into these new fields, and name the view DOE-EV (for convenience). The nice thing about the demographics_supplemental tables is that you can have multiple records per student, if necessary, and therefore report multiple records for a student as required by the state report.
•Once the new fields are added to the new table, you can code those fields so that only state-allowed data is entered. For directions on coding fields in web school office,
For schools who need to submit data regarding Special Education Evaluation (DOE-EV) and Special Education Transition (DOE-TR) reports, here are some suggestions for storing and submitting your data.
•Use one of the Demographics_Supplemental_# tables (where # represents 1 through 5) to store this data.
o Using one of these tables keeps your demographics table more “clean”
o It also allows you to have multiple records per student for situations where a student may enroll, transition, then re-enroll into a special education program.
•Add the new fields necessary to submit the data for these two reports.
o You can put all of the new fields for both reports in the same table.
§ DOE-EV
•Referral date
•Circumstances relevant to timeline
•Case conference date
•Student eligibility
•Services beginning for First Steps transition students
•Reason for missed deadline or services not beginning
§ DOE-TR
•Date of termination or transition
•Reason for termination or transition
o Adding fields to the table can be done by:
§ Following these instructions or
§ Use the yellow triangle icon by the red #1 to CREATE NEW FIELDS in your database if a field does not exist. Check with the district computer technician or other employee before adding a new field.
•Create views for entering the new data field values by following these directions
•Code some of the fields (like the circumstances, eligibility, reason for missed deadline, reason for termination) using these directions: