Here is the design document: https://docs.google.com/document/d/1IPpQ7j9sX9K7Hkj7EYkgKQB3kEKGRMsuKw5pdFwVEGk/edit#

Thanks jbanerje@redhat.com 

We will implement it with a simple logic:

if the compliance status is changed in the past day, then we treat the policy compliance status is non-compliant. (note: skip the first time changing from non-compliant to compliant).

more specific implementation is the compliance column value in local_status.compliance_history is based on compliance_changed_frequency.

if compliance_changed_frequency is greater than 0, it is non-compliant.

if compliance_changed_frequency is equal to 0, it is compliant.

We need to set the correct value for compliance_changed_frequency based on the policy events.