McDewey

Type: Validation (Insert/Update) Rule Name: PreferredMediaSource can only be Phone if Description: When line appearance has PreferredMediaS fully support recording Test Condition: On INSERT / UPDATE on DEVICENUMPLANM PREFERRED_MEDIA_SOURCE_PHONE THEN productsupportsfeature where tksupportsfe param in (empty or full) AND d.tkdevicepro Error Message: Device type does not support recording from Remedy: Set preferred media source to gateway. Rule (RI-2418): Type: Active (Insert/Update) Rule Name: CTI remote device, Spark Remote Device and it Description: Adding more than 5 DN's for CTIRD,SparkRD Test Condition: ON INSERT or UPDATE IF (Number of DN's a 2.3.107.10 fknumplan (FI-316) Type: guid (Cascade Delete, Null OK) Migration Source: convert from NumPlan.DirectoryNumber Rule (RI-85): Type: Active (Delete) Rule Name: Set unassociated DN IsCallable to False Description: When the last association between a DN and field for the DN's NumPlan record to false. Test Condition: ON DELETE from DeviceNumPlanMap IF (SE WHERE (fkNumPlan = @NumPlan.pkid) = 0) Rule (RI-86): Type: Validation (Insert/Update) Rule Name: Associate DNs with Devices Description: A Directory Number (NumPlan.tkPatternUsa (including Device Profiles), CTI Route Points 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: ?