---
title: "Insurance Coverages Table"
canonical: "https://help.agiloft.com/space/SDA2603/521281540/Insurance+Coverages+Table"
format: markdown
---
The Insurance Coverages table stores Insurance Certificates that are linked to companies, company documents, and contracts. In the out-of-the-box system, insurance coverage information is usually added from a Company, Company Documents, or Contract record, where you can find an embedded table on the Supplier Information, Details, or Attachments tab, respectively.

Although each record in the Insurance Coverages table can be linked to only one Company and Company Document record, it can be linked to multiple Contract records.

# Use Case

We recommend creating Insurance Coverage records from within Company Documents or Contracts records, which are part of the Supplier Portal. New coverage records are typically created as follows:

- From a Company Document record. See [Company Documents Table](https://agiloft-public.atlassian.net/wiki/spaces/SDA2603/pages/521276806) for details.
- From a Contract record, using the Create New Company Document button on the Attachments tab.

Insurance Coverage records are often linked to Supplier Company records in the Companies table. Once an insurance certificate is added to a Supplier record, that certificate can be linked to any other Contract records for that supplier. Creating Insurance Coverage records directly from the Company Document and Contract tables can be advantageous because:

- They can be displayed as a linked file within Insurance Coverage records, which may have separate expiration dates.
- When several coverage records have the same expiration date and are linked to the same Company Document record, the system can send an email to the supplier asking them to upload a new insurance certificate.

New Insurance Coverage records are created with a default Status of Valid and can be set to Replaced, Expired, or Contract Inactive. The Expiration Date and Main Contact are required fields. The Main Contact is the person at the supplier company from whom a replacement certificate can be requested. The options for Type of Coverage in the <span style="color: #333333">out-of-the-box system </span>include:

- Auto
- Employer's Liability
- Excess Liability
- General Liability
- Pollution Liability
- Professional Liability
- Worker's Comp

The out-of-the-box system is set up to show different fields in the record layout based on the selected Type of Coverage. This keeps similar record types in the same table, preventing the need for subtables. Each Type of Coverage value except Worker's Comp adds the Aggregate Amount field, which is used to input the total amount of coverage. Selecting Worker's Comp adds a Meet Statutory Limits field with radio buttons for Yes and No.

# Automation

 In the out-of-the-box system, the Insurance Coverages table contains four rules. To access the rules, you can click the menu icon on the nav bar. Search for<span style="color: #333333"> and select the Insurance Coverages table. Then expand the Insurance Coverages table in the nav bar, select Setup Insurance Coverages, and then select the Rules tab.</span>

- **Create: All Create Actions**: This rule runs whenever a new Insurance Coverage record is created, edited, or deleted by a user or web service. The rule consists of one Linked Record Action, L: Mark Previous Certificate as Replaced, that checks Company records and marks as "Replaced" any matching insurance certificates that have the same certificate type and an earlier expiration date than the new certificate.
- **TB Demo Data Update: Update date fields by one month each month so reports have data**: This time-based rule runs on the first day of each month at 12:00 AM and consists of two actions: U: Update Demo Dates and D: Delete History for TB: Demo Data Update Rule. U: Update Demo Dates increases the Date Created and Expiration Date fields by one month each, and D: Delete history for TB: Demo Data Update deletes history entries that are more than 100 days old.
- **TB: (DISABLED) Update Contracts (daily)**: This time-based rule is disabled by default in the out-of-the-box system. If enabled, the rule runs every two days at 1:00 AM. For valid Insurance Coverage records, an Update Fields Action, U: Set Default Contracts, updates the Contracts linked field with each supplier Contract record that has a Status of Active or greater. Insurance coverages are then automatically displayed within those Contract records.
- **TB: (DISABLED) Handle Insurance Certificate Expiration**: This time-based rule is disabled by default in the out-of-the-box system. If enabled, the rule runs every two days at 1:30 AM. For valid Insurance Coverage records that expire on or before the current day, an If-Then-Else Action, I: Handles Certs Expiring TODAY, updates the Status to Expired for active contracts and emails the Contract Manager to notify them of the expiration. For contracts that are not active, the action sets the Status to Inactive.

> 📝 Before enabling this rule to send notifications if coverage expires, it's a good idea to check whether a similar rule is enabled for the [Company Documents table](https://agiloft-public.atlassian.net/wiki/spaces/SDA2603/pages/521276806). If both tables have notification rules for expired certificates, duplicate emails may be sent for certificates with the same expiration date.

In addition to the rules for the Insurance Coverages table, automation can also be triggered by linked record actions from other tables. For example, a rule for the Companies table that is disabled by default in the out-of-the-box system notifies the insurance certificate owner 14 days before a certificate is due to expire. On the expiration date, the record's Status is updated in one of two ways:

- For associated contracts that are Active, the system sets the certificate's Status to Expired and sends an email to the Contract Managers about the expired certificate.
- For associated contracts are not active, the system sets the certificate's Status to Contract Inactive.

# Ownership

Insurance Coverage records are owned by their creator. Specifically, an Insurance Coverage record is owned by the user whose name in the People table matches the Created By field on the History tab of an Insurance Coverage record. You can check for this data in the History tab.