Information Steward Custom attributes

[Former Member]

Hi

Is there a link table in the Information Steward repo that has a link between rules and new custom attributes that were added and assigned to the rule?

[adrian_storen]

Yes. Here are the tables:

MMT_CUSTOM_FIELD (or MMB for the current record version) stores all custom attributes

MMT_CUSTOM_FIELD_VALUE (or MMB for the current record version) stores all custom attribute values for each custom attribute

MMT_RELATIONSHIP (or MMB) stores the relationship. Join on MMT_CUSTOM_FIELD_VALUE.table_id to MMT_RELATIONSHIP.table_id and MMT_CUSTOM_FIELD_VALUE.object_id = MMT_RELATIONSHIP.related_object_id.

MMT_DATA_GROUP (or relevant MMB eg MMB_BUSINESS_CATEGORY for categories) stores the target relationship. Join MMT_DATA_GROUP.data_group_id = MMT_RELATIONSHIP.object_id. Use MMT_RELATIONSHIP.related_table_id to find out the related table by looking up MMT_TABLE as it lists the table types (ie what related/table_id means in MMT_RELATIONSHIP)