SCRM 2006 SCRS_Lineage_Dimension_View

SCRS_Lineage_Dimension_View lists the source of SMS data stored in an SCRM data warehouse. It provides a detailed, permanent record of what data was extracted from operational SMS databases, in what synchronization run the data moved into the SCRM data warehouse, the total counts of the records changed, and the job durations.

SCRS_Lineage_Dimension_View

Column	Type	Constraint	Description
LineageKey	int	Not Null	Foreign key from the SC_LineageDimension_Table that uniquely identifies each DTS package, and its execution date and time, that extracted data from the source system. This is the primary key.
DTSSynchExecutionEndDate	datetime	Null values allowed	End date when a particular version of a DTS package execution was completed.
DTSPackageGUID	nvarchar	Not Null	GUID of executed DTS package.
DTSPackageName	nvarchar	Not Null	Name of executed DTS package.
DTSPackageVersion	nvarchar	Null values allowed	Version of executed DTS package.
LineageSourceSystem	nvarchar	Not Null	Source of the data being inserted—for example, SMS.
LineageSourceSMSSiteKey	int	Null values allowed	SMS site key associated with source of inserted data.
LineageSynchDuration	real	Null values allowed	Duration of the data lineage.
LineageSynchExecutionDate	datetime	Null values allowed	Date when a particular version of a particular DTS package was executed.
LineageSynchExecutionId	nvarchar	Not Null	Identifier that stores a GUID that represents each unique execution of a specific version of a DTS package.
LineageSynchStatusCode	int	Null values allowed	DTS package execution status code.
LineageSynchTotalDeletes	int	Null values allowed	Total number of deletes that occurred during package execution.
LineageSynchTotalErrors	int	Null values allowed	Total number of errors that occurred during package execution.
LineageSynchTotalInserts	int	Null values allowed	Total number of inserts that occurred during package execution.
LineageSynchTotalUpdates	int	Null values allowed	Total number of updates that occurred during package execution.

See Also

Other Resources

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