PhoneLog, 27 (ver3.6.1)
This table stored information for PowerLink, which is no longer used. This table currently stores transaction information relating to the number of times a parent, guardian, or student signs in to the PowerSchool Student and Parent portal. This information appears on the Net Access page in the PowerSchool admin portal.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Date_Value | 3.6.1 | Date | The date the record was created. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Duration | 3.6.1 | Float | How long the call lasted in minutes. |
EntryType | 3.6.1 | Number(10,0) | Type of this communication mechanism, 1=phone, 2=internet |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
LogType | 3.6.1 | Number(10,0) | Who logged in 1=Guardian, 2=Student. |
OptionsChosen | 3.6.1 | Varchar(40) | The options the user selected during this phone call. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StartTicks | 3.6.1 | Number(10,0) | The internal system clock ticks during this phone call. |
StartTime | 3.6.1 | Number(10,0) | The time this phone call started. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |