[Home] [Help] [Dependency Information]
Object Name: | AMS_METRICS_ALL_B |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_METRICS_ALL_B |
Subobject Name: | |
Status: | VALID |
AMS_METRICS_ALL_B stores all metric definitions in Oracle Marketing. The metrics are used to track many aspects of the marketing activities. Metrics can be user entered or system calculated using PL/SQL programs. Formula metrics calculate composite values made up of other metrics, for instance ROI and Response Rate. Metrics can be defined to calculate the value based on the amount of business defined. These are called Variable Metrics. With in an activity the value can be summarized to show totals such as costs. Metric values can also rollup the activity hierarchy using Rollup Metrics.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_METRICS_ALL_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | METRIC_ID |
AMS_METRICS_ALL_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | SUMMARY_METRIC_ID |
AMS_METRICS_ALL_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | METRIC_PARENT_ID |
AMS_METRICS_ALL_B_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | METRIC_CATEGORY |
AMS_METRICS_ALL_B_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED | METRIC_SUB_CATEGORY |
AMS_METRICS_ALL_B_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED | APPLICATION_ID |
AMS_METRICS_ALL_B_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED | ARC_METRIC_USED_FOR_OBJECT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
METRIC_ID | NUMBER | Yes | Unique Identifier. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
ARC_METRIC_USED_FOR_OBJECT | VARCHAR2 | (30) | Yes | Indicates wether the metrics was created for Campaigns, Events, or Collaterals. |
METRIC_CALCULATION_TYPE | VARCHAR2 | (30) | Yes | Indicates how the engine computes this metric, for example, using a function, expect a manual entry or rollup from other metrics. |
APPLICATION_ID | NUMBER | Yes | Indicates the application that defined this metrics | |
METRIC_CATEGORY | NUMBER | Metric category. | ||
METRIC_SUB_CATEGORY | NUMBER | Sub category for the metrics, refer to AMS_CATEGORIES_VL. | ||
ACCRUAL_TYPE | VARCHAR2 | (30) | Yes | Accrual type which can be FIXED or VARIABLE. |
VALUE_TYPE | VARCHAR2 | (30) | Yes | The return value type of a metric calculation, which can be either NUMBER or RATIO. |
SENSITIVE_DATA_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the metric is confidential. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the metric is active. |
FUNCTION_NAME | VARCHAR2 | (4000) | Name of the PL/SQL function to be executed for metrics of type FUNCTION. | |
METRIC_PARENT_ID | NUMBER | Reference to the metric which this metric rolls up to. | ||
SUMMARY_METRIC_ID | NUMBER | Reference to the metric which this metric is summarized to. | ||
COMPUTE_USING_FUNCTION | VARCHAR2 | (4000) | For a metric of type VARIABLE, this is the name of the PL/SQL function used for computing the metric value. | |
DEFAULT_UOM_CODE | VARCHAR2 | (3) | Default UOM code for the metric. | |
UOM_TYPE | VARCHAR2 | (10) | The UOM type. | |
FORMULA | VARCHAR2 | (4000) | Formula attached to the metric. | |
ORG_ID | NUMBER | (32) | Operating unit identifier. | |
HIERARCHY_ID | NUMBER | Foreign Key to Oracle Marketing Hierarchy. | ||
SET_FUNCTION_NAME | VARCHAR2 | (4000) | The Function to be called after metric execution. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
FUNCTION_TYPE | VARCHAR2 | (1) | Indidates whether it is a function or a procedure | |
DISPLAY_TYPE | VARCHAR2 | (30) | Determines the display format and storage format. | |
TARGET_TYPE | VARCHAR2 | (30) | Lookup values used for control group analysis | |
DENORM_CODE | VARCHAR2 | (30) | Lookup code for metric |
Cut, paste (and edit) the following text to query this object:
SELECT METRIC_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ARC_METRIC_USED_FOR_OBJECT
, METRIC_CALCULATION_TYPE
, APPLICATION_ID
, METRIC_CATEGORY
, METRIC_SUB_CATEGORY
, ACCRUAL_TYPE
, VALUE_TYPE
, SENSITIVE_DATA_FLAG
, ENABLED_FLAG
, FUNCTION_NAME
, METRIC_PARENT_ID
, SUMMARY_METRIC_ID
, COMPUTE_USING_FUNCTION
, DEFAULT_UOM_CODE
, UOM_TYPE
, FORMULA
, ORG_ID
, HIERARCHY_ID
, SET_FUNCTION_NAME
, SECURITY_GROUP_ID
, FUNCTION_TYPE
, DISPLAY_TYPE
, TARGET_TYPE
, DENORM_CODE
FROM AMS.AMS_METRICS_ALL_B;
AMS.AMS_METRICS_ALL_B does not reference any database object
AMS.AMS_METRICS_ALL_B is referenced by following:
|
|
|