LicenseAllocation Table

The LicenseAllocation table specifies the allocation of licenses for each organizational unit. The same licensable product definition (from SoftwareProduct) may have license allocations for more than one organizational unit.

Table 1. Database columns for LicenseAllocation table

Database Column



Type: integer. Key. Generated ID

Unique identifier for the license allocation record. This is automatically generated by SQL Server.


Type: integer. Key

The license that maps to an application. This is a foreign key into the SoftwareProduct table.


Type: integer. Key

Id of the organizational unit to which the software is allocated.


Type: integer. Nullable

The number of units allocated for the application.


Type: datetime. Nullable

The date and time that the license allocation expires.