app.engagement_insured_checks
View
For each engagement of a vendor and each additional insured the org requires on its project (org-wide or project), the current certificate that names the party with the endorsement. named_on_certificate_id is NULL when no current certificate does.
| Column | Type | Nullable | Description |
|---|---|---|---|
| engagement_id | uuid | Yes | Vendor engagement. |
| org_id | uuid | Yes | Org. |
| project_id | uuid | Yes | Project of the engagement. |
| vendor_id | uuid | Yes | Vendor facet of the engaged counterparty. |
| required_insured_id | uuid | Yes | Requirement. |
| insured_name | text | Yes | Party that must be named. |
| endorsement_kind | app.endorsement_kind | Yes | Endorsement required. |
| project_specific | boolean | Yes | True when the requirement is for this project only. |
| named_on_certificate_id | uuid | Yes | Current certificate naming the party; NULL when missing. |