Skip to main content
Skip table of contents

Virtual Tables

Virtual tables are used to store data in the PowerSchool database outside of the standard set of PowerSchool tables. Virtual table records can be viewed by accessing one of the following tables in DDE (Direct Database Export): VirtualTablesData, VirtualTablesData2, or VirtualTablesData3. The name of the virtual table is stored in the field related_To_Table.

The Tennessee-specific virtual tables in PowerSchool are:

Viewing Virtual Table Records

Use the following steps to view records for virtual tables in PowerSchool:

  1. Click System on the Start page. The System Administrator page appears.
  2. Click Direct Database Export. The Direct Database Export page appears.
  3. Choose one of the following tables from the Current Table pop-up menu:
    • VirtualTablesData
    • VirtualTablesData2
    • VirtualTablesData3
  4. Search for the following: related_To_Table = [name of the virtual table].
  5. Click Search all x records in this table.
  6. Click Table View. The List Records: VirtualTablesData page appears.
  7. Select a record. The Display Record: VirtualTablesData page appears.

Importing into Virtual Tables

It is recommended to import a small test set of data when first importing into a virtual table.  Review additional information about importing into virtual tables.

All of the virtual tables and fields used for Tennessee state reporting are documented in the Tennessee Extract Element Import Configuration File. This file can be imported by using the Special Functions > Interfaces to Other Systems > EIS > Import Element Extract Element Configuration File.

JavaScript errors detected

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

If this problem persists, please contact our support.