McDewey

Rule Name: Update the DateTimeStamp for Dynamic rec Description: When a record in a Dynamic table is update value Test Condition: ON INSERT/UPDATE INTO *Dynamic: LET cu currentTime (INTO DateTimeStamp); 2.3.42.4 fkcallingsearchspace_cfa (FI-637) Type: guid (Null OK) Default Value: NULL Remarks: Call Forward All 2.3.42.5 fkcallingsearchspace_scfa (FI-2765) Type: guid (Null OK) Default Value: NULL Migration Source: from CSSforCFA Clause Remarks: Secondary Call Forward All 2.3.42.6 fknumplan (FI-3298) Type: guid (Unique, Cascade Delete) Rule (RI-837): Type: Active (Insert/Update) Rule Name: Store Most Recent Call Foward History Reco Description: For each NumPlan DN maintain a history of specified. Test Condition: On Insert or Update of CallFoward Destinati 2.3.42.7 pkid (FI-3297) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints 2.3.43 callforwardhistorydynamic (TI-595) Description: To store the last 5 Call Forward destination DN updates done on a line Insert/Delete is not allowed. Fields: 2.3.43.1 datetimestamp (FI-6129) Type: long Remarks: Uniform Integer representation of the most recent time that forward destination for the associated line 2.3.43.2 dnorpattern (FI-6128) Type: dn (Not Modifiable)