A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.✑ Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID✑ PatientID values in all three tables are completely accurate✑ Patients may have encounters without lab orders or medicationsThe data architect needs to make sure that the count of patient lab orders is correct.Which method should the data architect to meet this requirement?
A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
B. load all three tables and use Count(Distinct PatientID)
C. load all three tables and use Count(PatientID)
D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)
A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.✑ Encoun
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.✑ Encoun
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!