This table holds insurance coverages linked to Companies, Company Documents, and Contracts. Each record in the table represents one insurance coverage type linked to a unique vendor company and vendor Company Document, but may be linked to one or more contracts.

Use Case

Although Insurance coverages can be used as a separate table, we recommend that they be used in conjunction with the Company Documents table, which is part of the Vendor Portal.  Whether or not it is the vendor who uploads the insurance certificate, this gives several advantages. 

New coverages will typically be created as follows:

New Insurance Coverages are created with a default Status of Valid. They may also have a Status of Expired or Contract Inactive. The Expiration Date and Main Contact are required fields. The Main Contact is the person at the vendor company from whom a replacement certificate can be requested. You can customize the Type of Coverage choice list as needed; the default options include Auto, Worker's Comp, Excess Liability, General Liability, etc.

Insurance coverages are typically created from a company document. If an insurance certificate was created in a company document, the Company Document section will show information about that record.

Insurance coverages are linked to vendor companies in the Company table. Once you add an insurance coverage to a vendor record, it can be linked to any contracts with that vendor.

Insurance coverage records contain information about related contracts for reference, held in the Contracts field. A time based rule, disabled by default, is designed to update the Contracts linked field with all contracts for that vendor that are currently pending or active. As a result, insurance coverages are automatically displayed within those contracts.

An Insurance Certificate Owner is defined in the company record just above the Insurance Coverages related table. The Insurance Certificate Owner is notified fourteen days before one or more certificates is due to expire.

When the Expiration Date arrives, the record's Status is updated in one of two ways:


Insurance Certificate records are owned by their creator. Specifically, an Insurance Certificate record is owned by the user whose Login matches the Creator Login field.


The Insurance Certificates table contains a rule that can be turned on to send notifications if a coverage expires.  But you may want to use rules on the Company Documents table instead, as they avoid sending duplicate emails for multiple certificates with the same expiration date.