McDewey

Errors occurring because of validation or check constraints defined in TypeFieldInfo will have a number that is equal to 35,000 plus the field number. For example, if an error 37131 occurs while updating FACInfo table, you can find the associated rule with 37131-35000 = (FI-)2131. Then check the format of input data against the validation for the "FACInfo.Code" field (or just search this document for "FI-2131"). Legend for Tables Elements defining a table Field Name (with links to referenced tables) Elements defining a field Elements defining a rule Multi-column uniqueness (combination of columns is unique) 2.3.1 aardialprefixmatrix (TI-182) Description: Defines the assigned digits to prepend to dialed digits to specified from and to Fields: 2.3.1.1 dialprefix (FI-1117) Type: string [24] Default Value: EMPTY Validation: ^[0-9A-D*#+]{0,24}$ Remarks: The prefix digits to use for automated alternate routing with 2.3.1.2 fkaarneighborhood_from (FI-1115) Type: guid (Cascade Delete, Not Modifiable) Remarks: Specifies the AAR Neighborhood from which a call is being m 2.3.1.3 fkaarneighborhood_to (FI-1116) Type: guid (Cascade Delete, Not Modifiable) Remarks: Specifies the AAR Neighborhood to which a call is being mad 2.3.1.4 pkid (FI-1114) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: fkaarneighborhood_from + fkaarneighborhood_to is unique. (MFI-55) Rules: Rule (RI-1): Type: Active (Insert) This table is modified by this rule. Rule Name: Insert AAR Matrix Description: On insert of a new AARNeighborhood the ma AARNeighborhood to itself and to every exist Insert into AARNeighborhood •