SoftwareAccessMode Table

The SoftwareAccessMode table holds the states an application has been accessed.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SoftwareAccessMode table

Database Column

Details

SoftwareAccessModeID

Type: integer. Key. Generated ID

The primary key of the SoftwareAccessMode table.

AccessModeID

Type: integer. Key

The access mode for the application. Foreign key to the AccessMode table.

InstalledSoftwareID

Type: integer. Key

The installed software title to which the access mode applies. Foreign key to the InstalledSoftware table

IsACL

Type: boolean. Key

Determines whether the software access mode record came from ACL data.