> ## Documentation Index
> Fetch the complete documentation index at: https://docs.canary.effectiveai.app/llms.txt
> Use this file to discover all available pages before exploring further.

# General liability book schema

> Every table, key and core column of a general liability book.

*Generated from the general liability book schema. `gl.SCHEMA.to_pandas()` returns the core columns as a DataFrame.*

## `policies`

Key: `policy_id`. Optional table.

Each column is yours.

## `submissions`

Key: `submission_id`. Required table.

| Column | Type | Unit | Values | Required | Meaning |
| - | - | - | - | - | - |
| `policy_id` | id | | | Yes | The policy the submission prices. |
| `effective_date` | date | | | Yes | The date the rated term starts. |
| `term_months` | int | months | | | The length of the rated term. |

## `locations`

Key: `submission_id`, `location_id`. Required table.

| Column | Type | Unit | Values | Required | Meaning |
| - | - | - | - | - | - |
| `postal_code` | text | | | | The postal code of the location. |
| `county` | text | | | | The county the location is in, such as Travis. |
| `state` | text | | | | The two-letter postal abbreviation of the location's state. |
| `floor_area` | number | sq ft | | | The floor area the insured occupies at the location. |
| `liquor_sales` | number | USD | | | The insured's sales of alcoholic beverages at the location for a year. |

## `classifications`

Key: `submission_id`, `location_id`, `class_id`. Optional table.

| Column | Type | Unit | Values | Required | Meaning |
| - | - | - | - | - | - |
| `iso_gl_code` | text | | | | The operation's class code in the ISO commercial general liability plan, such as 16901. |
| `iso_bop_code` | text | | | | The operation's class code in the ISO businessowners plan, such as 09421. |
| `iso_cp_code` | text | | | | The operation's class code in the ISO commercial property plan, such as 0542. |
| `naics_code` | text | | | | The operation's class code in the NAICS plan, such as 722511. |
| `sic_code` | text | | | | The operation's class code in the SIC plan, such as 5812. |
| `annual_sales` | number | USD | | | The operation's gross sales for a year, including its liquor sales. |
| `annual_payroll` | number | USD | | | The operation's payroll for a year. |

## `coverages`

Key: `submission_id`, `coverage_id`. Optional table.

`coverage_id` is one of `premises_operations`, `products_completed_operations`, `personal_advertising_injury`, `medical_payments`, `damage_to_rented_premises`, `liquor_liability`, `hired_non_owned_auto`, `employee_benefits_liability`, `unmanned_aircraft`, `terrorism`.

| Column | Type | Unit | Values | Required | Meaning |
| - | - | - | - | - | - |
| `limit` | number | USD | | | The limit for each occurrence or claim. |
| `aggregate_limit` | number | USD | | | The most the coverage pays in the policy term. |
| `deductible` | number | USD | | | The coverage's deductible. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.