Skip to main content
Starting with the next release, HDB updates will be identified by release date only — no more version numbers. This makes it easier to see at a glance when a change shipped. Release notes will continue to live in this section, dated in YYYY-MM-DD form.
This release deletes visit-note records consistently across bill, bill_item, and bill_item_dx, exposes a unified is_deleted flag on each of those tables, and retires a handful of columns that are no longer populated.

​
Schema Changes

TableChange
billadded is_deleted column
bill_itemadded is_deleted column
bill_itemdeprecated — deletion_time and deleted_by_user_id are now always NULL and will be removed in a future release
bill_item_dxadded is_deleted column
bill_item_dxdeprecated — icd9_code, bill_item_deletion_time, and deletelog_id are now always NULL and will be removed in a future release

​
Release Highlights

Visit-note deletions now propagate to bills When a visit note is deleted, the bill (bill), its line items (bill_item), and the diagnosis codes on those line items (bill_item_dx) are now flagged as deleted along with it. Previously each table tracked deletion independently, so a deleted visit note could still appear to have live bills and CPT/DX rows. is_deleted on bill, bill_item, and bill_item_dx A new boolean is_deleted column is now available on all three tables. Filter on is_deleted = false to scope queries to live records: 
select *
from bill
where is_deleted = false
For bill_item, the flag is true when the line item itself was deleted or when the parent bill is deleted. For bill_item_dx, the flag is true when the diagnosis row was deleted or when the parent bill item is deleted. Deprecated columns on bill_item The following columns are deprecated and now always return NULL. They remain in the schema for backwards compatibility and will be removed in a future release — migrate any queries that depend on them.
  • bill_item.deletion_time — superseded by bill_item.is_deleted.
  • bill_item.deleted_by_user_id — superseded by bill_item.is_deleted.
Deprecated columns on bill_item_dx The following columns are deprecated and now always return NULL. They remain in the schema for backwards compatibility and will be removed in a future release — migrate any queries that depend on them.
  • bill_item_dx.icd9_code — ICD-9 codes have not been used by Elation in production billing for many years; only icd10_code is populated going forward.
  • bill_item_dx.bill_item_deletion_time — superseded by bill_item_dx.is_deleted.
  • bill_item_dx.deletelog_id — superseded by bill_item_dx.is_deleted.
If you have existing queries that filter on bill_item.deleted_by_user_id is null, bill_item_dx.deletelog_id is null, or bill_item_dx.bill_item_deletion_time is null to exclude deleted records, update them to use is_deleted = false. See the Visit Notes and Bills article for an updated example query.
If you have any questions about this topic please reach out to Elation Support Portal with the subject line HDB - <your_question>