VirtualTablesDef, 121 (ver3.6.1)
This virtual design uses this to hold the user-defined/ custom dynamic table definitions and their relationships to other PowerSchool Real tables.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AccessPrivileges | 3.6.1 | Varchar(20) | Not currently used. |
ActualDataTable_Ref | 3.6.1 | Number(10,0) | Virtual Data table that stores the actual data for this table, such as VirtualTableData2. |
Created_By | 3.6.1 | Varchar(31) | Name of the user who created this record or on the XML file being imported. |
Created_On | 3.6.1 | Date | Date this record was created or that which is on the XML file being imported. |
Data_Can_Be_Added | 3.6.1 | Number(10,0) | Indicates whether data can be added to this table. 1=yes. |
Data_Can_Be_Deleted | 3.6.1 | Number(10,0) | Indicates whether data can be deleted from this table. 1=yes. |
Data_Can_Be_Modified | 3.6.1 | Number(10,0) | Indicates whether data can be modified for this table. 1=yes. |
DateOfImport | 3.6.1 | Date | Date this table definition was imported. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Def_Sort_Dir1 | 3.6.1 | Number(10,0) | Direction for the data on this table to be sorted. 1=Ascending. 0=Descending. |
Def_Sort_Fld1 | 3.6.1 | Varchar(79) | Field to be used when sorting the data on this table. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this virtual table. |
ExcludeFromListForExport | 3.6.1 | Number(10,0) | Indicates whether to be excluded for the export file. 1=yes. |
ExcludeFromListForImport | 3.6.1 | Number(10,0) | Indicates whether to be excluded from the import file. 1=yes. |
IncludeInList | 3.6.1 | Number(10,0) | Indicates whether to include this table in the lists of the tables. 1=yes |
InputPageInfo | 3.6.1 | Varchar(79) | Not currently used. |
Invisible | 3.6.1 | Number(10,0) | Indicates whether this file is invisible. 0=visible. |
IsMigrated | 10.1.0 | Number(1,0) | 1 indicates the virtual table definition is available as a schema extension. Defaults to 0. Required. Indexed. |
Kind | 3.6.1 | Varchar(20) | Type of the table this is, such as VIRTUAL. |
Last_Modified | 3.6.1 | Date | Date this record was last modified or on the XML file being imported. |
LinkedToTable | 3.6.1 | Varchar(30) | PowerSchool table name associated to this record, such as Students. |
LinkingField | 3.6.1 | Varchar(30) | Name of the Field that links this table to other tables. |
ListOption_InsertLinkToPageView | 3.6.1 | Number(10,0) | In the automatic list view (working feature), this option indicates if a link to the page view has to be insert (usually in the first column of the list. With the link, the user can click to access the page view where fields can usually be viewed/edited. |
ListOption_ShowIndex | 3.6.1 | Number(10,0) | In the automatic list view, this option indicates if a index has to be inserted as the first column in the list. It's just a line numbering. |
ListPageInfo | 3.6.1 | Varchar(79) | Not currently used. |
LoadedFrom_DateStamp | 3.6.1 | Varchar(21) | Datestamp of the import file - different than when loaded. |
LoadedFrom_FilePathOnly | 3.6.1 | CLOB | File path of where the import file exists on the directory. |
LoadedFrom_Filename | 3.6.1 | Varchar(79) | Filename of the file being imported. |
Modified_By | 3.6.1 | Varchar(31) | Name of the user who last modified this record or on the XML file being imported. |
SchoolSpecific | 3.6.1 | Number(10,0) | Indicates whether the data on this table is school specific. 1=yes. Then use the School_ID when reporting. |
School_ID | 3.6.1 | Number(10,0) | The internal number for the School with which this record is associated. |
Table_Name | 3.6.1 | Varchar(30) | Name given to this virtual table by the user. |
Unique_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
User_Label | 3.6.1 | Varchar(40) | Name to appear on the screen for this table. |