1. Tables and Views for SCM
  2. MSC_ST_ATTR_DESIGNATORS_INT

MSC_ST_ATTR_DESIGNATORS_INT

Table to collect attribute task designators 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 Comments
ATTRIBUTE_ID NUMBER 18 Unique Identifier of the Attribute Name in the Planning System.
ATTRIBUTE_NAME VARCHAR2 256 Attribute Name used in Attribute based planning.
ATTRIBUTE_VALUE VARCHAR2 2000 Attribute value for which designators will be defined.
ATTRIBUTE_NUMBER NUMBER 18 Number of the Attribute used in Attribute based planning. Eg., For Projects, attribute_number=1 and for tasks, it is 2.
ATTRIBUTE_VALUE_ID NUMBER 18 Unique Identifier of the Attribute Value in the Planning System.
DESIGNATOR1_ID NUMBER 18 Designator Id whose supplies are used in Net designator1 supply netting sequence.
DESIGNATOR1_VALUE VARCHAR2 2000 Attribute Value whose supplies are used in Net designator1 supply netting sequence.
DESIGNATOR1_DESC VARCHAR2 100 Description for Attribute designator1.
DESIGNATOR2_ID NUMBER 18 Designator Id whose supplies are used in Net designator2 supply netting sequence.
DESIGNATOR2_VALUE VARCHAR2 2000 Attribute name whose supplies are used in Net designator2 supply netting sequence.
DESIGNATOR2_DESC VARCHAR2 100 Description for Attribute designator2.
RELATIONSHIP_ID NUMBER 18 Unique identifier of the relationship.
SR_INSTANCE_CODE VARCHAR2 30 Source Instance code from which data is being populated.
SR_INSTANCE_ID NUMBER 18 Source application instance identifier.
REFRESH_NUMBER NUMBER 18 Refresh number populated by the collection program.
PROCESS_FLAG NUMBER 18 Process Flag indicates the status of records during pre-processing. 1- Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record.
DELETED_FLAG NUMBER 18 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 18 It Stores the Request ID of Job that loaded the data.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 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.