v3.8.0 released 2018-12-20

v3.7.1 released 2018-08-27

v3.7.0 released 2018-04-24

v3.6.2 released 2018-02-02

v3.6.1 released 2017-08-02

v3.6.0 released 2017-07-17

v3.5.6 released 2016-07-18

New imaging workflow timestamps, expanded fact table and metric additions:

Details on the new metrics:

Metric Description Definition
send_delay delay from image acquisition to start of transmission to PACS rad_pacs_metadata.first_image - rad_pacs_metadata.dicom_end
acquisition_duration duration of image acquisition rad_pacs_metadata.dicom_end - rad_pacs_metadata.dicom_begin
order_begin_acquisition how long it took for the first image to be acquired after the order was placed rad_pacs_metadata.dicom_begin - rad_exam_times.order_arrival
order_end_acquisition how long it took for the entire study to be acquired after the order was placed rad_pacs_metadata.dicom_end - rad_exam_times.order_arrival
acquisition_wait total time patient waited for image acquisition to start after patient arrival rad_pacs_metadata.dicom_begin - rad_exam_times.sign_in
acquisition_delay how delayed image acquisition started compared to the appointment time rad_pacs_metadata.dicom_begin - rad_exam_times.appointment
acquisition_ready how long it took from image acquisition to end of transmission to PACS rad_pacs_metadata.last_image - rad_pacs_metadata.dicom_end
acquisition_first_report how long after image acquisition is complete for the first preliminary or final report to be rendered (the report_event time is from the first_report_id) rad_reports.report_event - rad_pacs_metadata.dicom_end
acquisition_first_prelim how long after image acquisition is complete for a preliminary report to be rendered (the report_event time is from the first_prelim_report_id) rad_reports.report_event - rad_pacs_metadata.dicom_end
acquisition_first_final how long after image acquisition is complete for a final report to be rendered (the report_event time is from the first_final_report_id) rad_reports.report_event - rad_pacs_metadata.dicom_end

v3.5.5 released 2016-05-05

Fact table and metric additions:

Details on the new metrics:

Metric Description Definition
transport how quickly a patient can be transported from the floor to radiology rad_exam_times.begin_exam - rad_exam_times.schedule_event
order_first_report how long after an order is placed for the first preliminary or final report to be rendered (the report_event time is from the first_report_id) rad_reports.report_event - rad_exam_times.order_arrival
order_first_prelim how long after an order is placed for a preliminary report to be rendered (the report_event time is from the first_prelim_report_id) rad_reports.report_event - rad_exam_times.order_arrival
order_first_final how long after an order is placed for a final report to be rendered (the report_event time is from the first_final_report_id) rad_reports.report_event - rad_exam_times.order_arrival
schedule_first_report how long after an exam is scheduled for the first preliminary or final report to be rendered (the report_event time is from the first_report_id) rad_reports.report_event - rad_exam_times.schedule_event
schedule_first_prelim how long after an exam is scheduled for a preliminary report to be rendered (the report_event time is from the first_prelim_report_id) rad_reports.report_event - rad_exam_times.schedule_event
schedule_first_final how long after an exam is scheduled for a final report to be rendered (the report_event time is from the first_final_report_id) rad_reports.report_event - rad_exam_times.schedule_event

v3.5.4 released 2016-04-19

NO SCHEMA CHANGES

v3.5.3 released 2016-03-22

v3.5.2 released 2016-03-09

NO SCHEMA CHANGES

improved: better documentation generation scripts

v3.5.1 released 2016-03-04

bugfix: app_tracking partition rules now include browser_ip

v3.5.0 released 2016-02-02

Condense procedures and resources to be unique to an external_system instead of site

v3.4.5 released 2016-01-14

NO SCHEMA CHANGES

improved: modernization and enhancements to ICD and HCPCS loading scripts

v3.4.4 released 2015-12-16

bugfix: added missing FK constraint for rad_exam_facts.procedure_id

v3.4.3 released 2015-12-07

new: added compact_array function for next-gen Quality/Productivity app performance improvement

v3.4.2 released 2015-11-17

v3.4.1 released 2015-09-15

NO SCHEMA CHANGES

improvement: Scripting improvements for documentation generation:

v3.4.0 released 2015-09-09

Changed procedure volume_countable, new patient_age cols, documentation schema expansion, app usage tracking, and data quality tracking

v3.3.1 released 2014-12-10

new: added columns to procedures for pro and tech fees

v3.3.0 released 2014-11-24

new: metric and fact table expansion rad_exam_facts updates and additions:

Additional changes:

v3.2.4 released 2014-10-29

NO SCHEMA CHANGES

improvement: scripting and maintenance enhancements

v3.2.3 released 2014-10-17

NO SCHEMA CHANGES

improvement: scripting and maintenance enhancements

v3.2.2 released 2014-09-02

NO SCHEMA CHANGES

improvement: scripting and maintenance enhancements

v3.2.1 released 2014-08-29

NO SCHEMA CHANGES

improvement: scripting and maintenance enhancements

v3.2.0 released 2014-07-07

v3.1.3 released 2014-06-25

v3.1.2 released 2014-06-17

v3.1.1 released 2014-05-05

new added timestamp columns to rad_exam_times and rad_pacs_metadata:

new: rad_exam_metric and rad_exam_fact cols based on new timestamps:

