Log, 8 (ver3.6.1)
This table stored student log entries for various purposes. Administrators or teachers enter this free text in order to keep track of necessary information.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Category | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Consequence | 3.6.1 | Varchar(20) | This field is populated by a popup build from the Gen table cat=consequence. |
Custom | 3.6.1 | CLOB | Only used to store key-pair values during import if into this table. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Discipline_ActionDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_ActionTaken | 3.6.1 | Varchar(79) | The action taken for disciplining the student, such as S=Suspend. |
Discipline_ActionTakenDetail | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_ActionTakenEndDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_AdministratorID | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_AlcoholRelatedFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_DrugRelatedFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_DrugTypeDetail | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_DurationActual | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_DurationAssigned | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_DurationNotes | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_FelonyFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_GangRelatedFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_HateCrimeFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_HearingOfficerFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_IncidentContext | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_IncidentDate | 3.6.1 | Date | The Date of the incident took place. |
Discipline_IncidentLocDetail | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_IncidentLocation | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_IncidentType | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_IncidentTypeDetail | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_LikelyInjuryFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_MoneyLossValue | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_Offender | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_PoliceInvolvedFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_Reporter | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_ReporterID | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_SchoolRulesVioFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_Sequence | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_VictimType | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_WeaponRelatedFlag | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_WeaponType | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Discipline_WeaponTypeNotes | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DurationChangeSource | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. Note: Also known as Discipline_DurationChangeSource. |
Entry | 3.6.1 | CLOB | The actual description of the log. |
Entry_Author | 3.6.1 | Varchar(305) | The last name and first name of the person who entered the log entry. This is taken from the LastFirst field in the Teachers' table. |
Entry_Date | 3.6.1 | Date | The date the log entry was made. Indexed. |
Entry_Time | 3.6.1 | Number(10,0) | The time the log entry was made. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IncidentTypeCategory | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. Note: Also known as Discipline_IncidentTypeCategory |
LogTypeID | 3.6.1 | Number(10,0) | The internal number for the Gen table associated with the log entry. The name is taken from here. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
Student_Number | 3.6.1 | Float | Taken from Students table using the StudentID. |
Subject | 3.6.1 | Varchar(40) | The subject of the log entry. |
Subtype | 3.6.1 | Varchar(20) | Built from the value of the log type above on the Gen table. |
TeacherID | 3.6.1 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |