Application_DIM Table

FlexNet Manager Suite (Cloud)

Application_DIM is a dimension table storing applications (specific edition and version of a product).

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 Application_DIM table

Database Column

Details

ApplicationID

Type: integer. Key

Primary key of the application.

FullName

Type: text (max 512 characters). Key

Full name of the application.

PublisherName

Type: text (max 200 characters). Key

Publisher of the application.

ProductName

Type: text (max 200 characters). Key

Product name of the application.

EditionName

Type: text (max 50 characters)

Edition of the application.

VersionName

Type: text (max 50 characters)

Version of the application.

CategoryID

Type: integer. Key. Nullable

Category ID (UNSPSC) of the application.

ClassificationID

Type: integer. Key

Classification ID of the application.

ActionStatusID

Type: integer. Key

Action status ID of the application.

IsManaged

Type: boolean

Whether the application is a managed or unmanaged application.

StartOfLifeDate

Type: datetime. Key. Nullable

Start of life Date.

ReleaseDate

Type: datetime. Key. Nullable

The date the application was released.

EndOfSalesDate

Type: datetime. Key. Nullable

End of sales Date.

SupportedUntil

Type: datetime. Key. Nullable

The date the application will be supported.

ExtendedSupportUntil

Type: datetime. Key. Nullable

The date the application will be supported, in extended case.

EndOfLifeDate

Type: datetime. Key. Nullable

End of life Date.

FlexNet Manager Suite (Cloud)

Current