Table: AMS_ACT_METRIC_HST

Product:	AMS - Marketing
Description:	This table stores the historical value for a metrics being tracked against a marketing entity e.g. date and value for metrics 'ROI' for a specific marketing campaign.
Implementation/DBA Data:	AMS.AMS_ACT_METRIC_HST

Primary Key: AMS_ACT_METRIC_HST_PK

1. ACT_MET_HST_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_ACT_METRIC_HST		AMS_ACT_METRICS_ALL	AMS_ACT_METRIC_HST.ACTIVITY_METRIC_ID
AMS_ACT_METRIC_HST		AMS_MET_SCENARIOS	AMS_ACT_METRIC_HST.SCENARIO_ID
AMS_ACT_METRIC_HST		AMS_METRICS_ALL_B	AMS_ACT_METRIC_HST.METRIC_ID
AMS_ACT_METRIC_HST		AMS_OBJECT_ASSOCIATIONS	AMS_ACT_METRIC_HST.ACTIVITY_METRIC_ORIGIN_ID