MAXE Database Function

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

MINE Database Function

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_fieldTwo encounters, three records per encounter(324, 356, 213, 278, 410, 156){MINE( medical_record_ext_popup_.txt_mrepu_numeric_field )} Result: 156 Parent topic: Functions

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

DM Extended 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 Patient Procedure 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 Extended 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

NextGen® Enterprise EHR Template Editor Help 8

DM Extended Popup View 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 Patient Procedure 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 Extended Popup View Template Events and Actions

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_field Two encounters, three records per encounter (324, 356, 213, 278, 410, 156) {MAX( medical_record_ext_popup_.txt_mrepu_numeric_field )}` Result: 410

MAXE Database Function

Recommendations

MAX Database Function

MINE Database Function

MIN Database Function

DM Extended Popup Edit Field List Pick Actions

MR Extended Popup Active Text Click Actions

DM Extended Popup View Edit Field List Pick Actions

MAX Database Function

MINE Database Function

MIN Database Function

DM Extended Popup Edit Field List Pick Actions

MR Extended Popup Active Text Click Actions

DM Extended Popup View Edit Field List Pick Actions