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
From the Administration menu, choose Configuration, Profile Types.
Click Update Scripts, then click LEA Calendar Information.
Click on Subclass I Part B and then Execute Script.
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
From the Reporting menu, choose Standard reports.
Click Data reporting, then click Part B Federal Reporting.
Select Subclass I Standard.
Select the Year Range from the drop-down.
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. | 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 | {PlanType!} |
IEP/ISP/IFSP Entry (Start) Date | Start date of IEP or ISP. | Plan History Part B Profile | {PlanMeetingDate!} |
IEP/ISP/IFSP End Date | End date of IEP or ISP. | Plan History Part B Profile 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. | 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);
| 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.
| Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled October | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = October. | Calculated field. Use the following formula. | |
Enrolled November | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = November. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled December | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = December. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled January | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = January. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled February | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = February. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled March | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = March. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled April | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = April. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled May | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = May. | Calculated field. Use the following formula. | {EnrollmentSchool.ID}, {EnrollmentStartDate}, {EnrollmentExitDate} |
Enrolled June | This field counts the number of students who meet the following criteria on a month-on-month basis.
Here Month = June. | Calculated field. Use the following formula. | {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.
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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.
Note:
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} |