PrognoCIS Help: CPT

Search:

Progress Notes (and Forms and Letters) Templates can be used to generate a report for a specific encounter. If a template is designed to print a few fields/rows and is used for all relevant encounters, it provides an easy way of generating ad hoc reports providing a great deal of information. The trick is to define a SQL query to select the requisite encounter IDs. No other field should be selected in the query. Of course, a basic understanding of the underlying database structure is important, and as such, this report is best configured by the administrator or Bizmatics support staff.

Option Name: The option as seen in the selection list box by the end user.

Report Header: The name of the report as it will be printed. This name can consist of the following predefined tags:
   <X>: This is the number of days parameter selected for the report.
   <P>: The selected period for which the report is to be generated.
   <D>: The specific doctor selected.
   <A>: The applicable code selected.

SQL: The SQL required to generate the report. This can consist of special tags that are appropriately substituted before executing the SQL.
The special tags are:
[DATE_FROM] The 'From' date defined in the selected period.
[DATE_UPTO] The 'Up To' date defined in the selected period.
[TODAY] The run date.
[TODAY_MINUS_X] The run date minus the 'X' days parameter.
[YESTERDAY] The run date minus one day.
[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 last week. The week is assumed to start on Monday.
[LAST_WEEK_END] The last date of 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] The ID of the logged-in Doctor.
[SPL_CODE] The entered applicable code.
[THIS_PATIENT] The Patient ID selected from the current encounter.
[THIS_APPT_ID] The ID of the current appointment.
[EXTRA_PARAM] The value to be passed in case of a hyperlinked report.

Applicable: Select the appropriate checkbox which will decide what selections a user can make when they select this report to be executed.

Default Template: Select the required template to be used as a default when the report is to be generated.

Sequence No.: The sequence number in which the report options will be displayed in the list box.