Frequently Asked Question
All Categories » Reports - Using Stored Procedures
How to use the P_PATIENT_DOC_REFERRED_TO
Last Updated 6 years ago
Use the P_PATIENT_DOC_REFERRED_TO stored procedure to retrieve the list of physicians to whom the patient was referred to. The P_PATIENT_DOC_REFERRED_TO stored procedure accepts one parameter, which is the patient number. And, will return a list of doctor numbers, that corresponds to the DOCTORNUMBER field in the FAMILYDOCTOR table. Example : Retrieves Doctors names to which a patient has been referred to.
SELECT P1.DOCTORNUMBER, FAMILYDOCTOR.FIRSTNAME, FAMILYDOCTOR.LASTNAME FROM P_PATIENT_DOC_REFERRED_TO(:PATIENTNO) AS P1 JOIN FAMILYDOCTOR ON FAMILYDOCTOR.DOCTORNUMBER = P1.DOCTORNUMBER |
