AggStats, 46 (ver3.6.1)
This table keeps track of statistics on the server for a date (hits, parents' logins, page views, etc.).
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AdminPVs | 3.6.1 | Number(10,0) | The number of page views the admin application has had today. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Date_Value | 3.6.1 | Date | The date this record is stored for. A new record is created each day. Indexed. |
Enrollment | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Hits | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
NumSchools | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
PageViews | 3.6.1 | Number(10,0) | The number of page views for the day. |
ParentHits | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ParentLogins | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ParentPVs | 3.6.1 | Number(10,0) | The number of page views for parents have had today. |
PG3Hits | 3.6.1 | Number(10,0) | Total number of PowerGrade hits per day. Note: Renamed in ver5.0.13. |
PGIHits | 3.6.1 | Number(10,0) | Number of records that are sent to pgincoming queue per day. Note: Renamed in ver5.0.13. |
PortalPVs | 3.6.1 | Number(10,0) | This page view statistics is retrieved but never set in the system. It is used for calculating total page view. Used as interprocess variable <>portalpvs. |
ReportQueueJobs | 3.6.1 | Number(10,0) | Total number of jobs run in the day. Used as interprocess variable <>reportqueuejobs. |
Server | 3.6.1 | Varchar(31) | IP address of the PowerSchool server providing the statistics on a report. Indexed. |
Server_InstanceID | 4.2.0 | Number(10,0) | Identifier for the PowerSchool Server Instance. Indexed. |
ServerName | 3.6.1 | Varchar(8 0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StudentHits | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StudentLogins | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StudentPVs | 3.6.1 | Number(10,0) | The number of page views for students have had today. |
TeacherPVs | 3.6.1 | Number(10,0) | The number of page views for teachers have had today. |
Time | 3.6.1 | Number(10,0) | The time the stats were last checked. |
TotLogins | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
TotalPVs | 3.6.1 | Number(10,0) | The total number of page views the server has had. |
Type | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |