Schedule a demo

Delivering Data You Can Trust

10 min read

How to Easily Manage Unlimited Contacts in PowerSchool

July 8, 2019 at 4:13 PM

Contact data from the original core contact fields in PowerSchool were automatically migrated to the new contacts structure in PowerSchool 11.1. Contact data was migrated for all students that have ever existed within a PowerSchool database - both active and inactive.

The State Data Validation Suite (SDVS) generic contacts rules consist of 19 rules on a “Contacts” tab and 13 rules on a “Contacts Reports” tab. These rules are provided to help users clean up existing and/or new contact data.

The rules on the Contacts tab identify both erroneous existing data and important or required missing data. 

PowerSchool Data Validation for Student Contacts, Contacts tab 1 of 2


Rules on the Contacts Reports tab are additional helper rules that identify additional missing contact data - data a district may or may not require a contact to have.

This tab also includes 7 rules to help with the merging and consolidation of contacts.

Note: A description of each of these rules is included at the end of this article for reference.

It is important to keep in mind that since contact requirements vary from district to district, depending on the district needs and policies, it is possible that some rules may never get to the “0” and green check mark.

A district should strive to clean up as much data as possible per their district policy to attempt to get the error count as low as possible. All 0s and green check marks will most likely not be possible for some of the rules on the Contacts Reports tab.

PowerSchool Data Validation for Student Contacts, Contacts Reports tab 1 of 2

It is worth mentioning that the generic set of contacts rules mainly focuses on contacts tied to students that are currently active in the system - except for specific cases which are listed in the rule descriptions.

Contacts tied only to students that are inactive in the database are not top priority to correct and therefore are ignored.

In order to eliminate unnecessary data entry, it is recommended that districts, schools, and users use the suggested workflow outlined below to clean up any contact data existing in the system.

This workflow should be used throughout the year to keep contact data clean and ensure that duplicate contact records do not exist in the system. 

Suggested Workflow

Below is the suggested order in which a user should go through rules to correct contact data issues. By following this workflow a user should be able to eliminate some unnecessary data entry. 

  1. Make sure all students have at least one contact associated and any existing contacts have at least one student associated. Delete any erroneous contacts:
    1. Contacts > Students with No Associated Contacts
    2. Contacts > Contacts with No Associated Students
  1. Merge any contact records that should be combined:
    1. Contacts Reports > Contacts with Matching Name & Phone Number
    2. Contacts Reports > Contacts with Matching Name & Address
    3. Contacts Reports > Contacts with Matching Name & Email
    4. Contacts Reports > Contacts with Matching Phone Number
    5. Contacts Reports > Contacts with Matching Address
    6. Contacts Reports > Contacts with Matching Email
    7. Contacts Reports > Contacts with Matching Name
  1. Correct any contact records that are missing important data for existing methods of contact:
    1. Contacts > Existing Address Record - Missing City
    2. Contacts > Existing Address Record - Missing Country
    3. Contacts > Existing Address Record - Missing Postal Code
    4. Contacts > Existing Address Record - Missing State/Province
    5. Contacts > Existing Address Record - Missing Street
    6. Contacts > Existing Address Record - Missing Type
    7. Contacts > No Address Record - Contacts Marked to Receive Mail
    8. Contacts > Existing Email Record - Missing Type
    9. Contacts > Existing Phone Record - Missing Phone Number
    10. Contacts > Existing Phone Record - Missing Type
  1. Add missing important information to contact records:
    1. Contacts > Missing Contact First Name
    2. Contacts > Missing/Invalid Contact Relationship to Student
    3. Contacts > Contacts Without a Phone Record
    4. Contacts > Contacts Without Contact Information (No Address, No Email, No Phone)
  1. Go back through step 2 and merge any records that should be merged since data additions.

  2. Collect any additional information the district/school requires:
    1. Contacts Reports > No Address Record - Emergency
    2. Contacts Reports > No Address Record - Guardian
    3. Contacts Reports > No Address Record - Mother/Father/Parent
    4. Contacts Reports > No Email Record - Emergency
    5. Contacts Reports > No Email Record - Guardian
    6. Contacts Reports > No Email Record - Mother/Father/Parent
  1. Go back through steps 2, 3, 4, and 5.

  2. Clean up “No Name” contact records by either adding missing information or deleting the record - if that is the determination after review:
    1. Contacts > Contacts Without a Name (“No Name” Contact Records)
  1. Go back through steps 2, 3, 4, and 5.

  2. Inactivate contacts that are associated to only inactive students.
    1. Contacts > Active Contacts Associated to Only Inactive Students
  1. Activate or provide an end date for inactive contacts that are associated with active students.
    1. Contacts > Inactive Contacts Associated with Active Students
  1. Repeat and review throughout the school year as necessary.

 

Rules and Descriptions

Listed below are the rules contained on each tab along with a description of what the rule’s purpose is and the data the rule returns.

Contacts

Active Contacts Associated to Only Inactive Students
All active contacts that are associated to inactive students only. This rule excludes “No Name” contact records.

Contacts Without Contact Information (No Address, No Email, and No Phone)
All contact records tied to active students that have no method of contact. No active address, no email, and no phone record exists for the contact.

Contacts Without a Name ("No Name" Contact Records)
All “No Name” contact records tied to active students. These records were created from the auto-migration process that occurred in PowerSchool 11.1. These records will typically only contain the email address that was in the Guardian’s Email Address field on the Parents page.

Contacts Without a Phone Record
All contact records tied to active students that have no phone record. This rule excludes “No Name” contact records.

Contacts with No Associated Students
All active or inactive contact records that are not associated with any active or inactive students within the system. 

Existing Address Record - Missing City
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the City field. This rule excludes “No Name” contact records.

