Missing Policy Dates
Back to Query Directory
We are moving forward to get ready for the conversion to EMDEON. I am told that we have to have a beginning and end date for insurances when there is more than one insurance for a patient. Is it possible to have a query prepared that would identify patient accounts with more than one insurance where the “old” insurance does not have a beginning and end date?
SELECT p.lastname,p.firstname,p.id,pol.payornum,pol.payorname,pol.active, pol.inactive
FROM
patients p JOIN rv_policies pol ON p.ptnum = pol.ptnum
WHERE
p.licnum = 101
AND p.flag = 0
AND p.dischargedate IS NULL
AND pol.inspos > 1
AND (pol.active IS NULL OR pol.inactive IS NULL)
ORDER BY
p.lastname,p.firstname,p.id
FROM
patients p JOIN rv_policies pol ON p.ptnum = pol.ptnum
WHERE
p.licnum = 101
AND p.flag = 0
AND p.dischargedate IS NULL
AND pol.inspos > 1
AND (pol.active IS NULL OR pol.inactive IS NULL)
ORDER BY
p.lastname,p.firstname,p.id
CategoryQueries
