Related topics

Expression Builder

Writing a Conversion Rule

Fields Available in Expression Builder

Creating an Expression

To determine which records you want to import or export, you can type an expression in the text box in the Import/Export Record Selection group or use the Expression Builder. This group appears on the Template Defaults page as well as on the Import to Sage HRMS and Export from Sage HRMS pages.

  1. To access Expression Builder, click the Expression Builder arrow.
  2. Sage HRMS Link automatically defaults to the correct table in the From Table field so you do not need to make a selection in that field.
  3. Also, you do not need to make a selection in the Variables list; this list is available for programmers.
  4. Scroll through the Fields list and double-click the field you want to use in the expression.
  5. Expression Builder enters the field name in the Record Selection Criteria box.

    Note: Expression Builder enters the field name using the table alias. Sage HRMS does not recognize aliases during the import process. Therefore, if you are importing information, you must highlight and delete the file alias and period.

  6. Place the insertion point next to the field name and enter the logical operator.
  7. Enter a value to complete the expression.
  8. Click Verify. The Expression Builder presents a message indicating if you have used the correct structure for your expression. For example, if you have an equal sign, it will confirm that you have a value after the equal sign.
  9. When you are satisfied with the expression, click OK.

You want to export information only for those employees whose salary is over $40,000 per year.

  1. To access the Expression Builder, click the Expression Builder arrow.
  2. Scroll through the Fields list and double-click the p_salary field to place the salary field in the expression.
  3. Expression Builder enters the field name Pe.p_salary in the Record Selection Criteria box.
  4. Place the insertion point next to the field name and enter the greater than logical operator.
  5. Enter a value of 40000.
  6. The completed expression is: Pe.p_salary> 40000.
  7. Click Verify. The Expression Builder presents a message indicating if you’ve used the correct structure for your expression.
  8. When you are satisfied with the expression, click OK.