MSC_PLAN_MEASURES
This table is maintained by snapshot . The table is used to hold the list of measures in the scope of the plan.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_PLAN_MEASURES_PK |
PLAN_ID, MEASURE_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Identifier for the plan | |
| MEASURE_ID | NUMBER | Yes | Identifier for the measures in the plan | |
| MEASURE_CODE | VARCHAR2 | 30 | Yes | Measure Internal Code |
| STORE_RESULT | NUMBER | Store result flag, 1:store result for imported measures, 2/null: do not store result | ||
| EDITABLE | NUMBER | Editable flag, 1:editable, 2/null:read only | ||
| SHARED_FLAG | NUMBER | Shared measure flag, 1:Shared measure, 0/null:plan measure | ||
| GRANULARITY_ID | NUMBER | Yes | granularity of measure | |
| ODS_DATA_VIEW | VARCHAR2 | 30 | ODS source table/view for reading data | |
| HAS_DATA | NUMBER | 1 if the measure has data in the ODS_DATA_VIEW else 2 | ||
| ODS_DATA_TYPE | NUMBER | This column determines the data present for plan id -1 or planid in MSC_MEASURE_DATA .Depending upon the condition it has 4 values . When data present for -1 only its value is 1 . when data present for only plan id then its value is 2. when Data present for both -1 and the specified plan id then its value is 3. otherwise its value 4 . | ||
| LAST_SNAPSHOT_RUN | TIMESTAMP | Indicates the time of the last snapshot run, updated at the end of measure snapshot. | ||
| LAST_REFRESH_NUMBER | NUMBER | This stores the max(refresh number) of the measures of a plan. | ||
| FILTER_FROM_DATE | NUMBER | FILTER_FROM_DATE | ||
| FILTER_UNTIL_DATE | NUMBER | FILTER_UNTIL_DATE | ||
| SDATA_FROM_DATE | NUMBER | SDATA_FROM_DATE | ||
| SDATA_UNTIL_DATE | NUMBER | SDATA_UNTIL_DATE | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_PLAN_MEASURES_U1 | Unique | Default | PLAN_ID, MEASURE_ID |