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, |
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