Opportunity Stage Snapshots

The opportunity stage snapshot is used to view historical snapshots of the opportunity captured when it moves from one sales stage to the next.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.MooBiccExtractAM.OptyStgSnapshotExtractPVO

Primary Keys : OptyStgSnapshotId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActiveFlag	Indicates whether the opportunity stage snapshot is active.
CreatedBy	The user who created the opportunity stage snapshot row.
CreationDate	The date and time when the opportunity stage snapshot row was created.
LastUpdateDate	The date and time when the opportunity stage snapshot row was last updated.
LastUpdateLogin	The session login associated to the user who last updated the opportunity stage snapshot row.
LastUpdatedBy	The user who last updated the opportunity stage snapshot row.
OptyId	The identifier of the opportunity in the opportunity stage snapshot. This is a foreign key of the Opportunity view object.
OptyStgSnapshotId	The unique identifier of the opportunity stage snapshot . This is a primary key of the Opportunity Stage Snapshot view object.
StgEnterDate	The date when the opportunity entered this sales stage.
StgExitDate	The date when the opportunity exited this sales stage.
StgId	The identifier of the stage in the opportunity stage snapshot. This is a foreign key of the Sales Stage view object.
UserLastUpdateDate	The date and time when the opportunity stage snapshot was last updated.