MSTRLIST Database Function

File Maintenance Help for NextGen® Enterprise 8

View DB PickList Table Details

From the Master Files - System list, select DB Picklist Manager. The System Tables window opens. In the Available or Selected list, right-click the table name, then select Details. The column information from that table displays in the Columns list. Parent topic: DB Picklist Manager

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

HASALERT Database Function

Use: This function searches for NextGen® Enterprise EHR alerts and indicates whether a patient has any alerts or a specific alert: NextGen® Enterprise EHR alerts are created through the Alerts module. For more information on alerts, go to NextGen Healthcare Success Community and download the latest Alerts Module for NextGen® Enterprise EHR. Syntax: {HASALERT( )} Search for any alerts for the patient.{HASALERT( «"id"» )} or {HASALERT( «id» )} Search for a specific patient alert ID. Enter the alert ID (in double quotes) or the template field that contains the alert ID.{HASALERT («"id"»,«"id"»,«"id"»,...)} or {HASALERT («id»,«id»,«id»,...)} Search for an alert ID match among a group of multiple alert IDs. Enter the alert IDs (in double quotes) or the template fields that contain the alert IDs. Use commas between the IDs or fields. Arguments: «id» Alert ID or template field that contains the alert ID To find an alert ID, create a stored procedure database picklist that loads a list of aler

NextGen® Adaptive Content Engine Help Enterprise 8

Add Categories of Service Items in the Master DB Picklist

On the Assessment Plan Customization template, Order Sets (My Plan/CustomPlan) DBPicklists section, select the Full List display option. Right-click and select Add New. The Treatment Plan Dbp template opens. Select and/or type new information in the fields. Note: When you select an option from the Category field, the associated code is displayed in the Category Description field. Select Save, and then select Close to return to the Assessment Plan Customization template. In the Order Sets (My Plan/CustomPlan) DBPicklists section, select Save & Close. Parent topic: Categories and Picklists

NextGen® Enterprise EHR Template Editor Help 8

CODETABLE Database Function

Use: Displays the description for a given code and code type from the code_tables table. Syntax: {CODETABLE( «code» , «type»)} Arguments: «code» Code used to find the description (code_tables.code)«type» Type of code (code_tables.code_type) Note: Use the code type from the codes_table; do not use the code displayed in File Maintenance. You can query the code_tables in SQL Server to find the code and type in the format you need to enter. Returns: The description from the code_tables table. Example: Fields = txt_code, txt_type{template_name_.txt_code} = M{template_name_.txt_type} = mar_status{CODETABLE( {template_name_.txt_code}, {template_name_.txt_type})} Result: Married 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

Use:	Displays the description for a given mstr_list_item_id from the mstr_lists table. You can use this function to pull information from the Ethnicity, Language, or Race master list.
Syntax:	`{MSTRLIST( «id»)}`
Arguments:	`«id»` Master list item ID used to find the description (mstr_lists.mstr_list_item_id) Note: You can query the mstr_lists table in SQL Server to find the mstr_list_item_id).
Returns:	A string with the description from the mstr_lists table
Example:	`Field = txt_id {template_name_.txt_id} = AE145CF7-50C8-42E9-999A-0E1506B189B8 {MSTRLIST({template_name_.txt_id})}` Result: Caucasian

MSTRLIST Database Function

Recommendations

View DB PickList Table Details

MIN Database Function

HASALERT Database Function

Add Categories of Service Items in the Master DB Picklist

CODETABLE Database Function

MAX Database Function

View DB PickList Table Details

MIN Database Function

HASALERT Database Function

Add Categories of Service Items in the Master DB Picklist

CODETABLE Database Function

MAX Database Function