Looking use code to add a column to this table ("Meets Numerator Criteria") to indicate (utilizing 0 or 1) if the unique patient number meets the numerator criteria outlined below (utilizing a measurement period of 1/1/2020-12/31/2021). If all MedicalVisits satisfy numerator criteria, all rows per unique patient show 1 in column "Meets Numerator Criteria":
| Patient Number |
MedicalVisit |
Meets Numerator Criteria |
| 12345 |
2/2/2019 |
|
| 12345 |
8/8/2019 |
|
| 12345 |
2/2/2020 |
|
| 12345 |
10/10/2020 |
|
| 12345 |
4/15/2021 |
|
| 12345 |
11/23/2021 |
|
| 18345 |
2/2/2018 |
|
| 18345 |
8/8/2018 |
|
| 18345 |
3/2/2019 |
|
| 18345 |
9/8/2019 |
|
| 18345 |
3/2/2020 |
|
| 18345 |
11/10/2020 |
|
| 18345 |
5/15/2021 |
|
| 18345 |
12/23/2021 |
|
| 15345 |
2/10/2018 |
|
| 15345 |
8/10/2018 |
|
| 15345 |
3/10/2019 |
|
| 15345 |
9/10/2019 |
|
| 15345 |
3/10/2020 |
|
| 15345 |
11/10/2020 |
|
| 15345 |
5/10/2021 |
|
| 15345 |
12/10/2021 |
|
| 11341 |
2/17/2018 |
|
| 11341 |
8/17/2018 |
|
| 11341 |
3/17/2019 |
|
| 11341 |
9/17/2019 |
|
| 11341 |
3/17/2020 |
|
| 11341 |
11/17/2020 |
|
| 11341 |
5/17/2021 |
|
| 11341 |
12/17/2021 |
|
Numerator Criteria:
At least one visit occurs in the first semester of year prior to Measurement Period
AND: Intersection of:
Occurrence A of $MedicalVisit > 184 day(s) starts before start of "Measurement Period"
First: $MedicalVisit < 12 month(s) starts before start of "Measurement Period"
Last visit in the second semester of year prior to Measurement Period >= 60 days from first visit in prior semester
AND: Intersection of:
Most Recent: $MedicalVisit <= 184 day(s) starts before start of "Measurement Period"
$MedicalVisit >= 60 day(s) starts after start of Occurrence A of $MedicalVisit
Last visit in the first semester of Measurement Period >= 60 days from first visit in prior semester
AND: Intersection of:
Most Recent: $MedicalVisit < 6 month(s) starts after start of "Measurement Period"
$MedicalVisit >= 60 day(s) starts after start of First: $MedicalVisit <= 184 day(s) starts before start of "Measurement Period"
Last visit in the second semester of Measurement Period >= 60 days from first visit in prior semester
AND: Intersection of:
Most Recent: $MedicalVisit < 184 day(s) starts before end of "Measurement Period"
$MedicalVisit >= 60 day(s) starts after start of First: $MedicalVisit < 6 month(s) starts after start of "Measurement Period"