Add, edit, or copy a data transformation definition

When adding or editing a definition name, note the following:

  • Can include up to 80 characters.

  • Are case-sensitive.

  • Must have a unique name.

IMPORTANT: All the fields (inputs and results) in a single definition must be from the same table. Axiom will not let you select a field from a different table.

To add, edit, or copy a data transformation definition

  1. From the Enterprise Decision Support home page, in the Data enhancement and refinement drop-down, select Define data transformations.

    NOTE: Only users assigned the Axiom EDS Rules Writer role profile can see and access this feature.

  2. Do one of the following:

    • To add a definition, select + Add.
    • To edit or copy a definition, in the Actions column, select the ellipsis (...), and from the drop-down, select Edit or Copy.

  3. At the top of the page, enter a name for the definition.

    NOTE: Although the forward slash is accepted, you should avoid it.

  4. On the Step 1 Select data definition type page, complete the following fields:

    Field Description
    Type

    Select one of the following data definition types:

    • Assign Constant - Stores a numeric, text, flag (Boolean), or date constant in an Axiom field. For example, you can store a benchmark or best practices length of stay for hip replacement surgery in an encounter custom field.

    • Basic Calculation - Calculates and stores a value from Axiom numeric fields and constants. You may combine and group the fields and constants to form an expression using addition, subtraction, multiplication, and division operators.

    • Concatenate - Joins Axiom fields and constants. You can use the constant as a delimiter.

    • Comparison - Creates If-Then-Else formulas that compare Axiom fields to each other or to constants, and stores a value based on whether the comparison is true or false.

    • Copy Field - Copies the value of one field to another.

  5. Select Next, or select Step 2 Apply parameters. The fields to complete in this section are determined by the definition type you selected in Step 1. To complete the definition setup, select the following type:

    NOTE: A definition's inputs and results must be fields from within the same table.

Assign Constant

Click image to view full size

  1. Select Result field.

  2. In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to add, edit, or clear a value.

      NOTE: The dialog box only shows those tables and fields that you are allowed to update.

    2. Select a column name from those shown. You can find a desired column by doing one of the following:

      • In the search box, enter the part or all of the column name. Axiom shows columns that include the name.

      • To display a tree structure of all the columns, select the arrow next to the table name.

        • NOTE: Be aware of the maximum character limit of this column. Data going into the result field will be truncated if it exceeds that limit.

    3. Select Apply.

  3. Do one of the following:

    • Enter a value - The value you enter in the Value field is determined by the table and field you select in the Table drop-down. For example, if the field is a date field (such as Encounter table>DischargeDate), then a date picker will appear.

      Value type Description
      Numeric Enter a positive or negative number with up to four decimal places.
      Date/time Select a date and time.
      Text

      Enter a value.

      NOTE: If the value is large than the field, Axiom truncates the text.
      Boolean Select True or False.

    • Reset or clear the value - Some fields in the database store default values. For these types of fields, you can replace the current value with the default value by selecting the Reset to default check box. If the Axiom field does not have a default value, then this option inserts a blank (null) value.

  4. To identify the records in the database in which to apply the value, select Criteria. The Filter Wizard appears, letting you define specific attribute to define the record(s) to update. For example, to apply a specific discharge date, you may not want to apply that change to every encounter. You can use the Filter Wizard to define what condition in which to add or edit the value, such as based on procedure code, diagnosis code, or any other attribute tied to the encounter. For instructions, see Using the Filter Wizard.

  5. In the Details section on the right side of the page, complete the following:

    • Notes- (Optional) Enter your own description to help you identify the definition.

    • Active - Select the toggle to activate or deactivate the definition. Only active definitions can be processed.

      NOTE: If the rule is selected as active, then Axiom automatically reviews the definition for any missing information or criteria, which are indicated with error messages. After resolving these issues and saving, the definition can be processed.

  6. Select Save.

  7. To process the definition now, select Process. Follow the instructions in Process a data transformation definition.

    NOTE: You can process the definition later from the Data transformation definitions page.

