Application_DIM Table
Application_DIM
is a dimension table storing applications (specific edition and version of a product).
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.
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. |