How Bonneville Joint School Integrated Laserfiche with PowerSchool

Schools process large amounts of paperwork for each new and returning student.

The Problem

With nearly 12,000 students enrolled in 24 schools, Bonneville Joint School District No. 93 (D93) is the fifth largest school district in Idaho. Located in Bingham and Bonneville Counties, D93 employs over 1,600 people, of whom nearly 600 are certificated personnel.

D93 has 14 elementary schools, three middle schools, and four high schools, including two comprehensive high schools, an alternative high school, and a Magnet school. D93 also offers curriculum online through Bonneville Online.

To manage the large student population in the district’s schools, every school year, school secretaries would have to process large amounts of paperwork for each new and returning student. Since parents filled out 11 paper forms per child per year, it took 20-30 minutes per child just to enter the information into the PowerSchool student information system.

"As part of the student registration process, parents or guardians fill out an online new student registration form on the school’s website. Parents fill out an electronic student registration form during registration."

The Solution

Using Laserfiche Forms and Workflow, the district automated the entire student registration process, reducing the time required to complete the process by 96%—from 30 minutes to just one minute. Now, parents fill out an electronic student registration form, and the information is automatically pushed to PowerSchool, saving time for both parents and school district employees.

As part of the student registration process, parents or guardians fill out an online New Student Registration form on the school’s website. Parents fill out an electronic student registration form during registration.

Based on the parents or guardians’ selections, fields appear dynamically to obtain more information.

To simplify the routing of the form after it is submitted, the form includes a hidden field that contains the name of the appropriate school secretary. This field is populated using a database lookup based on the name of the school in which the student is being enrolled.

Once the form is submitted, it is routed to the Secretary specified in the hidden field. The Secretary reviews the form to ensure that all information, most importantly the address, is formatted correctly and makes any changes as needed.

Once the Secretary approves the form, it is saved in the Laserfiche repository, launching the “New Student Registration” workflow. The student registration process is mapped in Laserfiche Forms.

When a student is re-registered the following year, the parent inputs the student’s ID number into the form, and the rest of the information is populated automatically from the PowerSchool database. The parent can edit any of the information if it has changed from last year before submitting the form.

Once the form is approved, Laserfiche Workflow populates the PowerSchool database with information entered in the form. If the student’s record already exists in PowerSchool, information that has changed is updated. If the student is new, a new record is created.

Information in PowerSchool contains the three different tables, so three different data update activities are used. Each activity updates in a separate table:

  • Students
  • Studentcorefields
  • U_Studentsuserfields

If the student is a Spanish speaker, the U_Spanish field is also updated. Laserfiche Workflow inserts information from the registration form into the PowerSchool database.

Once updated, PowerSchool and Workflow automatically notifies the Secretary of the successful registration by email.

Laserfiche Solution Contributed By: David Covert, Enterprise Applications Supervisor, Bonneville Joint School District No. 93 Original Post

top