McDewey

Remarks: Refers to the Logical Partition Policy Uniqueness: fkgeolocationpolicy_a + tkgeolocationdevice_a + fkgeolocationpolicy_b + tkgeolo 2.3.215 globalsetting (TI-589) Description: Definition records for use by various applications as persistent global settings. a default setting or where referential or control rules are needed. Insert/Delete is not allowed. Fields: 2.3.215.1 pkid (FI-6123) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: GUID based surrogate primary key for unique application re record 2.3.215.2 settingvalue (FI-6125) Type: string [255] (Null OK) Remarks: Contains the actual Setting Value for the Global Setting as def key in this record Rule (RI-789): Type: Validation (Update) Rule Name: GlobalSetting Update Restriction Description: GlobalSetting.SettingValue can either be NUL Test Condition: ON UPDATE GlobalSetting IF (tkGlobalSetting (SettingValue = NumPlan.pkid WHERE Nump Error Message: The Global Setting "Default Enterprise Featur EFA DN (numplan.tkpatternusage = 17) 2.3.215.3 tkglobalsetting (FI-6124) Type: enum (Unique, Indexed, Not Modifiable) Remarks: Foreign key indentifying the associated type definition which with this setting Rule (RI-789): Type: Validation (Update) Rule Name: GlobalSetting Update Restriction Description: GlobalSetting.SettingValue can either be NUL Test Condition: ON UPDATE GlobalSetting IF (tkGlobalSetting (SettingValue = NumPlan.pkid WHERE Nump Error Message: The Global Setting "Default Enterprise Featur EFA DN (numplan.tkpatternusage = 17) Uniqueness: No multicolumn uniqueness constraints