Which table to be used for CI status updates

Dear All,

I have one ask from client, I am wondering which table I should be creating this BR on: cmdb_ci or cmdb_ci_hardware.

Rule needed for the following:

If the Status(install_status) = Absent, Retired or In Stock then the Operational Status should = Non-operational

If the Status(install_status) = Installed then the Operational Status should = Operational

The Operational Status supports the CMDB Health Score Card and CSDM metrics.

Also, I will need to run fix script to run for updating all the records as per above situation, so need suggestion on which table this values should be updated as a best/standard  practice.

Help is appreciated.

Regards,

Hanumant