app.insurance_certificate_checks
Vista
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.
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| certificate_id | uuid | Sí | Certificate. |
| org_id | uuid | Sí | Org. |
| vendor_id | uuid | Sí | Vendor. |
| insured_count | integer | Sí | Parties the certificate names. |
| required_count | integer | Sí | Org-wide required insureds. |
| missing_count | integer | Sí | Org-wide required insureds the certificate does not name. |
| is_current | boolean | Sí | True when valid today. |
| insureds_verified | boolean | Sí | True when the certificate names every org-wide required insured. |