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. | |
| BASE_MEASURE_ID | NUMBER | 18 | The measure id of the base measure for duplicated format measures | ||
| MAX_HIGH_RANGE | NUMBER | maximum high range of value | |||
| 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 | |||
| MIN_HIGH_RANGE | NUMBER | Minimum value for high range. | |||
| MAX_LOW_RANGE | NUMBER | Maximum for low range | |||
| MEASURE_CODE | VARCHAR2 | 30 | Yes | Measure internal code | |
| DATA_TYPE | NUMBER | 9 | Data type, 1:Number, 2:Currency, 3:Percent, 4:Date, 5:Text (fnd_lookup_values:MSC_MEASURE_DATA_TYPE) | ||
| EDITABLE | NUMBER | 9 | Editable flag, 1:editable, 0/null:read only | ||
| EDIT_RANGE | NUMBER | 9 | Edit range, 1:History, 2:Future, 3:History and Future, (fnd_lookup_values: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 | ODS measure flag, 1:ODS measure, 0/null:plan measure | ||
| AGGR_ORDER | NUMBER | 9 | Aggregation order, 1/null: Calculate then Aggrgate, 2:Aggrgate then Calculate, (fnd_lookup_values:MSC_MEASURE_AGGR_ORDER) | ||
| AGGR_METHOD_OTHER | VARCHAR2 | 20 | Sum, Average, Count, Min, Max, Most Common, Least Common, Latest, None, Weighted Avg | ||
| AGGR_METHOD_TIME | VARCHAR2 | 20 | Sum, Average, Count, Min, Max, Most Common, Least Common, Latest, None, Weighted Avg | ||
| WEIGHTED_BY | NUMBER | 18 | measure_id of reference measure weighted by | ||
| DISAGGR_METHOD_OTHER | VARCHAR2 | 20 | Same Value, Equal, By Measure, By Self | ||
| DISAGGR_BASIS_OTHER | NUMBER | 18 | measure_id 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 | measure_id 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. | ||
| EDIT_LOCK_EXPR | VARCHAR2 | 2000 | If the expression evaluates as true, the Measure is locked from editing. | ||
| SOURCE_TYPE | NUMBER | 9 | Measure source type, 0:Regular, 1:Level, 2:List, (fnd_lookup_values:MSC_MEASURE_SOURCE_TYPE). | ||
| SOURCE_LEVEL_ID | NUMBER | 18 | level_id, 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. | ||
| MAX_GRANULARITY_ID | NUMBER | 18 | Maximum possible granularity. | ||
| 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_ID | ||
| IS_SEEDED | NUMBER | 9 | IS_SEEDED | ||
| DECIMAL_PLACES | NUMBER | 9 | DECIMAL_PLACES | ||
| DATE_FORMAT | VARCHAR2 | 32 | DATE_FORMAT | ||
| TABLE_ID | NUMBER | 18 | TABLE_ID | ||
| IS_DISABLE | NUMBER | 9 | IS_DISABLE | ||
| ODS_DATA_VIEW | VARCHAR2 | 30 | Source view for measures. | ||
| 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 | Specifies a field to hold the base uom code of a measure. | ||
| BASE_CURRENCY_CODE | VARCHAR2 | 60 | Specifies a field to hold the base uom code of a 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 | Column required for CTO measures. | ||
| LINKING_MEASURE_ID | NUMBER | 18 | LINKING_MEASURE_ID | ||
| 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. |
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 |