Capturing Patient Visits

Question

I am trying to capture patient visits to determine if they are compliant or not. There is a column [Visit Type], which includes Intial

Visit, Quarterly visit, Monthly visit, Annual Visit, Acute/follow up visit, Post Hospitaliztion visit. I would like to return a column with a value "compliant" or "not-compliant" for each patient. If a patient is not seen every month then they are considered not compliant, additionally if they don' have a quarterly visit every 3 months they are not compliant. Every 3 months there should be a Quarterly or possibly Annual visit and in between these there should be some combination of Monthly, Post Hospitalization, Acute/Follow up Visit. If the patient has an effective end date the result should be "discharged"

Any help would be greatly appreciated.

ryan_mayu · Answer

could you pls provde the sample data(not the screenshot) and the expected output

cnel · Answer

Visit TypeGroup NumberEffective Begin DatePatient&nbsp; NamePatient Birth DatePatient CodeNote DatePhysicianPatient DepartementEffective End DateInitial Visit10010000272S7/1/2021Bill Nelson2/22/1974INS CHG1/4/2022Bob MarshalABC Company4/30/2022Quarterly Visit10010000419S7/1/2021Paul Conner9/11/1948&nbsp;3/5/2022Kim Blunt123 Company&nbsp;Annual Visit10010000353S1/9/2022Bonnie Thorn7/3/1936&nbsp;8/2/2022HenryClarkABC Company&nbsp;Acute/Follow Up Visit10010438139S1/1/2022MindyJenkins8/20/1951&nbsp;5/5/2022Henry ClarkABC Compnay9/28/2022Monthly Visit10010000419S2/15/2022HopeWalker7/9/1981INS CHG10/1/2022Mary Beth123 Company&nbsp;Post Hospitalization Visit10010028210S7/4/2022CindyStewart11/21/1952&nbsp;6/4/2022Cheryl HolderABC Company&nbsp;Quarterly Visit10010028210S7/4/2022CindyStewart11/21/1952&nbsp;7/24/2022Cheryl HolderABC Company&nbsp;&nbsp;

ryan_mayu · Answer

I think sample data is not enough.
if you have different scenarios, you need to provide the data for all scenarios.
hope i didn't misunderstand your question.
e.g
TOM 2022/1/1, 2022/2/1,2022/3/1
Jack 2022/1/1, 2022/4/1, 2022/7,1
Peter, 2022/1/1,2023/1/1
Linda 2022/1/1,2022/2/1,2022/6/1
we have monthly visit, quarterly visit, yearly visit and other scenario, the output for XXX is YYY
something like that
&nbsp;

cnel · Answer

Expected output is a new table with the patient name and a new column (Evaluation) that returns a value of Discharged, Compliant, or Not Compliant. I have a sample visualization that I am working on but I cant get figure out the calculation to return the expected result

cnel · Answer

I added the expected output above and included a screenshot of what I was working on. Does this give you enough information to go on ryan_mayu&nbsp;?&nbsp;

Forum Discussion

Capturing Patient Visits

9 Replies

Related content

Average Daily Patient Visits Calculation

Locate patients with only one visit

Count visits by Patient--then show all patients with a count >=2

Formula for pulling most recent patient visit

Count how many patients visit x number of times

Visit Type	Group Number	Effective Begin Date	Patient Name	Patient Birth Date	Patient Code	Note Date	Physician	Patient Departement	Effective End Date
Initial Visit	10010000272S	7/1/2021	Bill Nelson	2/22/1974	INS CHG	1/4/2022	Bob Marshal	ABC Company	4/30/2022
Quarterly Visit	10010000419S	7/1/2021	Paul Conner	9/11/1948		3/5/2022	Kim Blunt	123 Company
Annual Visit	10010000353S	1/9/2022	Bonnie Thorn	7/3/1936		8/2/2022	Henry Clark	ABC Company
Acute/Follow Up Visit	10010438139S	1/1/2022	Mindy Jenkins	8/20/1951		5/5/2022	Henry Clark	ABC Compnay	9/28/2022
Monthly Visit	10010000419S	2/15/2022	Hope Walker	7/9/1981	INS CHG	10/1/2022	Mary Beth	123 Company
Post Hospitalization Visit	10010028210S	7/4/2022	Cindy Stewart	11/21/1952		6/4/2022	Cheryl Holder	ABC Company
Quarterly Visit	10010028210S	7/4/2022	Cindy Stewart	11/21/1952		7/24/2022	Cheryl Holder	ABC Company