MSC_APPROVE_PLAN_MEASURES
This table holds the mapping of source measures and target measures along with the planId for which the source measures need to be copied to the target measures during the approve plan action.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_APPROVE_PLAN_MEASURES_PK |
PLAN_ID, SOURCE_MEASURE_ID, TARGET_MEASURE_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Identifier for the plan for which approve plan action runs | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| SOURCE_MEASURE_ID | NUMBER | Yes | Identifier for the measure,which indicates the source measures to be copied to the target measures during approve plan action | |
| TARGET_MEASURE_ID | VARCHAR2 | 50 | Yes | Identifier for the measure which indicates , to what target measures source measures need to be copied during approve plan action |
| 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_APPROVE_PLAN_MEASURES_U1 | Unique | Default | PLAN_ID, SOURCE_MEASURE_ID, TARGET_MEASURE_ID |