> For the complete documentation index, see [llms.txt](https://support.pears.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.pears.io/updates/data-mart-changelog/deprecations.md).

# Deprecated Tables and Columns

Every deprecated table and column in the PEARS data mart, when it was marked deprecated, and when it was removed.

This page is the full register of data mart deprecations: every table and column that has been marked deprecated, the release that marked it, and the release that removed it. A dash in the **Removed** column means the object is still in your data mart today.

Objects removed more than six months ago are dropped from this page. The changelog entry for the release that removed them keeps the record.

A deprecated object is kept for backward compatibility and is no longer maintained by PEARS. Remove references to it before it is deleted, because once it is gone any query still using it fails. Every version below links to that release's entry in the [Data Mart Changelog](/updates/data-mart-changelog.md), which covers the release in full and names what to use in place of each deprecated object.

## Deprecated Tables

Grouped by the PEARS module the table belongs to.

| Module           | Table                                | Deprecated                                                                                                         | Removed                                                                                                            |
| ---------------- | ------------------------------------ | ------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------ |
| Community Events | `event_registration_invoice_history` | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| Community Events | `event_registration_invoice_item`    | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| Lists            | `list_payment_status`                | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) | —                                                                                                                  |

## Deprecated Columns

Grouped by table. Columns on a table that is itself deprecated are covered by that table's row above and are not repeated here.

| Table                        | Column                 | Deprecated                                                                                                         | Removed                                                                                                            |
| ---------------------------- | ---------------------- | ------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------ |
| `crm_interaction`            | `interaction_datetime` | 2026-09-10 ([26.15.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.15.0)) | —                                                                                                                  |
| `crm_interaction`            | `is_note_private`      | 2026-09-10 ([26.15.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.15.0)) | —                                                                                                                  |
| `crm_person`                 | `site_id`              | 2026-09-10 ([26.15.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.15.0)) | —                                                                                                                  |
| `event`                      | `cancelled_at`         | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) | —                                                                                                                  |
| `event`                      | `cancelled_by_user_id` | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) | —                                                                                                                  |
| `event_registration_invoice` | `event_discount_id`    | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `event_registration_invoice` | `payment_status_id`    | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `event_registration_invoice` | `payment_status_name`  | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `event_registration_invoice` | `response_json`        | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `event_registration_invoice` | `session_id`           | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `event_registration_invoice` | `transaction_id`       | 2026-07-01 ([26.9.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.9.0))   | 2026-09-01 ([26.14.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.14.0)) |
| `list_age`                   | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_assessment_approach`   | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_assessment_method`     | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_census_tract`          | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_communication_method`  | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_crisis`                | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_delivery_method`       | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_entity_type`           | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_ethnicity`             | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_form_element_type`     | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_gender`                | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_geographic_unit`       | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_intervention_channel`  | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_intervention_topic`    | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_jurisdiction`          | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_market_channel`        | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_market_reach_source`   | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_market_segment`        | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_primary_topic`         | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_question_type`         | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_question_widget`       | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_race`                  | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_reach_source`          | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_registration_type`     | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_sector_of_influence`   | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_setting`               | `is_active`            | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |
| `list_survey_use`            | `description`          | 2026-08-13 ([26.12.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.12.0)) | —                                                                                                                  |
| `site`                       | `state_abbreviation`   | 2026-08-13 ([26.12.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.12.0)) | —                                                                                                                  |
| `site`                       | `zip_code`             | 2026-08-11 ([26.11.0](https://support.pears.io/updates/data-mart-changelog/pages/btmyP4N2TzB1bJiVp11y#id-26.11.0)) | —                                                                                                                  |