McDewey

Remarks: Once headset is associated with one enduser with any device Rule (RFI-731): Type: Inter-field Condition and Constraint Constraint: NOT EXISTS ( select M.fkEndUser from Heads fkEndUser group by M.fkEndUser having cou Remarks: Max 15 record is allowed for headsets associa 2.3.225 headsetinventory (TI-21071) Description: It stores the headset and dock inventory data in the UCM cluster Fields: 2.3.225.1 data (FI-28384) Type: json Remarks: JSON blob to store the Headset Inventory information. 2.3.225.2 defaulttimestamp (FI-28393) Type: long (Not Modifiable) Remarks: Records time headset was first know to the system Rule (RI-2400): Type: Active (Insert) Rule Name: set defaulttimestamp on Insert Description: When a HeadsetInventory record is inserted, value Test Condition: ON INSERT INTO HeadsetInventory: LET curr currentTime (INTO defaultTimestamp); Rule (RI-2400): Type: Active (Insert) This field is modified by this rule. Rule Name: set defaulttimestamp on Insert Description: When a HeadsetInventory record is inserted, value Test Condition: ON INSERT INTO HeadsetInventory: LET curr currentTime (INTO defaultTimestamp); 2.3.225.3 pkid (FI-28382) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.225.4 serialnum (FI-28383) Type: string [132] Default Value: EMPTY Remarks: Serial number of the HeadSet or Dock.