Existing Address Record - Missing Country
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the Country field. This rule excludes “No Name” contact records.

Existing Address Record - Missing Postal Code
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the Postal Code field. This rule excludes “No Name” contact records.

Existing Address Record - Missing State/Province
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the State/Province field. This rule excludes “No Name” contact records.

Existing Address Record - Missing Street
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the Address Line 1 field. This rule excludes “No Name” contact records.

Existing Address Record - Missing Type
All contact records tied to active students that have an existing active address record, but the address record is missing a value in the Type field. This rule excludes “No Name” contact records.

Existing Email Record - Missing Type
All contact records tied to active students that have an existing email record, but the email record is missing a value in the Type field. This rule excludes “No Name” contact records.

Existing Phone Record - Missing Phone Number
All contact records tied to active students that have an existing phone record, but the phone record is missing a value in the Phone Number field. This rule excludes "No Name" contact records.

Existing Phone Record - Missing Type
All contact records tied to active students that have an existing phone record, but the phone record is missing a value in the Type field. This rule excludes “No Name” contact records.

Inactive Contacts Associated with Active Students
All inactive contacts that are associated to at least one active student. This rule excludes “No Name” contact records.

Missing Contact First Name
All contact records tied to active students that are missing a value in the First Name field. This rule excludes “No Name” contact records.

Missing/Invalid Contact Relationship to Student
All contact records tied to active students that have a missing or invalid value in the Relationship field. This rule excludes “No Name” contact records.

No Address Record - Contacts Marked to Receive Mail
All contact records tied to active students that have the Receives Mail flag checked, but do not have an active address record. This rule excludes “No Name” contact records.

Students with No Associated Contacts
All active students that have no associated active contact, therefore the student has no contacts.

Contacts Reports

Contacts with Matching Address
All contact records grouped together based on a matching value in the Address Line 1 field. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Contacts with Matching Email Address
All contact records grouped together based on a matching value in the Email Address field. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Contacts with Matching Name
All contact records grouped together based on a matching First Name and Last Name. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Note: It is recommended that a district user clean up and merge contact records by means of the other "Contacts with Matching..." rules before using this rule as resolving issues with those rules will greatly reduce the number of records returned in this rule.

Contacts with Matching Name & Address
All contact records grouped together based on a matching value in the Address Line 1 field and a matching First and Last Name. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Contacts with Matching Name & Email Address
All contact records grouped together based on a matching value in the Email Address field and a matching First and Last Name. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Contacts with Matching Name & Phone Number
All contact records grouped together based on a matching value in the Phone Number field and a matching First and Last Name. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

Contacts with Matching Phone Number
All contact records grouped together based on a matching value in the Phone Number field. At least one of the contact records must be tied to an active student in order for any matches to appear. This rule excludes “No Name” contact records.

No Address Record - Emergency
All “Emergency” contact records tied to active students that have no active address record. This rule excludes “No Name” contact records.

Records that are considered an “Emergency” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Emergency 1”, “Emergency 2”, or “Emergency 3”.
  • Contacts that have a Relationship with the word “Emergency” in either the Code or Display Value.
  • Contacts that have the “Emergency Contact” checkbox checked on the contact record.

No Address Record - Guardian
All “Guardian” contact records tied to active students that have no active address record. This rule excludes “No Name” contact records.

Records that are considered a “Guardian” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Guardian”.
  • Contacts that have a Relationship with the word “Guardian” in either the Code or Display Value.

No Address Record - Mother/Father/Parent
All “Mother/Father/Parent” contact records tied to active students that have no active address record. This rule excludes “No Name” contact records.

Records that are considered a “Mother/Father/Parent” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Mother” or “Father”.
  • Contacts that have a Relationship with the word “Mother”, “Father”, or “Parent” in either the Code or Display Value.
Note: This rule ignores any Relationship with the word “Grand” somewhere in either the Code or Display Value.

No Email Record - Emergency
All “Emergency” contact records tied to active students that have no email record. This rule excludes “No Name” contact records.

Records that are considered an “Emergency” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Emergency 1”, “Emergency 2”, or “Emergency 3”.
  • Contacts that have a Relationship with the word “Emergency” in either the Code or Display Value.
  • Contacts that have the “Emergency Contact” checkbox checked on the contact record.

No Email Record - Guardian
All “Guardian” contact records tied to active students that have no email record. This rule excludes “No Name” contact records.

Records that are considered a “Guardian” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Guardian”.
  • Contacts that have a Relationship with the word “Guardian” in either the Code or Display Value.

No Email Record - Mother/Father/Parent
All “Mother/Father/Parent” contact records tied to active students that have no email record. This rule excludes “No Name” contact records.

Records that are considered a “Mother/Father/Parent” contact for the purpose of this rule are defined as:

  • Contacts with an Original Contact Type of “Mother” or “Father”.
  • Contacts that have a Relationship with the word “Mother”, “Father”, or “Parent” in either the Code or Display Value.
Note: This rule ignores any Relationship with the word “Grand” somewhere in either the Code or Display Value.
Joel Lepp
Written by Joel Lepp

Joel Lepp is an Education Data Specialist for Level Data. Prior to joining Level Data, he worked in education for 12 years. The last 6 of those years he was part of the Michigan State Reporting and Compliance team for PowerSchool where he supported and developed parts of the state reporting code used by Michigan's PowerSchool users. In the past, Joel has presented at various PowerSchool User Group (PSUG) conferences and was a member of the Michigan Pupil Accounting and Attendance Association (MPAAA). Joel's main function at Level Data is to help guide school districts across the country on the best practices and procedures for cleaning their data in order to maximize their district funding from their state.

Post a Comment

Featured