The PowerSchool Data Dictionary for SIS views is useful in collecting and viewing PowerSchool data, such as student average daily attendance (ADA), course schedules, student assessment data, demographic profiles, and discipline information. Included are the names, descriptions and source columns of the various views in the PowerSchool database. Each view definition is comprised of rows and columns, where the row corresponds to the values in the view, while the column corresponds to the data elements in the view. Each data element has a set of information that explains more about that piece of information, including data type, description and source column if applicable.
A view is a saved structured query language (SQL) object that represents business logic pulling a particular set of data from one or more underlying tables. The purpose of a view is to facilitate reporting by gathering the specific data that a report needs into a single, or a few, specific views. With views, the queries that must be built as part of a report can be simplified because much of the logic for collecting data is stored in the view.
This document provides a comprehensive list of all PowerSchool's SIS views and the information contained therein
Note: Table extensions are not included in PowerSchool's SIS views. Only legacy custom fields may appear.
This document is intended for a district or school's database administrators.
Views within this document follow a standard convention. View names appear as the view titles and the software release version indicating when the view was created. Database data elements appear as rows within each table along with the software release version indicating when the data element was created or modified.