Data Dictionary

Your state reporting data dictionary documentation contains state-specific database information and is a supplement to the PowerSchool Data Dictionary. 

Each state-specific table is comprised of rows and columns that correspond to the values and data elements in the table, including field name, software release version, data type, and description. Database table names are comprised of the table titles and the software release version, which indicates when the table was created. Column names that appear italicized are no longer used.  

Audit Columns 

Audit Columns contain information about the creation and modification of a record, and are automatically created for each record. Refer to Audit Columns for more information. 

Common Tables

In addition to state-specific tables, there are tables that are common across all states and provinces. Please refer to your state-specific documentation to determine if common tables are used to support reporting for your state. Refer to Common Tables for detailed information on the common tables available.