MINE Database Function

NextGen® Enterprise EHR Template Editor Help 8

MIN Database Function

Use: Displays the minimum value of a numeric field for the currently selected practice and patient. You can use this function with the following template types: Medical Records, Medical Records Popup, Medical Records Extended Popup, Demographics Extended Popup. Syntax: {MIN( «field» )} Arguments: «field» table_name.field_name (no braces) Returns: The minimum numeric value Example 1: Field = medical_record_template_.txt_mrt_numeric_field Five encounters (5, 45, 32, 121, 99){MIN( medical_record_template_.txt_mrt_numeric_field )} Result: 5 Example 2: Field = medical_record_popup_.txt_mrpu_numeric_fieldThree encounters (13, 84, 62){MIN( medical_record_popup_.txt_mrpu_numeric_field )} Result: 13 Example 3: Field = medical_record_ext_popup_.txt_mrepu_numeric_field Two encounters, three records per encounter(324, 356, 213, 278, 410, 156){MIN( medical_record_ext_popup_.txt_mrepu_numeric_field )} Result: 156 Example 4: Field = demographic_ext_popup_.txt_depu_numeric_field One encounter, four re

NextGen® Enterprise EHR Template Editor Help 8

MAXE Database Function

Use: Displays the maximum value of a numeric field for the currently selected patient for the current encounter. You can use this function with a Medical Records Extended Popup template. Syntax: {MAXE( «field» )} Arguments: «field» table_name.field_name (no braces) Returns: The maximum numeric value Example: Field = medical_record_ext_popup_.txt_mrepu_numeric_fieldTwo encounters, three records per encounter(324, 356, 213, 278, 410, 156){MAX( medical_record_ext_popup_.txt_mrepu_numeric_field )} Result: 410 Parent topic: Functions

NextGen® Enterprise EHR Template Editor Help 8

MAX Database Function

Use: Displays the maximum value of a numeric field for the currently selected practice and patient. You can use this function with the following template types: Medical Records, Medical Records Popup, Medical Records Extended Popup, Demographics Extended Popup. Syntax: {MAX( «field» )} Arguments: «field» table_name.field_name (no braces) Returns: The maximum numeric value Example 1: Field = medical_record_template_.txt_mrt_numeric_field Five encounters (5, 45, 32, 121, 99){MAX( medical_record_template_.txt_mrt_numeric_field )} Result: 121 Example 2: Field = medical_record_popup_.txt_mrpu_numeric_fieldThree encounters (13, 84, 62){MAX( medical_record_popup_.txt_mrpu_numeric_field )} Result: 84 Example 3: Field = medical_record_ext_popup_.txt_mrepu_numeric_field Two encounters, three records per encounter(324, 356, 213, 278, 410, 156){MAX( medical_record_ext_popup_.txt_mrepu_numeric_field )} Result: 410 Example 4: Field = demographic_ext_popup_.txt_depu_numeric_field One encounter, four

NextGen® Enterprise EHR Template Editor Help 8

MR Button List Pick Actions

Note: You must first set up a DBPickList or Pop-Up trigger on the same field to display the options that can be picked. Alert Assign Field Value Assign Note Value Change Field Color Change Field Style Create New Encounter Disable Control Enable Control Export Audio Fax Note Fax Report Generate CCD Goto Field Goto Module Grid Row Select Hide Item Launch Application Launch Document Launch Image Launch Template Lookup External Id Medical Necessity Modify Patient Patient Allergy Patient Diagnosis Patient Implantable Device Patient Education Patient Item Patient Lab Order Patient Medication Patient Problem Patient Procedure PickList Pop-Up Print Graph Print Note Print Report Radiology CDS Referral Refresh Data Grid Refresh Encounter UI Refresh Sidebar Refresh Template Region Highlight Reports Save Template Save & Close Template Send Email Service Item Lookup Set Default Values Show Item Stored Procedure System Password Template Pop-Up Toggle History Toggle Panel Toggle Sidebar Trigger Scrip

NextGen® Enterprise EHR Template Editor Help 8

DM Popup Edit Field List Pick Actions

Alert Assign Field Value Assign Note Value Change Field Color Change Field Style Disable Control Enable Control Export Audio Fax Note Fax Report Generate CCD Goto Field Grid Row Select Hide Item Launch Application Lookup External Id Modify Patient Patient Problem PickList Pop-Up Print Graph Print Note Print Report Refresh Data Grid Refresh Encounter UI Refresh Sidebar Refresh Template Region Highlight Reports Save Template Save & Close Template Send Email Service Item Lookup Set Default Values Show Item Stored Procedure System Password Template Pop-Up Toggle History Toggle Panel Toggle Sidebar Trigger Script Upload Extended Data View Category View Search Mode Web Navigate Web XChange Parent topic: DM Popup Template Events and Actions

NextGen® Enterprise EHR Template Editor Help 8

MR Extended Popup Active Text Click Actions

Add New Task Alert Assign Field Value Assign Note Value Change Field Color Change Field Style Clear Create New Encounter DBPickList Disable Control Enable Control Export Audio Fax Note Goto Field Grid Row Select Hide Item ICD SNOMED Map Launch Application Lookup External Id Medical Necessity Modify Patient Patient Appointments Patient Allergy Patient Diagnosis Patient Implantable Device Patient Lab Order Patient Medication Patient Portal Patient Problem Patient Procedure Pop-Up Print Graph Print Note Refresh Data Grid Refresh Encounter UI Refresh Sidebar Refresh Template Region Highlight Reports Save Template Save & Close Template Send Email Service Item Lookup Set Default Values Show Item Stored Procedure System Password Template Pop-Up Toggle History Toggle Panel Toggle Sidebar Trigger Script Upload Extended Data View Category View Search Mode Web Navigate Web XChange Parent topic: MR Extended Popup Template Events and Actions

Use:	Displays the minimum value of a numeric field for the currently selected patient for the current encounter. You can use this function with a Medical Records Extended Popup template.
Syntax:	`{MINE( «field» )}`
Arguments:	`«field» table_name.field_name (no braces)`
Returns:	The minimum numeric value
Example:	`Field = medical_record_ext_popup_.txt_mrepu_numeric_field Two encounters, three records per encounter (324, 356, 213, 278, 410, 156) {MINE( medical_record_ext_popup_.txt_mrepu_numeric_field )}` Result: 156

MINE Database Function

Recommendations

MIN Database Function

MAXE Database Function

MAX Database Function

MR Button List Pick Actions

DM Popup Edit Field List Pick Actions

MR Extended Popup Active Text Click Actions

MINE Database Function

MIN Database Function

MAXE Database Function

MAX Database Function

MR Button List Pick Actions

DM Popup Edit Field List Pick Actions

MR Extended Popup Active Text Click Actions