How do the contract statuses work?
We are running version
| 15.4.11.2 |
If I look in the cconth DB table, the cconth_stat_id doesn't seem to align with the codes I see in the 'Contract Statuses' module.
For example, in the 'Contract Statuses' module, it says that 700 is Expired.
If I look in the database table for all records with cconth_stat_id = '700' it comes back with no rows, yet we have a ton of expired contracts.
The module also says 200 = approved and 300 = active.
Yet a DB query seems to return expired contracts if the cconth_stat_id = 200 & is_active = n.
And if cconth_stat_id = 200 & is_active = y, then the status appears to be active.
Just want to understand how what's in the database relates to the status I see in the contract in the web gui.