The P_NEXT_VISIT_DATE stored procedure is used to retrieve the patient's next visit date(either stored in the table PATIENTS, the next appointment or the next recall). If there is no date that can be found as the next visit date, the returned value will be NULL Here are some examples, on how to use it:
Simple Example
SELECT NEXT_VISIT_DATE FROM P_NEXT_VISIT_DATE(:PATIENTNO) |
Embedded within another query
SELECT PATIENTNO, FIRSTNAME, LASTNAME, MIDDLENAME, (SELECT NEXT_VISIT_DATE FROM P_NEXT_VISIT_DATE(PATIENTS.PATIENTNO)) as NEXT_VISIT_DATE FROM PATIENTS |
