Snapshots

The snapshots view object contains information such as snapshot date, quarter end indicator, year end indicator, period end indicator, purge date, and so on.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.SnapshotExtractPVO

Primary Keys : SnapshotId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CreatedBy	The user who created the snapshot row.
CreationDate	The date and time when the snapshot row was created.
LastUpdateDate	The date and time when the snapshot row was last updated.
LastUpdateLogin	The session login associated to the user who last updated the snapshot row.
LastUpdatedBy	The user who last updated the snapshot row.
PeriodEndFlag	Indicates if the snapshot row is an end of period snapshot.
PurgeDate	The purge date of the snapshot row.
QuarterEndFlag	Indicates if the snapshot row is an end of quarter snapshot.
SnapshotDate	The snapshot date of the snapshot row.
SnapshotId	The unique identifier of the snapshot. This is a primary key of the Snapshot view object.
UserLastUpdateDate	The date and time of last update date of the snapshot row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database.
YearEndFlag	Indicates if the snapshot row is an end of year snapshot.