R_AU_SERVICES

This table displays a log of the changes made to Services.

Note: A user account named LOFTUSER (Oracle) or loftuser (PostgreSQL) exists in the Spectrum database (LoftStore). This user account has the permissions necessary to see views and run reports using the Spectrum Reporting Schema. If you are using Loftware Spectrum Cloud, Loftware Cloud Operations may have assigned a unique username for your reporting user account. Contact Loftware Cloud Operations for details.

Note: All timestamps are relative to the time on the database server.

Column Name Type Description

ID

Number

The internal identification number of a Service.

Key: Primary Key
MODIFIED Timestamp

The time when this Service was last modified.
CREATED Timestamp

The time when this Service was created.

CREATED_ISSUER

Number

The ID of the User that created this audit entry.

LAST_UPDATED_ISSUER

Number

The ID of the User that last modified this audit entry.

CURRENT_CREATED_ISSUER

String

The name of the User that created this audit entry.

CURRENT_LAST_UPDATED_ISSUER

String

The name of the User that last modified this audit entry.

AUDIT_ACTION String

The type of audit action performed on this Service.

CREATE

INSERT

UPDATE

DELETE

AUDIT_DATE Timestamp

The date and time when the audit action was performed on this Service.
OBJECT_ID Number

Loftware use only.
BEANNAME String

The internal class name referenced by this Service.
DATABASE_REQUIRED Number

Whether this Service requires database access.

1: The Service requires database access.

0: The Service does not require database access.
DELEGATE String

The internal name of the class that will perform the work.
DESCRIPTION String

The user-defined description of this Service.
LOAD_BALANCED Number

Whether the Service is load balanced.

1: The Service is load balanced.

0: The Service is not load balanced.
CASED_NAME String

The name of this Service.
STATUS Number

Whether the Service is active.

1: The Service is active.

0: The Service is not active.