Skip to end of metadata
Go to start of metadata

KSSA_ACTIVITY persists the objects that make up the activity log, supporting the activity service. This provides a security log of activity that happens within the system.


Table: ACTIVITY

Tracks activity within the KSA system.

Column

Description

ID

Autonumbered primary key for the ACTIVITY table.

CREATION_DATE

Date and time of the logged activity.

IP

IP address of the originating system that caused the activity.

MAC

Optional MAC address of the system that caused the activity.

CREATOR_ID

The account identifier for the person or system that triggered the activity.

ALTERED_ACNT_ID

The account against which the activity was logged, if applicable.

ALTERED_ENTITY

The type of entity that was altered, as derived from the code. For example "Currency" etc.

ALTERED_ENTITY_ID

In conjunction with ALTERED_ENTITY, the identifier for the specific entity that was altered/ created.

ALTERED_ENTITY_PROPERTY

The specific property that was altered by the change.

LOG_DETAIL

Readable explanation of the activity that has occurred. For example "A new credit type was created within the system."

OLD_ATTRIBUTE

If the value of an attribute is changed during this auditable activity, then the old value is stored here. For example, if a last name is changed from "Blogs" to "Bloggs" then OLD_ATTRIBUTE would be equal to 'Blogs' (and NEW_ATTRIBUTE would be equal to 'Bloggs'

NEW_ATTRIBUTE

An optional attribute that describes the activity in more detail. For example, if a new debit type, called "Bookstore Charge" was created, then the attribute would be set as "Bookstore Charge".

ACTIVITY_TYPE_ID_FK

A classification of the problem, for example EXCEPTION, SECURITY, etc. These types are defined in the KSSA_ACTIVITY_TYPE table. It is envisaged that the basic types of error will be predefined in the software, but their names can be configured, and other types can be added in future revisions.

Table: ACTIVITY_TYPE

Stores the types of activities that exist in the system. While these types can be configured, it is envisioned that the KSA system will come with predefined types that can be customized (by name) but it is not, at this time, envisioned that the administrator would add new types of activities. The level is the level of the activity, which is a numerical value, The lower the value, the more transactional the detail, the higher, the more serious the detail. We will adopt the Apache LogLevel names for this purpose. These are emerg, alert, crit, error, warn, notice, info, debug. More information can be found at

http://httpd.apache.org/docs/2.0/mod/core.html#loglevel

Column

Description

ID

Autonumbered primary key.

NAME

A friendly name for the activity. This would be displayed to the user.

CODE

Short code for the activity type.

DESCRIPTION

UI Description of the activity type.

  • No labels