app.insurance_certificate_checks
View
Per certificate: how many parties it names, how many the org requires org-wide, and how many of those it misses. insureds_verified is missing_count = 0; project requirements are checked per engagement in app.engagement_insured_checks.
| Column | Type | Nullable | Description |
|---|---|---|---|
| certificate_id | uuid | Yes | Certificate. |
| org_id | uuid | Yes | Org. |
| vendor_id | uuid | Yes | Vendor. |
| insured_count | integer | Yes | Parties the certificate names. |
| required_count | integer | Yes | Org-wide required insureds. |
| missing_count | integer | Yes | Org-wide required insureds the certificate does not name. |
| is_current | boolean | Yes | True when valid today. |
| insureds_verified | boolean | Yes | True when the certificate names every org-wide required insured. |