MSC_MEASURES_B
Measures definition base table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_MEASURES_B_PK |
MEASURE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MEASURE_ID | NUMBER | 18 | Yes | Measure identifier of a measure record. | |
| BASE_MEASURE_ID | NUMBER | 18 | The measure id of the base measure for duplicated format measures. | ||
| MAX_HIGH_RANGE | NUMBER | Maximum high range value of a measure. | |||
| GOAL_VALUES | NUMBER | 1 | Values for goals: 1 for Low values are better, 2 for High values are better. | ||
| MIN_LOW_RANGE | NUMBER | Minimum value for low range of a measure. | |||
| MIN_HIGH_RANGE | NUMBER | Minimum value for high range of a measure. | |||
| MAX_LOW_RANGE | NUMBER | Maximum value for low range of a measure. | |||
| MEASURE_CODE | VARCHAR2 | 30 | Yes | A unique internal Code for the measure. | |
| DATA_TYPE | NUMBER | 9 | Data type of the measure. Valid values: 1:Number, 2:Currency, 3:Percent, 4:Date, 5:Text. | ||
| EDITABLE | NUMBER | 9 | Indicates whether the measure is editable. Valid values: 1:editable, 0 or null:read only. | ||
| EDIT_RANGE | NUMBER | 9 | Edit range. Valid values: 1:History, 2:Future, 3:History and Future, See FND_LOOKUP_VALUES(ORA_MSC_MEASURE_EDIT_RANGE). | ||
| STORE_RESULT | NUMBER | 9 | Store result flag, 1:store result for imported measures, 0/null:do not store result. | ||
| SHARED_FLAG | NUMBER | 9 | Operation Data Store(ODS) measure flag, 1:ODS measure, 0/null:plan measure. | ||
| AGGR_ORDER | NUMBER | 9 | Aggregation order. Valid values: 1/NULL:Calculate then Aggregate, 2:Aggregate then Calculate. See FND_LOOKUP_VALUES (ORA_MSC_MEASURE_AGGR_ORDER). | ||
| AGGR_METHOD_OTHER | VARCHAR2 | 20 | Aggregation methods for other. Valid values: Sum, Average, Count, Min, Max, Most Common, Least Common, Latest, None, Weighted Avg. | ||
| AGGR_METHOD_TIME | VARCHAR2 | 20 | Aggregation methods for time. Valid values: Sum, Average, Count, Min, Max, Most Common, Least Common, Latest, None, Weighted Avg. | ||
| WEIGHTED_BY | NUMBER | 18 | Reference measure identifier of reference measure weighted by. | ||
| DISAGGR_METHOD_OTHER | VARCHAR2 | 20 | Same Value, Equal, By Measure, By Self. | ||
| DISAGGR_BASIS_OTHER | NUMBER | 18 | Reference measure identifier of base measure used to split the current measure on other dimensions. Valid only when disaggr_method_other is By Measure. | ||
| DISAGGR_METHOD_TIME | VARCHAR2 | 20 | Same Value, Equal, By Measure, By Self. | ||
| DISAGGR_BASIS_TIME | NUMBER | 18 | Reference measure identifier of base measure used to split the current measure on Time dimension. Valid only when disaggr_method_time is By Measure. | ||
| EXPRESSION | VARCHAR2 | 2000 | Expression of the current measure. | ||
| EDIT_LOCK_EXPR | VARCHAR2 | 2000 | If the expression evaluates as true, the Measure is locked from editing. | ||
| SOURCE_TYPE | NUMBER | 9 | Measure source type. Valid values: 0=Regular, 1=Level, 2=List. | ||
| SOURCE_LEVEL_ID | NUMBER | 18 | Level Identifier, if measure values are sourced from a level attribute. | ||
| SOURCE_ATTRIBUTE_NAME | VARCHAR2 | 100 | Attribute name, if measure values are sourced from a level attribute. | ||
| OWNER | NUMBER | 9 | Owner (0/NULL=Configure Measures, 1=Demand Analysis, 2=Table Expression) | ||
| GRANULARITY_ID | NUMBER | 18 | Fact type identifier granularity ID for the measure. | ||
| MAX_GRANULARITY_ID | NUMBER | 18 | Maximum possible granularity identifier. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SOURCE_ATTRIBUTE_ID | NUMBER | 18 | Source attribute identifier of a measure. | ||
| IS_SEEDED | NUMBER | 9 | Flag indicating if the measure is seeded. | ||
| DECIMAL_PLACES | NUMBER | 9 | Decimal precision of the current measure. | ||
| DATE_FORMAT | VARCHAR2 | 32 | Date format of the current measure if the measure data type is date. | ||
| TABLE_ID | NUMBER | 18 | The table identifier with which the current measure is associated. | ||
| IS_DISABLE | NUMBER | 9 | Flag indicating whether the current attribute is disabled. | ||
| ODS_DATA_VIEW | VARCHAR2 | 30 | Source view name for measure data. | ||
| SEC_BASIS | NUMBER | 18 | Specifies a secondary field for selecting a measure to split by. User can choose only measures which contain pre-calculated proportions. | ||
| BASE_UOM_CODE | VARCHAR2 | 12 | Base unit of measure code of the measure. | ||
| BASE_CURRENCY_CODE | VARCHAR2 | 60 | Base currency code of the measure. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| RELEVANT_PLAN_TYPE | NUMBER | 9 | Used to identify the supported Plan Types for the respective measure. | ||
| MEASURE_CALC_TYPE | NUMBER | 9 | Used to identify the measure calculation type. | ||
| PROPAGATION_RULE_ID | NUMBER | 18 | Rule identifier for configure to order measures. | ||
| LINKING_MEASURE_ID | NUMBER | 18 | The measure identifier which linkes to the current measure. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| EXPRESSION_ADDL_INFO | VARCHAR2 | 100 | Expression additional information, such as scaling options with choices of Relative Scale or 100% Scale. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| msc_measure_group_assign | msc_measures_b | MEASURE_ID |
| msc_measure_uom | msc_measures_b | MEASURE_ID |
| msc_measure_goal | msc_measures_b | MEASURE_ID |
| msc_measures_tl | msc_measures_b | MEASURE_ID |
| msc_measure_references | msc_measures_b | MEASURE_ID |
| msc_measure_cond_formats | msc_measures_b | MEASURE_ID |
| msc_measure_currency | msc_measures_b | MEASURE_ID |
| msc_catalog_measures | msc_measures_b | MEASURE_ID |
| msc_measure_dependency | msc_measures_b | MEASURE_ID |
| msc_measure_context_gran | msc_measures_b | MEASURE_ID |
| msc_measure_dim_params | msc_measures_b | MEASURE_ID |
| msc_measure_values | msc_measures_b | MEASURE_ID |
| msc_association_context | msc_measures_b | MEASURE_ID |
| msc_measure_formats | msc_measures_b | MEASURE_ID |
| msc_measure_pricelist | msc_measures_b | MEASURE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_MEASURES_B_U1 | Unique | FUSION_TS_TX_DATA | MEASURE_ID, ORA_SEED_SET1 |
| MSC_MEASURES_B_U11 | Unique | FUSION_TS_TX_DATA | MEASURE_ID, ORA_SEED_SET2 |
| MSC_MEASURES_B_U2 | Unique | Default | MEASURE_CODE, ORA_SEED_SET1 |
| MSC_MEASURES_B_U21 | Unique | Default | MEASURE_CODE, ORA_SEED_SET2 |