Diagnosis
Billing diagnosis dates are traditionally _ the discharge date of the visit
After
The table you utilize to pull the patient_id for medications administered to the patient
med_order
Notes from this table should be excluded when returning notes to researchers unless they have explicit permission from the IRB to obtain them
HNO_NOTE_CONFIDENTIAL
Use this command to de-duplicate results
DISTINCT
The standard we map lab results and clinical observations to is
LOINC
This table's dx_code column can be null
Problem List
AVS stands for
after visit summary
Since the notes are stored as a _ datatype, it is best practice to pull a distinct list of _ using a _ _ and return notes from that temporary table to remove duplicate notes
CLOB, NOTE_IDS, WITH CLAUSE
with clauses
Scheduled visits can be found in this table
VISIT_APPOINTMENT
The diagnosis codes used to populate the PHENOTYPE table columns can be found in these two tables
REF_CMS_CHRONIC & REF_CMS_CHRONIC_PVT
To review at home medications the patient is taking I would pull back data from this table
MED_CURRENT
Imaging notes are found in this table
NOTE
Use this functionality to organize rows of data into columns of data
The two types of billing are
Professional Billing & Hospital Billing
The month and year ICD switched from ICD9 to ICD10
The two standards we map medications to are
RXNORM & NDC
NOTE_RSLT has notes from these two tables
LAB_RESULT & ORDERS
The difference between VARCHAR and VARCHAR2 oracle datatypes is
VARCHAR can store up to 2000 bytes and varchar2 can store up to 4000 bytes. VARCHAR will occupy space for NULL values and VARCHAR2 will not occupy any space.
Social vulnerability index can be found in this table
GEOCODE_MUSC
The table that contains the diagnosis codes shown on the Order Summary screen of EPIC
VISIT_DIAGNOSIS
To find the first chemo date of a patient I would go to this table
HCC.TREATMENT_SUMRY (MST_DEF_CHEMO_DATE)
When filtering on date fields for HNO notes it is best practice to do a coalesce between these two columns
coalesce(ni.date_of_service, n.contact_date)
To select rows from one or more data sources for updating and insertion into a table or a view we use a
merge statement
T-