Scripts

Part B Caseload

This script will update the child's Caseload profile and works as follows:

• Removes any staff name where Manually Added = No.

• Inserts the student's Special Ed Teacher/Case Manager from the student's Special Education Part B profile.

• Inserts the Assigned Provider name from the student's Part B IEP Services profile where the service start date is less than or equal to “todays” date and the service end date is greater than “todays” date.

Set Profile Tags

When the script is executed, it will validate the student data as described below and will display REF as the student tag as follows:

• The student does not have an active IEP (IEP tag is not displayed) or active Service Plan (SP tag is not displayed) and

• Where the Initial Eligibility date on the Special Education Part B profile is blank and

• The student's latest Referral Part B profile reason is Initial, Out of State IEP or Part C to Part B Transition and

• Where the Consent Response on the Referrals Part B profile does not have any of the values selected or

• Where the Consent Response on the Referrals Part B profile has the Consent Granted checkbox selected

When the script is executed, it will validate the student data as described below and will display or IEP as the student tag as follows:

• The student's Initial Eligibility Outcome or Eligibility Outcome on the Special Education Part B profile is Eligible and

• The student's Special Education Exit Date on the Special Education Part B profile is blank and

• The IEP Start Date (IEP tag) or Comparable on the Special Education Part B profile is not blank or

• The Initial IEP Date on the Special Education Part B profile is not blank and

• LEA Entry/Exit latest enrollment record has a blank Enrollment Exit Date value or

• LEA Entry/Exit latest enrollment record has an exit reason not equal to Died or is permanently incapacitated, Exited state; exited to home-schooling or a public, private, or online diploma-granting school in a different state, Exited the state public school system to attend a private school in the same state, Exited to a school outside of the United States, Exited to an institution that is not administered or tracked by DC public or public charter schools (for example, military, Federal Bureau of Prisons, DC Jail programs not administered by DCPS, etc.), Received a state diploma from the Office of the State Superintendent of Education, Received a technical certification or nationally or state-recognized vocational education certification, Student voluntarily discontinued education after enrolling in an adult education program in a DC public or public charter school, Withdrawn due to reaching the maximum age served by the LEA or because student will reach the maximum age served by the LEA before completion of school is possible, Withdrawn for ineligibility reasons (for example, immunization or residency); eligible to seek re-enrollment, or Withdrawn from school, under the age for compulsory.

NOTE: The SP (Service Plan) icon is not managed via the script. The SP icon will appear when the student has an Service Plan Completion Date on the Special Ed Info profile and the Special Ed Exit Date is blank and the Enrollment Exit Date in the LEA Enrollment Entry/Exit profile is blank and the student is Eligible for Special Education (on the Special Ed Info profile) and the IEP flag is not valid.

Update Staff LEAPOC Field

This script will set the Staff LEAPOC flag for Staff members imported into a Part B district tenant.

Populate SWD Count Summary

This script runs when the Special Education Count Date in the Global profile equals the current date. It will populate the SWD Count Summary child profile for students meeting the script's selection criteria. 

OSSE Trigger - Set

This script sets the OSSE Trigger flag to notify the State|Regional Module that the staging data is ready for processing.

OSSE Trigger - Unset

This script unsets the OSSE Trigger flag to indicate that the State|Regional Module has processed the data. 

Insert/Update Historical Disability Profile

The script will create a new primary or secondary disability record in the student's Disability History Part B profile based when the student's Eligibility Outcome (under Initial Eligibility Information or Eligibility Determination sections of the Special Education Part B profile) has a value of Eligible. The script will use the student's Most Recent Eligibility Start Date (or the Initial Eligibility Date if the Most Recent Eligibility Start Date is blank) as the Disability Start date. The script will use the Primary or Secondary Disability values on the Special Education Part B profile to create the Disability History records.

The script will end existing Disability History records when the student has a later date value in the Special Education Part B profile, Most Recent Eligibility Start Date that is greater than the Disability History start date, and the disability (primary or secondary) is different from what the existing Disability History profile has reported.

The script will end existing Disability History records when the student has a value of Not Eligible on the Special Education Part B profile, Eligibility Outcome.

Set First Delivered, Attempted date in IEP Services

The script will search for the earliest service capture record associated to the IEP Service Part B profile. If the service capture record has a session type of 1,2,4,5,6 it will insert the service capture date into the First Attempted field. If the service capture record has a Service Type (SessionTypePartB keyword table) value of Yes in the Provided Session column (e.g. Consultation and Direct Service).

Part B Deactivate Students

The script will deactivate (displays INACTIVE in red font) when the student has an Enrollment Exit Date that is less than or equal to “todays” date in the most recent LEA Entry/Exit profile.

CFSA Security Group Assigned to Caseload

This script automatically inserts the staff’s name into the Caseload profile when the staff has the CFSA security group assigned and the student has the IS the child linked with CFSA option checked.

The checkbox “Manually Added” is set to No as the staff was added via the script. The script will NOT remove names from the student’s Caseload profile.

Clear ORP Checkbox When Service Provider Is Blank

Currently, when a student with an IEP Service Part B record transfers between LEAs/tenants via the transfer envelope process, the assigned Staff ID from the sending district often does not exist in the receiving district. This results in a data discrepancy where the IEP Services Part B profile retains a "Service Provider Position" and a checked ORP (Ordering/Referring Provider) status, but the Service Provider Name field becomes blank. To ensure data integrity and compliance with state reporting (OSSE), a daily automated script is required to identify these orphaned records and uncheck the ORP flag when no valid service provider is assigned.