McDewey

Test Condition: ? Rule (RI-87): Type: Validation (Insert/Update) Rule Name: Associate Route Pattern with Devices Description: A Route Pattern (NumPlan.tkPatternUsage = Trunk, Hunt List or Route List. Test Condition: ? Rule (RI-89): Type: Validation (Insert/Update) Rule Name: Route Group Member Exclusion Description: A Route Group cannot contain a device that nor devices that are already members of a R Test Condition: ? Rule (RI-90): Type: Validation (Insert/Update) Rule Name: Gateway Port in Route Group Description: If an individual port on a gateway is assigne assigned to a Route Group, nor can it be asso individual ports can be assigned to the same Test Condition: ? Rule (RI-229): Type: Validation (Insert/Update) Rule Name: ValidateDevNumPlanIndex Description: A device (phone) cannot have the same line Test Condition: ON INSERT/UPDATE INTO DeviceNumPlanM DeviceNumPlanMap WHERE (fkDevice = ne new_NumPlanIndex) AND (fkPartitionUsage exception; Error Message: Duplicate phone line. Remedy: ? 2.3.107.17 pkid (FI-280) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: generated, new table gets all records in NumPlan Remarks: Unique ID to identify a record. Rule (RI-94): Type: Validation (Insert/Update) Rule Name: Maximum MaxCalls Per Device/Line