McDewey

Type: guid (Indexed, Cascade Delete) Migration Source: convert from CallManagerGroupList.CallManagerGroupID Rule (RI-12): Type: Validation (Insert/Update) Rule Name: CallManager Group limited to 3 CallManage Description: The can be no more than three (3) Cisco Call Test Condition: SELECT Count(*) FROM CallManagerGroupM @CallManagerGroup.pkid > 3 Error Message: A Cisco CallManager Group may not contain 2.3.48.3 pkid (FI-171) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Migration Source: Generated Remarks: Unique ID to identify a record. Rule (RI-269): Type: Active (Insert/Update/Delete records) Rule Name: callmanagergroupmember versionstamp Description: on change to anything in callmanagergroup Test Condition: update callmanager group member 2.3.48.4 priority (FI-174) Type: long Check Constraint: Priority >= 0 Migration Source: CallManagerGroupList.Priority Remarks: CallManager Groups are made up of an ordered list of from members of the group. There is no requirment for a membe requirment that the priorities be sequential within a CallMa Uniqueness: fkcallmanagergroup + fkcallmanager is unique. (MFI-2) fkcallmanagergroup + priority is unique. (MFI-3) 2.3.49 callpark (TI-2843) Description: Table for storing CTI ID for ParkDNs Records may be modified only by installation and/or DB triggers. Fields: 2.3.49.1 ctiid (FI-26768) Type: identity (Unique, Not Modifiable) Check Constraint: (ctiid >= 0) AND (ctiid <= 4194304) Migration Source: No more CTI ID values available for Call Park. Limit of 4,194 IDs are reset during upgrade.