As we move into next year, we must prepare for our usual mad flurry of activity in updating patient records to reflect the new calendar year. Deductibles need to be re-configured. Copays that increase with session frequency also need to be readjusted. We usually put such information under the ADDITIONAL tab in the patient record, specifically in the spaces called Scheduler reminder and Transaction Screen Reminder. I need a query that shows the data entered in these fields for each patient.
This query will output a line if there is either a “don’t schedule” reason OR a transaction memo. The list will include only Active list patients with no discharge date entered and something entered in either or both of the reminder fields.
SELECT
lastName+','+firstName+' '+ id AS "Patient",
noschedreason,
trannote
FROM
sos.patients
WHERE
flag = 0
AND dischargedate IS NULL
AND (noSchedReason <>'' OR trannote <>'')
ORDER By LastName, FirstName
