Additional Resources
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.
About South Carolina State Reporting
School funding in South Carolina is based, in part, on two acts:
Education Finance Act (EFA)
Education Improvement Act (EIA)
School funding is partly based on students’ EFA classifications. Under the EFA, funding is weighted according to membership in certain types of programs. For example, students enrolled in programs designed to overcome learning disabilities are funded at a higher rate than students in general programs.
The EIA provides funding for expenditures on programs such as Advanced Placement and Gifted and Talented classes. A student is assigned an EIA code if they are enrolled in a designated program. A student may have no EIA codes, or as many as 10 EIA codes. As with EFA codes, school funding is based partly on how many students have each EIA code on the 45th and 135th school day of each school year.
To accurately determine your school district’s funding, you must enter the self-contained Class and the EFA and EIA codes into student records. You must validate these entries against three tables provided by the South Carolina Department of Education:
EFA Codes/Grades
EFA/EIA Compatibility
EIA Codes/Grades
South Carolina Resources
The following resources provide additional information for South Carolina state reporting: