cmn_notif_device table questions

[Eileen Hessmill]

One of our executives was not receiving approval notifications. I found information in the community about the cmn_notif_device table, and sure enough, the Type field in his entry was set to an invalid value. I could not determine how that may have happened since the table is not audited. 

I also noticed that when the email address on the user record is updated, the email address field on the cmn_notif_device is automatically updated and vice versa via a business rule. When a user is set to inactive, cmn_notif_device.active field is not updated to inactive. 

What is the cmn_notif_device table used for? 

Should the cmn_notif_device.active field auto update when the user record is updated?

Should this table be audited? How else could I determine how it was updated to prevent future issues? 

Thank you!

[Hardik Vyas2 · Accepted solution]

This table is basically used to store user devices and there dresses ..

Eg.  a use has an email device and a pager device and an sms device so for a specific user this table stores values for all the three devices  

This table is primary used for users subscriptions .

Mark as helpful id this helps.

Thanks