Answers 100% Solved
What are five commonly needed multiple response tables? - ✔✔RX_MED_CLS_PHRM
This table contains medications' pharmaceutical classes.
RX_MED_CLS_THERA
This table contains medications' therapeutic classes.
RX_MED_SUBCLS
This table contains the pharmacological sub classes.
RX_MED_GEN_NAME
This table contains the simple generic name.
RX_MED_ATC
This table contains the Anatomical Therapeutic Chemical Classifications (ATC)
associated with this medication. This identifier is particularly important for
reporting outside of the United States.
This table contains medications' pharmaceutical classes. - ✔✔RX_MED_CLS_PHRM
This table contains the Anatomical Therapeutic Chemical Classifications (ATC) associated with
this
,medication. This identifier is particularly important for reporting outside of the United States.
-
✔✔RX_MED_ATC
This table contains the simple generic name. - ✔✔RX_MED_GEN_NAME
This table contains medications' therapeutic classes. - ✔✔RX_MED_CLS_THERA
This table contains the pharmacological sub classes. - ✔✔RX_MED_SUBCLS
when reporting on medication usage, ___________ and _____________ are irrelevant -
✔✔strength
form
why is it not a good idea to do this in this scenario:
You are writing a report on patients who were given radiopharmaceutical
medications. You need to create a filter that looks for medications that are
radiopharmaceuticals. Your first instinct might be to write a filter similar to this:
where MEDICATION_ID in (/*...*/) - ✔✔1. you would have trouble identifying all medications
that
qualify as a
radiopharmaceutical. Once you did identify all these medications, you may find it
to be a somewhat large number.
, 2. if any new radiopharmaceuticals
were added to your system in the next med load, you would need to add that
medication to your report.
What are two ways to report on medications: - ✔✔ERX groupers
VCG groupers
What is the difference between ERX groupers and VCG groupers - ✔✔The first, ERX groupers,
allow
Willow analysts to attach any number of 'tags' to each medication record (for example,
'Radiopharmaceutical'
or 'Chemotherapy medication').
The second, VCG groupers, are lists of records that can provide consistent reporting
definitions across an
organization.
T/F: each medication can have many tags from each category list as needed - ✔✔true
what are some columns in rx_med_two - ✔✔**medication_id
medication_name
rx_templt_typ_name
medispan_ddi