Basic Calculation

Click image to view full size

  1. Select Result field.

  2. In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to store the value.

      NOTE: The dialog box only shows those tables and fields that you are allowed to update. Only numeric fields are allowed for this definition type.

    2. Select a column name from those shown. You can find a desired column by doing one of the following:

      • In the search box, enter the part or all of the column name. Axiom displays columns that include the name.

      • Select the arrow next to the table name to display a tree structure of all the columns.

        • NOTE: Be aware of the maximum character limit of this column. Data going into the result field will be truncated if it exceeds that limit.

    3. Select Apply.

  3. In the formula box, enter a formula by using numbers, using the variables identified as A-E, or a combination of the two. Valid operators are:

    Operator Description
    ( )

    Use for grouping definition

    For example, A+(B*(C-D))
    + Addition
    - Subtraction
    * Multiplication
    / Division

  4. In Fields A-E, select the fields to select the values to use in the formula. In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to store the calculated value.

      NOTE: The dialog box only shows those tables that you are allowed to update. You are not updating these fields, but simply using them as the inputs. Axiom shows numeric fields only.

    2. To select a column name, do one of the following:

      • In the search box, enter the part or all of the column name. Axiom shows columns that include the name.

      • Select the arrow next to the table name to display a tree structure of all the columns.

    3. Select Apply.

  5. To identify the records in the database in which to apply the value, select Criteria. The Filter Wizard appears letting you define specific attribute to define the record(s) to update. For example, to apply a specific discharge date, you may not want to apply that change to every encounter. You can use the Filter Wizard to define what condition in which to add or edit the value, such as based on procedure code, diagnosis code, or any other attribute tied to the encounter. For instructions, see Using the Filter Wizard.

  6. In the Details section on the right side of the page, complete the following:

    • Notes- (Optional) Enter your own description to help you identify the definition.

    • Active - Select the toggle to activate or deactivate the definition. Only active definitions can be processed.

  7. Select Save.

  8. To process the definition now, select Process. Follow the instructions in Process a data transformation definition.

    NOTE: You can process the definition later from the Data transformation definitions page.

Concatenate

Click image to view full size

  1. Select Result field.

  2. In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to store the value.

      NOTE: The dialog box only shows those tables/fields that you are allowed to update. Only text fields are allowed for this definition type.

    2. Select a column name from those shown. You can find a desired column by doing one of the following:

      • In the search box, enter the part or all of the column name. Axiom will display columns that include the name.

      • Select the arrow next to the table name to display a tree structure of all the columns.

        • NOTE: Be aware of the maximum character limit of this column. Data going into the result field will be truncated if it exceeds that limit.

    3. Select Apply.

  3. Select , and select one of the following from the drop-down:

    • Add constant - Enter a constant value of up to 25 characters, including spaces.

    • Add field - Select a field from the database by selecting the table where it resides.

  4. As needed, continue to add constants and/or fields by selecting .

    TIP: To remove a constant/fields, select the trash can icon .

  5. To identify the records in the database in which to apply the value, select Criteria. The Filter Wizard appears letting you define specific attribute to define the record(s) to update. For example, to apply a specific discharge date, you may not want to apply that change to every encounter. You can use the Filter Wizard to define what condition in which to add or edit the value, such as based on procedure code, diagnosis code, or any other attribute tied to the encounter. For instructions, see Using the Filter Wizard.

  6. In the Details section on the right side of the page, complete the following:

    • Notes- (Optional) Enter your own description to help you identify the definition.

    • Active - Select the toggle to activate or deactivate the definition. Only active definitions can be processed.

  7. Select Save.

  8. To process the definition now, select Process. Follow the instructions in Process a data transformation definition.

    NOTE: You can process the definition later from the Data transformation definitions page.

Comparison

