Virtual Tables
About 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.
- Students: SC_EFA_History Virtual Table
- Students: SC_EIA_History Virtual Table
- Students: SC_EIA_Students_SC03 Virtual Table
- SC_Reported_Records Virtual Table
- Students: SC_SC04_EFA Virtual Table
- Students: SC_SC07 Virtual Table
- Students: SC_SC07_Error Log Virtual Table
- Students: SC_SC08_EFA Virtual Table
- Students: SC_Verification_Error_Log Virtual Table
- Students: SC_Verification_Log Virtual Table
Viewing Virtual Table Records
To view virtual tables:
- On the Start page, click System. The System Administrator page appears.
- Click Direct Database Export. The Direct Database Export page appears.
- Choose one of the following tables from the Current Table pop-up menu:
- VirtualTablesData
- VirtualTablesData2
- VirtualTablesData3
- Search for the following: related_To_Table = [name of the virtual table].
- Click Search all x records in this table.
- Click Table View. The List Records: VirtualTablesData page appears.
- Select a record. The Display Record: VirtualTablesData page appears.
Importing into Virtual Tables
Review additional information about importing into virtual tables.
Note: It is recommended that you import a small test set of data when first importing into a virtual table.