Topics

Appointment Report

Search:

The idea is to print the details of all appointments on specified days. The simplest applicability could be to have a list of patients visited, Visit Type, Reason for Visit, and Co-Payment so that billing is fast and accurate. The system executes a query to get the appointment IDs satisfying the date and other conditions. The details of an appointment can be printed using all appointment tags. Since we are printing details of more than one appointment, a matrix format of the report is ideal. A user, as such, can design an HTML table row with the necessary field tags in each column so that one row is printed per appointment. The user can design templates with multiple rows per appointment, if required. Properties: This button is exclusively visible to users with Read Access to the Properties Master screen. Access to this button is strategically granted to enhance user functionality. Clicking the Properties button triggers a pop-up, presenting a list of properties from the Properties Master screen in PrognoCIS that cater to the Appointment Report. The queries are defined in the Appointment Reports property. apptrep.sql.1 is an SQL query to select appointment IDs based on the selected period and Appointment Doctor. The following special tags are used to define the SQL: [DATE_FROM] the 'From' date defined in the selected period. [DATE_UPTO] the 'Up To' date defined in the selected period. [TODAY] is the run date. [YESTERDAY] is the run date minus one. [THIS_WEEK_START] the start date of the current week. The week is assumed to start on Monday. [THIS_WEEK_END] the last date of the current week. The week is assumed to end on Sunday. [LAST_WEEK_START] the start date of the last week. The week is assumed to start on Monday. [LAST_WEEK_END] the last date of the last week. The week is assumed to end on Sunday. [THIS_MONTH_START] the start date of the current month. [THIS_MONTH_END] the last date of the current month. [THIS_DOC] is the ID of the logged-in doctor. apptrep.name.1 is the Report Name available in the list box. apptrep.template.1 is the default template to be used for the report. apptrep.sql.1 is an SQL query to select appointment IDs based on the selected period and Appointment Doctor.