Click image to view full size

  1. In the If section, complete the following:

    Field Description
    Input

    In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to store the value.

      NOTE: The dialog box only shows those tables that you are allowed to update.

    2. Select a column name by doing one of the following:

      • In the search box, enter the part or all of the column name. Axiom displays columns that include the name.

      • To display a tree structure of all the columns, select the arrow next to the table name.

    3. Select Apply.
    Operator

    Select one of the following:

    > Greater than
    >= Greater than or equal to
    < Less than
    <= Less than or equal to
    = Equal to
    <> Not equal to
    Between Only number or date values are available for comparison.
    Like

    Only text values are available for comparison.

    TIP: You can use % and _ (underscore) to represent any string of characters or any single character. For example, %Aspirin will find Baby Aspirin, Buffered Aspirin, etc.
    Numeric constant Enter a numeric, date, or text value, depending on the input field type you selected.

  2. Add more If statements, as needed, by selecting .

    NOTE: Select first to choose if you are using a value from an existing field or entering a constant.

    TIP: To remove a constant/fields, select the trash can icon .

  3. In the Then section, complete the following:

    Field Description
    Result

    Select the table and column in which to store the value if the comparison is true.

    NOTE: Be aware of the maximum character limit of this column. Data going into the result field will be truncated if it exceeds that limit.
    Text constant Enter the text value to add or edit to the field.

  4. Add more Then statements, as needed, by selecting .

    NOTE: Select first to select if you are using a value from an existing field or entering a constant.

  5. In the Else (Optional) section, in the Text constant field, enter the text value to add or edit to the field.

    NOTE: You cannot change the Result field here. Whatever result field you selected in the Then section is used here.

  6. To identify the records in the database in which to apply the value, select Criteria. The Filter Wizard dialog box appears letting you define specific attribute to define the record(s) to update. For example, to apply a specific discharge date, you may not want to apply that change to every encounter. You can use the Filter Wizard to define what condition in which to add or edit the value, such as based on procedure code, diagnosis code, or any other attribute tied to the encounter. For instructions, see Using the Filter Wizard.

  7. In the Details section on the right side of the page, complete the following:

    • Notes- (Optional) Enter your own description to help you identify the definition.

    • Active - Select the toggle to activate or deactivate the definition. Only active definitions can be processed.

  8. Select Save.

  9. To process the definition, select Process. Follow the instructions in Process a data transformation definition.

    NOTE: You can process the definition later from the Data transformation definitions page.

Copy Field

Click image to view full size

  1. Select Result field.

  2. In the Select field dialog box, do the following:

    1. From the Table drop-down, select the table in which to copy the value.

      NOTE: The dialog box only shows those tables/fields that you are allowed to update.

    2. Select a column name from those shown. You can find a desired column by doing one of the following:

      • In the search box, enter the part or all of the column name. Axiom shows columns that include the name.

      • To display a tree structure of all the columns, select the arrow next to the table name.

        • NOTE: Be aware of the maximum character limit of this column. Data going into the result field will be truncated if it exceeds that limit.

    3. Select Apply.

  3. Select Input field, and in the Select field dialog box, select the table and column to copy the value.

  4. To identify the records in the database in which to apply the value, select Criteria. The Filter Wizard appears letting you define specific attribute to define the record(s) to update. For example, to apply a specific discharge date, you may not want to apply that change to every encounter. You can use the Filter Wizard to define what condition in which to add or edit the value, such as based on procedure code, diagnosis code, or any other attribute tied to the encounter. For instructions, see Using the Filter Wizard.

  5. In the Details section on the right side of the page, complete the following:

    • Notes- (Optional) Enter your own description to help you identify the definition.

    • Active - Select the toggle to activate or deactivate the definition. Only active definitions can be processed.

  6. Seelct Save.

  7. To process the definition, select Process. Follow the instructions in Process a data transformation definition.

    NOTE: You can process the definition later from the Data transformation definitions page.