SCRM 2006 SCRS_Package_Dimension_View

2006-09-10

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 `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
PackageEndDateKey	smallint	Null values allowed	Stores the end of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
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.

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures