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. |