stored procedures & models to handle udpates to monitor records