6.77.2 Schema Changes

Schema changes between CareRight V6.77.1 and 6.77.2

New Tables/Views

  • v_account_statements


New Columns

TableColumn

episodes

qhapdc_funding_source

branding_settingscustom_layout_name
receiptsreversal_timestamp
refundsreversal_timestamp






Changed Views

  • v_ledger - adds missing Receipt Reversals
  • v_relationships - adds email column
  • v_refunds - adds effective_date, refund_id as an explicit column
  • v_receipts - adds effective_date, receipt_id as an explicit column
  • v_transactions - adds user id

Changed Columns

  • None

Deleted Tables

  • None

Deleted Columns

  • tyro_terminals - idx_tyro_terminals_unique
  • staff_members - primary_location_id