For the complete documentation index, see llms.txt. This page is also available as Markdown.

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, 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)

2026-09-01 (26.14.0)

Community Events

event_registration_invoice_item

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

Lists

list_payment_status

2026-09-01 (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)

—

crm_interaction

is_note_private

2026-09-10 (26.15.0)

—

crm_person

site_id

2026-09-10 (26.15.0)

—

event

cancelled_at

2026-09-01 (26.14.0)

—

event

cancelled_by_user_id

2026-09-01 (26.14.0)

—

event_registration_invoice

event_discount_id

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

event_registration_invoice

payment_status_id

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

event_registration_invoice

payment_status_name

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

event_registration_invoice

response_json

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

event_registration_invoice

session_id

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

event_registration_invoice

transaction_id

2026-07-01 (26.9.0)

2026-09-01 (26.14.0)

list_age

is_active

2026-08-11 (26.11.0)

—

list_assessment_approach

is_active

2026-08-11 (26.11.0)

—

list_assessment_method

is_active

2026-08-11 (26.11.0)

—

list_census_tract

is_active

2026-08-11 (26.11.0)

—

list_communication_method

is_active

2026-08-11 (26.11.0)

—

list_crisis

is_active

2026-08-11 (26.11.0)

—

list_delivery_method

is_active

2026-08-11 (26.11.0)

—

list_entity_type

is_active

2026-08-11 (26.11.0)

—

list_ethnicity

is_active

2026-08-11 (26.11.0)

—

list_form_element_type

is_active

2026-08-11 (26.11.0)

—

list_gender

is_active

2026-08-11 (26.11.0)

—

list_geographic_unit

is_active

2026-08-11 (26.11.0)

—

list_intervention_channel

is_active

2026-08-11 (26.11.0)

—

list_intervention_topic

is_active

2026-08-11 (26.11.0)

—

list_jurisdiction

is_active

2026-08-11 (26.11.0)

—

list_market_channel

is_active

2026-08-11 (26.11.0)

—

list_market_reach_source

is_active

2026-08-11 (26.11.0)

—

list_market_segment

is_active

2026-08-11 (26.11.0)

—

list_primary_topic

is_active

2026-08-11 (26.11.0)

—

list_question_type

is_active

2026-08-11 (26.11.0)

—

list_question_widget

is_active

2026-08-11 (26.11.0)

—

list_race

is_active

2026-08-11 (26.11.0)

—

list_reach_source

is_active

2026-08-11 (26.11.0)

—

list_registration_type

is_active

2026-08-11 (26.11.0)

—

list_sector_of_influence

is_active

2026-08-11 (26.11.0)

—

list_setting

is_active

2026-08-11 (26.11.0)

—

list_survey_use

description

2026-08-13 (26.12.0)

—

site

state_abbreviation

2026-08-13 (26.12.0)

—

site

zip_code

2026-08-11 (26.11.0)

—

Last updated