How to define a Subtype Definition

Before defining a Subtype Definition for a subtype set, consider whether the exclusivity rule or the totality rule (or both) apply to the subtype set. If neither apply, defining the Subtype Definition serves no practical purpose.

To define a Subtype Definition:

1.	Choose Define, Subtype Groups, Definitions from the USoft Definer menu.

2.	Enter a Definition name, for example, BRANCH_LOCATION.

3.	Enter the name of the supertype.

To get USoft to enforce the exclusivity rule for the subtype set, set Exclusivef to either 'Immediate' or 'Deferred'. If you choose 'Deferred', the application will not enforce the rule until the user commits. The advantage is that you avoid early error messages. The disadvantage is that the user is not informed about the rule until commit.

To get USoft to enforce the totality rule for the subtype set, set Total to either 'Immediate' or 'Deferred'. If you choose 'Deferred', the application will not enforce the rule until the user commits. The advantage is that you avoid early error messages. The disadvantage is that the user is not informed about the rule until commit.

6.	In the Elements box, type a list of all the subtypes in the set.

7.	If the exclusivity rule applies (you have set Exclusive to 'Immediate' or 'Deferred'), then for each of the listed subtypes, consider if you want USoft to de-select other subtypes if a subtype is selected. If you do, check the "Automatic Change" box.

Example

You have a BRANCH Subtype Definition with subtypes OWNED_BRANCH and LEASED_BRANCH. You set the exclusivity rule for this subtype set. This means that a branch cannot be at the same time an OWNED_BRANCH and a LEASED_BRANCH. You set "Automatic Change" for OWNED_BRANCH. This means that for an owned branch, if the user sets the BRANCH to LEASED_BRANCH by setting LEASED_BRANCH = 'Y' in the BRANCH record, USoft will automatically set OWNED_BRANCH = 'N' and will also attempt to drop the OWNED_BRANCH record, thereby dropping data in OWNED_BRANCH subtype columns. This automated behavior applies only when the end user updates the BRANCH record. It does not apply if the end user expresses that the branch is an owned branch by inserting a new OWNED_BRANCH record.

For each of the listed subtypes for which you have checked the Automatic Change box, consider if you want to check the Confirm box. If you do, the user is warned of the behavior and asked to confirm the switch to the other subtype. If you do not, the Automatic Change behavior described in Step 7 is performed silently.