Skip to main content
Skip table of contents

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.

  1. From the start page, navigate to the Data Dictionary page.

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

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

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

Maine Resources

Maine Data Connect Reporting

The reports for Connect are:

  • October 1st Enrollment

  • April 1 Enrollment

  • ESEA Demographics

Main Reports Due by Month

July Report Names

Open

Due

Daily Attendance Certification

6/1

7/15

EFT-21 Safety Training Report

7/1

7/30

EFT-24 Transportation Vehicle and Operations Report

7/1

7/30

Truancy Certification

6/6

7/15

SpED Exit Report

6/1

7/30

 

 

 

August Report Names

Open

Due

EF-M-39 A - Adult Education Reporting

6/1

8/30

Graduation Reporting

6/1

8/30

 

 

 

September

Open

Due

No Reports due at this time

-

-

 

 

 

October Report Names

Open

Due

CTE October Student Counts

10/1

10/30

Dropout Certification

10/2

10/15

EF-S-05 Part 1 Special Education Counts

10/1

10/15

EF-S-05 Part II Special Services Staff

7/1

10/30

NEO Staff Certification

7/1

10/30

October 1st Enrollment Count

10/1

10/30

Q1 Behavior Reporting

10/1

10/15

Q1 Bullying Reporting

10/1

10/15

Q1 Daily Attendance Validation

10/1

10/15

Q1 Truancy Reporting

10/1

10/15

Restrain and Seclusion

6/1

10/15

 

 

 

November Report Names

Open

Due

EF-M-39 B - Adult Education Reporting

11/15

12/1

 

 

 

December Report Names

Open

Due

No reports due at this time

-

-

 

 

 

January Report Names

Open

Due

Q2 Behavior Reporting

1/1

1/15

Q2 Bullying Reporting

1/1

1/15

Q2 Daily Attendance Verification

1/1

1/15

Q2 Truancy Reporting

1/1

1/15

 

 

 

February Report Names

Due

Open

No reports due at this time

-

-

 

 

 

March Report Names

Open

Due

No reports due at this time

-

-

 

 

 

April Report Names

Open

Due

April Enrollment Counts

4/1

4/15

High Cost Out of District Placement Report

3/1

4/15

Q3 Behavior Reporting

4/1

4/15

Q3 Bullying Reporting

4/1

4/15

Q3 Daily Attendance Verification

4/1

4/15

Q3 Truancy Reporting

4/1

4/15

 

 

 

May Report Names

Open

Due

No reports due at this time

-

-

 

 

 

June Report Names

Open

Due

End of Year Enrollment Exits

6/1

6/30

ESEA Demographics

5/15

6/15

Maine School Application

5/1

6/30

Perkins 3S1 CTE Post-Secondary Placement Reporting

9/30

6/30

Q4 Behavior Certification

6/1

6/30

Q4 Bullying Certification

6/1

6/30

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.