Affirm/Data Quality Tool

The School District of Philadelphia uses Affirm as our data quality tool. Affirm is used to verify that student data within Infinite Campus is accurate. The resources below are organized into rule-specific categories.

ResourcesRule DescriptionResource TypePotential Users
DS 100Behavior Resolution Start & End Date must be on an instructional day during the school yearQuick FixPrincipal, AP, Climate Manager, Dean
DS 109Behavior Resolution Start Date must not be before the associated Incident DateQuick FixPrincipal, AP, Climate Manager, Dean
DS 121Every absence coded as out-of-school-suspension (Code 15) must be linked to an out-of-school suspension on the behavior tabQuick FixPrincipal, AP, Climate Manager, Dean
DS 122Suspension Behavior Resolutions cannot start or end in the middle of the school dayQuick FixPrincipal, AP, Climate Manager, Dean
DS 123Suspension Behavior Resolutions for different Behavior Incidents cannot overlapQuick FixPrincipal, AP, Climate Manager, Dean
DS 125When an incident has multiple Behavior Events, the start and end dates for suspension Behavior Resolution must be exactly the sameQuick FixPrincipal, AP, Climate Manager, Dean
DS 150Students can only be suspended for valid legal offenses according to the Behavior Matrix.Quick FixPrincipal, AP, Climate Manager, Dean
DS 151K-2 students cannot have a suspension Behavior Resolution without approvalQuick FixPrincipal, AP, Climate Manager, Dean
DS 300Every Behavior Resolution of "11 - Referred to the ICU" must be called into the ICU desk.Quick FixPrincipal, AP, Climate Manager, Dean
DS 302Every Behavior Event must have a Behavior Resolution for each OffenderQuick FixPrincipal, AP, Climate Manager, Dean
DS 303Every Behavior Event must have at least one Offender or VictimQuick FixPrincipal, AP, Climate Manager, Dean
DS 402A Behavioral Incident should not have two Behavior Events of the same type for the same studentQuick FixPrincipal, AP, Climate Manager, Dean
DS 403A student should not have multiple behavioral incidents
that occur at the same time (within 5 minutes)
Quick FixPrincipal, AP, Climate Manager, Dean
DS 404A single Code of Conduct violation event should not have 2 Behavior Resolutions of the same typeQuick FixPrincipal, AP, Climate Manager, Dean
DS 500Only Behavior Events of Seclusion/Restraint (Code 33/34) must have a completed Behavior Response Quick FixPrincipal, AP, Climate Manager, Dean
DS 502Only Behavior Events of Seclusion/Restraint (Code 33/34) must have the checkbox selected for "This event required the use of a Behavior Response"Quick FixPrincipal, AP, Climate Manager, Dean
ResourcesRule DescriptionResource TypePotential Users
EL 105All students who were tested for EL services must have an Initial Placement LevelQuick FixEL Point Person
EL 107All students who were tested for EL services must have an Initial Placement Level and DateQuick FixEL Point Person
EL 108Students actively enrolled with a home primary language other than English need to have an EL Initial Placement Record created within the EL Screening window.Quick FixEL Point Person
EL 120When the EL Placement Level is "NA: Not Administered," the Not Administered Reason must be indicatedQuick FixEL Point Person
EL 500Students who took ACCESS or Alternate ACCESS need
to have an EL Initial Placement Record
Quick FixEL Point Person
ResourcesRule DescriptionResource TypePotential Users
EN 320A student with an enrollment for the next school year must have an age within the appropriate range for the grade level.Quick FixPrincipal, AP, Secretary, Enrollment Support
EN 410The student's current enrollment should have the correct Online Registration application number attached to itQuick FixPrincipal, AP, Secretary
EN 415An OLR application should move on from ‘Submitted-New’, ‘Pending – Outreach’, or ‘Nurse Approved’ status with three (3) business days.Quick FixPrincipal, AP, Secretary
ResourcesRule DescriptionResource TypePotential Users
SR 100Name can contain letters, space, apostrophe or dash (hyphen) but cannot end with a suffix, space or special characterQuick FixPrincipal, Secretary, Enrollment Support
SR 110Student Birth Date is requiredQuick FixPrincipal, Secretary, Enrollment Support
SR 112Student Age must fall within the appropriate range for their grade for students who are not in Special EdQuick FixPrincipal, Secretary, Enrollment Support
SR 113Date Entered US School must be prior to todayQuick FixPrincipal, Secretary, Enrollment Support
SR 120A students home primary language cannot be blank if the student has an EL Initial Placement test record indicating the student is an ELQuick FixPrincipal, Secretary, Enrollment Support
SR 121EL students who entered SDP in the last 3 years and are in 5th, 6th, or 7th grade should have a birth country specifiedQuick FixPrincipal, Secretary, Enrollment Support
SR 150Federal Designation, State Designation, and Race/Ethnicity Determination fields must all be filled appropriatelyFederal Designation, State Designation, and Race/Ethnicity Determination fields must all be filled appropriately.Principal, Secretary, Enrollment Support
SR 151Federal Hispanic/Latino Code is requiredQuick FixPrincipal, Secretary, Enrollment Support
SR 154If student is Hispanic/Latino, State Race Code must be HispanicQuick FixPrincipal, Secretary, Enrollment Support
SR 155Federal race designation and state race designations must alignQuick FixPrincipal, Secretary, Enrollment Support
SR 200Students must have one and only one active primary householdQuick FixPrincipal, Secretary, Enrollment Support
SR 201A student’s active Primary Household must have only one current addressQuick FixPrincipal, Secretary, Enrollment Support
ResourcesRule DescriptionResource TypePotential Users
SCH 100Students must not be scheduled into multiple homeroom sectionsQuick FixSchedulers
Resource NameRule DescriptionResource TypePotential Users
CI100Every actively enrolled student must have a Computer assignmentQuick FixPrincipal, Assistant Principal, School Technology Coordinator (STC), PPIS Designee, Secretary, SIS Coach
CI101Students may not have more than 1 computer assignmentQuick FixPrincipal, Assistant Principal, School Technology Coordinator (STC), PPIS Designee, Secretary, SIS Coach