PSM_UserEventLog (ver2.2)

AccountFirstName

2.2

Varchar2(50)

FirstName copied from the PSM_Account table at the time the record is created as a historical record of the user information.

AccountID

2.2

Number(19,0)

Internal ID of the PSM_Account record to which this record is associated.

AccountLastName

2.2

Varchar2(50)

LastName copied from the PSM_Account table at the time the record is created as a historical record of the user information.

AccountSessionID

2.2

Number(19,0)

Internal ID of the PSM_AccountSession record to which this record is associated.

AccountUserName

2.2

Varchar2(50)

UserName copied from the PSM_Account table at the time the record is created as a historical record of the user information.

Description

2.2

Varchar2(256)

Describes the event, which occurred. Format is Admin: <admin name> logged in as teacher <teacher name>.

EventTime

2.2

Timestamp(6)

Date and time in which the event originated.

ID

2.2

Number(19,0)

Unique sequential number generated by the application. Required.

SourceIP

2.2

Varchar2(30)

IP address from which the request originated. Required.

TeacherFirstName

2.2

Varchar2(50)

FirstName copied from the PSM_Teacher table at the time the record is created as a historical record of the user information.

TeacherID

2.2

Number(19,0)

Internal ID of the PSM_Teacher record to which this record is associated.

TeacherLastName

2.2

Varchar2(50)

LastName copied from the PSM_Teacher table at the time the record is created as a historical record of the user information

TeacherNotifiedFlag

2.2

Number(3,0)

1 indicates the teacher has read the notification. Defaults to 0. Required.

TeacherUserName

2.2

Varchar2(50)

UserName copied from the PSM_Teacher table at the time the record is created as a historical record of the user information.

UserEventTypeID

2.2

Number(19,0)

Internal ID of the PSM_UserEventType record to which this record is associated.

UserType

2.2

Number(10,0)

Indicates the type of user for which this audit record is stored. Valid values: 1 = Administrator, 2 = Teacher.

WhenCreated

2.2

Timestamp(6)

Date and time the record was created. Defaults to system date. Required.

WhenModified

2.2

Timestamp(6)

Date and time the record was modified. Defaults to system date. Required.

WhoCreated

2.2

Varchar2(100)

The user login that created the record. Defaults to database user. Required.

WhoModified

2.2

Varchar2(100)

The user login that modified the record. Defaults to database user. Required.