The ProcessModel sheet provides the rules to drive subsetting. The ProcessModel and RuleList sheets are populated during a Basic or Advanced Subset by the BUILDMODEL action.
You can switch the Subset Rules on or off from the ProcessModel sheet. Each rule is displayed by row, with additional information available for reference in the RuleList sheet. Simply set Active to "Yes" or "No" to filter rules.
The columns for each row are:
ParentTable: The Parent Table name
ChildTable: The Child Table name
ParentColumn: The Parent Key Columns
ChildColumn: The Child Key Columns
Active: Set to "Yes" or "No" to include a Rule or not.
ParentSchema: The Source Parent Schema name
ChildSchema: The Source Child Schema name
FKName: The Foreign Key name
Direction: "DOWN" or "UP" indicates the relationship between ParentTable and ChildTable
Level: The level in the hierarchical table relationships of the rule.
An example ProcessModel sheet appears as follows: