Health Analytics Database Project
| EncounterId | PtId | DateOfService | Provider | A1C | BP-Systolic | BP-Diastolic | Cholesterol | Retinopathy | Neuropathy |
|---|
| PtId | PtLast | PtFirst | PtDOB | MRNumber | PtSex | PtRace |
|---|
PARAMETERS __PtId Value;
SELECT DISTINCTROW *
FROM Encounters AS MPI
WHERE ([__PtId] = PtId);
SELECT DISTINCTROW *
FROM MPI;