Application_DIM Table

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. Key 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.
`PublisherID`	Type: integer. Key. Nullable Publisher ID of the application.