Revision [216]
Last edited on 2009-05-05 10:06:25 by SethKriegerAdditions:
======Missing Policy Dates======
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
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
Deletions:
comments here appear in italics
paste your tested query here
