In Database Management Systems (DBMS), the collection of information that defines the basic organization of a database, and the objects contained therein, is called the Data Dictionary. The Data Dictionary typically contains a list of all tables in the database, the column definitions in each table, the types of each field, and an associated description.
This document lists all PowerSchool database fields associated to PowerTeacher gradebook. Included are the names of the tables (or views) in which the fields exist, the types of data that can be entered into or retrieved from the fields, and an associated description of the fields.
This document is intended for a district or school's database administrators (DBA). A DBA directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system, and establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system.
Tables and (views) follow a standard convention. Table (or view) names appear as the table title along with the version string indicating when the object was created or modified. Column names that appear italicized are designated as "No Longer Used." All Foreign Key fields are specified as such in the Description column of each table.