Attributes Staging Table (Master Data Services)

Use the attributes staging table (mdm.tblStgMemberAttribute) in the Master Data Services database to:

• Update attribute values of existing members and collections.

• Delete members or collections.

• Reactivate members or collections.

This topic contains the following sections:

• Table Columns

• Examples

Table Columns

Column Name	Description
ID	Displays an automatically assigned identifier. If the batch has not been processed, this field is blank.
Batch_ID	Displays an automatically assigned identifier that groups records for staging. All members in the batch are assigned this identifier, which is displayed in the Master Data Manager user interface in the ID column. This value is also in mdm.tblStgBatch, in the ID field. If the batch has not been processed, this field is blank.
UserName	Optional value. Specify a user name to filter the records in the Master Data Manager user interface. The logged in user can view: Records for his or her user name, and Records with no user name assigned. The user name should match the name in the Master Data Manager Users list, for example DOMAIN\user_name or server\user_name.
ModelName	Required value. Specify the case-sensitive name of the model.
EntityName	Required value. Specify the name of the entity.
MemberType_ID	Required value. Specify the type of member. Possible values are: 1 to indicate leaf member. 2 to indicate consolidated member. 3 to indicate collection.
MemberCode	Required value. Specify the code for the member that you want to update.
AttributeName	Required value. Specify the attribute name. You can use MDMMemberStatus for AttributeName to deactivate or reactivate a member or collection. For more information, see How to: Delete a Member or Collection by Using tblStgMemberAttribute (Master Data Services) and How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services).
AttributeValue	For free-form attributes, specify the new text or string value for the attribute. For domain-based attributes, specify the code for the member that will be the attribute. If you leave this field blank, when the staging process runs, the attribute value is updated to a blank value. The only exceptions are numeric values, date values, or the Name attribute. These cannot be assigned a blank value through staging. If you used MDMMemberStatus for AttributeName, use De-Activated or Active for AttributeValue. Note You cannot stage file attributes.
Status_ID	Displays the status of the import process. Possible values are: 0, which you specify to indicate that the record is ready for staging. 1, which is automatically assigned and indicates that staging for the record has succeeded. 2, which is automatically assigned and indicates that staging for the record has failed.
ErrorCode	Displays an error code. For all records with a Status_ID of 2, view the Staging Batch Errors page in Master Data Manager for a more detailed description.

Examples

You can save the following examples to a flat file and import them into your Master Data Services database if you have completed the following tasks:

• Deployed the sample Product model that is in the Master Data Services\Samples\Packages directory where you installed Master Data Services. For more information about deploying the sample Product model, see Deploying Models (Master Data Services).

• Imported the example in Members Staging Table (Master Data Services).

For more information about importing data into a database by using SQL Server Integration Services, see How to: Run the SQL Server Import and Export Wizard.

Updating attribute values

The following example shows how to update an attribute value for a leaf member, a consolidated member, and a collection.

• The first line in this example contains the column names.

• The second line updates the DaysToManufacture attribute value to 4 for the BK-M101 leaf member.

• The third line sets the Name attribute value to Men/Women for the MW consolidated member.

• The fourth line sets the Description attribute value to John Yokim's Products for the JR collection.

  ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
  Product,Product,1,BK-M101,DaysToManufacture,4
  Product,Product,2,MW,Name,Men/Women
  Product,Product,3,JR,Description,John Yokim's Products
  

Deleting a member

The following example shows how to delete a member by using MDMMemberStatus for the attribute and De-Activated for the attribute value.

ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
Product,Product,1,BK-M101,MDMMemberStatus,De-Activated

For more information, see How to: Delete a Member or Collection by Using tblStgMemberAttribute (Master Data Services).

Reactivating a member

The following example shows how to reactivate a deleted member by using MDMMemberStatus for the attribute and Active for the attribute value.

ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
Product,Product,1,GUID,MDMMemberStatus,Active

For information about how to determine the GUID, see How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services).

See Also

Tasks

How to: Delete a Member or Collection by Using tblStgMemberAttribute (Master Data Services)

How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services)

How to: Update Attribute Values by Using tblStgMemberAttribute (Master Data Services)

Concepts

Importing Data (Master Data Services)

Staging Error Messages (Master Data Services)