B
Basil
I have a Claims Table with fields: ptid, claimid, activityid, proc. Each
claimid can have multiple activityids, and each activityid has one proc.
I'm generating queries of this data as such:
-Query1: count of claims where proc =New (i.e. # of new ptid claims)
-Query2: count of claims where proc = Return (i.e. # of returning ptid claims,
each ptid could have multiple records in Query2)
-Query3: count of claims in Query2 where ptid is also in Query1 (i.e. count
the number of returning claims generated from ptids having new claims. This
will be used to calculate the % return claims generated from new patients.)
claimid can have multiple activityids, and each activityid has one proc.
I'm generating queries of this data as such:
-Query1: count of claims where proc =New (i.e. # of new ptid claims)
-Query2: count of claims where proc = Return (i.e. # of returning ptid claims,
each ptid could have multiple records in Query2)
-Query3: count of claims in Query2 where ptid is also in Query1 (i.e. count
the number of returning claims generated from ptids having new claims. This
will be used to calculate the % return claims generated from new patients.)