Misc Tab |
  
|
Misc Tab |
|
Optional filter expression when mapping MPI fields (Will not perform the mapping if expression evaluates false): A filter can be entered, when mapping from the MPI table, to only populate the value if the filter is TRUE. For example, if you only wanted the value to populate if the patient is an inpatient, you could enter PTTYPE="I". This is an advanced feature. Please contact ChartNet Tech support.
Optional string expression that will be applied to the value before it is mapped in from another table: An expression that can be applied if you wish to change the value populated from another table. Examples are below.
Example 1: RIGHT("%value%",5) -- returns the right-most 5 characters from the mapped field.
Example 2: LEFT("%value%,8) -- returns the left-most 8 characters from the mapped field.
Example 3: "ABC"+%value% -- appends "ABC" to the beginning of the mapped field.
Example 4: SUBSTR("%value%", 3, 6) -- returns characters 3 thru 6 from the mapped field.
* Expression can contain D:Base functions or string operators. Must use %value% in the expression to represent the field's value.