Data Cache Data Model

ssn_application_name

string(240)

Application Name

☑

Name and version of the application connected.

ssn_cnt_heart_beat

decimal

☑

Number of times the last heart beat was updated.

ssn_code

string(240)

Code

☑

Unique code.

ssn_computer_manufacturer

string(240)

☐

Computer system manufacturer.

ssn_computer_model

string(240)

☐

Computer system model.

ssn_cpu_time_sec

decimal

☑

CPU time spent by the process during the lifetime of the session.

ssn_created_at

string(60)

Created in

☑

The code of the function in the modules table from within which the user created the record. This value will never change after creation of the record.

ssn_created_by

string(60)

Created by

☑

Who created the record.

ssn_date_created

datetime

Created at

☑

The system time in UTC at which the record was created. This value will never change after creation of the record.

ssn_date_end

datetime

☐

Moment at which the session ended (UTC).

ssn_date_last_heart_beat

datetime

☐

Moment at which the last heart beat was registered for the session (UTC).

ssn_date_modified

datetime

Updated at

☑

The system time in UTC at which the record was last updated. This value will change for every mutation of the record.

ssn_date_start

datetime

Start Date

☑

Moment at which the session started (UTC).

ssn_event_modified

string(30)

☐

Code of last event that modified the row.

ssn_id

decimal

ID

☑

Unique identifier.

ssn_iiid

string(240)

IIID

☑

Invantive installation ID.

ssn_ip_address_external

string(240)

☑

External IP address.

ssn_ip_address_internal

string(240)

☑

Internal IP address.

ssn_iuid

string(240)

IUID

☑

Invantive user ID.

ssn_license_contract_code

string(240)

License Contract Code

☑

License contract code.

ssn_license_key_identifier

string(240)

License Key Identifier

☑

License key ID.

ssn_machine_name

string(240)

Machine Name

☑

Name of the machine on which the session is running.

ssn_modified_at

string(60)

Updated in

☑

The code of the function in the modules table from within which the user last updated the record. This value will change for every mutation of the record.

ssn_modified_by

string(60)

Updated by

☑

The name of the user in the users table whom last updated the record. This value will change for every update of the record.

ssn_nk

string(240)

Natural Key

☑

Natural key.

ssn_orig_system_group

string(240)

Original System Group

☐

Reference for identifying the group of records on the system from which it originated. It is commonly used to group records for later validation in an application control.

ssn_orig_system_reference

string(240)

Original System Reference

☐

Reference for identifying the record on the system from which it originated.

ssn_physical_memory_bytes

int64

☐

Physical memory in bytes.

ssn_physical_memory_load

int32

☐

Physical memory load (%).

ssn_pool_identity

string(240)

Pool Identity

☐

Pool identity.

ssn_process_arguments

string(2000)

☐

Arguments of the process running the session.

ssn_process_filename

string(240)

Executable

☑

Executable started to create the process running the session.

ssn_process_label

string(240)

☑

Identification of the running process on the operating system.

ssn_process_owner

string(240)

☑

Owner on the operating system of the process in which the session is running.

ssn_session_created

string(240)

Session Created

☑

The ID of the session which created the record. This value will not change after insert.

ssn_session_modified

string(240)

Session Updated

☑

The ID of the session which last updated the record.

ssn_transaction_created

string(240)

Transaction Created

☑

The ID of the transaction which created the record.

ssn_transaction_modified

string(240)

Transaction Updated

☑

The ID of the transaction which last updated the record.

ssn_working_directory

string(240)

☑

Working directory of the process running the session.