MAXE Database Function

NextGen® Enterprise EHR Template Editor Help, 8.3.1

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.3.1

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

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

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

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

MAXE Database Function

MAX Database Function

MINE Database Function

MIN Database Function

MAXE Database Function

MAX Database Function

MINE Database Function

MAXE Database Function

MAX Database Function

MINE Database Function

MIN Database Function