2 ms·
If you just want to see the prices with the things, this is a more abbreviated query: SELECT `hospital_id`, `row_id`, `line_type`, `description`, `payer_catego
by MPSimmons 3y ago
If you just want to see the prices with the things, this is a more abbreviated query:
SELECT `hospital_id`, `row_id`, `line_type`, `description`, `payer_category`, `payer_name`, `standard_charge` FROM `rate`
Adding an 'order by' clause makes the query time out.
"CC" in many of the descriptions seems to mean "complications and comorbidity". "MCC" is Major Complication or Comorbidity. Some other abbreviations can be looked up here: https://www.asha.org/practice-portal/professional-issues/documentation-in-health-care/common-medical-abbreviations/ https://www.asha.org/practice-portal/professional-issues/doc...