MSC_ST_ATTR_VAL_REL_INT
Table to collect attribute value relationships from source system and store them in ODS to be used by other planning modules. This is interface table for MSC_ATTR_VAL_RELATIONSHIPS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| ATTRIBUTE1_NAME | VARCHAR2 | 256 | Attribute name of the first attribute. Eg., 'Project' in Project-Task relationship. | |||
| ATTRIBUTE1_NUMBER | NUMBER | Number of the Attribute used in Attribute based planning. Eg., For Projects, attribute_number=1 and for tasks, it is 2. | ||||
| ATTRIBUTE1_ID | NUMBER | 18 | Attribute Identifier of the first attribute. Eg., attribute_id of 'Project' in Project-Task relationship. | |||
| ATTRIBUTE1_VALUE | VARCHAR2 | 2000 | Attribute value of the first attribute. Eg., Project_Number 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_NAME | VARCHAR2 | 256 | Attribute name of the second attribute. Eg., 'Task' in Project-Task relationship. | |||
| ATTRIBUTE2_NUMBER | NUMBER | Number of the Attribute used in Attribute based planning. Eg., For Projects, attribute_number=1 and for tasks, it is 2. | ||||
| ATTRIBUTE2_ID | NUMBER | 18 | Attribute Identifier of the second attribute. Eg., attribute_id of 'Task' in Project-Task relationship. | |||
| ATTRIBUTE2_VALUE | VARCHAR2 | 2000 | Attribute value of the second attribute. Eg., 'Task_Number' 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_NAME | VARCHAR2 | 256 | Attribute name of the third attribute in the relationship. Eg., 'Color' in 'Style-Size-Color' relationship. | |||
| ATTRIBUTE3_NUMBER | NUMBER | Number of the Attribute used in Attribute based planning. Eg., For Projects, attribute_number=1 and for tasks, it is 2. | ||||
| ATTRIBUTE3_ID | NUMBER | 18 | Attribute Identifier of the third attribute. Eg., attribute_id of ''Color' in 'Style-Size-Color' relationship. | |||
| ATTRIBUTE3_VALUE | VARCHAR2 | 2000 | Attribute value of the third attribute. Eg., 'Red' in 'Style-Size-Color' relationship. | |||
| ATTRIBUTE3_VAL_ID | NUMBER | 18 | Attribute value ID of the third attribute. Eg., attribute_value_id of 'Red' Color in 'Style-Size-Color' relationship. | |||
| ATTRIBUTE_SET_NAME | VARCHAR2 | 128 | Attribute set Name of the SET through which current relationship is defined. | |||
| ATTRIBUTE_SET_ID | NUMBER | 18 | Attribute set Identifier of the SET through which current relationship is defined. | |||
| RELATIONSHIP_ID | NUMBER | 18 | Running number. Unique value of the relationship. | |||
| SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | |||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | ||||
| DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row will be deleted | ||||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | |||
| ERROR_TEXT | VARCHAR2 | 2000 | This will describe the reason for the error if any. | |||
| LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | ||||
| 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_VALUE | VARCHAR2 | 100 | Task name whose supplies are used in Net designator1 supply netting sequence. | Obsolete | ||
| TASK_DESIGNATOR1_ID | NUMBER | 18 | Task Id whose supplies are used in Net designator1 supply netting sequence. | Obsolete | ||
| TASK_DESIGNATOR1_DESC | VARCHAR2 | 100 | Description for Task designator1. | Obsolete | ||
| TASK_DESIGNATOR2_VALUE | VARCHAR2 | 100 | Task name whose supplies are used in Net designator2 supply netting sequence. | Obsolete | ||
| TASK_DESIGNATOR2_ID | NUMBER | 18 | Task Id whose supplies are used in Net designator2 supply netting sequence. | Obsolete | ||
| TASK_DESIGNATOR2_DESC | VARCHAR2 | 100 | Description for Task designator2. | Obsolete |