Additional Resources
See the following resources for more information on PowerSchool and Wisconsin state reporting.
On this page:
PowerSchool SIS
Use PowerSchool Administrator Help to learn about the PowerSchool Student Information System (SIS), to serve as a reference for your daily work, and to assist you in navigating through the system. For the most up-to-date information, click Help and select System Help on any page in PowerSchool.
PowerSchool Data Dictionary
Navigation: System Management, Data, Data Dictionary.
The Data Dictionary page provides access to tables, views, and fields stored in PowerSchool SIS. Use it to explore database structures, review field details, and locate indexes or other metadata.
The Data Dictionary was previously available in Community but is now integrated directly into PowerSchool SIS.
From the start page, navigate to the Data Dictionary page.
From the Search Type dropdown, select whether to display Tables/Views, Fields, or Tables/Views & Fields.
This is a view-only page and cannot be edited. Tables listed are based on the currently logged in users export permissions.
Enter a keyword in the Search box or select a specific table or field.
At least two characters must be entered into the search box in order to perform a search.
The selected table and field information is displayed on the right panel.
Click Clear to remove keywords from the search.
Table and Field Information
Select a table to view its information in the right panel. This view displays table and field information based on this PowerSchool SIS instance.
Columns
The table columns listed below only appear when appropriate.
Header | Description |
|---|---|
Column Name | The name of the column in the database. |
SQL Type | The type and length of the column. Length displays for appropriate fields only. |
Validation Min Length | The calculated Data Validation minimum length, if defined, for this field. This value includes Core, State, and User-defined Data Validation rules. |
Validation Max Length | The calculated Data Validation maximum length, if different from the database length, for this field. This value includes Core, State, and User-defined Data Validation rules. |
Validation Required | The calculated Data Validation is required for this field. This value includes Core, State, and User-defined Data Validation rules. |
Description | The description of the field. |
Version | The version of SIS when the field was added. |
Indexes
Header | Description |
|---|---|
Index Name | The name of the index. |
Columns | The index columns appear in the order defined in the database. |
Unique | The index is unique. If it were not unique, it would remain unfilled. |
Release Notes
To learn more about a specific release, see the release notes. Release notes are available in the PowerSchool online help. To access, click Help and select System Help on any page in PowerSchool, and then click Release Notes and locate the version of PowerSchool you would like to read about.
PowerSchool Data Exchange
Ed-Fi Resources
Wisconsin Ed-Fi Administrator Setup Quick Reference Guide
The Wisconsin Ed-Fi Administrator Setup Quick Reference Guide provides details on the required steps to enable and configure PowerSchool for the Wisconsin Ed-Fi implementation. Topics include the PowerSchool Ed-Fi Plugin, Ed-Fi Setup, Download Data process, and Ed-Fi Code Set Mapping.
Wisconsin State Resources
- Wisconsin Department of Public Instruction
- Wisconsin DPI Data home
- WISEdata
- WSLS
- ISES
- CWCS
- School Performance Report
- WI Information System for Education
- Wisconsin Web Access Management System
- Career and Technical Information
- Wisconsin Immunization Program
- CRDC - Wisconsin Department of Public Instruction
IMPORTANT NOTE: DPI provides PARTIAL data files to districts to help complete the whole CRDC survey. About 60% of the data an LEA submits is replicated in state data collections. By converting the identical data that an LEA submits to DPI into an CRDC - compatible file format, the burden of the CRDC survey is greatly reduced on LEAs. Accuracy and timeliness is increased as well. Wisconsin Districts which elect to opt out of receiving DPI data files will be responsible for providing each data element required for CRDC.
Please refer to the WI DPI CRDC Question Map to Data Support Matrix for a complete listing of data that will be provided by DPI.