Skip to main content
Skip table of contents

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(30)

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.