Skip to main content
Skip table of contents

DL Subclass I Standard

The Subclass I Standard reports details about important steps such as evaluations, parental consent, and eligibility decisions. The report helps track if these steps are completed on time and follows the rules set by special education guidelines. It supports schools in making sure students get the help they need.

Submission requirements

This report includes:

  • Students who are between the ages of three and five years old as of the selected school year.

  • Students who had an active IEP plan during the school year.

  • Students who were enrolled in the reporting district (not in excluded schools) at any time between September 15 and June 30 of the selected school year.

IEP and Enrollment Conditions

  • The IEP meeting must have occurred while the student was still actively enrolled in the district.

  • The IEP must be a new or ongoing plan; amended-only plans are not included.

Additional Notes

  • Both active and inactive student records are included in the report.

  • Students enrolled in excluded schools are not counted.

Set reporting duration

Select the year range from the drop-down menu in the report.

Execute Update Script

  1. From the Administration menu, choose Configuration, Profile Types.

  2. Click Update Scripts, then click LEA Calendar Information.

  3. Click on Subclass I Part B and then Execute Script.

  4. Click Refresh after opening the report in the application.

This scheduled script runs daily during non-peak hours. However, to view immediate updates after any changes, the script must be executed manually.

Columns not listed here are populated through the script:

  • Student USI

  • Student Name

  • LEA Code

  • LEA Name

  • School Code

  • School Name

  • Enrolled

Generate report

  1. From the Reporting menu, choose Standard reports.

  2. Click Data reporting, then click Part B Federal Reporting.

  3. Select Subclass I Standard.

  4. Select the Year Range from the drop-down.

  5. Click Update Report with Values.

Field descriptions

Data Element

Description

Data Source

Database Field Name

Student USI

The system will display the student's USI.

Student>Demographics>

{StateID}

Student Name

The system will display the first and last name of the student.

Student>Demographics>

{FirstName} 

Third Birthday

The system will calculate the Student's third birthday.

Calculated based on the Date of birth.

{ThirdBirthday_Data}

Sixth Birthday

The system will calculate the Student's sixth birthday.

Calculated based on the Date of birth.

(SixthBirthday_Data)

LEA Code

The LEA Code for the Student must be within the reporting date range. The student will appear multiple times in the report for each time the student changes LEAs.  

LEA Entry/Exit Profile

{EnrollmentDistrict} LEA ID {ID}

LEA Name

LEA Name that is in the reporting date range. 
The student will appear multiple times in the report, every time the student changes LEAs.  

LEA Entry/Exit Profile

{EnrollmentDistrict} Name {NAME}

School Code

Code of the school where the student was most recently enrolled in the LEA.

LEA Entry/Exit Profile

{EnrollmentSchool} ID

School Name

Description of the school where the student was most recently enrolled in the LEA.

LEA Entry/Exit Profile

{EnrollmentSchool}

IDEA Service Type

An indicator of what type of services the student was receiving. The IEP indicates that the student had an IEP and was enrolled in a DC LEA; an ISP indicates that the student had an ISP and was enrolled in a parentally placed private school. 

Plan History Part B Profile
Report IEP if {PlanMeetingDate} is available and Plan Type = IEP
Report ISP if {PlanMeetingDate} is available and Plan Type = Service Plan
Repeat the student row if the student has more than 1 IEP or more than Service Plan

{PlanType!}

IEP/ISP/IFSP Entry (Start) Date

Start date of IEP or ISP.
For IEP: Must be Stage 5 enrollment.
For ISP: Must be Stage 4 enrollment (PRO, LEA Code: 001, School Code: 7000)

Plan History Part B Profile
Report the associated {PlanMeetingDate} for both IEP and Service Plan Types.           
Repeat the student row if the student has more than 1 IEP or more than Service Plan
IFSP is not used at this time as Part C is on hold.

{PlanMeetingDate!}

IEP/ISP/IFSP End Date

End date of IEP or ISP.

Plan History Part B Profile
Report the associated {{PlanEndDate}} for both IEP and Service Plan Types.           
Repeat the student row if the student has more than 1 IEP and Service Plan.

IFSP is not used at this time as Part C is on hold

{PlanEndDate}

IEP/ISP/IFSP Negation Date

If applicable, the negation date of IEP or ISP.

Special Education Part B Profile

(IEPNegationDate}

{SpecialEducationExitDate}

Earliest snapshot date of Stage 4 or Stage 5 Enrollment in the Current School Year

Start date of IEP or ISP.
For IEP: Must be Stage 5 enrollment.
For ISP: Must be Stage 4 enrollment (PRO, LEA Code: 001, School Code: 7000)

LEA Entry/Exit profile.

{EnrollmentStartDate}

Date IEP/ISP Services Completed

The date on which all services on the IEP or Service plan had been completed at least once since the start of the IEP. For students with IEPs without related services prescribed, the IEP start date is shown for the purposes of calculation.

SelectCase( not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ): PlanMeetingDate, MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_Sp_Data: null: TopOneValueOf(PartBIEPServices, SClassDelivered, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate): FirstSessionDate DESC) )

{SClassDelivered}

Date IFSP Services Completed

The date on which all services on IFSP had been completed at least once.

This column will appear empty.

This column will appear empty.

Has Specialized Instruction Prescribed

Indication of if the student has specialized instruction prescribed on the current IEP; only applicable to students with IEPs (not IFSPs or ISPs);

  • "No" indicates that no specialized instruction is prescribed;

  • "Yes" indicates that specialized instruction is prescribed.

  • "NA" indicates that the student is not an IEP

SelectCase( PlanType in(SP): "NA", HasSpecInst_Data: "Yes": "No" )

{HasSpecInst_Data}

Earliest date of Specialized Instruction

The earliest date on which the student has specialized instruction is provided. Does not have to be on the current IEP

SelectCase( PlanType in(SP) or not HasSpecInst_Data: "NA": Character(Student.FirstDateSI) )

{HasSpecializedInstruction:R}

Enrolled September

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before September 15 of the particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 9, 15) and (ConstructDate(YearParam.StartYear, 9, 15) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled October

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = October.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 10, 1) and (ConstructDate(YearParam.StartYear, 10, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

Enrolled November

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = November.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 11, 1) and (ConstructDate(YearParam.StartYear, 11, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled December

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = December.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 12, 1) and (ConstructDate(YearParam.StartYear, 12, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled January

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = January.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 1, 1) and (ConstructDate(YearParam.StartYear, 1, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled February

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = February.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 2, 1) and (ConstructDate(YearParam.StartYear, 2, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled March

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = March.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 3, 1) and (ConstructDate(YearParam.StartYear, 3, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled April

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = April.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 4, 1) and (ConstructDate(YearParam.StartYear, 4, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled May

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = May.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 5, 1) and (ConstructDate(YearParam.StartYear, 5, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Enrolled June

This field counts the number of students who meet the following criteria on a month-on-month basis.

  • Checks if a relevant enrollment record exists.

  • Validates if enrollment belongs to the current district.

  • Ensures the student started enrollment on or before the 1st of the month in that particular year, then

    • Value is displayed as 1

    • Otherwise, the value is displayed as 0.

Here Month = June.

Calculated field. Use the following formula.
ifelse (Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 6, 1) and (ConstructDate(YearParam.StartYear, 6, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)), 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}

Subclass I September

Month on month basis this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before September 15 of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services before September 15.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

And if all conditions are met, the return value is 1, and the total count is incremented.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 9, 15) and ConstructDate(YearParam.StartYear, 9, 15) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 9, 15) and (ConstructDate(YearParam.StartYear, 9, 15) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 9, 15)) <= ConstructDate(YearParam.StartYear, 9, 15) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I October

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = October.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 10, 1) and ConstructDate(YearParam.StartYear, 10, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 10, 1) and (ConstructDate(YearParam.StartYear, 10, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 10, 1)) <= ConstructDate(YearParam.StartYear, 10, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I November

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = November.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 11, 1) and ConstructDate(YearParam.StartYear, 11, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 11, 1) and (ConstructDate(YearParam.StartYear, 11, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 11, 1)) <= ConstructDate(YearParam.StartYear, 11, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I December

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = December.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 12, 1) and ConstructDate(YearParam.StartYear, 12, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 12, 1) and (ConstructDate(YearParam.StartYear, 12, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 12, 1)) <= ConstructDate(YearParam.StartYear, 12, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I January

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = January.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 1, 1) and ConstructDate(YearParam.StartYear, 1, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 1, 1) and (ConstructDate(YearParam.StartYear, 1, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 1, 1)) <= ConstructDate(YearParam.StartYear, 1, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I February

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = February.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 2, 1) and ConstructDate(YearParam.StartYear, 2, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 2, 1) and (ConstructDate(YearParam.StartYear, 2, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 2, 1)) <= ConstructDate(YearParam.StartYear, 2, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I March

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = March.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 3, 1) and ConstructDate(YearParam.StartYear, 3, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 3, 1) and (ConstructDate(YearParam.StartYear, 3, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 3, 1)) <= ConstructDate(YearParam.StartYear, 3, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I April

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = April.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 4, 1) and ConstructDate(YearParam.StartYear, 4, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 4, 1) and (ConstructDate(YearParam.StartYear, 4, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 4, 1)) <= ConstructDate(YearParam.StartYear, 4, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I May

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = May.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 5, 1) and ConstructDate(YearParam.StartYear, 5, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 5, 1) and (ConstructDate(YearParam.StartYear, 5, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 5, 1)) <= ConstructDate(YearParam.StartYear, 5, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

Subclass I June

On a month-on-month basis, this field is used to count the number of students who meet the following criteria.

  • Enrollment Criteria: The student must be enrolled in the district, excluding specific schools (6000 and sometimes 7000 under certain conditions).

  • Meeting Plan Validity: The meeting date must be on or before the 1st of the 'Month' of the start year, and the plan must still be valid.

  • Service Completion: The student must not have missing service data and must have received required services on or before the 1st of the 'Month' of the start year.

  • IEP Services: Checks whether certain Individualized Education Program (IEP) service types exist within the required timeframe.

Note:

  • Iif all conditions are met, the return value is 1

  • If the conditions are not met, the return value is 0.

Here Month = June.

ifelse( PlanMeetingDate <= ConstructDate(YearParam.StartYear, 6, 1) and ConstructDate(YearParam.StartYear, 6, 1) <= PlanEndDate_Data and Exists(EnrollmentLEAEntryExit, EnrollmentDistrict = Globals.ThisDistrict and not (EnrollmentSchool.ID = "6000" or (EnrollmentSchool.ID <> "7000" and EnrollmentStage in(Stage4))) and EnrollmentStartDate <= ConstructDate(YearParam.StartYear, 6, 1) and (ConstructDate(YearParam.StartYear, 6, 1) <= EnrollmentExitDate or EnrollmentExitDate is empty)) and not(MissingService_Data[D1] or MissingService_Data[D2] or MissingService_Data[D16] or MissingService_Data[D3] or MissingService_Data[D4] or MissingService_Data[D5] or MissingService_Data[D6] or MissingService_Data[D14] or MissingService_Data[D8] or MissingService_Data[D7] or MissingService_Data[D9] or MissingService_Data[D15] or MissingService_Data[D12] or MissingService_Data[D11] or MissingService_APE_Data or MissingService_SI_Data or MissingService_Sp_Data) and (( ifnull(ServiceDeliveredDate_Data[D1], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D2], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D16], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D3], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D4], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D5], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D6], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D14], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D8], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D7], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D9], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D15], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D12], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDeliveredDate_Data[D11], ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDelivered_APE_Data, ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDelivered_SI_Data, ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) and ifnull(ServiceDelivered_Sp_Data, ConstructDate(YearParam.StartYear, 6, 1)) <= ConstructDate(YearParam.StartYear, 6, 1) ) or not Exists(PartBIEPServices, ( IEPServiceType in(Related) or (IEPServiceType in(Sped) and SPEDService in (8)) or (IEPServiceType in(Consultation) and ConsSRVS in (2)) or (IEPServiceType in(Sped) and SPEDService in (7)) or (IEPServiceType in(Consultation) and ConsSRVS in (1)) or (IEPServiceType in(Sped) and SPEDService in (6)) or (IEPServiceType in(Consultation) and ConsSRVS in (15)) ) and Outer.PlanMeetingDate = IEPDate and (Outer.AmendmentDate is empty or Outer.AmendmentDate < SRVSEndDate) ) ) , 1, 0)

{EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate}, {MissingService_Data}, {MissingService_APE_Data}, {MissingService_SI_Data}, {MissingService_Sp_Data}, {ServiceDeliveredDate_Data}, {ServiceDelivered_APE_Data}, {ServiceDelivered_SI_Data}, {ServiceDelivered_Sp_Data}

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.