# Data Lake Table Reference



This page is the complete field-level reference for every table in the Socotra [Data Lake](/features/reporting/datalake).

<Callout>
  The order of fields shown in this reference is for informational purposes only
  and may differ from the order in the underlying [Data Lake
  Database](/features/reporting/datalake) schema or [Delta
  Files](/features/reporting/delta-files). The exact schema may also vary
  between the two. To view the authoritative schema, connect directly to the
  Data Lake Database using your provided credentials or download the
  `createTableFile` provided by the{' '}
  <ApiLink name="DeltaFilesGetResponse">Delta Files API</ApiLink>.
</Callout>

Contents [#contents]

* [Schema Conventions](#schema-conventions)
* [Attribute Labels](#attribute-labels)
* [Policy Tables](#policy-tables)
* [Billing Tables](#billing-tables)
* [Claims Tables](#claims-tables)
* [Producer Management Tables](#producer-management-tables)
* [Work Management Tables](#work-management-tables)
* [Auxiliary Data Tables](#auxiliary-data-tables)
* [Moratoriums Tables](#moratoriums-tables)

Schema Conventions [#schema-conventions]

The Data Lake adheres to these schema conventions:

* **Locators**: Locators are unique identifiers in the Socotra platform; most tables have a `locator` column that represents the unique identifier for each record. They are stored in `ULID` format.
* **Tenant Locators**: All tables have a `tenant_locator` column referencing the record's corresponding tenant. They are stored in `UUID` format.
* **User Locators**: User locators are persisted as either a `user_locator` or for certain user actions using the `_by` format (e.g. `created_by`, `updated_by`, `completed_by`). They are stored in `UUID` format.
* **Primary Keys**: All tables have a composite primary key, each containing a `tenant_locator` and either a `locator` or other column(s).
* **Foreign Keys**: No tables have explicit foreign keys established, but many foreign relationships exist. Fields named `_locator` are typically implicit foreign keys, with the prefix indicating the referenced entity (e.g. `account_locator` -> `accounts.locator`).
* **Polymorphic Relationships**: Some table relationships follow a polymorphic pattern, with a discriminator `_type` column paired with a `_locator` column where the target table depends on the type value (e.g. `reference_type` = `policy` -> `reference_locator` = `policies.locator`).
* **Indexes**: Primary keys and the `datalake_updated_timestamp` are indexed on all tables, with minimal indexes beyond that.
* **Timestamps**: All timestamps are in Coordinated Universal Time (UTC) unless otherwise indicated.
* **Data Lake Timestamps**: The `datalake_created_timestamp` and `datalake_updated_timestamp` are on all tables. These reflect when the record was written or updated in the Data Lake, rather than when the business event occurred. Use domain-specific timestamps (e.g. `created_time_utc`, `updated_time_utc`) for understanding business or operational events.
* **Monetary Amounts**: Monetary amounts are typically stored as `decimal(19,3)` and are in the currency indicated by the `currency` column on that record or parent entity.
* **Soft Deletion**: Records are never hard-deleted. Any tables with records subject to deletion in the platform have a `deleted` property that provides a soft indication of whether or not the record has been deleted. A value of `1` (`true`) indicates that the record has been deleted.
* **Data Extensions**: All tables ending in `_data_extensions` reflect configuration-defined fields and their values, persisted as key-value pairs of `field_name` / `field_value`.
* **Possible Values**: The list of possible values enumerated for system properties listed reflects the latest set of values as defined by the platform; as such, it may not reflect all possible values that existed historically. Columns marked with `defined in configuration` indicate that the list of possible values may be dependent on the tenant configuration, which is also subject to change over redeployments.

Attribute Labels [#attribute-labels]

The following labels are provided in the **Attributes** column for applicable table columns in the reference:

* `PK`: Column is part of the table's primary key.
* `Index`: Column is indexed.
* `Relationship`: Column has a known connection to another table, documented in the **Relationships** section below each table; relationships are not enforced as database foreign keys. Cardinality is provided for each relationship — `many-to-one`/`one-to-one` means a safe single-row lookup, `one-to-many`/`many-to-many` means the join can return multiple rows. Some relationship columns depend on a companion `Discriminator` column to know which table they resolve to.
* `Discriminator`: Column determines how another column's `Relationship` value should be interpreted.

Policy Tables [#policy-tables]

* [accounts](#accounts)
* [account\_data\_extensions](#account_data_extensions)
* [quotes](#quotes)
* [quote\_elements](#quote_elements)
* [quote\_element\_tree](#quote_element_tree)
* [quote\_element\_charges](#quote_element_charges)
* [quote\_coverage\_terms](#quote_coverage_terms)
* [quote\_element\_underwriting\_flags](#quote_element_underwriting_flags)
* [quote\_data\_extensions](#quote_data_extensions)
* [quote\_preferences](#quote_preferences)
* [policies](#policies)
* [terms](#terms)
* [transactions](#transactions)
* [transaction\_data\_extensions](#transaction_data_extensions)
* [affected\_transactions](#affected_transactions)
* [segments](#segments)
* [policy\_segment\_elements](#policy_segment_elements)
* [policy\_element\_tree](#policy_element_tree)
* [policy\_element\_charges](#policy_element_charges)
* [policy\_coverage\_terms](#policy_coverage_terms)
* [policy\_element\_underwriting\_flags](#policy_element_underwriting_flags)
* [policy\_data\_extensions](#policy_data_extensions)
* [policy\_auto\_renewals](#policy_auto_renewals)
* [policy\_transaction\_change\_instructions](#policy_transaction_change_instructions)
* [policy\_preferences](#policy_preferences)
* [policy\_status](#policy_status)

<span id="accounts" />

accounts [#accounts]

**API Reference:** [Accounts API](/api/accounts)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                     | Type           | Nullable | Attributes | Description                                                                                                     | Possible Values                   |
| ------------------------------- | -------------- | -------- | ---------- | --------------------------------------------------------------------------------------------------------------- | --------------------------------- |
| `tenant_locator`                | `char(36)`     | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                                                          |                                   |
| `locator`                       | `char(26)`     | **no**   | `PK`       | Unique identifier of the account (ULID)                                                                         |                                   |
| `account_state`                 | `varchar(32)`  | **no**   |            | Current [state of the account ](/features/accounts#account-states)                                              | `draft`, `validated`, `discarded` |
| `billing_level`                 | `varchar(50)`  | **no**   |            | Level at which billing within the account takes place. Value may be `policy` or `account`                       | `account`, `inherit`, `policy`    |
| `type`                          | `varchar(128)` | **no**   |            | The [account type ](/features/accounts#accounts) per the tenant configuration                                   | *defined in configuration*        |
| `region`                        | `varchar(128)` | yes      |            | The region assigned to the account (if any)                                                                     |                                   |
| `auto_renewal_plan_name`        | `varchar(128)` | yes      |            | Name of the account's [auto-renewal plan ](/features/policy-management/renewal-management#autorenewal) (if any) | *defined in configuration*        |
| `delinquency_plan_name`         | `varchar(128)` | yes      |            | Name of the account's [delinquency plan ](/features/billing/delinquency#configuration) (if any)                 | *defined in configuration*        |
| `excess_credit_plan_name`       | `varchar(128)` | yes      |            | Name of the account's [excess credit plan ](/features/billing/excess-credits#configuration) (if any)            | *defined in configuration*        |
| `shortfall_tolerance_plan_name` | `varchar(128)` | yes      |            | Name of the account's shortfall tolerance plan (if any)                                                         | *defined in configuration*        |
| `account_number`                | `varchar(128)` | yes      |            | The [custom number](/configuration/general-topics/entity-numbering) assigned to the account (if any)            |                                   |
| `datalake_created_timestamp`    | `datetime(6)`  | **no**   |            | Time in UTC the record was created                                                                              |                                   |
| `datalake_updated_timestamp`    | `datetime(6)`  | **no**   | `Index`    | Time in UTC the record was last updated                                                                         |                                   |

***

<span id="account_data_extensions" />

account_data_extensions [#account_data_extensions]

**API Reference:** [Accounts API](/api/accounts)

**Primary Key:** `tenant_locator`, `account_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                        | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | -------------------------------------------------------------------------------------------------- | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                             |                            |
| `account_locator`            | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the [account the data ](/features/accounts#extension-data) is associated with (UULD) |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                                   |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the extension data field                                                           | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                                             | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                                      |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                 |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                            |                            |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="quotes" />

quotes [#quotes]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type             | Nullable | Attributes     | Description                                                                                                   | Possible Values                                                                                                                                                  |
| ---------------------------- | ---------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`       | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                        |                                                                                                                                                                  |
| `locator`                    | `char(26)`       | **no**   | `PK`           | Unique identifier of the [quote ](/features/policy-quotation/quotes) (UULD)                                   |                                                                                                                                                                  |
| `account_locator`            | `char(26)`       | **no**   | `Relationship` | Unique identifier of the quote's parent account (UULD)                                                        |                                                                                                                                                                  |
| `group_locator`              | `char(26)`       | yes      |                | Unique identifier of the group the quote belongs to, if any (UULD)                                            |                                                                                                                                                                  |
| `product_name`               | `varchar(128)`   | **no**   |                | The name of the configured <ApiLink name="ProductRef">product</ApiLink> the quote is based on                 |                                                                                                                                                                  |
| `quote_state`                | `varchar(50)`    | **no**   |                | The [state ](/features/policy-quotation/quotes#quotes) in which the quote currently resides                   | `draft`, `validated`, `earlyUnderwritten`, `priced`, `underwritten`, `accepted`, `issued`, `underwrittenBlocked`, `declined`, `rejected`, `refused`, `discarded` |
| `billing_level`              | `varchar(50)`    | **no**   |                | Level at which billing within the account takes place `policy` or `account`                                   | `account`, `inherit`, `policy`                                                                                                                                   |
| `policy_locator`             | `char(26)`       | yes      | `Relationship` | The identifier of the resultant policy (if quote has been issued)                                             |                                                                                                                                                                  |
| `quick_quote_locator`        | `char(26)`       | yes      |                | The identifier of the originating [quick quote ](/features/policy-quotation/quick-quotes) (if any)            |                                                                                                                                                                  |
| `region`                     | `varchar(128)`   | yes      |                | The region assigned to the <ApiLink name="QuoteCreateRequest">quote</ApiLink> (if any)                        |                                                                                                                                                                  |
| `jurisdiction`               | `varchar(128)`   | yes      |                | The jurisdiction assigned to the <ApiLink name="QuoteCreateRequest">quote</ApiLink> (if any)                  |                                                                                                                                                                  |
| `producer_code`              | `varchar(128)`   | yes      |                | The producer code assigned to the <ApiLink name="QuoteCreateRequest">quote</ApiLink> (if any)                 |                                                                                                                                                                  |
| `auto_renewal_plan_name`     | `varchar(128)`   | yes      |                | Name of the quote's [auto-renewal plan ](/features/policy-management/renewal-management#autorenewal) (if any) | *defined in configuration*                                                                                                                                       |
| `delinquency_plan_name`      | `varchar(128)`   | yes      |                | Name of the quote's [delinquency plan ](/features/billing/delinquency#configuration) (if any)                 | *defined in configuration*                                                                                                                                       |
| `issued_time_utc`            | `datetime(6)`    | yes      |                | Timestamp the quote was issued                                                                                |                                                                                                                                                                  |
| `start_time_utc`             | `datetime(6)`    | yes      |                | Timestamp quote is effective as of                                                                            |                                                                                                                                                                  |
| `end_time_utc`               | `datetime(6)`    | yes      |                | Timestamp quote coverage ends                                                                                 |                                                                                                                                                                  |
| `accepted_time_utc`          | `datetime(6)`    | yes      |                | Timestamp the quote was moved to the accepted state                                                           |                                                                                                                                                                  |
| `created_at_utc`             | `datetime(6)`    | **no**   |                | Timestamp the quote was created                                                                               |                                                                                                                                                                  |
| `created_by`                 | `char(36)`       | **no**   |                | The identifier of the user that created the quote                                                             |                                                                                                                                                                  |
| `currency`                   | `varchar(128)`   | yes      |                | Currency the quote was written in                                                                             |                                                                                                                                                                  |
| `duration`                   | `decimal(19,15)` | yes      |                | The number of units of [duration\_basis ](/features/financials/durations) the quote spans                     |                                                                                                                                                                  |
| `duration_basis`             | `varchar(32)`    | yes      |                | The units of time that the [duration ](/features/financials/durations) of the quote is expressed in           | `years`, `months`, `weeks`, `days`, `hours`                                                                                                                      |
| `timezone`                   | `varchar(128)`   | yes      |                | The timezone the quote was written in                                                                         |                                                                                                                                                                  |
| `expiration_time_utc`        | `datetime(6)`    | yes      |                | The timestamp after which the quote can no longer be accepted or issued                                       |                                                                                                                                                                  |
| `underwriting_status`        | `varchar(50)`    | yes      |                | The outcome of the [underwriting process ](/features/underwriting) (if completed)                             |                                                                                                                                                                  |
| `quote_number`               | `varchar(128)`   | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the quote (if any)            |                                                                                                                                                                  |
| `invoice_fee_amount`         | `decimal(19,3)`  | yes      |                | Amount of the quote's invoice fee (if any)                                                                    |                                                                                                                                                                  |
| `anonymized_time_utc`        | `datetime(6)`    | yes      |                | Time in UTC the quote was anonymized                                                                          |                                                                                                                                                                  |
| `datalake_created_timestamp` | `datetime(6)`    | **no**   |                | Time in UTC the record was created                                                                            |                                                                                                                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`    | **no**   | `Index`        | Time in UTC the record was last updated                                                                       |                                                                                                                                                                  |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)

***

<span id="quote_elements" />

quote_elements [#quote_elements]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes     | Description                                                                                                              | Possible Values                                                  |
| ---------------------------- | -------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                                   |                                                                  |
| `locator`                    | `char(26)`     | **no**   | `PK`           | Unique identifier of the quote [element ](/getting-started/create-a-tenant-configuration-file#what-is-an-element) (ULID) |                                                                  |
| `quote_locator`              | `char(26)`     | **no**   | `Relationship` | Identifier of the quote the element is associated with (ULID)                                                            |                                                                  |
| `parent_locator`             | `char(26)`     | yes      | `Relationship` | Identifier of the parent element immediately above in the quotes data hierarchy                                          |                                                                  |
| `category`                   | `varchar(128)` | yes      |                | The [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on            | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `type`                       | `varchar(128)` | **no**   |                | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on          | *defined in configuration*                                       |
| `deleted`                    | `tinyint(1)`   | yes      |                | Indicates whether the record has been deleted                                                                            |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                                                       |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                                                  |                                                                  |

**Relationships:**

* `quote_locator` → `quotes.locator` (`many-to-one`)
* `parent_locator` → `quote_elements.locator` (`many-to-one`)

***

<span id="quote_element_tree" />

quote_element_tree [#quote_element_tree]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `quote_locator`, `parent_locator`, `child_locator`

| Column Name                  | Type          | Nullable | Attributes           | Description                                                                      | Possible Values |
| ---------------------------- | ------------- | -------- | -------------------- | -------------------------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                           |                 |
| `quote_locator`              | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the quote the element is associated with (ULID)                    |                 |
| `parent_locator`             | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the element immediately above in the quote's data hierarchy (ULID) |                 |
| `child_locator`              | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of an element immediately below in the quote's data hierarchy (ULID)  |                 |
| `depth`                      | `int(11)`     | **no**   |                      | The number of levels of child elements below in the quote's data hierarchy       |                 |
| `deleted`                    | `tinyint(1)`  | yes      |                      | Indicates whether the record has been deleted                                    |                 |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                      | Time in UTC the record was created                                               |                 |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`              | Time in UTC the record was last updated                                          |                 |

**Relationships:**

* `quote_locator` → `quotes.locator` (`many-to-one`)
* `parent_locator` → `quote_elements.locator` (`many-to-one`)
* `child_locator` → `quote_elements.locator` (`many-to-one`)

***

<span id="quote_element_charges" />

quote_element_charges [#quote_element_charges]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type             | Nullable | Attributes              | Description                                                                                                                                             | Possible Values                                                                                      |
| ---------------------------- | ---------------- | -------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`       | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                                                                                                  |                                                                                                      |
| `locator`                    | `char(26)`       | **no**   | `PK`                    | Unique identifier of the quote charge (ULID)                                                                                                            |                                                                                                      |
| `account_locator`            | `char(26)`       | **no**   | `Relationship`          | Identifier of the account the charge is associated with (ULID)                                                                                          |                                                                                                      |
| `quote_locator`              | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the quote the charge is associated with (ULID)                                                                                            |                                                                                                      |
| `product_name`               | `varchar(128)`   | **no**   |                         | The name of the configured product the quote is based on                                                                                                |                                                                                                      |
| `element_locator`            | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the element the charge is directly associated with (ULID)                                                                                 |                                                                                                      |
| `element_category`           | `varchar(128)`   | yes      |                         | The [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on                                           | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine`                                     |
| `element_type`               | `varchar(128)`   | **no**   |                         | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on                                         | *defined in configuration*                                                                           |
| `start_time_utc`             | `datetime(6)`    | **no**   |                         | Start of the period covered by the charge                                                                                                               |                                                                                                      |
| `end_time_utc`               | `datetime(6)`    | **no**   |                         | End of the period covered by the charge                                                                                                                 |                                                                                                      |
| `duration`                   | `decimal(19,15)` | yes      |                         | The number of units of `duration_basis` the charge spans                                                                                                |                                                                                                      |
| `duration_basis`             | `varchar(32)`    | yes      |                         | The units of time that the `duration` of the quote is expressed in                                                                                      | `years`, `months`, `weeks`, `days`, `hours`                                                          |
| `charge_category`            | `varchar(128)`   | **no**   |                         | The category the charge type is based on                                                                                                                | `none`, `premium`, `tax`, `fee`, `credit`, `invoiceFee`, `cededPremium`, `nonFinancial`, `surcharge` |
| `charge_type`                | `varchar(128)`   | **no**   |                         | The configured type the charge is based on                                                                                                              | *defined in configuration*                                                                           |
| `amount`                     | `decimal(19,3)`  | **no**   |                         | The [amount ](/features/financials/charges#charges) of the charge                                                                                       |                                                                                                      |
| `rate`                       | `decimal(19,10)` | **no**   |                         | [Rate ](/features/financials/charges#charges) describes the amount per unit time (rate \* duration = amount)                                            |                                                                                                      |
| `reference_rate`             | `decimal(19,10)` | **no**   |                         | The [reference rate ](/features/financials/charges#charges) for the charge returned in the rater (if any)                                               |                                                                                                      |
| `invoicing`                  | `varchar(128)`   | **no**   |                         | Indicates how the system invoices the charge according to its `charge_type`, with possible values listed as `invoicing` in <ApiLink name="ChargeRef" /> | `scheduled`, `next`, `immediate`                                                                     |
| `handling`                   | `varchar(128)`   | **no**   |                         | Indicates how the system handles the charge according to its `charge_type`, with possible values listed as `handling` in <ApiLink name="ChargeRef" />   | `flat`, `normal`, `retention`                                                                        |
| `tag`                        | `varchar(128)`   | yes      |                         | The [tag ](/features/financials/charges#charges) for the charge returned in the rater (if any)                                                          |                                                                                                      |
| `deleted`                    | `tinyint(1)`     | yes      |                         | Indicates whether the record has been deleted                                                                                                           |                                                                                                      |
| `datalake_created_timestamp` | `datetime(6)`    | **no**   |                         | Time in UTC the record was created                                                                                                                      |                                                                                                      |
| `datalake_updated_timestamp` | `datetime(6)`    | **no**   | `Index`                 | Time in UTC the record was last updated                                                                                                                 |                                                                                                      |
| `created_at_utc`             | `datetime(6)`    | yes      |                         | UTC timestamp when this record was created in Socotra.                                                                                                  |                                                                                                      |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `quote_locator` → `quotes.locator` (`many-to-one`)
* `element_locator` → `quote_elements.locator` (`many-to-one`)

***

<span id="quote_coverage_terms" />

quote_coverage_terms [#quote_coverage_terms]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `element_locator`, `name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                                | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | -------------------- | -------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                                     |                                                                  |
| `quote_locator`              | `char(26)`      | **no**   | `Relationship`       | Identifier of the quote the coverage term is associated with (ULID)                                                        |                                                                  |
| `element_locator`            | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the element the coverage term is associated with (ULID)                                                      |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                      | The [category](/features/policy-management/policy-elements#categories-and-types) the associated element type is based on   | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | **no**   |                      | The [configured type](/features/policy-management/policy-elements#categories-and-types) the associated element is based on | *defined in configuration*                                       |
| `name_md5`                   | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `name`                                                                                                 |                                                                  |
| `name`                       | `varchar(1024)` | **no**   |                      | The configured name of the coverage term                                                                                   | *defined in configuration*                                       |
| `option`                     | `varchar(1024)` | **no**   |                      | The selected option or value of the coverage term                                                                          | *defined in configuration*                                       |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                                                              |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                                         |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                                    |                                                                  |

**Relationships:**

* `quote_locator` → `quotes.locator` (`many-to-one`)
* `element_locator` → `quote_elements.locator` (`many-to-one`)

***

<span id="quote_element_underwriting_flags" />

quote_element_underwriting_flags [#quote_element_underwriting_flags]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes              | Description                                                                                                                                                                       | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | ----------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                                                                                                                            |                                                                  |
| `locator`                    | `char(26)`      | **no**   | `PK`                    | Unique identifier of the [underwriting flag ](/features/underwriting#what-is-an-underwriting-flag) for the quote element (ULID)                                                   |                                                                  |
| `quote_locator`              | `char(26)`      | **no**   | `Index`, `Relationship` | Identifier of the quote the underwriting flag is associated with (ULID)                                                                                                           |                                                                  |
| `element_locator`            | `char(26)`      | yes      | `Index`, `Relationship` | Identifier of the quote element the underwriting flag is associated with (ULID)                                                                                                   |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                         | The [category](/features/policy-management/policy-elements#categories-and-types) the associated element type is based on                                                          | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | yes      |                         | The [configured type](/features/policy-management/policy-elements#categories-and-types) the associated element is based on                                                        | *defined in configuration*                                       |
| `level`                      | `varchar(128)`  | **no**   |                         | The [level ](/features/underwriting#what-is-an-underwriting-flag) of the underwriting flag, with possible values listed as `level` in <ApiLink name="UnderwritingFlagResponse" /> | `info`, `block`, `decline`, `reject`, `approve`                  |
| `task_locator`               | `char(26)`      | yes      | `Relationship`          | Identifier of the task associated with the underwriting flag (ULID)                                                                                                               |                                                                  |
| `note`                       | `varchar(1024)` | yes      |                         | The custom note associated with the underwriting flag                                                                                                                             |                                                                  |
| `created_by`                 | `char(36)`      | yes      |                         | Identifier of the user that created the underwriting flag (UUID)                                                                                                                  |                                                                  |
| `created_time_utc`           | `datetime(6)`   | **no**   |                         | Time in UTC the underwriting flag was created                                                                                                                                     |                                                                  |
| `cleared_by`                 | `char(36)`      | yes      |                         | Identifier of the user that cleared the underwriting flag (UUID)                                                                                                                  |                                                                  |
| `cleared_time_utc`           | `datetime(6)`   | yes      |                         | Time in UTC the underwriting flag was cleared                                                                                                                                     |                                                                  |
| `deleted`                    | `tinyint(1)`    | yes      |                         | Indicates whether the record has been deleted                                                                                                                                     |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                         | Time in UTC the record was created                                                                                                                                                |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`                 | Time in UTC the record was last updated                                                                                                                                           |                                                                  |

**Relationships:**

* `quote_locator` → `quotes.locator` (`many-to-one`)
* `element_locator` → `quote_elements.locator` (`many-to-one`)
* `task_locator` → `tasks.locator` (`many-to-one`)

***

<span id="quote_data_extensions" />

quote_data_extensions [#quote_data_extensions]

**API Reference:** [Quotes API](/api/quotes/quotes)

**Primary Key:** `tenant_locator`, `element_locator`, `is_static`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                     | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | -------------------- | --------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                          |                                                                  |
| `quote_locator`              | `char(26)`      | **no**   | `Relationship`       | Identifier of the quote the element data is associated with (ULID)                                              |                                                                  |
| `element_locator`            | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the element the data is associated with (ULID)                                                    |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                      | The [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on   | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | **no**   |                      | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on | *defined in configuration*                                       |
| `is_static`                  | `tinyint(4)`    | **no**   | `PK`                 | Whether the data is static or not                                                                               |                                                                  |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                                                |                                                                  |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field                            | *defined in configuration*                                       |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                                                          | *defined in configuration*                                       |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                                                   |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                              |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                         |                                                                  |

**Relationships:**

* `quote_locator` → `quotes.locator` (`many-to-one`)
* `element_locator` → `quote_elements.locator` (`many-to-one`)

***

<span id="quote_preferences" />

quote_preferences [#quote_preferences]

**Primary Key:** `tenant_locator`, `quote_locator`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                        | Possible Values                                                                                                               |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                             |                                                                                                                               |
| `quote_locator`              | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the quote the preferences are associated with (ULID) |                                                                                                                               |
| `installment_plan_name`      | `varchar(128)`  | yes      |                      | Name of the installment plan assigned to the quote, if any         | *defined in configuration*                                                                                                    |
| `installment_weights`        | `varchar(1024)` | yes      |                      | Custom weights for installment amounts, if specified               |                                                                                                                               |
| `anchor_mode`                | `varchar(128)`  | yes      |                      | Mode for anchoring installment generation timing                   | `generateDay`, `termStartDay`, `dueDay`                                                                                       |
| `anchor_time_utc`            | `datetime(6)`   | yes      |                      | Time in UTC to anchor installment generation, if applicable        |                                                                                                                               |
| `anchor_type`                | `varchar(128)`  | yes      |                      | Type of anchor for installment generation timing                   | `none`, `dayOfMonth`, `anchorTime`, `dayOfWeek`, `weekOfMonth`                                                                |
| `cadence`                    | `varchar(128)`  | yes      |                      | Frequency of installment generation (e.g., `monthly`, `quarterly`) | `none`, `fullPay`, `weekly`, `everyOtherWeek`, `monthly`, `quarterly`, `semiannually`, `annually`, `thirtyDays`, `everyNDays` |
| `day_of_month`               | `varchar(128)`  | yes      |                      | Day of the month for installment generation, if applicable         |                                                                                                                               |
| `day_of_week`                | `varchar(128)`  | yes      |                      | Day of the week for installment generation, if applicable          | `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`                                                  |
| `due_lead_days`              | `varchar(128)`  | yes      |                      | Number of days before due date that invoices are generated         |                                                                                                                               |
| `generate_lead_days`         | `varchar(128)`  | yes      |                      | Number of days in advance to generate installments                 |                                                                                                                               |
| `max_installments_per_term`  | `int(11)`       | yes      |                      | Maximum number of installments allowed per term, if specified      |                                                                                                                               |
| `week_of_month`              | `varchar(128)`  | yes      |                      | Week of the month for installment generation, if applicable        | `none`, `first`, `second`, `third`, `fourth`, `fifth`                                                                         |
| `autopay_lead_days`          | `varchar(128)`  | yes      |                      | Number of days in advance of the due date to autopay invoice       |                                                                                                                               |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                 |                                                                                                                               |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                            |                                                                                                                               |

**Relationships:**

* `quote_locator` → `quotes.locator` (`one-to-one`)

***

<span id="policies" />

policies [#policies]

**API Reference:** [Policies API](/api/policy-management/policies)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                                                    | Possible Values                             |
| ---------------------------- | --------------- | -------- | -------------- | -------------------------------------------------------------------------------------------------------------- | ------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                         |                                             |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the policy (ULID)                                                                         |                                             |
| `account_locator`            | `char(26)`      | **no**   | `Relationship` | Identifier of the account the policy is associated with (ULID)                                                 |                                             |
| `issued_transaction_locator` | `char(26)`      | **no**   | `Relationship` | Identifier of the transaction that issued the policy (ULID)                                                    |                                             |
| `latest_term_locator`        | `char(26)`      | **no**   | `Relationship` | Identifier of the latest term for the policy (ULID)                                                            |                                             |
| `latest_segment_locator`     | `char(26)`      | yes      | `Relationship` | Identifier of the latest segment for the policy (ULID)                                                         |                                             |
| `product_name`               | `varchar(128)`  | **no**   |                | Name of the product associated with the policy                                                                 |                                             |
| `start_time_utc`             | `datetime(6)`   | **no**   |                | Time in UTC the policy goes into effect                                                                        |                                             |
| `end_time_utc`               | `datetime(6)`   | **no**   |                | Time in UTC the policy is no longer effective                                                                  |                                             |
| `coverage_end_time_utc`      | `datetime(6)`   | yes      |                | Time in UTC the policy coverage ends                                                                           |                                             |
| `currency`                   | `varchar(128)`  | yes      |                | Currency the policy was written in                                                                             |                                             |
| `duration_basis`             | `varchar(32)`   | yes      |                | The units of time that the [duration ](/features/financials/durations) of the policy is expressed in           | `years`, `months`, `weeks`, `days`, `hours` |
| `timezone`                   | `varchar(128)`  | yes      |                | The timezone the policy was written in                                                                         |                                             |
| `billing_level`              | `varchar(50)`   | **no**   |                | Level at which billing for the policy takes place. Value may be `policy` or `account`                          | `account`, `inherit`, `policy`              |
| `created_time_utc`           | `datetime(6)`   | **no**   |                | Time in UTC the policy was created                                                                             |                                             |
| `created_by`                 | `char(36)`      | **no**   |                | Identifier of the user that created the policy (UUID)                                                          |                                             |
| `region`                     | `varchar(128)`  | yes      |                | The region assigned to the policy (if any)                                                                     |                                             |
| `jurisdiction`               | `varchar(128)`  | yes      |                | The jurisdiction assigned to the policy (if any)                                                               |                                             |
| `auto_renewal_plan_name`     | `varchar(128)`  | yes      |                | Name of the policy's [auto-renewal plan ](/features/policy-management/renewal-management#autorenewal) (if any) | *defined in configuration*                  |
| `delinquency_plan_name`      | `varchar(128)`  | yes      |                | Name of the policy's [delinquency plan ](/features/billing/delinquency#configuration) (if any)                 | *defined in configuration*                  |
| `invoice_fee_amount`         | `decimal(19,3)` | yes      |                | Amount of the policy's invoice fee (if any)                                                                    |                                             |
| `policy_number`              | `varchar(128)`  | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the policy (if any)            |                                             |
| `anonymized_time_utc`        | `datetime(6)`   | yes      |                | Time in UTC the policy was anonymized                                                                          |                                             |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                             |                                             |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                                        |                                             |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `issued_transaction_locator` → `transactions.locator` (`many-to-one`)
* `latest_term_locator` → `terms.locator` (`many-to-one`)
* `latest_segment_locator` → `segments.locator` (`many-to-one`)

***

<span id="terms" />

terms [#terms]

**API Reference:** [Policy Terms API](/api/policy-management/policy-terms)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                       | Type           | Nullable | Attributes     | Description                                                                                      | Possible Values |
| --------------------------------- | -------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------ | --------------- |
| `tenant_locator`                  | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                           |                 |
| `locator`                         | `char(26)`     | **no**   | `PK`           | Unique identifier of the term (UUID)                                                             |                 |
| `static_locator`                  | `char(26)`     | **no**   |                | Static identifier of the term that persists across changes (ULID)                                |                 |
| `policy_locator`                  | `char(26)`     | **no**   | `Relationship` | Identifier of the policy the term is associated with (ULID)                                      |                 |
| `originating_transaction_locator` | `char(26)`     | **no**   | `Relationship` | Identifier of the transaction the term is associated with (ULID)                                 |                 |
| `start_time_utc`                  | `datetime(6)`  | **no**   |                | Time in UTC the term is effective                                                                |                 |
| `end_time_utc`                    | `datetime(6)`  | **no**   |                | Time in UTC the term is no longer effective                                                      |                 |
| `number`                          | `int(11)`      | **no**   |                | Sequential number of the term within the policy                                                  |                 |
| `auto_renewal_locator`            | `char(26)`     | yes      | `Relationship` | Identifier of the auto-renewal associated with the term (ULID), if any                           |                 |
| `previous_term_locator`           | `char(26)`     | yes      | `Relationship` | Identifier of the term that preceded this term (ULID), if any                                    |                 |
| `supersedes_term_locator`         | `char(26)`     | yes      | `Relationship` | Identifier of the term that this term supersedes (ULID), if any                                  |                 |
| `term_number`                     | `varchar(128)` | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the term, if any |                 |
| `deleted`                         | `tinyint(1)`   | yes      |                | Indicates whether the record has been deleted                                                    |                 |
| `datalake_created_timestamp`      | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                               |                 |
| `datalake_updated_timestamp`      | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                          |                 |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `originating_transaction_locator` → `transactions.locator` (`many-to-one`)
* `auto_renewal_locator` → `policy_auto_renewals.locator` (`many-to-one`)
* `previous_term_locator` → `terms.locator` (`many-to-one`)
* `supersedes_term_locator` → `terms.locator` (`many-to-one`)

***

<span id="transactions" />

transactions [#transactions]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                     | Type           | Nullable | Attributes     | Description                                                                         | Possible Values                                                                                                                                                                                            |
| ------------------------------- | -------------- | -------- | -------------- | ----------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`                | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                              |                                                                                                                                                                                                            |
| `locator`                       | `char(26)`     | **no**   | `PK`           | Unique identifier of the transaction (ULID)                                         |                                                                                                                                                                                                            |
| `policy_locator`                | `char(26)`     | **no**   | `Relationship` | Identifier of the policy the transaction is associated with (ULID)                  |                                                                                                                                                                                                            |
| `term_locator`                  | `char(26)`     | **no**   | `Relationship` | Identifier of the term the transaction is associated with (ULID)                    |                                                                                                                                                                                                            |
| `effective_time_utc`            | `datetime(6)`  | **no**   |                | Time in UTC the transaction becomes effective                                       |                                                                                                                                                                                                            |
| `transaction_state`             | `varchar(50)`  | **no**   |                | Current state of the transaction                                                    | `draft`, `initialized`, `validated`, `earlyUnderwritten`, `priced`, `underwritten`, `accepted`, `issued`, `underwrittenBlocked`, `declined`, `rejected`, `refused`, `discarded`, `invalidated`, `reversed` |
| `category`                      | `varchar(50)`  | **no**   |                | Category of the transaction                                                         | `issuance`, `change`, `renewal`, `cancellation`, `reinstatement`, `reversal`, `aggregate`                                                                                                                  |
| `type`                          | `varchar(128)` | **no**   |                | The configured type of the transaction                                              | *defined in configuration*                                                                                                                                                                                 |
| `created_by`                    | `char(36)`     | **no**   |                | Identifier of the user that created the transaction (UUID)                          |                                                                                                                                                                                                            |
| `created_time_utc`              | `datetime(6)`  | **no**   |                | Time in UTC the transaction was created                                             |                                                                                                                                                                                                            |
| `aggregate_transaction_locator` | `char(26)`     | yes      | `Relationship` | Identifier of the aggregate transaction this transaction is part of (ULID), if any  |                                                                                                                                                                                                            |
| `base_transaction_locator`      | `char(26)`     | yes      | `Relationship` | Identifier of the transaction this transaction is derived from (ULID), if any       |                                                                                                                                                                                                            |
| `reapplication_of_locator`      | `char(26)`     | yes      | `Relationship` | Identifier of the transaction this transaction is a reapplication of (ULID), if any |                                                                                                                                                                                                            |
| `static_locator`                | `char(26)`     | yes      |                | Static identifier of the transaction that persists across changes (ULID)            |                                                                                                                                                                                                            |
| `issued_time_utc`               | `datetime(6)`  | yes      |                | Time in UTC the transaction was issued                                              |                                                                                                                                                                                                            |
| `accepted_time_utc`             | `datetime(6)`  | yes      |                | Time in UTC the transaction was accepted                                            |                                                                                                                                                                                                            |
| `underwriting_status`           | `varchar(50)`  | yes      |                | The outcome of the underwriting process (if completed)                              |                                                                                                                                                                                                            |
| `datalake_created_timestamp`    | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                  |                                                                                                                                                                                                            |
| `datalake_updated_timestamp`    | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                             |                                                                                                                                                                                                            |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `term_locator` → `terms.locator` (`many-to-one`)
* `aggregate_transaction_locator` → `transactions.locator` (`many-to-one`)
* `base_transaction_locator` → `transactions.locator` (`many-to-one`)
* `reapplication_of_locator` → `transactions.locator` (`many-to-one`)

***

<span id="transaction_data_extensions" />

transaction_data_extensions [#transaction_data_extensions]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `transaction_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                      | Possible Values                                                                           |
| ---------------------------- | --------------- | -------- | -------------------- | ---------------------------------------------------------------- | ----------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                           |                                                                                           |
| `transaction_locator`        | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the transaction the data is associated with (UULD) |                                                                                           |
| `transaction_category`       | `varchar(128)`  | **no**   |                      | Category of the associated transaction                           | `issuance`, `change`, `renewal`, `cancellation`, `reinstatement`, `reversal`, `aggregate` |
| `transaction_type`           | `varchar(128)`  | **no**   |                      | Configured type of the associated transaction                    | *defined in configuration*                                                                |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                 |                                                                                           |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the extension data field                         | *defined in configuration*                                                                |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                           | *defined in configuration*                                                                |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                    |                                                                                           |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                               |                                                                                           |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                          |                                                                                           |

**Relationships:**

* `transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="affected_transactions" />

affected_transactions [#affected_transactions]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `transaction_locator`, `affected_transaction_locator`

| Column Name                    | Type          | Nullable | Attributes           | Description                                                                                                       | Possible Values           |
| ------------------------------ | ------------- | -------- | -------------------- | ----------------------------------------------------------------------------------------------------------------- | ------------------------- |
| `tenant_locator`               | `char(36)`    | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                            |                           |
| `transaction_locator`          | `char(26)`    | **no**   | `PK`, `Relationship` | Unique identifier of the affecting transaction (ULID)                                                             |                           |
| `affected_transaction_locator` | `char(26)`    | **no**   | `PK`, `Relationship` | Unique identifier of the affected transaction (ULID)                                                              |                           |
| `action`                       | `varchar(50)` | **no**   |                      | Action taken by the affecting transaction onto the affected transaction. Value may be `reversed` or `invalidated` | `reversed`, `invalidated` |
| `datalake_created_timestamp`   | `datetime(6)` | **no**   |                      | Time in UTC the record was created                                                                                |                           |
| `datalake_updated_timestamp`   | `datetime(6)` | **no**   | `Index`              | Time in UTC the record was last updated                                                                           |                           |

**Relationships:**

* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `affected_transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="segments" />

segments [#segments]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type             | Nullable | Attributes     | Description                                                        | Possible Values                             |
| ---------------------------- | ---------------- | -------- | -------------- | ------------------------------------------------------------------ | ------------------------------------------- |
| `tenant_locator`             | `char(36)`       | **no**   | `PK`           | Unique identifier of the tenant (UUID)                             |                                             |
| `locator`                    | `char(26)`       | **no**   | `PK`           | Unique identifier of the segment (ULID)                            |                                             |
| `policy_locator`             | `char(26)`       | **no**   | `Relationship` | Identifier of the policy the segment is associated with (ULID)     |                                             |
| `transaction_locator`        | `char(26)`       | **no**   | `Relationship` | Identifier of the transaction that created the segment (ULID)      |                                             |
| `term_locator`               | `char(26)`       | **no**   | `Relationship` | Identifier of the term the segment is associated with (ULID)       |                                             |
| `start_time_utc`             | `datetime(6)`    | **no**   |                | Time in UTC the segment begins                                     |                                             |
| `end_time_utc`               | `datetime(6)`    | **no**   |                | Time in UTC the segment ends                                       |                                             |
| `duration`                   | `decimal(19,15)` | **no**   |                | The number of units of `duration_basis` the segment spans          |                                             |
| `duration_basis`             | `varchar(32)`    | yes      |                | The units of time that the duration of the segment is expressed in | `years`, `months`, `weeks`, `days`, `hours` |
| `type`                       | `varchar(50)`    | **no**   |                | The type of segment                                                | `coverage`, `gap`                           |
| `based_on`                   | `char(26)`       | yes      | `Relationship` | Identifier of the segment this segment is based on (ULID), if any  |                                             |
| `producer_code`              | `varchar(128)`   | yes      |                | The producer code assigned to the segment (if any)                 |                                             |
| `producer_code_of_record`    | `varchar(128)`   | yes      |                | The producer code of record assigned to the segment (if any)       |                                             |
| `anonymized_time_utc`        | `datetime(6)`    | yes      |                | Time in UTC the segment was anonymized                             |                                             |
| `deleted`                    | `tinyint(1)`     | yes      |                | Indicates whether the record has been deleted                      |                                             |
| `datalake_created_timestamp` | `datetime(6)`    | **no**   |                | Time in UTC the record was created                                 |                                             |
| `datalake_updated_timestamp` | `datetime(6)`    | **no**   | `Index`        | Time in UTC the record was last updated                            |                                             |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `term_locator` → `terms.locator` (`many-to-one`)
* `based_on` → `segments.locator` (`many-to-one`)

***

<span id="policy_segment_elements" />

policy_segment_elements [#policy_segment_elements]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                   | Type           | Nullable | Attributes     | Description                                                                                                           | Possible Values                                                  |
| ----------------------------- | -------------- | -------- | -------------- | --------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`              | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                                |                                                                  |
| `locator`                     | `char(26)`     | **no**   | `PK`           | Unique identifier of the segment element (UUID)                                                                       |                                                                  |
| `policy_locator`              | `char(26)`     | **no**   | `Relationship` | Identifier of the policy the segment element is associated with (ULID)                                                |                                                                  |
| `transaction_locator`         | `char(26)`     | **no**   | `Relationship` | Identifier of the transaction the segment element is associated with (ULID)                                           |                                                                  |
| `segment_locator`             | `char(26)`     | **no**   | `Relationship` | Identifier of the segment the element is associated with (ULID)                                                       |                                                                  |
| `parent_locator`              | `char(26)`     | yes      | `Relationship` | Identifier of the parent element immediately above in the policy data hierarchy (ULID)                                |                                                                  |
| `static_locator`              | `char(26)`     | **no**   |                | Static identifier of the segment element that persists across changes (ULID)                                          |                                                                  |
| `category`                    | `varchar(128)` | yes      |                | The element [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `type`                        | `varchar(128)` | **no**   |                | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on       | *defined in configuration*                                       |
| `original_effective_time_utc` | `datetime(6)`  | yes      |                | Time in UTC of the original effective date of the segment element                                                     |                                                                  |
| `deleted`                     | `tinyint(1)`   | yes      |                | Indicates whether the record has been deleted                                                                         |                                                                  |
| `datalake_created_timestamp`  | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                                                    |                                                                  |
| `datalake_updated_timestamp`  | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                                               |                                                                  |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `parent_locator` → `policy_segment_elements.locator` (`many-to-one`)

***

<span id="policy_element_tree" />

policy_element_tree [#policy_element_tree]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `segment_locator`, `parent_locator`, `child_locator`

| Column Name                  | Type          | Nullable | Attributes                    | Description                                                                       | Possible Values |
| ---------------------------- | ------------- | -------- | ----------------------------- | --------------------------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`, `Index`                 | Unique identifier of the tenant (UUID)                                            |                 |
| `policy_locator`             | `char(26)`    | **no**   | `Index`, `Relationship`       | Identifier of the policy the element tree is associated with (ULID)               |                 |
| `transaction_locator`        | `char(26)`    | **no**   | `Index`, `Relationship`       | Identifier of the transaction the element tree is associated with (ULID)          |                 |
| `segment_locator`            | `char(26)`    | **no**   | `PK`, `Index`, `Relationship` | Identifier of the segment the element tree is associated with (ULID)              |                 |
| `parent_locator`             | `char(26)`    | **no**   | `PK`, `Relationship`          | Identifier of the element immediately above in the policy's data hierarchy (ULID) |                 |
| `child_locator`              | `char(26)`    | **no**   | `PK`, `Relationship`          | Identifier of an element immediately below in the policy's data hierarchy (ULID)  |                 |
| `depth`                      | `int(11)`     | **no**   |                               | The number of levels of child elements below in the policy's data hierarchy       |                 |
| `deleted`                    | `tinyint(1)`  | yes      |                               | Indicates whether the record has been deleted                                     |                 |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                               | Time in UTC the record was created                                                |                 |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`                       | Time in UTC the record was last updated                                           |                 |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `parent_locator` → `policy_segment_elements.locator` (`many-to-one`)
* `child_locator` → `policy_segment_elements.locator` (`many-to-one`)

***

<span id="policy_element_charges" />

policy_element_charges [#policy_element_charges]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type             | Nullable | Attributes              | Description                                                                                                                                             | Possible Values                                                                                      |
| ---------------------------- | ---------------- | -------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`       | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                                                                                                  |                                                                                                      |
| `locator`                    | `char(26)`       | **no**   | `PK`                    | Unique identifier of the charge (ULID)                                                                                                                  |                                                                                                      |
| `account_locator`            | `char(26)`       | **no**   | `Relationship`          | Identifier of the account the charge is associated with (ULID)                                                                                          |                                                                                                      |
| `policy_locator`             | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the policy the charge is associated with (ULID)                                                                                           |                                                                                                      |
| `transaction_locator`        | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the transaction the charge is associated with (ULID)                                                                                      |                                                                                                      |
| `segment_locator`            | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the segment the charge is associated with (ULID)                                                                                          |                                                                                                      |
| `product_name`               | `varchar(128)`   | **no**   |                         | The name of the configured product the policy is based on                                                                                               |                                                                                                      |
| `segment_element_locator`    | `char(26)`       | **no**   | `Index`, `Relationship` | Identifier of the segment element the charge is directly associated with (ULID)                                                                         |                                                                                                      |
| `element_static_locator`     | `char(26)`       | yes      | `Relationship`          | Static identifier of the element that persists across changes (ULID)                                                                                    |                                                                                                      |
| `element_category`           | `varchar(128)`   | yes      |                         | The [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on                                           | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine`                                     |
| `element_type`               | `varchar(128)`   | **no**   |                         | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on                                         | *defined in configuration*                                                                           |
| `start_time_utc`             | `datetime(6)`    | **no**   |                         | Time in UTC the period covered by the charge begins                                                                                                     |                                                                                                      |
| `end_time_utc`               | `datetime(6)`    | **no**   |                         | Time in UTC the period covered by the charge ends                                                                                                       |                                                                                                      |
| `duration`                   | `decimal(19,15)` | yes      |                         | The number of units of `duration_basis` the charge spans                                                                                                |                                                                                                      |
| `duration_basis`             | `varchar(32)`    | yes      |                         | The units of time that the `duration` of the charge is expressed in                                                                                     | `years`, `months`, `weeks`, `days`, `hours`                                                          |
| `charge_category`            | `varchar(128)`   | **no**   |                         | The category the charge type is based on                                                                                                                | `none`, `premium`, `tax`, `fee`, `credit`, `invoiceFee`, `cededPremium`, `nonFinancial`, `surcharge` |
| `charge_type`                | `varchar(128)`   | **no**   |                         | The configured type the charge is based on                                                                                                              | *defined in configuration*                                                                           |
| `amount`                     | `decimal(19,3)`  | **no**   |                         | The amount of the charge                                                                                                                                |                                                                                                      |
| `rate`                       | `decimal(19,10)` | **no**   |                         | Rate describes the amount per unit time (rate \* duration = amount)                                                                                     |                                                                                                      |
| `reference_rate`             | `decimal(19,10)` | **no**   |                         | The reference rate for the charge returned in the rater (if any)                                                                                        |                                                                                                      |
| `rate_difference`            | `decimal(19,10)` | **no**   |                         | The difference between the rate and reference rate (if any)                                                                                             |                                                                                                      |
| `reversal_of_locator`        | `char(26)`       | yes      | `Relationship`          | Identifier of the charge reversed by this charge (if any)                                                                                               |                                                                                                      |
| `tag`                        | `varchar(128)`   | yes      |                         | The tag for the charge returned in the rater (if any)                                                                                                   |                                                                                                      |
| `invoicing`                  | `varchar(128)`   | **no**   |                         | Indicates how the system invoices the charge according to its `charge_type`, with possible values listed as `invoicing` in <ApiLink name="ChargeRef" /> | `scheduled`, `next`, `immediate`                                                                     |
| `handling`                   | `varchar(128)`   | **no**   |                         | Indicates how the system handles the charge according to its `charge_type`, with possible values listed as `handling` in <ApiLink name="ChargeRef" />   | `flat`, `normal`, `retention`                                                                        |
| `deleted`                    | `tinyint(1)`     | yes      |                         | Indicates whether the record has been deleted                                                                                                           |                                                                                                      |
| `datalake_created_timestamp` | `datetime(6)`    | **no**   |                         | Time in UTC the record was created                                                                                                                      |                                                                                                      |
| `datalake_updated_timestamp` | `datetime(6)`    | **no**   | `Index`                 | Time in UTC the record was last updated                                                                                                                 |                                                                                                      |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `segment_element_locator` → `policy_segment_elements.locator` (`many-to-one`)
* `element_static_locator` → `policy_segment_elements.static_locator` (`many-to-many`)
* `reversal_of_locator` → `policy_element_charges.locator` (`many-to-one`)

***

<span id="policy_coverage_terms" />

policy_coverage_terms [#policy_coverage_terms]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `segment_element_locator`, `name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                                | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | -------------------- | -------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                                     |                                                                  |
| `policy_locator`             | `char(26)`      | **no**   | `Relationship`       | Identifier of the policy the element data is associated with (ULID)                                                        |                                                                  |
| `transaction_locator`        | `char(26)`      | **no**   | `Relationship`       | Identifier of the transaction the element data is associated with (ULID)                                                   |                                                                  |
| `segment_locator`            | `char(26)`      | **no**   | `Relationship`       | Identifier of the segment the element data is associated with (ULID)                                                       |                                                                  |
| `segment_element_locator`    | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the element the coverage term is associated with (ULID)                                                      |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                      | The [category](/features/policy-management/policy-elements#categories-and-types) the associated element type is based on   | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | **no**   |                      | The [configured type](/features/policy-management/policy-elements#categories-and-types) the associated element is based on | *defined in configuration*                                       |
| `name_md5`                   | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `name`                                                                                                 |                                                                  |
| `name`                       | `varchar(1024)` | **no**   |                      | The configured name of the coverage term                                                                                   | *defined in configuration*                                       |
| `option`                     | `varchar(1024)` | **no**   |                      | The selected option or value of the coverage term                                                                          | *defined in configuration*                                       |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                                                              |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                                         |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                                    |                                                                  |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `segment_element_locator` → `policy_segment_elements.locator` (`many-to-one`)

***

<span id="policy_element_underwriting_flags" />

policy_element_underwriting_flags [#policy_element_underwriting_flags]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes              | Description                                                                                                                | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | ----------------------- | -------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                                                                     |                                                                  |
| `locator`                    | `char(26)`      | **no**   | `PK`                    | Unique identifier of the underwriting flag (ULID)                                                                          |                                                                  |
| `policy_locator`             | `char(26)`      | **no**   | `Index`, `Relationship` | Identifier of the policy the underwriting flag is associated with (ULID)                                                   |                                                                  |
| `transaction_locator`        | `char(26)`      | **no**   | `Index`, `Relationship` | Identifier of the transaction the underwriting flag is associated with (ULID)                                              |                                                                  |
| `segment_locator`            | `char(26)`      | yes      | `Index`, `Relationship` | Identifier of the segment the underwriting flag is associated with (ULID)                                                  |                                                                  |
| `segment_element_locator`    | `char(26)`      | yes      | `Index`, `Relationship` | Identifier of the policy element the underwriting flag is associated with (ULID)                                           |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                         | The [category](/features/policy-management/policy-elements#categories-and-types) the associated element type is based on   | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | yes      |                         | The [configured type](/features/policy-management/policy-elements#categories-and-types) the associated element is based on | *defined in configuration*                                       |
| `level`                      | `varchar(128)`  | **no**   |                         | The level of the underwriting flag                                                                                         | `info`, `block`, `decline`, `reject`, `approve`                  |
| `note`                       | `varchar(1024)` | yes      |                         | The custom note associated with the underwriting flag                                                                      |                                                                  |
| `task_locator`               | `char(26)`      | yes      | `Relationship`          | Identifier of the task associated with the underwriting flag (ULID)                                                        |                                                                  |
| `created_by`                 | `char(36)`      | yes      |                         | Identifier of the user that created the underwriting flag (UUID)                                                           |                                                                  |
| `created_time_utc`           | `datetime(6)`   | **no**   |                         | Time in UTC the underwriting flag was created                                                                              |                                                                  |
| `cleared_by`                 | `char(36)`      | yes      |                         | Identifier of the user that cleared the underwriting flag (UUID)                                                           |                                                                  |
| `cleared_time_utc`           | `datetime(6)`   | yes      |                         | Time in UTC the underwriting flag was cleared                                                                              |                                                                  |
| `deleted`                    | `tinyint(1)`    | yes      |                         | Indicates whether the record has been deleted                                                                              |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                         | Time in UTC the record was created                                                                                         |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`                 | Time in UTC the record was last updated                                                                                    |                                                                  |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `segment_element_locator` → `policy_segment_elements.locator` (`many-to-one`)
* `task_locator` → `tasks.locator` (`many-to-one`)

***

<span id="policy_data_extensions" />

policy_data_extensions [#policy_data_extensions]

**API Reference:** [Policies API](/api/policy-management/policies)

**Primary Key:** `tenant_locator`, `segment_element_locator`, `is_static`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                     | Possible Values                                                  |
| ---------------------------- | --------------- | -------- | -------------------- | --------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                          |                                                                  |
| `policy_locator`             | `char(26)`      | **no**   | `Relationship`       | Identifier of the policy the element data is associated with (ULID)                                             |                                                                  |
| `transaction_locator`        | `char(26)`      | **no**   | `Relationship`       | Identifier of the transaction the element data is associated with (ULID)                                        |                                                                  |
| `segment_locator`            | `char(26)`      | **no**   | `Relationship`       | Identifier of the segment the element data is associated with (ULID)                                            |                                                                  |
| `segment_element_locator`    | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the element the data is associated with (ULID)                                                    |                                                                  |
| `element_category`           | `varchar(128)`  | yes      |                      | The [category](/features/policy-management/policy-elements#categories-and-types) the element type is based on   | `product`, `coverage`, `exposure`, `exposureGroup`, `policyLine` |
| `element_type`               | `varchar(128)`  | **no**   |                      | The [configured type](/features/policy-management/policy-elements#categories-and-types) the element is based on | *defined in configuration*                                       |
| `is_static`                  | `tinyint(4)`    | **no**   | `PK`                 | Whether the data is static or not                                                                               |                                                                  |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                                                |                                                                  |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field                            | *defined in configuration*                                       |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                                                          | *defined in configuration*                                       |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                                                   |                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                              |                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                         |                                                                  |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)
* `segment_element_locator` → `policy_segment_elements.locator` (`many-to-one`)

***

<span id="policy_auto_renewals" />

policy_auto_renewals [#policy_auto_renewals]

**API Reference:** [Policy Auto-Renewal API](/api/policy-management/renewal-management)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                             | Type           | Nullable | Attributes              | Description                                                                      | Possible Values                                                                     |
| --------------------------------------- | -------------- | -------- | ----------------------- | -------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------- |
| `tenant_locator`                        | `char(36)`     | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                           |                                                                                     |
| `locator`                               | `char(26)`     | **no**   | `PK`                    | Unique identifier of the policy auto-renewal (ULID)                              |                                                                                     |
| `term_locator`                          | `char(26)`     | **no**   | `Relationship`          | Identifier of the term the auto-renewal is associated with (ULID)                |                                                                                     |
| `policy_locator`                        | `char(26)`     | **no**   | `Index`, `Relationship` | Identifier of the policy the auto-renewal is associated with (ULID)              |                                                                                     |
| `state`                                 | `varchar(50)`  | **no**   |                         | Current state of the auto-renewal                                                | `active`, `discarded`, `doNotRenew`, `issued`, `error`, `terminated`, `invalidated` |
| `renewal_transaction_type`              | `varchar(128)` | **no**   |                         | The configured type of the renewal transaction                                   | *defined in configuration*                                                          |
| `renewal_transaction_locator`           | `char(26)`     | yes      | `Relationship`          | Identifier of the renewal transaction (ULID), if created                         |                                                                                     |
| `new_term_duration`                     | `int(11)`      | yes      |                         | Duration of the new term in units of the policy's `duration_basis`, if specified |                                                                                     |
| `renewal_transaction_create_time_utc`   | `datetime(6)`  | **no**   |                         | Time in UTC scheduled for the renewal transaction creation                       |                                                                                     |
| `renewal_transaction_created_time_utc`  | `datetime(6)`  | yes      |                         | Time in UTC the renewal transaction was created                                  |                                                                                     |
| `renewal_transaction_accept_time_utc`   | `datetime(6)`  | yes      |                         | Time in UTC scheduled for the renewal transaction acceptance                     |                                                                                     |
| `renewal_transaction_accepted_time_utc` | `datetime(6)`  | yes      |                         | Time in UTC the renewal transaction was accepted                                 |                                                                                     |
| `renewal_transaction_issue_time_utc`    | `datetime(6)`  | yes      |                         | Time in UTC scheduled for the renewal transaction issuance                       |                                                                                     |
| `renewal_transaction_issued_time_utc`   | `datetime(6)`  | yes      |                         | Time in UTC the renewal transaction was issued                                   |                                                                                     |
| `datalake_created_timestamp`            | `datetime(6)`  | **no**   |                         | Time in UTC the record was created                                               |                                                                                     |
| `datalake_updated_timestamp`            | `datetime(6)`  | **no**   | `Index`                 | Time in UTC the record was last updated                                          |                                                                                     |

**Relationships:**

* `term_locator` → `terms.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)
* `renewal_transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="policy_transaction_change_instructions" />

policy_transaction_change_instructions [#policy_transaction_change_instructions]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `locator`, `transaction_locator`

| Column Name                  | Type          | Nullable | Attributes                    | Description                                                                              | Possible Values                     |
| ---------------------------- | ------------- | -------- | ----------------------------- | ---------------------------------------------------------------------------------------- | ----------------------------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`                          | Unique identifier of the tenant (UUID)                                                   |                                     |
| `locator`                    | `char(26)`    | **no**   | `PK`                          | Unique identifier of the change instruction (ULID)                                       |                                     |
| `policy_locator`             | `char(26)`    | **no**   | `Index`, `Relationship`       | Identifier of the policy the change instruction is associated with (ULID)                |                                     |
| `transaction_locator`        | `char(26)`    | **no**   | `PK`, `Index`, `Relationship` | Identifier of the transaction the change instruction is associated with (ULID)           |                                     |
| `action`                     | `varchar(50)` | **no**   |                               | The action to be performed by the change instruction                                     | `add`, `params`, `modify`, `delete` |
| `data`                       | `longtext`    | yes      |                               | Structured data defining the change instruction details                                  |                                     |
| `effective_time_utc`         | `datetime(6)` | yes      |                               | Time in UTC the change instruction becomes effective                                     |                                     |
| `static_locator`             | `char(26)`    | yes      |                               | Static identifier of the element the change instruction applies to (ULID), if applicable |                                     |
| `new_policy_end_time_utc`    | `datetime(6)` | yes      |                               | Time in UTC the policy ends, if the change instruction modifies it                       |                                     |
| `trigger_billing_change`     | `tinyint(1)`  | yes      |                               | Indicates whether the change instruction should trigger billing changes                  |                                     |
| `deleted`                    | `tinyint(1)`  | yes      |                               | Indicates whether the record has been deleted                                            |                                     |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                               | Time in UTC the record was created                                                       |                                     |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`                       | Time in UTC the record was last updated                                                  |                                     |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="policy_preferences" />

policy_preferences [#policy_preferences]

**API Reference:** [Policy Transactions API](/api/policy-management/policy-transactions)

**Primary Key:** `tenant_locator`, `transaction_locator`

| Column Name                  | Type            | Nullable | Attributes              | Description                                                               | Possible Values                                                                                                               |
| ---------------------------- | --------------- | -------- | ----------------------- | ------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`, `Index`           | Unique identifier of the tenant (UUID)                                    |                                                                                                                               |
| `policy_locator`             | `char(26)`      | **no**   | `Index`, `Relationship` | Identifier of the policy the preferences are associated with (ULID)       |                                                                                                                               |
| `transaction_locator`        | `char(26)`      | **no**   | `PK`, `Relationship`    | Identifier of the transaction the preferences are associated with (ULID)  |                                                                                                                               |
| `billing_plan_name`          | `varchar(128)`  | yes      |                         | Name of the billing plan assigned to the policy, if any                   | *defined in configuration*                                                                                                    |
| `billing_level`              | `varchar(128)`  | yes      |                         | Level at which billing for the policy takes place (`policy` or `account`) | `account`, `inherit`, `policy`                                                                                                |
| `installment_weights`        | `varchar(1024)` | yes      |                         | Custom weights for installment amounts, if specified                      |                                                                                                                               |
| `installment_plan_name`      | `varchar(128)`  | yes      |                         | Name of the installment plan assigned to the policy, if any               | *defined in configuration*                                                                                                    |
| `anchor_mode`                | `varchar(128)`  | yes      |                         | Mode for anchoring installment generation timing                          | `generateDay`, `termStartDay`, `dueDay`                                                                                       |
| `anchor_time_utc`            | `datetime(6)`   | yes      |                         | Time in UTC to anchor installment generation, if applicable               |                                                                                                                               |
| `anchor_type`                | `varchar(128)`  | yes      |                         | Type of anchor for installment generation timing                          | `none`, `dayOfMonth`, `anchorTime`, `dayOfWeek`, `weekOfMonth`                                                                |
| `cadence`                    | `varchar(128)`  | yes      |                         | Frequency of installment generation (e.g., `monthly`, `quarterly`)        | `none`, `fullPay`, `weekly`, `everyOtherWeek`, `monthly`, `quarterly`, `semiannually`, `annually`, `thirtyDays`, `everyNDays` |
| `day_of_month`               | `varchar(128)`  | yes      |                         | Day of the month for installment generation, if applicable                |                                                                                                                               |
| `day_of_week`                | `varchar(128)`  | yes      |                         | Day of the week for installment generation, if applicable                 | `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`                                                  |
| `due_lead_days`              | `varchar(128)`  | yes      |                         | Number of days before due date that invoices are generated                |                                                                                                                               |
| `generate_lead_days`         | `varchar(128)`  | yes      |                         | Number of days in advance to generate installments                        |                                                                                                                               |
| `autopay_lead_days`          | `varchar(128)`  | yes      |                         | Number of days in advance of the due date to autopay invoice              |                                                                                                                               |
| `max_installments_per_term`  | `int(11)`       | yes      |                         | Maximum number of installments allowed per term, if specified             |                                                                                                                               |
| `week_of_month`              | `varchar(128)`  | yes      |                         | Week of the month for installment generation, if applicable               | `none`, `first`, `second`, `third`, `fourth`, `fifth`                                                                         |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                         | Time in UTC the record was created                                        |                                                                                                                               |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`                 | Time in UTC the record was last updated                                   |                                                                                                                               |

**Relationships:**

* `policy_locator` → `policies.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`one-to-one`)

***

<span id="policy_status" />

policy_status [#policy_status]

**Description:** This table contains one record per policy. Each record represents the current status of that policy. Multiple status fields may be true for a given policy.

**Primary Key:** `tenant_locator`, `policy_locator`

| Column Name                  | Type          | Nullable | Attributes           | Description                                                      | Possible Values |
| ---------------------------- | ------------- | -------- | -------------------- | ---------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                           |                 |
| `policy_locator`             | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the policy the status record corresponds to (ULID) |                 |
| `on_risk`                    | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `onRisk`               |                 |
| `pending`                    | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `pending`              |                 |
| `expired`                    | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `expired`              |                 |
| `cancelled`                  | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `cancelled`            |                 |
| `cancel_pending`             | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `cancelPending`        |                 |
| `delinquent`                 | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `delinquent`           |                 |
| `do_not_renew`               | `tinyint(1)`  | **no**   |                      | Indicates if the policy is in a status of `doNotRenew`           |                 |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                      | Time in UTC the record was created                               |                 |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`              | Time in UTC the record was last updated                          |                 |

**Relationships:**

* `policy_locator` → `policies.locator` (`one-to-one`)

***

Billing Tables [#billing-tables]

* [installments](#installments)
* [installment\_items](#installment_items)
* [installment\_settings](#installment_settings)
* [invoices](#invoices)
* [invoice\_items](#invoice_items)
* [payments](#payments)
* [payment\_data\_extensions](#payment_data_extensions)
* [disbursements](#disbursements)
* [disbursement\_data\_extensions](#disbursement_data_extensions)
* [delinquencies](#delinquencies)
* [delinquency\_references](#delinquency_references)
* [billing\_holds](#billing_holds)
* [write\_offs](#write_offs)
* [credit\_distributions](#credit_distributions)
* [credit\_items](#credit_items)
* [external\_cash\_transactions](#external_cash_transactions)
* [financial\_instruments](#financial_instruments)
* [ledger\_accounts](#ledger_accounts)
* [ledger\_account\_line\_items](#ledger_account_line_items)
* [fa\_transactions](#fa_transactions)
* [fa\_transaction\_account\_lines](#fa_transaction_account_lines)

<span id="installments" />

installments [#installments]

**API Reference:** [Installments API](/api/billing/installments)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                    | Type            | Nullable | Attributes     | Description                                                                                                  | Possible Values |
| ------------------------------ | --------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------------------ | --------------- |
| `tenant_locator`               | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                       |                 |
| `locator`                      | `char(26)`      | **no**   | `PK`           | Unique identifier of the installment (ULID)                                                                  |                 |
| `account_locator`              | `char(26)`      | **no**   | `Relationship` | Identifier of the account the installment is associated with (ULID)                                          |                 |
| `due_time_utc`                 | `datetime(6)`   | **no**   |                | Time in UTC the installment payment is due                                                                   |                 |
| `generate_time_utc`            | `datetime(6)`   | **no**   |                | Time in UTC the installment was generated                                                                    |                 |
| `autopay_time_utc`             | `datetime(6)`   | yes      |                | Time in UTC the installment payment execution will be triggered                                              |                 |
| `currency`                     | `varchar(128)`  | **no**   |                | Currency of the installment                                                                                  |                 |
| `timezone`                     | `varchar(128)`  | **no**   |                | Timezone in which the installment was generated                                                              |                 |
| `coverage_duration`            | `decimal(19,3)` | **no**   |                | Duration of coverage represented by the installment                                                          |                 |
| `coverage_start_time_utc`      | `datetime(6)`   | **no**   |                | Time in UTC when coverage for the installment begins                                                         |                 |
| `coverage_end_time_utc`        | `datetime(6)`   | **no**   |                | Time in UTC when coverage for the installment ends                                                           |                 |
| `installment_duration`         | `decimal(19,3)` | **no**   |                | Duration of the installment period                                                                           |                 |
| `installment_start_time_utc`   | `datetime(6)`   | **no**   |                | Time in UTC when the installment period begins                                                               |                 |
| `installment_end_time_utc`     | `datetime(6)`   | **no**   |                | Time in UTC when the installment period ends                                                                 |                 |
| `installment_frame_index`      | `int(11)`       | **no**   |                | Index of the installment within the billing frame sequence                                                   |                 |
| `installment_lattice_locator`  | `char(26)`      | **no**   |                | Identifier of the installment lattice that this installment corresponds from                                 |                 |
| `installment_settings_locator` | `char(26)`      | yes      | `Relationship` | Identifier of the installment settings locator that applies to this installment                              |                 |
| `reversal_of_locator`          | `char(26)`      | yes      | `Relationship` | Identifier of the installment that this installment is a reversal of, if applicable                          |                 |
| `migrated_from_locator`        | `char(26)`      | yes      | `Relationship` | Identifier of the installment that this installment was migrated from, in the case of a billing mode change  |                 |
| `enhanced_by_plugin`           | `tinyint(1)`    | yes      |                | Indicates if this installment was enhanced by the Installment Plugin or follows default installment settings |                 |
| `created_by`                   | `char(36)`      | **no**   |                | Identifier of the user that created the installment (UUID)                                                   |                 |
| `created_at_utc`               | `datetime(6)`   | **no**   |                | Time in UTC the installment was created                                                                      |                 |
| `updated_by`                   | `char(36)`      | **no**   |                | Identifier of the user that last updated the installment (UUID)                                              |                 |
| `updated_at_utc`               | `datetime(6)`   | **no**   |                | Time in UTC the installment was last updated                                                                 |                 |
| `invoice_locator`              | `char(26)`      | yes      | `Relationship` | Identifier of the invoice the installment is associated with (ULID), if any                                  |                 |
| `policy_locator`               | `char(26)`      | yes      | `Relationship` | Identifier of the policy the installment is associated with (ULID), if any                                   |                 |
| `term_locator`                 | `char(26)`      | yes      | `Relationship` | Identifier of the term the installment is associated with (ULID), if any                                     |                 |
| `quote_locator`                | `char(26)`      | yes      | `Relationship` | Identifier of the quote the installment is associated with (ULID), if any                                    |                 |
| `transaction_locator`          | `char(26)`      | yes      | `Relationship` | Identifier of the transaction that triggered the installment (ULID), if any                                  |                 |
| `datalake_created_timestamp`   | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                           |                 |
| `datalake_updated_timestamp`   | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                                      |                 |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `installment_settings_locator` → `installment_settings.locator` (`many-to-one`)
* `reversal_of_locator` → `installments.locator` (`many-to-one`)
* `migrated_from_locator` → `installments.locator` (`many-to-one`)
* `invoice_locator` → `invoices.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)
* `term_locator` → `terms.locator` (`many-to-one`)
* `quote_locator` → `quotes.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="installment_items" />

installment_items [#installment_items]

**API Reference:** [Installments API](/api/billing/installments)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes              | Description                                                                         | Possible Values                                                                                      |
| ---------------------------- | --------------- | -------- | ----------------------- | ----------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                    | Unique identifier of the tenant (UUID)                                              |                                                                                                      |
| `locator`                    | `char(26)`      | **no**   | `PK`                    | Unique identifier of the installment item (ULID)                                    |                                                                                                      |
| `installment_locator`        | `char(26)`      | **no**   | `Index`, `Relationship` | Identifier of the installment the installment item is associated with (ULID)        |                                                                                                      |
| `charge_locator`             | `char(26)`      | **no**   | `Relationship`          | Identifier of the charge the installment item is associated with (ULID)             |                                                                                                      |
| `segment_element_locator`    | `char(26)`      | **no**   | `Relationship`          | Identifier of the segment element the installment item is associated with (ULID)    |                                                                                                      |
| `charge_category`            | `varchar(128)`  | **no**   |                         | Category of the associated charge                                                   | `none`, `premium`, `tax`, `fee`, `credit`, `invoiceFee`, `cededPremium`, `nonFinancial`, `surcharge` |
| `charge_type`                | `varchar(128)`  | **no**   |                         | Type of the associated charge                                                       | *defined in configuration*                                                                           |
| `amount`                     | `decimal(19,3)` | **no**   |                         | Amount of the installment item                                                      |                                                                                                      |
| `created_time_utc`           | `datetime(6)`   | **no**   |                         | Time in UTC the installment item was created                                        |                                                                                                      |
| `created_by`                 | `char(36)`      | yes      |                         | Identifier of the user that created the installment item (UUID)                     |                                                                                                      |
| `element_static_locator`     | `char(26)`      | **no**   | `Relationship`          | Static identifier of the associated segment element (ULID)                          |                                                                                                      |
| `invoice_item_locator`       | `char(26)`      | yes      | `Relationship`          | Identifier of the associated invoice item (ULID), if any                            |                                                                                                      |
| `reversal_of_locator`        | `char(26)`      | yes      | `Relationship`          | Identifier of the installment item reversed by this installment item (ULID), if any |                                                                                                      |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                         | Time in UTC the record was created                                                  |                                                                                                      |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`                 | Time in UTC the record was last updated                                             |                                                                                                      |

**Relationships:**

* `installment_locator` → `installments.locator` (`many-to-one`)
* `charge_locator` → `policy_element_charges.locator` (`many-to-one`)
* `segment_element_locator` → `policy_segment_elements.locator` (`many-to-one`)
* `element_static_locator` → `policy_segment_elements.static_locator` (`many-to-many`)
* `invoice_item_locator` → `invoice_items.locator` (`many-to-one`)
* `reversal_of_locator` → `installment_items.locator` (`many-to-one`)

***

<span id="installment_settings" />

installment_settings [#installment_settings]

**API Reference:** [Installment Lattices API](/api/billing/installment-lattices)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes | Description                                                                 | Possible Values                                                                                                               |
| ---------------------------- | --------------- | -------- | ---------- | --------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                      |                                                                                                                               |
| `locator`                    | `char(26)`      | **no**   | `PK`       | Unique identifier of the installment settings (UUID)                        |                                                                                                                               |
| `installment_weights`        | `varchar(1024)` | yes      |            | Custom weights for installment amounts, if specified                        |                                                                                                                               |
| `anchor_mode`                | `varchar(128)`  | **no**   |            | Mode for anchoring installment generation timing                            | `generateDay`, `termStartDay`, `dueDay`                                                                                       |
| `anchor_time_utc`            | `datetime(6)`   | yes      |            | Time in UTC to anchor installment generation, if applicable                 |                                                                                                                               |
| `anchor_type`                | `varchar(128)`  | yes      |            | Type of anchor for installment generation timing                            | `none`, `dayOfMonth`, `anchorTime`, `dayOfWeek`, `weekOfMonth`                                                                |
| `cadence`                    | `varchar(128)`  | **no**   |            | Frequency of installment generation (e.g., `monthly`, `quarterly`)          | `none`, `fullPay`, `weekly`, `everyOtherWeek`, `monthly`, `quarterly`, `semiannually`, `annually`, `thirtyDays`, `everyNDays` |
| `day_of_month`               | `varchar(128)`  | yes      |            | Day of the month for installment generation, if applicable                  |                                                                                                                               |
| `day_of_week`                | `varchar(128)`  | yes      |            | Day of the week for installment generation, if applicable                   | `monday`, `tuesday`, `wednesday`, `thursday`, `friday`, `saturday`, `sunday`                                                  |
| `week_of_month`              | `varchar(128)`  | yes      |            | Week of the month for installment generation, if applicable                 | `none`, `first`, `second`, `third`, `fourth`, `fifth`                                                                         |
| `due_lead_days`              | `varchar(128)`  | **no**   |            | Number of days before due date that invoices are generated                  |                                                                                                                               |
| `generate_lead_days`         | `varchar(128)`  | **no**   |            | Number of days in advance to generate installments                          |                                                                                                                               |
| `autopay_lead_days`          | `varchar(128)`  | yes      |            | Number of days in advance of the due date to trigger autopay for an invoice |                                                                                                                               |
| `max_installments_per_term`  | `int(11)`       | yes      |            | Maximum number of installments allowed per term, if specified               |                                                                                                                               |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |            | Time in UTC the record was created                                          |                                                                                                                               |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`    | Time in UTC the record was last updated                                     |                                                                                                                               |

***

<span id="invoices" />

invoices [#invoices]

**API Reference:** [Invoices API](/api/billing/invoices)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                                         | Possible Values                            |
| ---------------------------- | --------------- | -------- | -------------- | --------------------------------------------------------------------------------------------------- | ------------------------------------------ |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                              |                                            |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the invoice (ULID)                                                             |                                            |
| `account_locator`            | `char(26)`      | **no**   | `Relationship` | Identifier of the account the invoice is associated with (ULID)                                     |                                            |
| `start_time_utc`             | `datetime(6)`   | **no**   |                | Time in UTC when the invoice period begins                                                          |                                            |
| `end_time_utc`               | `datetime(6)`   | **no**   |                | Time in UTC when the invoice period ends                                                            |                                            |
| `due_time_utc`               | `datetime(6)`   | **no**   |                | Time in UTC when the invoice is due                                                                 |                                            |
| `generated_time_utc`         | `datetime(6)`   | **no**   |                | Time in UTC the invoice was generated                                                               |                                            |
| `currency`                   | `varchar(128)`  | **no**   |                | Currency of the invoice                                                                             |                                            |
| `timezone`                   | `varchar(128)`  | **no**   |                | Timezone in which the invoice was generated                                                         |                                            |
| `invoice_state`              | `varchar(50)`   | **no**   |                | Current state of the invoice                                                                        | `building`, `open`, `settled`, `discarded` |
| `invoice_number`             | `varchar(128)`  | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the invoice, if any |                                            |
| `total_amount`               | `decimal(19,3)` | yes      |                | Total amount of the invoice                                                                         |                                            |
| `total_remaining_amount`     | `decimal(19,3)` | yes      |                | Remaining unpaid amount of the invoice                                                              |                                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                  |                                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                             |                                            |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="invoice_items" />

invoice_items [#invoice_items]

**API Reference:** [Invoices API](/api/billing/invoices)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                      | Possible Values                                                                                      |
| ---------------------------- | --------------- | -------- | -------------- | -------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                           |                                                                                                      |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the invoice item (ULID)                                     |                                                                                                      |
| `invoice_locator`            | `char(26)`      | **no**   | `Relationship` | Identifier of the invoice the item is associated with (ULID)                     |                                                                                                      |
| `timezone`                   | `varchar(128)`  | **no**   |                | Timezone for the invoice item                                                    |                                                                                                      |
| `amount`                     | `decimal(19,3)` | yes      |                | Amount of the invoice item                                                       |                                                                                                      |
| `charge_category`            | `varchar(128)`  | **no**   |                | Category of the associated charge                                                | `none`, `premium`, `tax`, `fee`, `credit`, `invoiceFee`, `cededPremium`, `nonFinancial`, `surcharge` |
| `charge_type`                | `varchar(128)`  | **no**   |                | Configured type of the associated charge                                         | *defined in configuration*                                                                           |
| `policy_locator`             | `char(26)`      | yes      | `Relationship` | Identifier of the policy the invoice item is associated with (ULID), if any      |                                                                                                      |
| `quote_locator`              | `char(26)`      | yes      | `Relationship` | Identifier of the quote the invoice item is associated with (ULID), if any       |                                                                                                      |
| `element_static_locator`     | `char(26)`      | yes      | `Relationship` | Static identifier of the element associated with the invoice item (ULID), if any |                                                                                                      |
| `remaining_amount`           | `decimal(19,3)` | yes      |                | Remaining unpaid amount of the invoice item                                      |                                                                                                      |
| `settlement_time_utc`        | `datetime(6)`   | yes      |                | Time in UTC when the invoice item was fully settled                              |                                                                                                      |
| `unsettled_time_utc`         | `datetime(6)`   | yes      |                | Time in UTC the invoice item was unsettled                                       |                                                                                                      |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                               |                                                                                                      |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                          |                                                                                                      |

**Relationships:**

* `invoice_locator` → `invoices.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)
* `quote_locator` → `quotes.locator` (`many-to-one`)
* `element_static_locator` → `policy_segment_elements.static_locator` (`many-to-many`)

***

<span id="payments" />

payments [#payments]

**API Reference:** [Payments API](/api/billing/payments)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                                          | Possible Values                                                                                                                  |
| ---------------------------- | --------------- | -------- | -------------- | ---------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                               |                                                                                                                                  |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the payment (UUID)                                                              |                                                                                                                                  |
| `currency`                   | `varchar(128)`  | **no**   |                | Currency of the payment                                                                              |                                                                                                                                  |
| `payment_state`              | `varchar(30)`   | **no**   |                | Current state of the payment                                                                         | `draft`, `validated`, `requested`, `executing`, `posting`, `posted`, `failed`, `cancelled`, `reversing`, `reversed`, `discarded` |
| `amount`                     | `decimal(19,3)` | yes      |                | Amount of the payment                                                                                |                                                                                                                                  |
| `type`                       | `varchar(128)`  | **no**   |                | The configured type of the payment                                                                   | *defined in configuration*                                                                                                       |
| `created_by`                 | `char(36)`      | **no**   |                | Identifier of the user that created the payment (UUID)                                               |                                                                                                                                  |
| `created_at_utc`             | `datetime(6)`   | **no**   |                | Time in UTC the payment was created                                                                  |                                                                                                                                  |
| `account_locator`            | `char(26)`      | yes      | `Relationship` | Identifier of the account the payment is associated with (ULID), if any                              |                                                                                                                                  |
| `ext_cash_trx_locator`       | `char(26)`      | yes      | `Relationship` | Identifier of the external cash transaction (ULID), if any                                           |                                                                                                                                  |
| `posted_at_utc`              | `datetime(6)`   | yes      |                | Time in UTC the payment was posted                                                                   |                                                                                                                                  |
| `remaining_amount`           | `decimal(19,3)` | yes      |                | Remaining unapplied amount of the payment                                                            |                                                                                                                                  |
| `reversal_reason`            | `varchar(1024)` | yes      |                | Reason for the payment reversal, if reversed                                                         |                                                                                                                                  |
| `reversed_at_utc`            | `datetime(6)`   | yes      |                | Time in UTC the payment was reversed                                                                 |                                                                                                                                  |
| `reversed_by`                | `char(36)`      | yes      |                | Identifier of the user who reversed the payment (UUID)                                               |                                                                                                                                  |
| `aggregate_payment_locator`  | `char(26)`      | yes      | `Relationship` | Identifier of the aggregate payment this payment belongs to (ULID), if any                           |                                                                                                                                  |
| `payment_mode`               | `varchar(128)`  | yes      |                | Indicates the mode of the payment (e.g., `normal`, `aggregate`)                                      | `normal`, `aggregate`                                                                                                            |
| `retry_plan_name`            | `varchar(256)`  | yes      |                | Name of the payment execution retry plan associated with the payment, if any                         | *defined in configuration*                                                                                                       |
| `next_request_time_utc`      | `datetime(6)`   | yes      |                | Time in UTC the next payment request will be attempted                                               |                                                                                                                                  |
| `payment_number`             | `varchar(128)`  | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the payment (if any) |                                                                                                                                  |
| `anonymized_time_utc`        | `datetime(6)`   | yes      |                | Time in UTC the payment was anonymized                                                               |                                                                                                                                  |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                   |                                                                                                                                  |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                              |                                                                                                                                  |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `ext_cash_trx_locator` → `external_cash_transactions.locator` (`many-to-one`)
* `aggregate_payment_locator` → `payments.locator` (`many-to-one`)

***

<span id="payment_data_extensions" />

payment_data_extensions [#payment_data_extensions]

**API Reference:** [Payments API](/api/billing/payments)

**Primary Key:** `tenant_locator`, `payment_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                          | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------------------------ | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                               |                            |
| `payment_locator`            | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the payment the extension data is associated with (ULID)               |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                     |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                               | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                        |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                   |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                              |                            |

**Relationships:**

* `payment_locator` → `payments.locator` (`many-to-one`)

***

<span id="disbursements" />

disbursements [#disbursements]

**API Reference:** [Disbursements API](/api/billing/disbursements)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                                               | Possible Values                                                                   |
| ---------------------------- | --------------- | -------- | -------------- | --------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                    |                                                                                   |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the disbursement (UUID)                                                              |                                                                                   |
| `currency`                   | `varchar(128)`  | **no**   |                | Currency of the disbursement                                                                              |                                                                                   |
| `disbursement_state`         | `varchar(30)`   | **no**   |                | Current state of the disbursement                                                                         | `draft`, `validated`, `approved`, `executed`, `reversed`, `rejected`, `discarded` |
| `amount`                     | `decimal(19,3)` | yes      |                | Amount of the disbursement                                                                                |                                                                                   |
| `type`                       | `varchar(128)`  | **no**   |                | The configured type of the disbursement                                                                   | *defined in configuration*                                                        |
| `created_by`                 | `char(36)`      | **no**   |                | Identifier of the user that created the disbursement (UUID)                                               |                                                                                   |
| `created_at_utc`             | `datetime(6)`   | **no**   |                | Time in UTC the disbursement was created                                                                  |                                                                                   |
| `account_locator`            | `char(26)`      | yes      | `Relationship` | Identifier of the account the disbursement is associated with (ULID), if any                              |                                                                                   |
| `ext_cash_trx_locator`       | `char(26)`      | yes      | `Relationship` | Identifier of the external cash transaction (ULID), if any                                                |                                                                                   |
| `disbursement_number`        | `varchar(128)`  | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the disbursement (if any) |                                                                                   |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                        |                                                                                   |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                                   |                                                                                   |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `ext_cash_trx_locator` → `external_cash_transactions.locator` (`many-to-one`)

***

<span id="disbursement_data_extensions" />

disbursement_data_extensions [#disbursement_data_extensions]

**API Reference:** [Disbursements API](/api/billing/disbursements)

**Primary Key:** `tenant_locator`, `disbursement_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                          | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------------------------ | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                               |                            |
| `disbursement_locator`       | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the disbursement the extension data is associated with (ULID)          |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                     |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                               | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                        |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                   |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                              |                            |

**Relationships:**

* `disbursement_locator` → `disbursements.locator` (`many-to-one`)

***

<span id="delinquencies" />

delinquencies [#delinquencies]

**API Reference:** [Delinquency API](/api/billing/delinquency)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                            | Type           | Nullable | Attributes     | Description                                                                      | Possible Values                                                               |
| -------------------------------------- | -------------- | -------- | -------------- | -------------------------------------------------------------------------------- | ----------------------------------------------------------------------------- |
| `tenant_locator`                       | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                           |                                                                               |
| `locator`                              | `char(26)`     | **no**   | `PK`           | Unique identifier of the delinquency (ULID)                                      |                                                                               |
| `account_locator`                      | `char(26)`     | **no**   | `Relationship` | Identifier of the account the delinquency is associated with (ULID)              |                                                                               |
| `timezone`                             | `varchar(128)` | **no**   |                | Timezone for the delinquency                                                     |                                                                               |
| `delinquency_state`                    | `varchar(52)`  | **no**   |                | Current state of the delinquency                                                 | `preGrace`, `inGrace`, `lapseTriggered`, `settled`, `lapseTransactionCreated` |
| `advance_lapse_to`                     | `varchar(128)` | **no**   |                | The state to which the system should automatically advance the lapse transaction | `draft`, `validated`, `priced`, `underwritten`, `accepted`, `issued`          |
| `grace_period_days`                    | `int(11)`      | **no**   |                | Number of days in the grace period before lapse                                  |                                                                               |
| `lapse_transaction_type`               | `varchar(128)` | **no**   |                | The configured type of lapse transaction to be created                           | *defined in configuration*                                                    |
| `delinquency_level`                    | `varchar(128)` | yes      |                | Level at which the delinquency is applied. Value may be `policy` or `invoice`    | `policy`, `invoice`                                                           |
| `created_at_utc`                       | `datetime(6)`  | **no**   |                | Time in UTC the delinquency was created                                          |                                                                               |
| `updated_at_utc`                       | `datetime(6)`  | **no**   |                | Time in UTC the delinquency was last updated                                     |                                                                               |
| `grace_end_at_utc`                     | `datetime(6)`  | yes      |                | Time in UTC when the grace period ends                                           |                                                                               |
| `grace_started_at_utc`                 | `datetime(6)`  | yes      |                | Time in UTC when the grace period started                                        |                                                                               |
| `lapse_transaction_effective_date_utc` | `datetime(6)`  | yes      |                | Effective date in UTC for the lapse transaction, if applicable                   |                                                                               |
| `datalake_created_timestamp`           | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                               |                                                                               |
| `datalake_updated_timestamp`           | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                          |                                                                               |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="delinquency_references" />

delinquency_references [#delinquency_references]

**Description:** This table contains multiple records per delinquency. Each record represents a relationship between a delinquency and another entity, such as a policy or invoice.

**API Reference:** [Delinquency API](/api/billing/delinquency)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                            | Type           | Nullable | Attributes      | Description                                                                                                                            | Possible Values     |
| -------------------------------------- | -------------- | -------- | --------------- | -------------------------------------------------------------------------------------------------------------------------------------- | ------------------- |
| `tenant_locator`                       | `char(36)`     | **no**   | `PK`            | Unique identifier of the tenant (UUID)                                                                                                 |                     |
| `locator`                              | `char(26)`     | **no**   | `PK`            | Unique identifier of the delinquency reference (ULID)                                                                                  |                     |
| `delinquency_locator`                  | `char(26)`     | **no**   | `Relationship`  | Identifier of the delinquency that the referenced entity is associated with (ULID)                                                     |                     |
| `reference_locator`                    | `char(26)`     | **no**   | `Relationship`  | Identifier of the reference, with referenced entity defined by `reference_type` (ULID)                                                 |                     |
| `reference_type`                       | `varchar(128)` | **no**   | `Discriminator` | Reference type of the delinquency reference, with possible values listed as `referenceType` in <ApiLink name="DelinquencyReference" /> | `policy`, `invoice` |
| `transaction_locator`                  | `char(26)`     | yes      | `Relationship`  | Identifier of the lapse transaction associated with this delinquency reference                                                         |                     |
| `preempting_lapse_transaction_locator` | `char(26)`     | yes      | `Relationship`  | Identifier of the lapse transaction associated with another delinquency reference that preempts this one                               |                     |
| `datalake_created_timestamp`           | `datetime(6)`  | **no**   |                 | Time in UTC the record was created                                                                                                     |                     |
| `datalake_updated_timestamp`           | `datetime(6)`  | **no**   | `Index`         | Time in UTC the record was last updated                                                                                                |                     |

**Relationships:**

* `delinquency_locator` → `delinquencies.locator` (`many-to-one`)
* `reference_locator` *(depends on `reference_type`)*:
  * `policy` → `policies.locator` (`many-to-one`)
  * `invoice` → `invoices.locator` (`many-to-one`)
* `transaction_locator` → `transactions.locator` (`many-to-one`)
* `preempting_lapse_transaction_locator` → `transactions.locator` (`many-to-one`)

***

<span id="billing_holds" />

billing_holds [#billing_holds]

**API Reference:** [Billing Holds API](/api/billing/holds)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type          | Nullable | Attributes     | Description                                                          | Possible Values                                         |
| ---------------------------- | ------------- | -------- | -------------- | -------------------------------------------------------------------- | ------------------------------------------------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`           | Unique identifier of the tenant (UUID)                               |                                                         |
| `locator`                    | `char(26)`    | **no**   | `PK`           | Unique identifier of the billing hold (ULID)                         |                                                         |
| `account_locator`            | `char(26)`    | **no**   | `Relationship` | Identifier of the account the billing hold is associated with (ULID) |                                                         |
| `hold_state`                 | `varchar(50)` | **no**   |                | Current state of the billing hold                                    | `draft`, `validated`, `active`, `discarded`, `released` |
| `target_type`                | `varchar(50)` | **no**   |                | The type of entity the billing hold applies to                       | `invoicing`, `delinquency`                              |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                | Time in UTC the record was created                                   |                                                         |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`        | Time in UTC the record was last updated                              |                                                         |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="write_offs" />

write_offs [#write_offs]

**API Reference:** [Write-Offs API](/api/billing/write-offs)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                       | Possible Values                    |
| ---------------------------- | --------------- | -------- | -------------- | ----------------------------------------------------------------- | ---------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                            |                                    |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the write-off (ULID)                         |                                    |
| `account_locator`            | `char(26)`      | **no**   | `Relationship` | Identifier of the account the write-off is associated with (ULID) |                                    |
| `currency`                   | `varchar(128)`  | **no**   |                | Currency of the write-off                                         |                                    |
| `write_off_state`            | `varchar(30)`   | **no**   |                | Current state of the write-off                                    | `draft`, `distributed`, `reversed` |
| `amount`                     | `decimal(19,3)` | **no**   |                | Amount of the write-off                                           |                                    |
| `credit_type`                | `varchar(128)`  | **no**   |                | Type of credit associated with the write-off                      | `writeOff`, `shortfallWriteOff`    |
| `created_by`                 | `char(36)`      | **no**   |                | Identifier of the user that created the write-off (UUID)          |                                    |
| `created_at_utc`             | `datetime(6)`   | **no**   |                | Time in UTC the write-off was created                             |                                    |
| `reversal_reason`            | `varchar(1024)` | yes      |                | Reason for the write-off reversal, if reversed                    |                                    |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                |                                    |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                           |                                    |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="credit_distributions" />

credit_distributions [#credit_distributions]

**API Reference:** [Credit Distribution API](/api/billing/credit-distribution)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes     | Description                                                                                                                                                         | Possible Values                                           |
| ---------------------------- | --------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                                                                              |                                                           |
| `locator`                    | `char(26)`      | **no**   | `PK`           | Unique identifier of the credit distribution (ULID)                                                                                                                 |                                                           |
| `account_locator`            | `char(26)`      | yes      | `Relationship` | Identifier of the associated account (ULID)                                                                                                                         |                                                           |
| `currency`                   | `varchar(128)`  | **no**   |                | Currency of the credit distribution                                                                                                                                 |                                                           |
| `credit_distribution_state`  | `varchar(30)`   | **no**   |                | State in which the credit distribution currently resides, with possible values listed as `creditDistributionState` in <ApiLink name="CreditDistributionResponse" /> | `draft`, `validated`, `executed`, `reversed`, `discarded` |
| `amount`                     | `decimal(19,3)` | **no**   |                | Amount of the credit distribution                                                                                                                                   |                                                           |
| `created_time_utc`           | `datetime(6)`   | **no**   |                | Time in UTC the credit distribution was created                                                                                                                     |                                                           |
| `created_by`                 | `char(36)`      | yes      |                | Identifier of the user that created the credit distribution (UUID)                                                                                                  |                                                           |
| `execution_time_utc`         | `datetime(6)`   | yes      |                | Time in UTC the credit distribution was executed                                                                                                                    |                                                           |
| `reversal_reason`            | `varchar(1024)` | yes      |                | Reason for the credit distribution reversal                                                                                                                         |                                                           |
| `reversal_time_utc`          | `datetime(6)`   | yes      |                | Time in UTC the credit distribution was reversed                                                                                                                    |                                                           |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                | Time in UTC the record was created                                                                                                                                  |                                                           |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`        | Time in UTC the record was last updated                                                                                                                             |                                                           |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="credit_items" />

credit_items [#credit_items]

**API Reference:** [Credits API](/api/billing/credits)

**Primary Key:** `tenant_locator`, `credit_locator`, `container_locator`, `container_type`

| Column Name                  | Type            | Nullable | Attributes            | Description                                                                                                        | Possible Values                                                                                |
| ---------------------------- | --------------- | -------- | --------------------- | ------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                                             |                                                                                                |
| `credit_locator`             | `char(26)`      | **no**   | `PK`, `Relationship`  | Identifier of the associated credit (ULID), with referenced entity defined by `credit_type`                        |                                                                                                |
| `credit_type`                | `varchar(128)`  | **no**   | `Discriminator`       | Type of the associated credit, with possible values listed as `creditType` in <ApiLink name="CreditResponse" />    | `creditDistribution`, `disbursement`, `payment`, `subpayment`, `shortfallWriteOff`, `writeOff` |
| `container_locator`          | `char(26)`      | **no**   | `PK`, `Relationship`  | Identifier of the associated source or target container (ULID), with referenced entity defined by `container_type` |                                                                                                |
| `container_type`             | `varchar(128)`  | **no**   | `PK`, `Discriminator` | Type of the associated container, with possible values listed as `containerType` in <ApiLink name="CreditItem" />  | `invoice`, `account`, `subpayment`, `invoiceItem`                                              |
| `amount`                     | `decimal(19,3)` | yes      |                       | Amount of the credit item                                                                                          |                                                                                                |
| `deleted`                    | `tinyint(1)`    | yes      |                       | Indicates whether the record has been deleted                                                                      |                                                                                                |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                       | Time in UTC the record was created                                                                                 |                                                                                                |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`               | Time in UTC the record was last updated                                                                            |                                                                                                |

**Relationships:**

* `credit_locator` *(depends on `credit_type`)*:
  * `creditDistribution` → `credit_distributions.locator` (`many-to-one`)
  * `disbursement` → `disbursements.locator` (`many-to-one`)
  * `payment` → `payments.locator` (`many-to-one`)
  * `subpayment` → `payments.locator` (`many-to-one`)
  * `shortfallWriteOff` → `write_offs.locator` (`many-to-one`)
  * `writeOff` → `write_offs.locator` (`many-to-one`)
* `container_locator` *(depends on `container_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `invoice` → `invoices.locator` (`many-to-one`)
  * `invoiceItem` → `invoice_items.locator` (`many-to-one`)
  * `subpayment` → `payments.locator` (`many-to-one`)

***

<span id="external_cash_transactions" />

external_cash_transactions [#external_cash_transactions]

**Primary Key:** `tenant_locator`, `locator`

| Column Name                    | Type           | Nullable | Attributes     | Description                                                                                              | Possible Values                          |
| ------------------------------ | -------------- | -------- | -------------- | -------------------------------------------------------------------------------------------------------- | ---------------------------------------- |
| `tenant_locator`               | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                   |                                          |
| `locator`                      | `char(26)`     | **no**   | `PK`           | Unique identifier of the external cash transaction (ULID)                                                |                                          |
| `financial_instrument_locator` | `char(26)`     | yes      | `Relationship` | Identifier of the financial instrument the transaction was executed against (ULID), if any               |                                          |
| `transaction_method`           | `varchar(128)` | yes      |                | The method used to execute the transaction                                                               | `ach`, `cash`, `eft`, `standard`, `wire` |
| `transaction_number`           | `varchar(128)` | yes      |                | The identifier or confirmation number for the transaction, as returned by the external payment processor |                                          |
| `datalake_created_timestamp`   | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                                       |                                          |
| `datalake_updated_timestamp`   | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                                  |                                          |

**Relationships:**

* `financial_instrument_locator` → `financial_instruments.locator` (`many-to-one`)

***

<span id="financial_instruments" />

financial_instruments [#financial_instruments]

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes     | Description                                                                      | Possible Values                                  |
| ---------------------------- | -------------- | -------- | -------------- | -------------------------------------------------------------------------------- | ------------------------------------------------ |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                           |                                                  |
| `locator`                    | `char(26)`     | **no**   | `PK`           | Unique identifier of the financial instrument (ULID)                             |                                                  |
| `account_locator`            | `char(26)`     | yes      | `Relationship` | Identifier of the account the financial instrument is associated with (ULID)     |                                                  |
| `institution_name`           | `varchar(128)` | yes      |                | Name of the financial institution (e.g. bank or card issuer)                     |                                                  |
| `instrument_type`            | `varchar(50)`  | yes      |                | The type of financial instrument                                                 | `checking`, `savings`, `creditCard`, `debitCard` |
| `default_transaction_method` | `varchar(50)`  | yes      |                | The default transaction method used when transacting with this instrument        | `ach`, `cash`, `eft`, `standard`, `wire`         |
| `retry_plan_name`            | `varchar(256)` | yes      |                | Name of the retry plan applied to failed transactions on this instrument, if any | *defined in configuration*                       |
| `external_identifier`        | `varchar(512)` | yes      |                | Identifier for the instrument as provided by the external payment processor      |                                                  |
| `external_account_number`    | `varchar(128)` | yes      |                | Account number for the instrument, as provided by the external payment processor |                                                  |
| `nickname`                   | `varchar(128)` | yes      |                | Custom nickname for the financial instrument                                     |                                                  |
| `expiration_time_utc`        | `datetime(6)`  | yes      |                | Time in UTC the financial instrument (e.g. card) expires, if applicable          |                                                  |
| `is_default`                 | `tinyint(1)`   | yes      |                | Whether this is the account's default financial instrument                       |                                                  |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                               |                                                  |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                          |                                                  |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)

***

<span id="ledger_accounts" />

ledger_accounts [#ledger_accounts]

**API Reference:** [Accounting API](/api/accounting)

**Primary Key:** `tenant_locator`, `reference_type`, `reference_locator`, `currency`

| Column Name                  | Type            | Nullable | Attributes            | Description                                                                                                                              | Possible Values                                                                                                                                                          |
| ---------------------------- | --------------- | -------- | --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                                                                   |                                                                                                                                                                          |
| `reference_type`             | `char(68)`      | **no**   | `PK`, `Discriminator` | Reference type of the ledger account balance, with possible values listed as `referenceType` in <ApiLink name="LedgerAccountResponse" /> | `accountCreditBalance`, `invoiceCreditBalance`, `cash`, `creditCash`, `charge`, `credit`, `installmentItem`, `invoiceItem`, `account`, `policy`, `accountExpenseBalance` |
| `reference_locator`          | `char(26)`      | **no**   | `PK`, `Relationship`  | Identifier of the reference, with referenced entity defined by `reference_type` (ULID)                                                   |                                                                                                                                                                          |
| `currency`                   | `varchar(128)`  | **no**   | `PK`                  | Currency of the ledger account balance                                                                                                   |                                                                                                                                                                          |
| `balance`                    | `decimal(19,3)` | **no**   |                       | Balance of the ledger account                                                                                                            |                                                                                                                                                                          |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                       | Time in UTC the record was created                                                                                                       |                                                                                                                                                                          |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`               | Time in UTC the record was last updated                                                                                                  |                                                                                                                                                                          |

**Relationships:**

* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `policy` → `policies.locator` (`many-to-one`)
  * `invoiceItem` → `invoice_items.locator` (`many-to-one`)
  * `installmentItem` → `installment_items.locator` (`many-to-one`)
  * `credit`:
    * `payments.locator` (`many-to-one`)
    * `credit_distributions.locator` (`many-to-one`)
    * `disbursements.locator` (`many-to-one`)
    * `write_offs.locator` (`many-to-one`)
  * `accountCreditBalance` → `accounts.locator` (`many-to-one`)
  * `accountExpenseBalance` → `accounts.locator` (`many-to-one`)
  * `invoiceCreditBalance` → `invoices.locator` (`many-to-one`)
  * `cash` → `accounts.locator` (`many-to-one`)
  * `creditCash` → `payments.locator` (`many-to-one`)
  * `charge` → `policy_element_charges.locator` (`many-to-one`)

***

<span id="ledger_account_line_items" />

ledger_account_line_items [#ledger_account_line_items]

**API Reference:** [Accounting API](/api/accounting)

**Primary Key:** `tenant_locator`, `reference_type`, `reference_locator`, `ordering_number`

| Column Name                  | Type            | Nullable | Attributes            | Description                                                                                                                                | Possible Values                                                                                                                                                          |
| ---------------------------- | --------------- | -------- | --------------------- | ------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                                                                     |                                                                                                                                                                          |
| `reference_type`             | `char(68)`      | **no**   | `PK`, `Discriminator` | Reference type of the ledger account line item, with possible values listed as `referenceType` in <ApiLink name="LedgerAccountResponse" /> | `accountCreditBalance`, `invoiceCreditBalance`, `cash`, `creditCash`, `charge`, `credit`, `installmentItem`, `invoiceItem`, `account`, `policy`, `accountExpenseBalance` |
| `reference_locator`          | `char(26)`      | **no**   | `PK`, `Relationship`  | Identifier of the reference, with referenced entity defined by `reference_type` (ULID)                                                     |                                                                                                                                                                          |
| `ordering_number`            | `int(11)`       | **no**   | `PK`                  | Ordering number of the ledger account line item                                                                                            |                                                                                                                                                                          |
| `fa_transaction_locator`     | `char(26)`      | **no**   | `Relationship`        | Unique identifier of the financial accounting transaction (ULID)                                                                           |                                                                                                                                                                          |
| `fa_transaction_time_utc`    | `datetime(6)`   | **no**   |                       | Time in UTC the financial accounting transaction was created                                                                               |                                                                                                                                                                          |
| `fa_transaction_note`        | `varchar(128)`  | yes      |                       | Note associated with the financial accounting transaction                                                                                  |                                                                                                                                                                          |
| `accounting_type`            | `varchar(10)`   | **no**   |                       | Indicates the accounting side of the entry (`debit` or `credit`)                                                                           | `credit`, `debit`                                                                                                                                                        |
| `amount`                     | `decimal(19,3)` | **no**   |                       | Amount of the ledger account line item                                                                                                     |                                                                                                                                                                          |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                       | Time in UTC the record was created                                                                                                         |                                                                                                                                                                          |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`               | Time in UTC the record was last updated                                                                                                    |                                                                                                                                                                          |

**Relationships:**

* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `policy` → `policies.locator` (`many-to-one`)
  * `invoiceItem` → `invoice_items.locator` (`many-to-one`)
  * `installmentItem` → `installment_items.locator` (`many-to-one`)
  * `credit`:
    * `payments.locator` (`many-to-one`)
    * `credit_distributions.locator` (`many-to-one`)
    * `disbursements.locator` (`many-to-one`)
    * `write_offs.locator` (`many-to-one`)
  * `accountCreditBalance` → `accounts.locator` (`many-to-one`)
  * `accountExpenseBalance` → `accounts.locator` (`many-to-one`)
  * `invoiceCreditBalance` → `invoices.locator` (`many-to-one`)
  * `cash` → `accounts.locator` (`many-to-one`)
  * `creditCash` → `payments.locator` (`many-to-one`)
  * `charge` → `policy_element_charges.locator` (`many-to-one`)
* `fa_transaction_locator` → `fa_transactions.locator` (`many-to-one`)

***

<span id="fa_transactions" />

fa_transactions [#fa_transactions]

**API Reference:** [Accounting API](/api/accounting)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes | Description                                                      | Possible Values |
| ---------------------------- | -------------- | -------- | ---------- | ---------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`       | Unique identifier of the tenant (UUID)                           |                 |
| `locator`                    | `char(26)`     | **no**   | `PK`       | Unique identifier of the financial accounting transaction (ULID) |                 |
| `transaction_time_utc`       | `datetime(6)`  | **no**   |            | Time in UTC the financial accounting transaction was created     |                 |
| `transaction_note`           | `varchar(128)` | yes      |            | Note associated with the financial accounting transaction        |                 |
| `currency`                   | `varchar(128)` | **no**   |            | Currency of the financial accounting transaction                 |                 |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |            | Time in UTC the record was created                               |                 |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`    | Time in UTC the record was last updated                          |                 |

***

<span id="fa_transaction_account_lines" />

fa_transaction_account_lines [#fa_transaction_account_lines]

**API Reference:** [Accounting API](/api/accounting)

**Primary Key:** `tenant_locator`, `fa_transaction_locator`, `ordering_number`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                                                                     | Possible Values                                                                                                                                                          |
| ---------------------------- | --------------- | -------- | -------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                                                                          |                                                                                                                                                                          |
| `fa_transaction_locator`     | `char(26)`      | **no**   | `PK`, `Relationship` | Unique identifier of the financial accounting transaction (ULID)                                                                                                |                                                                                                                                                                          |
| `ordering_number`            | `int(11)`       | **no**   | `PK`                 | Ordering number of the financial accounting transaction account line                                                                                            |                                                                                                                                                                          |
| `reference_type`             | `char(68)`      | **no**   | `Discriminator`      | Reference type of the financial accounting transaction account line, with possible values listed as `referenceType` in <ApiLink name="LedgerAccountResponse" /> | `accountCreditBalance`, `invoiceCreditBalance`, `cash`, `creditCash`, `charge`, `credit`, `installmentItem`, `invoiceItem`, `account`, `policy`, `accountExpenseBalance` |
| `reference_locator`          | `char(26)`      | **no**   | `Relationship`       | Identifier of the reference, with referenced entity defined by `reference_type` (ULID)                                                                          |                                                                                                                                                                          |
| `accounting_type`            | `varchar(10)`   | **no**   |                      | Indicates the accounting side of the entry (`debit` or `credit`)                                                                                                | `credit`, `debit`                                                                                                                                                        |
| `amount`                     | `decimal(19,3)` | **no**   |                      | Amount of the financial accounting transaction account line                                                                                                     |                                                                                                                                                                          |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                                                                              |                                                                                                                                                                          |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                                                                         |                                                                                                                                                                          |

**Relationships:**

* `fa_transaction_locator` → `fa_transactions.locator` (`many-to-one`)
* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `policy` → `policies.locator` (`many-to-one`)
  * `invoiceItem` → `invoice_items.locator` (`many-to-one`)
  * `installmentItem` → `installment_items.locator` (`many-to-one`)
  * `credit`:
    * `payments.locator` (`many-to-one`)
    * `credit_distributions.locator` (`many-to-one`)
    * `disbursements.locator` (`many-to-one`)
    * `write_offs.locator` (`many-to-one`)
  * `accountCreditBalance` → `accounts.locator` (`many-to-one`)
  * `accountExpenseBalance` → `accounts.locator` (`many-to-one`)
  * `invoiceCreditBalance` → `invoices.locator` (`many-to-one`)
  * `cash` → `accounts.locator` (`many-to-one`)
  * `creditCash` → `payments.locator` (`many-to-one`)
  * `charge` → `policy_element_charges.locator` (`many-to-one`)

***

Claims Tables [#claims-tables]

* [fnols](#fnols)
* [fnol\_data\_extensions](#fnol_data_extensions)
* [claims](#claims)
* [claim\_data\_extensions](#claim_data_extensions)

<span id="fnols" />

fnols [#fnols]

**API Reference:** [FNOL API](/api/claims)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes     | Description                                                                                      | Possible Values                                                       |
| ---------------------------- | -------------- | -------- | -------------- | ------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                           |                                                                       |
| `locator`                    | `char(26)`     | **no**   | `PK`           | Unique identifier of the first notice of loss or FNOL (UUID)                                     |                                                                       |
| `type`                       | `varchar(128)` | **no**   |                | The configured type of the FNOL                                                                  | *defined in configuration*                                            |
| `fnol_state`                 | `varchar(128)` | **no**   |                | Current state of the FNOL                                                                        | `draft`, `validated`, `onClaim`, `completed`, `rejected`, `discarded` |
| `account_locator`            | `char(26)`     | yes      | `Relationship` | Identifier of the account the FNOL is associated with (ULID), if any                             |                                                                       |
| `policy_locator`             | `char(26)`     | yes      | `Relationship` | Identifier of the policy the FNOL is associated with (ULID), if any                              |                                                                       |
| `segment_locator`            | `char(26)`     | yes      | `Relationship` | Identifier of the segment the FNOL is associated with (ULID), if any                             |                                                                       |
| `region`                     | `varchar(128)` | yes      |                | The region assigned to the FNOL, if any                                                          |                                                                       |
| `fnol_number`                | `varchar(128)` | yes      |                | The [custom number](/configuration/general-topics/entity-numbering) assigned to the FNOL, if any |                                                                       |
| `created_by`                 | `char(36)`     | **no**   |                | Identifier of the user that created the FNOL (UUID)                                              |                                                                       |
| `created_at_utc`             | `datetime(6)`  | **no**   |                | Time in UTC the FNOL was created                                                                 |                                                                       |
| `updated_by`                 | `char(36)`     | yes      |                | Identifier of the user that last updated the FNOL (UUID)                                         |                                                                       |
| `updated_at_utc`             | `datetime(6)`  | yes      |                | Time in UTC the FNOL was last updated                                                            |                                                                       |
| `incident_time_utc`          | `datetime(6)`  | yes      |                | Time in UTC when the incident occurred                                                           |                                                                       |
| `incident_timezone`          | `varchar(126)` | yes      |                | Timezone in which the incident occurred                                                          |                                                                       |
| `incident_summary`           | `longtext`     | yes      |                | Summary description of the incident                                                              |                                                                       |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                               |                                                                       |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                          |                                                                       |

**Relationships:**

* `account_locator` → `accounts.locator` (`many-to-one`)
* `policy_locator` → `policies.locator` (`many-to-one`)
* `segment_locator` → `segments.locator` (`many-to-one`)

***

<span id="fnol_data_extensions" />

fnol_data_extensions [#fnol_data_extensions]

**API Reference:** [FNOL API](/api/claims)

**Primary Key:** `tenant_locator`, `fnol_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                          | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------------------------ | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                               |                            |
| `fnol_locator`               | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the FNOL the extension data is associated with (ULID)                  |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                     |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                               | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                        |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                   |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                              |                            |

**Relationships:**

* `fnol_locator` → `fnols.locator` (`many-to-one`)

***

<span id="claims" />

claims [#claims]

**API Reference:** [FNOL API](/api/claims)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes     | Description                                                | Possible Values            |
| ---------------------------- | -------------- | -------- | -------------- | ---------------------------------------------------------- | -------------------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                     |                            |
| `locator`                    | `char(26)`     | **no**   | `PK`           | Unique identifier of the claim (ULID)                      |                            |
| `type`                       | `varchar(128)` | **no**   |                | The configured type of the claim                           | *defined in configuration* |
| `fnol_locator`               | `char(26)`     | yes      | `Relationship` | Identifier of the FNOL the claim is associated with (ULID) |                            |
| `created_by`                 | `char(36)`     | **no**   |                | Identifier of the user that created the claim (UUID)       |                            |
| `created_at_utc`             | `datetime(6)`  | **no**   |                | Time in UTC the claim was created                          |                            |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                | Time in UTC the record was created                         |                            |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                    |                            |

**Relationships:**

* `fnol_locator` → `fnols.locator` (`many-to-one`)

***

<span id="claim_data_extensions" />

claim_data_extensions [#claim_data_extensions]

**API Reference:** [FNOL API](/api/claims)

**Primary Key:** `tenant_locator`, `claim_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                          | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------------------------ | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                               |                            |
| `claim_locator`              | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the claim the extension data is associated with (ULID)                 |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                     |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the [extension data ](/configuration/data-extensions/overview) field | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extensions data field                                               | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | yes      |                      | Indicates whether the record has been deleted                                        |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                   |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                              |                            |

**Relationships:**

* `claim_locator` → `claims.locator` (`many-to-one`)

***

Producer Management Tables [#producer-management-tables]

* [producers](#producers)
* [producer\_data\_extensions](#producer_data_extensions)
* [producer\_hierarchy](#producer_hierarchy)
* [producer\_codes](#producer_codes)
* [producer\_code\_data\_extensions](#producer_code_data_extensions)

<span id="producers" />

producers [#producers]

**API Reference:** [Producer Management API](/api/producer-management)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type          | Nullable | Attributes     | Description                                                 | Possible Values                                           |
| ---------------------------- | ------------- | -------- | -------------- | ----------------------------------------------------------- | --------------------------------------------------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`           | Unique identifier of the tenant (UUID)                      |                                                           |
| `locator`                    | `char(26)`    | **no**   | `PK`           | Unique identifier of the producer (ULID)                    |                                                           |
| `producer_state`             | `varchar(50)` | **no**   |                | Current state of the producer                               | `draft`, `validated`, `suspended`, `discarded`, `retired` |
| `producer_type`              | `varchar(50)` | **no**   |                | The configured type of the producer                         | *defined in configuration*                                |
| `parent_locator`             | `char(26)`    | yes      | `Relationship` | Identifier of the producer's parent producer (ULID), if any |                                                           |
| `created_by`                 | `char(36)`    | **no**   |                | Identifier of the user that created the producer (UUID)     |                                                           |
| `created_time_utc`           | `datetime(6)` | **no**   |                | Time in UTC the producer was created                        |                                                           |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                | Time in UTC the record was created                          |                                                           |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`        | Time in UTC the record was last updated                     |                                                           |

**Relationships:**

* `parent_locator` → `producers.locator` (`many-to-one`)

***

<span id="producer_data_extensions" />

producer_data_extensions [#producer_data_extensions]

**API Reference:** [Producer Management API](/api/producer-management)

**Primary Key:** `tenant_locator`, `producer_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                              | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | -------------------------------------------------------------------------------------------------------- | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                   |                            |
| `producer_locator`           | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the [producer](/features/producer-management/producers) the data is associated with (ULID) |                            |
| `producer_type`              | `varchar(50)`   | **no**   |                      | The configured type of the producer                                                                      | *defined in configuration* |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                                         |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the extension data field                                                                 | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extension data field                                                                    | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | **no**   |                      | Indicates whether the record has been deleted                                                            |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                       |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                  |                            |

**Relationships:**

* `producer_locator` → `producers.locator` (`many-to-one`)

***

<span id="producer_hierarchy" />

producer_hierarchy [#producer_hierarchy]

**API Reference:** [Producer Management API](/api/producer-management)

**Primary Key:** `tenant_locator`, `parent_locator`, `child_locator`

| Column Name                  | Type          | Nullable | Attributes           | Description                                                                  | Possible Values |
| ---------------------------- | ------------- | -------- | -------------------- | ---------------------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                       |                 |
| `parent_locator`             | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the parent producer in the hierarchy (ULID)                    |                 |
| `child_locator`              | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the child producer in the hierarchy (ULID)                     |                 |
| `depth`                      | `int(11)`     | **no**   |                      | The number of levels between the parent and child producers in the hierarchy |                 |
| `deleted`                    | `tinyint(1)`  | **no**   |                      | Indicates whether the record has been deleted                                |                 |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                      | Time in UTC the record was created                                           |                 |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`              | Time in UTC the record was last updated                                      |                 |

**Relationships:**

* `parent_locator` → `producers.locator` (`many-to-one`)
* `child_locator` → `producers.locator` (`many-to-one`)

***

<span id="producer_codes" />

producer_codes [#producer_codes]

**API Reference:** [Producer Management API](/api/producer-management)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type           | Nullable | Attributes     | Description                                                                                                       | Possible Values                                           |
| ---------------------------- | -------------- | -------- | -------------- | ----------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`           | Unique identifier of the tenant (UUID)                                                                            |                                                           |
| `locator`                    | `char(26)`     | **no**   | `PK`           | Unique identifier of the producer code (ULID)                                                                     |                                                           |
| `producer_locator`           | `char(26)`     | **no**   | `Relationship` | Identifier of the [producer](/features/producer-management/producers) the producer code is associated with (ULID) |                                                           |
| `producer_code_state`        | `varchar(30)`  | **no**   |                | Current state of the producer code                                                                                | `draft`, `validated`, `suspended`, `discarded`, `retired` |
| `producer_code_type`         | `varchar(50)`  | **no**   |                | The configured type of the producer code                                                                          | *defined in configuration*                                |
| `producer_code`              | `varchar(128)` | yes      |                | The code value assigned to the producer code (if any)                                                             |                                                           |
| `created_by`                 | `char(36)`     | **no**   |                | Identifier of the user that created the producer code (UUID)                                                      |                                                           |
| `created_time_utc`           | `datetime(6)`  | **no**   |                | Time in UTC the producer code was created                                                                         |                                                           |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                | Time in UTC the record was created                                                                                |                                                           |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`        | Time in UTC the record was last updated                                                                           |                                                           |

**Relationships:**

* `producer_locator` → `producers.locator` (`many-to-one`)

***

<span id="producer_code_data_extensions" />

producer_code_data_extensions [#producer_code_data_extensions]

**API Reference:** [Producer Management API](/api/producer-management)

**Primary Key:** `tenant_locator`, `producer_code_locator`, `field_name_md5`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                                   | Possible Values            |
| ---------------------------- | --------------- | -------- | -------------------- | ------------------------------------------------------------------------------------------------------------- | -------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                                        |                            |
| `producer_code_locator`      | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the [producer code](/features/producer-management/producers) the data is associated with (ULID) |                            |
| `producer_code_type`         | `varchar(50)`   | **no**   |                      | The configured type of the producer code                                                                      | *defined in configuration* |
| `producer_code`              | `varchar(128)`  | yes      |                      | The code value assigned to the producer code (if any)                                                         |                            |
| `field_name_md5`             | `char(32)`      | **no**   | `PK`                 | The MD5 hash of the `field_name`                                                                              |                            |
| `field_name`                 | `varchar(4096)` | **no**   |                      | The key name of the extension data field                                                                      | *defined in configuration* |
| `field_value`                | `varchar(1024)` | yes      |                      | The value of the extension data field                                                                         | *defined in configuration* |
| `deleted`                    | `tinyint(1)`    | **no**   |                      | Indicates whether the record has been deleted                                                                 |                            |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                                            |                            |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                                       |                            |

**Relationships:**

* `producer_code_locator` → `producer_codes.locator` (`many-to-one`)

***

Work Management Tables [#work-management-tables]

* [tasks](#tasks)
* [task\_history](#task_history)
* [task\_references](#task_references)
* [user\_associations](#user_associations)
* [user\_association\_history](#user_association_history)
* [user\_qualifications](#user_qualifications)

<span id="tasks" />

tasks [#tasks]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                  | Type            | Nullable | Attributes | Description                                                                                      | Possible Values                                    |
| ---------------------------- | --------------- | -------- | ---------- | ------------------------------------------------------------------------------------------------ | -------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                                           |                                                    |
| `locator`                    | `char(26)`      | **no**   | `PK`       | Unique identifier of the task (ULID)                                                             |                                                    |
| `task_category`              | `varchar(128)`  | **no**   |            | The configured category of the task                                                              |                                                    |
| `task_type`                  | `varchar(128)`  | **no**   |            | The configured type of the task                                                                  | *defined in configuration*                         |
| `task_state`                 | `varchar(128)`  | **no**   |            | Current state of the task                                                                        | `active`, `pastDeadline`, `completed`, `cancelled` |
| `description`                | `varchar(2048)` | yes      |            | The description of the task, if any                                                              |                                                    |
| `task_number`                | `varchar(128)`  | yes      |            | The [custom number](/configuration/general-topics/entity-numbering) assigned to the task, if any |                                                    |
| `deadline_time_utc`          | `datetime(6)`   | yes      |            | Time in UTC of the task deadline                                                                 |                                                    |
| `assigned_to`                | `char(36)`      | yes      |            | Identifier of the user that the task is assigned to (UUID)                                       |                                                    |
| `completed_by`               | `char(36)`      | yes      |            | Identifier of the user that completed the task (UUID)                                            |                                                    |
| `completed_time_utc`         | `datetime(6)`   | yes      |            | Time in UTC the task was completed                                                               |                                                    |
| `created_by`                 | `char(36)`      | **no**   |            | Identifier of the user that created the task (UUID)                                              |                                                    |
| `created_time_utc`           | `datetime(6)`   | **no**   |            | Time in UTC the task was created                                                                 |                                                    |
| `updated_by`                 | `char(36)`      | yes      |            | Identifier of the user that last updated the task (UUID)                                         |                                                    |
| `updated_time_utc`           | `datetime(6)`   | yes      |            | Time in UTC the task was last updated                                                            |                                                    |
| `source`                     | `varchar(128)`  | yes      |            | Source of the task                                                                               |                                                    |
| `tag`                        | `varchar(128)`  | yes      |            | Tag of the task                                                                                  |                                                    |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |            | Time in UTC the record was created                                                               |                                                    |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`    | Time in UTC the record was last updated                                                          |                                                    |

***

<span id="task_history" />

task_history [#task_history]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `task_locator`, `history_locator`

| Column Name                  | Type            | Nullable | Attributes           | Description                                                                                   | Possible Values                                    |
| ---------------------------- | --------------- | -------- | -------------------- | --------------------------------------------------------------------------------------------- | -------------------------------------------------- |
| `tenant_locator`             | `char(36)`      | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                                        |                                                    |
| `task_locator`               | `char(26)`      | **no**   | `PK`, `Relationship` | Identifier of the task this history record belongs to (ULID)                                  |                                                    |
| `history_locator`            | `char(26)`      | **no**   | `PK`                 | Unique identifier of this history record of the task (ULID)                                   |                                                    |
| `task_state`                 | `varchar(128)`  | **no**   |                      | State of the task as of this history record                                                   | `active`, `pastDeadline`, `completed`, `cancelled` |
| `description`                | `varchar(2048)` | yes      |                      | The description of the task as of this history record, if any                                 |                                                    |
| `assigned_to`                | `char(36)`      | yes      |                      | Identifier of the user the task was assigned to as of this history record (UUID)              |                                                    |
| `deadline_time_utc`          | `datetime(6)`   | yes      |                      | Time in UTC of the task deadline as of this history record                                    |                                                    |
| `created_by`                 | `char(36)`      | **no**   |                      | Identifier of the user that created the task (UUID)                                           |                                                    |
| `created_time_utc`           | `datetime(6)`   | **no**   |                      | Time in UTC the task was created                                                              |                                                    |
| `updated_by`                 | `char(36)`      | yes      |                      | Identifier of the user that made this update (UUID)                                           |                                                    |
| `updated_time_utc`           | `datetime(6)`   | yes      |                      | Time in UTC this history record was recorded                                                  |                                                    |
| `completed_by`               | `char(36)`      | yes      |                      | Identifier of the user that completed the task, if completed as of this history record (UUID) |                                                    |
| `completed_time_utc`         | `datetime(6)`   | yes      |                      | Time in UTC the task was completed, if completed as of this history record                    |                                                    |
| `source`                     | `varchar(128)`  | yes      |                      | Source of the task                                                                            |                                                    |
| `tag`                        | `varchar(128)`  | yes      |                      | Tag of the task                                                                               |                                                    |
| `datalake_created_timestamp` | `datetime(6)`   | **no**   |                      | Time in UTC the record was created                                                            |                                                    |
| `datalake_updated_timestamp` | `datetime(6)`   | **no**   | `Index`              | Time in UTC the record was last updated                                                       |                                                    |

**Relationships:**

* `task_locator` → `tasks.locator` (`many-to-one`)

***

<span id="task_references" />

task_references [#task_references]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `task_locator`, `reference_locator`, `reference_type`

| Column Name                     | Type           | Nullable | Attributes            | Description                                                                                                        | Possible Values                                                                                                              |
| ------------------------------- | -------------- | -------- | --------------------- | ------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`                | `char(36)`     | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                                             |                                                                                                                              |
| `task_locator`                  | `char(26)`     | **no**   | `PK`, `Relationship`  | Identifier of the task associated with the referenced entity (ULID)                                                |                                                                                                                              |
| `reference_locator`             | `char(26)`     | **no**   | `PK`, `Relationship`  | Identifier of the entity associated with the task, with referenced entity defined by `reference_type` (ULID)       |                                                                                                                              |
| `reference_type`                | `varchar(128)` | **no**   | `PK`, `Discriminator` | Type of the associated entity, with possible values listed as `referenceType` in <ApiLink name="TaskReference" />  | `account`, `quickQuote`, `quote`, `policy`, `transaction`, `invoice`, `underwritingFlag`, `payment`, `quoteGroup`, `inquiry` |
| `underwriting_flag_entity_type` | `varchar(128)` | yes      |                       | If `reference_type` = `underwritingFlag`, this indicates whether the flag is associated with a `quote` or `policy` | `quote`, `policy`                                                                                                            |
| `deleted`                       | `tinyint(1)`   | **no**   |                       | Indicates whether the record has been deleted                                                                      |                                                                                                                              |
| `datalake_created_timestamp`    | `datetime(6)`  | **no**   |                       | Time in UTC the record was created                                                                                 |                                                                                                                              |
| `datalake_updated_timestamp`    | `datetime(6)`  | **no**   | `Index`               | Time in UTC the record was last updated                                                                            |                                                                                                                              |

**Relationships:**

* `task_locator` → `tasks.locator` (`many-to-one`)
* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `quote` → `quotes.locator` (`many-to-one`)
  * `quickQuote` → `quotes.quick_quote_locator` (`many-to-many`) *(no source table yet)*
  * `policy` → `policies.locator` (`many-to-one`)
  * `transaction` → `transactions.locator` (`many-to-one`)
  * `invoice` → `invoices.locator` (`many-to-one`)
  * `payment` → `payments.locator` (`many-to-one`)
  * `underwritingFlag` *(depends on `underwriting_flag_entity_type`)*:
    * `policy` → `policy_element_underwriting_flags.locator` (`many-to-one`)
    * `quote` → `quote_element_underwriting_flags.locator` (`many-to-one`)
  * `inquiry` → *(no table)*
  * `quoteGroup` → `quotes.group_locator` (`many-to-many`) *(no source table yet)*

***

<span id="user_associations" />

user_associations [#user_associations]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                     | Type           | Nullable | Attributes      | Description                                                                                                         | Possible Values                                                                                                              |
| ------------------------------- | -------------- | -------- | --------------- | ------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`                | `char(36)`     | **no**   | `PK`            | Unique identifier of the tenant (UUID)                                                                              |                                                                                                                              |
| `locator`                       | `char(26)`     | **no**   | `PK`            | Identifier of the user association record (ULID)                                                                    |                                                                                                                              |
| `user_locator`                  | `char(36)`     | **no**   |                 | Identifier of the user given the association (UUID)                                                                 |                                                                                                                              |
| `user_association_role`         | `varchar(128)` | **no**   |                 | The role given to the user as part of the association                                                               |                                                                                                                              |
| `user_association_state`        | `varchar(64)`  | **no**   |                 | The current state of the user association                                                                           | `active`, `completed`, `disassociated`, `discarded`                                                                          |
| `reference_locator`             | `char(26)`     | **no**   | `Relationship`  | Identifier of the entity that is part of the association, with referenced entity defined by `reference_type` (ULID) |                                                                                                                              |
| `reference_type`                | `varchar(128)` | **no**   | `Discriminator` | Type of the associated entity, with possible values listed as `referenceType` in <ApiLink name="UserAssociation" /> | `account`, `quickQuote`, `quote`, `policy`, `transaction`, `invoice`, `underwritingFlag`, `payment`, `quoteGroup`, `inquiry` |
| `underwriting_flag_entity_type` | `varchar(128)` | yes      |                 | If `reference_type` = `underwritingFlag`, this indicates whether the flag is associated with a `quote` or `policy`  | `quote`, `policy`                                                                                                            |
| `created_by`                    | `char(36)`     | **no**   |                 | Identifier of the user that created the user association (UUID)                                                     |                                                                                                                              |
| `created_time_utc`              | `datetime(6)`  | **no**   |                 | Time in UTC the user association was created                                                                        |                                                                                                                              |
| `updated_by`                    | `char(36)`     | yes      |                 | Identifier of the user that last updated the user association (UUID)                                                |                                                                                                                              |
| `updated_time_utc`              | `datetime(6)`  | yes      |                 | Time in UTC the user association was last updated                                                                   |                                                                                                                              |
| `datalake_created_timestamp`    | `datetime(6)`  | **no**   |                 | Time in UTC the record was created                                                                                  |                                                                                                                              |
| `datalake_updated_timestamp`    | `datetime(6)`  | **no**   | `Index`         | Time in UTC the record was last updated                                                                             |                                                                                                                              |

**Relationships:**

* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `quote` → `quotes.locator` (`many-to-one`)
  * `quickQuote` → `quotes.quick_quote_locator` (`many-to-many`) *(no source table yet)*
  * `policy` → `policies.locator` (`many-to-one`)
  * `transaction` → `transactions.locator` (`many-to-one`)
  * `invoice` → `invoices.locator` (`many-to-one`)
  * `payment` → `payments.locator` (`many-to-one`)
  * `underwritingFlag` *(depends on `underwriting_flag_entity_type`)*:
    * `policy` → `policy_element_underwriting_flags.locator` (`many-to-one`)
    * `quote` → `quote_element_underwriting_flags.locator` (`many-to-one`)
  * `inquiry` → *(no table)*
  * `quoteGroup` → `quotes.group_locator` (`many-to-many`) *(no source table yet)*

***

<span id="user_association_history" />

user_association_history [#user_association_history]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `user_association_locator`, `history_locator`

| Column Name                  | Type          | Nullable | Attributes           | Description                                                              | Possible Values                                     |
| ---------------------------- | ------------- | -------- | -------------------- | ------------------------------------------------------------------------ | --------------------------------------------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`                 | Unique identifier of the tenant (UUID)                                   |                                                     |
| `user_association_locator`   | `char(26)`    | **no**   | `PK`, `Relationship` | Identifier of the user association this history record belongs to (ULID) |                                                     |
| `history_locator`            | `char(26)`    | **no**   | `PK`                 | Unique identifier of this history record of the user association (ULID)  |                                                     |
| `user_locator`               | `char(36)`    | **no**   |                      | Identifier of the user given the association (UUID)                      |                                                     |
| `user_association_state`     | `varchar(64)` | **no**   |                      | State of the user association as of this history record                  | `active`, `completed`, `disassociated`, `discarded` |
| `created_by`                 | `char(36)`    | **no**   |                      | Identifier of the user that created the user association (UUID)          |                                                     |
| `created_time_utc`           | `datetime(6)` | **no**   |                      | Time in UTC the user association was created                             |                                                     |
| `updated_by`                 | `char(36)`    | yes      |                      | Identifier of the user that made this update (UUID)                      |                                                     |
| `updated_time_utc`           | `datetime(6)` | yes      |                      | Time in UTC this history record was recorded                             |                                                     |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |                      | Time in UTC the record was created                                       |                                                     |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`              | Time in UTC the record was last updated                                  |                                                     |

**Relationships:**

* `user_association_locator` → `user_associations.locator` (`many-to-one`)

***

<span id="user_qualifications" />

user_qualifications [#user_qualifications]

**API Reference:** [Work Management API](/api/work-management)

**Primary Key:** `tenant_locator`, `user_locator`, `qualification_category`, `qualification_level`

| Column Name                  | Type          | Nullable | Attributes | Description                                                             | Possible Values |
| ---------------------------- | ------------- | -------- | ---------- | ----------------------------------------------------------------------- | --------------- |
| `tenant_locator`             | `char(36)`    | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                  |                 |
| `user_locator`               | `char(36)`    | **no**   | `PK`       | Unique identifier of the user (UUID)                                    |                 |
| `qualification_category`     | `varchar(64)` | **no**   | `PK`       | The configured category of the qualification level assigned to the user |                 |
| `qualification_level`        | `varchar(64)` | **no**   | `PK`       | The qualification level assigned to the user                            |                 |
| `deleted`                    | `tinyint(1)`  | **no**   |            | Time in UTC the claim was created                                       |                 |
| `datalake_created_timestamp` | `datetime(6)` | **no**   |            | Time in UTC the record was created                                      |                 |
| `datalake_updated_timestamp` | `datetime(6)` | **no**   | `Index`    | Time in UTC the record was last updated                                 |                 |

***

Auxiliary Data Tables [#auxiliary-data-tables]

* [aux\_data](#aux_data)
* [diaries](#diaries)

<span id="aux_data" />

aux_data [#aux_data]

**API Reference:** [Aux Data API](/api/aux-data/aux-data)

**Primary Key:** `tenant_locator`, `locator`, `key_name`

| Column Name                  | Type           | Nullable | Attributes | Description                                                                                              | Possible Values                |
| ---------------------------- | -------------- | -------- | ---------- | -------------------------------------------------------------------------------------------------------- | ------------------------------ |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                                                   |                                |
| `locator`                    | `varchar(64)`  | **no**   | `PK`       | User-defined identifier for grouping auxiliary data keys (e.g., an entity locator or `global`)           |                                |
| `key_name`                   | `varchar(126)` | **no**   | `PK`       | Name of the auxiliary data key, unique within the given `locator`                                        |                                |
| `var_value`                  | `longtext`     | **no**   |            | Value assigned to the auxiliary data key, stored as text                                                 |                                |
| `ui_type`                    | `varchar(64)`  | **no**   |            | Indicates how the auxiliary data should appear in the UI; value may be `normal`, `readonly`, or `hidden` | `normal`, `hidden`, `readonly` |
| `created_time_utc`           | `datetime(6)`  | **no**   |            | Time in UTC the auxiliary data was created                                                               |                                |
| `updated_time_utc`           | `datetime(6)`  | **no**   |            | Time in UTC the auxiliary data was last updated                                                          |                                |
| `updated_by`                 | `char(36)`     | yes      |            | Identifier of the user who created the auxiliary data (UUID)                                             |                                |
| `expiration_time_utc`        | `datetime(6)`  | yes      |            | Time in UTC the auxiliary data expires                                                                   |                                |
| `aux_data_settings_name`     | `varchar(128)` | yes      |            | Name of the settings that apply to the auxiliary data                                                    |                                |
| `deleted`                    | `tinyint(1)`   | yes      |            | Indicates whether the record has been deleted                                                            |                                |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |            | Time in UTC the record was created                                                                       |                                |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`    | Time in UTC the record was last updated                                                                  |                                |

***

<span id="diaries" />

diaries [#diaries]

**API Reference:** [Diary API](/api/aux-data/diary)

**Primary Key:** `tenant_locator`, `locator`

| Column Name                     | Type           | Nullable | Attributes      | Description                                                                                                                 | Possible Values                                                                                                                           |
| ------------------------------- | -------------- | -------- | --------------- | --------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| `tenant_locator`                | `char(36)`     | **no**   | `PK`            | Unique identifier of the tenant (UUID)                                                                                      |                                                                                                                                           |
| `locator`                       | `char(26)`     | **no**   | `PK`            | Identifier of the diary entry                                                                                               |                                                                                                                                           |
| `reference_locator`             | `char(26)`     | **no**   | `Relationship`  | Identifier of the entity that is associated with the diary entry, with referenced entity defined by `reference_type` (ULID) |                                                                                                                                           |
| `reference_type`                | `varchar(32)`  | **no**   | `Discriminator` | Type of the associated entity, with possible values listed as `referenceType` in <ApiLink name="DiaryEntryResponse" />      | `quote`, `policy`, `transaction`, `task`, `fnol`, `invoice`, `account`, `underwritingFlag`, `payment`, `quoteGroup`, `inquiry`, `element` |
| `underwriting_flag_entity_type` | `varchar(128)` | yes      |                 | If `reference_type` = `underwritingFlag`, this indicates whether the flag is associated with a `quote` or `policy`          | `quote`, `policy`                                                                                                                         |
| `diary_state`                   | `varchar(50)`  | **no**   |                 | Current state of the diary, with possible values listed as `diaryState` in <ApiLink name="DiaryEntryResponse" />            | `active`, `discarded`                                                                                                                     |
| `diary_category`                | `varchar(256)` | yes      |                 | An optional category that can be given to a diary entry                                                                     |                                                                                                                                           |
| `contents`                      | `longtext`     | **no**   |                 | Contents of the diary entry, stored as text                                                                                 |                                                                                                                                           |
| `created_by`                    | `char(36)`     | **no**   |                 | Identifier of the user that created the diary entry (UUID)                                                                  |                                                                                                                                           |
| `created_time_utc`              | `datetime(6)`  | **no**   |                 | Time in UTC the diary entry was created                                                                                     |                                                                                                                                           |
| `updated_by`                    | `char(36)`     | **no**   |                 | Identifier of the user that last updated the diary entry (UUID)                                                             |                                                                                                                                           |
| `updated_time_utc`              | `datetime(6)`  | **no**   |                 | Time in UTC the diary entry was last updated                                                                                |                                                                                                                                           |
| `datalake_created_timestamp`    | `datetime(6)`  | **no**   |                 | Time in UTC the record was created                                                                                          |                                                                                                                                           |
| `datalake_updated_timestamp`    | `datetime(6)`  | **no**   | `Index`         | Time in UTC the record was last updated                                                                                     |                                                                                                                                           |

**Relationships:**

* `reference_locator` *(depends on `reference_type`)*:
  * `account` → `accounts.locator` (`many-to-one`)
  * `quote` → `quotes.locator` (`many-to-one`)
  * `policy` → `policies.locator` (`many-to-one`)
  * `transaction` → `transactions.locator` (`many-to-one`)
  * `invoice` → `invoices.locator` (`many-to-one`)
  * `payment` → `payments.locator` (`many-to-one`)
  * `fnol` → `fnols.locator` (`many-to-one`)
  * `task` → `tasks.locator` (`many-to-one`)
  * `underwritingFlag` *(depends on `underwriting_flag_entity_type`)*:
    * `policy` → `policy_element_underwriting_flags.locator` (`many-to-one`)
    * `quote` → `quote_element_underwriting_flags.locator` (`many-to-one`)
  * `quoteGroup` → `quotes.group_locator` (`many-to-many`) *(no source table yet)*
  * `inquiry` → *(no table)*
  * `element`:
    * `quote_elements.locator` (`many-to-one`)
    * `policy_segment_elements.static_locator` (`many-to-many`)

***

Moratoriums Tables [#moratoriums-tables]

* [moratoriums](#moratoriums)
* [moratorium\_elections](#moratorium_elections)
* [moratorium\_statuses](#moratorium_statuses)

<span id="moratoriums" />

moratoriums [#moratoriums]

**API Reference:** [Moratoriums API](/api/moratoriums)

**Primary Key:** `tenant_locator`, `moratorium_name`

| Column Name                  | Type           | Nullable | Attributes | Description                                                                                                                                                      | Possible Values                |
| ---------------------------- | -------------- | -------- | ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------ |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`       | Unique identifier of the tenant (UUID)                                                                                                                           |                                |
| `moratorium_name`            | `varchar(128)` | **no**   | `PK`       | Unique name of the moratorium                                                                                                                                    |                                |
| `moratorium_type`            | `varchar(128)` | **no**   |            | The type of the moratorium                                                                                                                                       | *defined in configuration*     |
| `description`                | `varchar(512)` | yes      |            | The description of the moratorium                                                                                                                                |                                |
| `application_mode`           | `varchar(128)` | **no**   |            | Indicates whether the moratorium applies to all eligible policies or whether there is an option to opt in or out. Value may be `mandatory`, `optIn`, or `optOut` | `mandatory`, `optIn`, `optOut` |
| `effective_time_utc`         | `datetime(6)`  | **no**   |            | Time in UTC the moratorium takes effect                                                                                                                          |                                |
| `end_time_utc`               | `datetime(6)`  | yes      |            | Time in UTC the moratorium ends                                                                                                                                  |                                |
| `is_effective_time_waived`   | `tinyint(1)`   | yes      |            | Indicates whether eligible policies issued after the moratorium effective time are affected                                                                      |                                |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |            | Time in UTC the record was created                                                                                                                               |                                |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   |            | Time in UTC the record was last updated                                                                                                                          |                                |

***

<span id="moratorium_elections" />

moratorium_elections [#moratorium_elections]

**API Reference:** [Moratoriums API](/api/moratoriums)

**Primary Key:** `tenant_locator`, `entity_type`, `entity_locator`, `moratorium_name`

| Column Name                  | Type           | Nullable | Attributes            | Description                                                                                      | Possible Values   |
| ---------------------------- | -------------- | -------- | --------------------- | ------------------------------------------------------------------------------------------------ | ----------------- |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                           |                   |
| `moratorium_name`            | `varchar(128)` | **no**   | `PK`, `Relationship`  | Unique name of the moratorium                                                                    |                   |
| `entity_type`                | `varchar(128)` | **no**   | `PK`, `Discriminator` | The type of the entity associated with the moratorium election. Value may be `quote` or `policy` | `quote`, `policy` |
| `entity_locator`             | `char(26)`     | **no**   | `PK`, `Relationship`  | The locator of the entity associated with the moratorium election (ULID)                         |                   |
| `election`                   | `varchar(128)` | **no**   |                       | The election made for the moratorium. Value may be `optIn` or `optOut`                           | `optIn`, `optOut` |
| `is_deleted`                 | `tinyint(1)`   | **no**   |                       | Indicates whether the record has been deleted                                                    |                   |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                       | Time in UTC the record was created                                                               |                   |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`               | Time in UTC the record was last updated                                                          |                   |

**Relationships:**

* `moratorium_name` → `moratoriums.moratorium_name` (`many-to-one`)
* `entity_locator` *(depends on `entity_type`)*:
  * `policy` → `policies.locator` (`many-to-one`)
  * `quote` → `quotes.locator` (`many-to-one`)

***

<span id="moratorium_statuses" />

moratorium_statuses [#moratorium_statuses]

**API Reference:** [Moratoriums API](/api/moratoriums)

**Primary Key:** `tenant_locator`, `moratorium_name`, `entity_type`, `entity_locator`

| Column Name                  | Type           | Nullable | Attributes            | Description                                                                                                                                                      | Possible Values                |
| ---------------------------- | -------------- | -------- | --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------ |
| `tenant_locator`             | `char(36)`     | **no**   | `PK`                  | Unique identifier of the tenant (UUID)                                                                                                                           |                                |
| `moratorium_name`            | `varchar(128)` | **no**   | `PK`, `Relationship`  | Unique name of the moratorium                                                                                                                                    |                                |
| `entity_type`                | `varchar(128)` | **no**   | `PK`, `Discriminator` | The type of the entity associated with the moratorium status. Value may be `quote` or `policy`                                                                   | `quote`, `policy`              |
| `entity_locator`             | `char(26)`     | **no**   | `PK`, `Relationship`  | The locator of the entity associated with the moratorium status (ULID)                                                                                           |                                |
| `is_applicable`              | `tinyint(1)`   | **no**   |                       | Indicates whether the moratorium is applicable to the associated entity                                                                                          |                                |
| `is_eligible`                | `tinyint(1)`   | **no**   |                       | Indicates whether the associated entity is eligible for the moratorium                                                                                           |                                |
| `is_in_scope`                | `tinyint(1)`   | **no**   |                       | Indicates whether the associated entity is governed by the moratorium based on both applicability and eligibility                                                |                                |
| `application_mode`           | `varchar(128)` | **no**   |                       | Indicates whether the moratorium applies to all eligible policies or whether there is an option to opt in or out. Value may be `mandatory`, `optIn`, or `optOut` | `mandatory`, `optIn`, `optOut` |
| `datalake_created_timestamp` | `datetime(6)`  | **no**   |                       | Time in UTC the record was created                                                                                                                               |                                |
| `datalake_updated_timestamp` | `datetime(6)`  | **no**   | `Index`               | Time in UTC the record was last updated                                                                                                                          |                                |

**Relationships:**

* `moratorium_name` → `moratoriums.moratorium_name` (`many-to-one`)
* `entity_locator` *(depends on `entity_type`)*:
  * `policy` → `policies.locator` (`many-to-one`)
  * `quote` → `quotes.locator` (`many-to-one`)

***

See Also [#see-also]

* [Reporting Overview](/features/reporting/reporting-overview)
* [Data Lake Data Model](/features/reporting/data-model)
* [Data Lake Database](/features/reporting/datalake)
* [Data Lake Delta Files](/features/reporting/delta-files)
