CODETABLE Database Function

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

File Maintenance Help for NextGen® Enterprise

Open Code Tables

Open File Maintenance. Select Code Tables. The Code Tables List window opens. Code Tables List window Select a code table from the Code Table list. The list updates to display the codes in the selected code table. To open a code in the code table, double-click it. Parent topic: Code Table Descriptions

File Maintenance Help for NextGen® Enterprise 8

Open Code Tables

Open File Maintenance. Select Code Tables. The Code Tables List window opens. Select a code table from the Code Table list. The list updates to display the codes in the selected code table. To open a code in the code table, double-click it. Parent topic: Code Table Descriptions

Mirth® Connect by NextGen Healthcare User Guide

Code Template Library Table

The table in the top section of the Edit Code Templates View shows all currently configured code templates and libraries. The name column is displayed as a tree, showing libraries at the hierarchical top level, and all child code templates at a lower level. The filter field at the bottom allows you to easily filter down to a particular code template or library by typing in all or part of the name. The status label to the left of the filter displays how many total code templates / libraries are configured, and how many are currently shown with the given filter. For additional information on tables in Mirth® Connect, see Mirth Connect Administrator. Image of the Code Templates library table Column Description Name The name of the code template or library. This column displays as a tree, showing libraries at the hierarchical top level, and all child code templates at a lower level. Double-click on this column to edit the name. Id The unique identifier for the code template or library. Typ

NextGen® Adaptive Content Engine Help Enterprise 8.3.1

Coded Results Mapping Details

The fields on the this template enable you to specify the source table, source field, range of values, and specific codes to map the values with. The following table describes the fields on the Coded Results Mapping template. Fields Description Source Table Table associated with a template that has the mapped field values. When you select Source Table, a list appears with templates that have a source field. If the source table is shared, it retrieves the name from the source template. Source Field Name of the source field for the data value being mapped. This field provides options that correspond to the source table you entered. Field Value One of the possible values that can be stored in Source Field. Map any Value Indicates that a value in Field Value maps to specific Code Value. Min and Max Maps a range of values with a specific code. You can only enter numbers or decimals for minimum and maximum values for the range. Code System The code system associated with the code value that

Mirth® Connect by NextGen Healthcare User Guide

Code Template Tasks

The following context-specific tasks are available throughout the Edit Code Templates View: Task Icon Task Name Description Refresh Refreshes the list of code templates / libraries. If there are unsaved changes, you are prompted to save first before refreshing. Save Changes Saves all changes made to all code templates / libraries. Changes to a code template will cause its revision to increment. Changes to a library, or adding/removing code templates to/from the library, will cause its revision to increment. New Code Template Creates a new code template in the currently selected library. If there are currently no libraries configured for your server, you must first create a new library before this task becomes available. New Library Creates a new code template library and adds it to the table. By default the library is not included in any channels. Use the Channels table in the Edit Library Panel to link the library to specific channels. Import Code Templates Import a single code templa

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

CODETABLE Database Function

Recommendations

CODETABLE Database Function

Open Code Tables

Open Code Tables

Code Template Library Table

Coded Results Mapping Details

Code Template Tasks

CODETABLE Database Function

Open Code Tables

Open Code Tables

Code Template Library Table

Coded Results Mapping Details

Code Template Tasks