MSC_ATTR_VAL_RELATIONSHIPS
Table to collect attribute value relationships from source system and store them in ODS to be used by other planning modules. Two attributes can be related to each other with a parent-child relationship. This table holds that information.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
msc_attr_val_relationship_PK |
PLAN_ID, RELATIONSHIP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | This column represents the plan Identifier. | |
| RELATIONSHIP_ID | NUMBER | 18 | Yes | Running number. Dummy value to avoid violation. | |
| ATTRIBUTE1_ID | NUMBER | 18 | Yes | Attribute Identifier of the first attribute in relationship. Eg., attribute_id of 'Project' in Project-Task relationship. | |
| ATTRIBUTE1_VAL_ID | NUMBER | 18 | Attribute value ID of the first attribute. Eg., attribute_value_id of 'Project' in Project-Task relationship. | ||
| ATTRIBUTE2_ID | NUMBER | 18 | Attribute Identifier of the second attribute. Eg., attribute_id of 'Task' in Project-Task relationship. | ||
| ATTRIBUTE2_VAL_ID | NUMBER | 18 | Attribute value ID of the second attribute. Eg., attribute_value_id of 'Task' in Project-Task relationship. | ||
| ATTRIBUTE3_ID | NUMBER | 18 | Attribute Identifier of the third attribute. | ||
| ATTRIBUTE3_VAL_ID | NUMBER | 18 | Attribute value ID of the third attribute. | ||
| ATTRIBUTE_SET_ID | NUMBER | 18 | Attribute set Identifier of the SET through which current relationship is defined. | ||
| REFRESH_NUMBER | NUMBER | 18 | Refresh number of the cycle or process that populates the record. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| TASK_DESIGNATOR1_ID | NUMBER | 18 | Task Id whose supplies are used in Net designator1 supply netting sequence. | ||
| TASK_DESIGNATOR1_DESC | VARCHAR2 | 100 | Description for Task designator1. | ||
| TASK_DESIGNATOR2_ID | NUMBER | 18 | Task Id whose supplies are used in Net designator2 supply netting sequence. | ||
| TASK_DESIGNATOR2_DESC | VARCHAR2 | 100 | Description for Task designator2. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ATTR_VAL_REL_N1 | Non Unique | FUSION_TS_TX_IDX | PLAN_ID, ATTRIBUTE_SET_ID, ATTRIBUTE1_ID, ATTRIBUTE1_VAL_ID |
| MSC_ATTR_VAL_REL_N2 | Non Unique | FUSION_TS_TX_IDX | PLAN_ID, ATTRIBUTE1_ID, ATTRIBUTE1_VAL_ID |
| MSC_ATTR_VAL_REL_U1 | Unique | Default | PLAN_ID, RELATIONSHIP_ID |