Relationship Staging Table (Master Data Services)

  • Article

Use the relationship staging table (stg.name_Relationship) in the Master Data Services database to change the location of members in an explicit hierarchy, based on the relationship the members have to one another.

Table Columns

The following table explains what each of the fields in the Relationship staging table are used for.

Column Name

Description

ID

An automatically assigned identifier. Do not enter a value in this field. If the batch has not been processed, this field is blank.

RelationshipType

Required

The type of relationship that’s being set. Possible values are:

  • 1:Parent

  • 2: Sibling (at the same level)

ImportStatus_ID

Required

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 the staging process for the record has succeeded.

  • 2, which is automatically assigned and indicates that the staging process for the record has failed.

Batch_ID

Required by web service only

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.

If the batch has not been processed, this field is blank.

BatchTag

Required, except by web service

A unique name for the batch, up to 50 characters.

HierarchyName

Required

The explicit hierarchy name. Each consolidated member can belong to one hierarchy only.

ParentCode

Required

For parent-child relationships, the code of the consolidated member that will be the parent of the child leaf or consolidated member.

For sibling relationships, the code of one of the siblings.

ChildCode

Required

For parent-child relationships, the code of the consolidated or leaf member that will be the child.

For sibling relationships, the code of one of the siblings.

Sort Order

Optional

An integer that indicates the order of the member in relation to the other members under the parent. Each child member should have a unique identifier.

ErrorCode

Displays an error code. For all records with a ImportStatus_ID of 2, see Staging Process Errors (Master Data Services).

See Also

Tasks

Move Explicit Hierarchy Members by Using the Staging Process (Master Data Services)

View Errors that Occur During the Staging Process (Master Data Services)

Concepts

Importing Data (Master Data Services)

Staging Process Errors (Master Data Services)