Metric Description Definition
order_first_image how long it took for the first image to be available after the order was placed rad_pacs_metadata.first_image - rad_exam_times.order_arrival`
order_last_image how long it took for the entire study to be available after the order was placed rad_pacs_metadata.last_image - rad_exam_times.order_arrival`
first_image_prelim how long after the first image was available for a preliminary report to be rendered (the report_event time is from the first_prelim_report_id) rad_reports.report_event - rad_pacs_metadata.first_image
last_image_prelim how long after the entire study was available for a preliminary report to be rendered (the report_event time is from the first_prelim_report_id) rad_reports.report_event - rad_pacs_metadata.last_image
first_image_final how long after the first image was available for a final report to be rendered (the report_event time is from the first_final_report_id) rad_reports.report_event - rad_pacs_metadata.first_image
last_image_final how long after the entire study was available for a final report to be rendered (the report_event time is from the first_final_report_id) rad_reports.report_event - rad_pacs_metadata.last_image
end_exam_first_image delay from when study was completed to when image transmission began rad_pacs_metadata.first_image - rad_exam_times.end_exam
end_exam_last_image delay from when study was completed to when entire exam was available for interpretation rad_pacs_metadata.last_image - rad_exam_times.end_exam
send_duration duration of transmitting the entire study to PACS (implicitly omits send time for first image) rad_pacs_metadata.last_image - rad_pacs_metadata.first_image

Other updates:

v3.1.0 released 2014-04-30

new: added rad_exam_facts fact table to support analytics / business intelligence apps:

v3.0.7 released 2014-04-30

improvement: 2.x-3.x upgrade and documentation scripts

v3.0.6 released 2014-04-22

improvement: 2.x-3.x upgrade and documentation scripts

v3.0.5 released 2014-04-07

improvement: 2.x-3.x upgrade and documentation scripts

v3.0.4 released 2014-04-03

new: added universal_event_types values for finance model

v3.0.3 released 2014-03-31

new: added message documentation for finance messages

v3.0.2 released 2014-03-27

v3.0.1 released 2014-03-25

new: added rad_reports.report_impression column from v2.4.0

v3.0.0 released 2014-03-18

This is a major update to the data model which renames and adds many things, with the primary focus being the addition of a finance data model domain.

Altered Tables

Procedures and HCPCS Codes

References to CPT have been replaced w/ HCPCS. HCPCS is a superset of CPT.

Having said all that, you need to know if a particular site is a facility or non-facility, as well as the GPCI constants to calculate the CMS fee

Finally: this is only regarding CMS fees (and skips several obscure rules about outpatient imaging, specific CPT codes, etc.). Radiologist professional RVU is still tied to CPT (and is now called cms_hcpcs.work_rvu), however since fees moved to procedure-level, RVU is now duplicated there also. This should further simplify providing RVU for 1:N-CPT-mapped procedures.

Billing Data Model

The new, universal billing model is based on the fundamental table claims, a summary containing the claim/invoice number and a foreign key to the most recent claim_transactions (which are the detailed, individual transactions records).

ICD Codes

Diagnosis codes have been a long-requested feature, and are now included for charge data and to expand patient visit information.

Other New Tables

v2.4.0 released 2014-03-25

added new column rad_reports.report_impression to enable new radiology report functionality

v2.3.27 released 2014-01-14

updated residents table to allow NULL values in columns

v2.3.26 released 2014-01-07

New TRIP status for additional workflow step, revised descriptions to be more concise

v2.3.25 released 2013-11-10

updated documentation for new data manager messages

v2.3.24 released 2013-10-28

New TRIP statuses for more workflow steps

v2.3.23 released 2013-08-13

documentation for data manager messaging now up-to-date

v2.3.22 released 2013-08-08

documentation for data manager messaging now included

v2.3.21 released 2013-08-06

v2.3.20 released 2013-07-25

expanded data manager infrastructure to support future features

v2.3.19 released 2013-07-22

improved scripts to generate schema documentation with SchemaSpy

v2.3.18 released 2013-07-22

added scripts to generate schema documentation with SchemaSpy

v2.3.17 released 2013-07-03

added new clinical roles for employee mappings

v2.3.16 released 2013-07-01

v2.3.15 released 2013-06-30

v2.3.14 released 2013-06-30

v2.3.13 released 2013-06-14

v2.3.12 released 2013-05-24

added additional indexes for performance

v2.3.11 released 2013-03-29

removed foreign key constraint from people.current_employee_id to avoid recusion problems when creating new people and employees

v2.3.10 released 2013-03-15

updated scripts used for new installs

v2.3.9 released 2013-03-13

v2.3.8 released 2013-03-13

v2.3.7 released 2013-03-07

v2.3.6 released 2013-03-07

v2.3.5 released 2013-02-28

v2.3.3 released 2013-02-28

v2.3.2 released 2013-02-28

v2.3.1 released 2013-02-28

v2.3.0 released 2013-02-27

v2.2.2 released 2013-02-25

added additional indexes for performance

v2.2.1 released 2013-02-13

fixed read-only used by SDK

v2.2.0 released 2013-02-13

added read-only used by SDK

v2.1.6 released 2013-01-31

added additional indexes for performance

v2.1.5 released 2013-01-31

added additional indexes for performance

v2.1.4 released 2013-01-31

added additional indexes for performance

v2.1.3 released 2013-01-10

added additional indexes for performance

v2.1.2 released 2012-12-28

added rad_exams.visit_id foreign key

v2.1.1 released 2012-12-20

added additional indexes for performance

v2.1.0 released 2012-12-18

added additional indexes for performance

v2.0.1 released 2012-12-03

rad_exam_metrics columns changed from integer to bigint

v2.0.0 released 2012-11-02

major changes from 1.x data model