SCRM 2006 SCRS_Package_Dimension_View
SCRS_Package_Dimension_View lists the SMS software packages that are available for software distribution across all SMS installations in the enterprise.
SCRS_Package_Dimension_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| PackageKey | int | Not Null | Foreign key that uniquely identifies each package in the SC_PackageDimension_Table. |
| PackageContainsSourceFiles | int | Null values allowed | Indicates whether the package contains source files. |
| PackageContentsVersion | int | Null values allowed | Incremented when the package is updated or the source files are refreshed. |
| PackageEndTimeKey | int | Null values allowed | Stores the end of the time period that this row was valid. A |
| PackageEndDateKey | smallint | Null values allowed | Stores the end of the time period that this row was valid. A |
| PackageEndDateLineageKey | int | Null values allowed | References the DTS lineage of the package that first detected that this managed node no longer exists in the SMS site database. |
| PackageStartTimeKey | int | Not Null | Start of the time period that this row was known to be valid. Indicates time when SMS first created the item. |
| PackageStartDateKey | smallint | Not Null | Start of the time period that this row was known to be valid. Indicates time when SMS first created the item. |
| PackageStartDateLineageKey | int | Not Null | References the DTS lineage of the package that first detected that this managed node exists in the SMS site database. |
| PackageDescription | nvarchar | Null values allowed | Textual description of the package. |
| PackageId | nvarchar | Not Null | Unique, auto-generated key that you use to relate programs, advertisements, and distribution points to the package. |
| PackageLanguage | nvarchar | Null values allowed | Used with Manufacturer, Name, and Version to identify a package in the SMS Administrator console. For example, you could have English and German versions of the same package. |
| PackageManufacturer | nvarchar | Null values allowed | Manufacturer, or publisher, of the package, used with Name, Version, and Language to identify a package in the SMS Administrator console. |
| PackageName | nvarchar | Not Null | Name of the package, used with PackageName, PackageVersion, and PackageLanguage to identify a package in the SMS Administrator console. This is the only property that is required to create a package instance. |
| PackageOSDeployment | int | Null values allowed | Indicates whether the package is associated with an operating system deployment. |
| PackageVersion | nvarchar | Null values allowed | Version of the package, used with Manufacturer, Name, and Language to identify a package in the SMS Administrator console. |