ARTICLE: PowerSchool: How To Export Database Extension Definitions

ARTICLE: PowerSchool: How To Export Database Extension Definitions

As part of your REACH Boarding to PowerSchool mapping, there might be fields which are not standard fields. In order to set up the integration we will need to know the corresponding table and field names of the database extensions where this data resides. To do this, we will need an export of your database extension definitions.

  1. Log in to your PowerSchool admin console
  2. In the school selection dropdown, choose “District Office”

  1. Go to <your powerschool url>/admin/customization/CreatePackagePage.action and you will see a screen similar to the following:

  1. Under “Select Individual Files”, navigate to “user_schema_root” and select all the xml files under it. After being selected, each one will appear in the “Selected Files” section.

  1. Fill out the fields as shown and then click on “Create Plugin Zip File” 



This will create a zip file and download it to your computer. Please upload this file to securedrop.reach.cloud , as it will allow us to determine the correct table and field names for your database extension values in the mapping.

Do NOT email your sensitive data to us

    • Related Articles

    • ARTICLE: Loading Staff Data Manually

      We are able to automatically pull in data from most major Student Information Systems. Please contact us for details. Download the Data Template Navigate to Data Management > Export Data . Click Download Staff Data Importer Template File near the ...
    • ARTICLE: Loading Student Data Manually

      We are able to automatically pull in data from most major Student Information Systems. Please contact us for details. Download the Data Template Navigate to Data Management > Import Data . Click Download Data Importer Template File on the left. Data ...
    • ARTICLE: Temporary Student not Managed by Sync

      If your Reach database is controlled by the data sync with your school system, students who are not identified as students in the system will be removed from Reach with every sync update. However, you can set the student profile to NOT be managed by ...
    • ARTICLE: Synergetic Sync - Exclusion List

      Sometimes when your school's Synergetic database is syncing to REACH each day you may need to exclude some contacts in REACH that you do not want updated by the Synergetic sync.  Examples of this may be where a relationship for a Guardian in REACH is ...
    • ARTICLE: Student Summary

      Student Summary Dashboard The Student Summary is the Dashboard to view the collated information of individual student profiles in the Reach Portal. The goal of the Summary dashboard is to provide a holistic view of student activities, display all ...