Scripts

Scripts execute a series of commands, typically to update an extensive data set in a single process.

Navigate to Administration, Configuration, Profile Types, and then Update Scripts.

Executing a Script

Click the magnifying glass next to the script to execute it. A summary of the script, its content, the schedule for running, and the last time the script ran are listed.
Click the Execute Script button.
Click OK on the dialog box to confirm the execution of the script. When the script processing is completed, a message will appear listing the number of successfully processed records.

Scripts

Name	Description
DeleteUnassignedStaffFromCaseload	This script will remove the staff’s name from the profile if the profile record if the “Manually Added” checkbox is not checked (false) and does not match the student’s Speech Therapist, Case Manager or Special Education Teacher in the Special Education Information profile. Any staff manually added to the student’s Caseload will not be removed via the script and must be removed by a user.
00_SPED Exit Date & Reason from Enrollment	When the student’s Enrollment Exit Reason value is Enrollment in another AR School (code 010), Moved Out of State (code 014),or Enrolled in an AR Charter School (code 017), the system will insert the Special Ed Exit Reason matching the same exit value and Special Ed exit date using enrollment exit date. The enrollment value of Deceased (code 030) will insert the special ed exit reason of 030. Reach Max Age (code 170) enrollment value will insert the special ed exit reason of 170. The script updates the students Special Ed Information screen as well as the Special Education Exit History profile.
Maintain Enrollment History - AR Model	When the script is executed, it will insert/add or update a record in the student's Enrollment History profile based on the following logic: ADDS a new Enrollment History record if there is no existing record with the same Enrollment Start date using the Enrollment Start Date from the Student Information profile. The system will insert a new record and inserts the District, School, Grade, Enrollment Start Date values from the Student Information profile. UPDATES the existing Enrollment History record if the school, grade, Enrollment End Date or Enrollment Exit Reason change. When the Enrollment Start Date on the Student Information Profile changes (e.g., new school year), the system will CREATE a new Enrollment History record. If there is an existing Enrollment History record with a blank end date, the script will use the day prior to the new enrollment start date and insert that into the Enrollment End Date field so there are no overlapping active enrollments.
eSchoolPLUS program Profile	The script will create or update (end date and exit reason) an existing record based on the following: Early Childhood Program (newly referred and found eligible for special education) The profile script will CREATE an Early Childhood eSP Program record when: the most recent Referral record has an IEP Type = Early Childhood and has a Parent Consent to Place date value where there is no open/active Early Childhood eSchoolPLUS Program profile record and no open/active School Age eSchoolPLUS Program profile record and where the student is under 7 years old as of the current date (today). It will create the Early Childhood Program record using the Referral profile Parent Consent to Place date value as the start date. The profile script will UPDATE an Early Childhood eSP Program record when: the student has an Early Childhood Program profile record where the end date is blank and the student has either an Early Childhood Exit Date or Special Ed Exit Date on the Special Education Information profile. It will use the Special Education exit date and reason from the Special Education Information profile and updates the currently open ended Early Childhood record. School Age Program (newly referred and found eligible for special education) The profile script will CREATE an School Age eSP Program record when: the most recent Referral record has an IEP Type = School Age and has a Parent Consent to Place date value where there is no open/active School Age eSchoolPLUS Program record. It will create the School Age Program record using the Referral profile Parent Consent to Place date value as the start date and where the student Active (student is not inactive as displayed in red font Inactive) and the student’s Special Ed Exit Date is blank and student has an Early Childhood Exit Date in the Special Education Information profile and does NOT have an eSP Program profile record with the day after the Early Childhood Exit Date value, it will create a new school age program record using the day after the Early Childhood exit date as the School Age program record’s start date. This means that the student exited the Early Childhood program but is still in Special Education, now in the School Age program continuing to receive special education services. The script will then update the existing Early Childhood program record with the Early Childhood exit date and exit reason (from the Special Education profile) as the Early Childhood program end date and exit reason. It also creates a new School Age program record with the start date, using the day after the Early Childhood exit date. The profile script will UPDATE an School Age eSP Program record when: the student has a School Age Program profile record with a blank end date and the student has a Special Ed Exit Date on their Special Ed Info profile, it will update the exit date and reason from the Special Education Information profile. School Age Program (student moves into district with an existing IEP) When a student with an IEP has moved into the district as a special education student, the script will create a new School Age Program or Early Childhood Program record when the student has the following: student does not have an open ended existing eSchoolPLUS School Age or Early Childhood program record (record exists with no end date) and; the student has the IEP flag displayed and; the student has an Enrollment Start Date (on the Student Information screen) and; the student does not have an Enrollment End Date (on the Student Information screen The script will insert a School Age or Early Childhood eSP Program record using the Plan Type value on the Special Education Information profile. The script will use the Enrollment Start date as the eSP Program record’s start date value.
Set Profile Tags	This script will set the student’s REF (Referral icon that appears next to the student’s name) based on the following logic: student does not have an Annual Review Due Date on the Special Education Information profile AND On the latest referral profile record: Parent Consent = Granted or no value is indicated Reason for Completion = blank
Set Student to Inactive	This script will deactivate the student if there is an Enrollment Exit Date on the Student Information profile.