McDewey

Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints Rules: Rule (RI-201): Type: Validation (Update/Delete) Rule applied when record is inserted or upda Rule Name: Standard CCM Super Users Group Restriction Description: The CCM Super Users Group must contain at locking primary administrator out of the syst Test Condition: ON DELETE FROM ApplicationUserDirGroup (SELECT COUNT() FROM ApplicationUserDir UPDATE ApplicationUserDirGroupMap IF (Di <> new_fkDirGroup) THEN throw exception Error Message: CCM Super User Group must contain at least Remedy: Add another Application User to be the CCM 2.3.147 dmmsdevice (TI-416) Description: Cellular Subscriber data not in Device Table Fields: 2.3.147.1 cnumber (FI-3144) Type: dn (Null OK) DN Type: DN_TYPE_ALL_DIGITS Default Value: NULL Validation: ^[0-9#+]{0,50}$ Remarks: Subscriber cellular number 2.3.147.2 disableappdialrules (FI-3142) Type: bool Default Value: FALSE 2.3.147.3 enablefollowme (FI-3145) Type: bool Default Value: TRUE 2.3.147.4 fkdevice (FI-3141) Type: guid (Unique, Indexed, Cascade Delete) 2.3.147.5 fkdevice_wsm (FI-3143) Type: guid (Indexed, Cascade Delete) 2.3.147.6 pkid (FI-3140) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid()