Share via

Leaf Member Staging Table (Master Data Services)

  • Article

Use the leaf members staging table (stg.name_Leaf) in the Master Data Services database to create, update, deactivate, and delete leaf members. You can also use it to update attribute values for leaf members.

Table Columns

The following table explains what each of the fields in the Leaf 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.

ImportType

Required

Determines what to do when staged data matches data that already exists in the Master Data Services database.

  • 0: Create new members. Replace existing MDS data with staged data, but only if the staged data is not NULL. NULL values are ignored. To change a string attribute value to NULL, set it ~NULL~. To change a number attribute value to NULL, set it to -98765432101234567890. To change a datetime attribute value to NULL, set it to 5555-11-22T12:34:56.

  • 1: Create new members only. Any updates to existing MDS data fail.

  • 2: Create new members. Replace existing MDS data with staged data. If you import NULL values, they will overwrite existing MDS values.

  • 3: Deactivate the member, based on the Code value. All attributes, hierarchy and collection memberships, and transactions are maintained but no longer available in the UI. If the member is used as a domain-based attribute value of another member, the deactivation will fail. See ImportType 5 for an alternative.

  • 4: Permanently delete the member, based on the Code value. All attributes, hierarchy and collection memberships, and transactions are permanently deleted. If the member is used as a domain-based attribute value of another member, the deletion will fail. See ImportType 6 for an alternative.

  • 5: Deactivate the member, based on the Code value. All attributes, hierarchy and collection memberships, and transactions are maintained but no longer available in the UI. If the member is used as a domain-based attribute value of other members, the related values will be set to NULL. ImportType 5 is for leaf members only.

  • 6: Permanently delete the member, based on the Code value. All attributes, hierarchy and collection memberships, and transactions are permanently deleted. If the member is used as a domain-based attribute value of other members, the related values will be set to NULL. ImportType 6 is for leaf members only.

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.

ErrorCode

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

Code

Required, except when codes are generated automatically for ImportType 1 or 2; see Automatic Code Creation (Master Data Services) for more information

A unique code for the member.

Name

Optional

A name for the member.

NewCode

Use only if you are changing the member code.

<Attribute name>

A column exists for each attribute in the entity. Use this with an ImportType of 0 or 2. 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. For link attributes, the URL must start with http://.

Note

You cannot stage file attributes.

See Also

Tasks

Load or Update Members in Master Data Services by Using the Staging Process

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

Concepts

Importing Data (Master Data Services)

Staging Process Errors (Master Data Services)