Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Create Mapping Table

Create Mapping Table

You've created a mapping table definition.
Security:
Set Up: Mapping Tables
 domain in the Accounting Center functional area.
You can create a mapping table to define rules to map your input values to your target output values.
  1. Access the
    Create Mapping Table
     task.
  2. For
    Mapping Table Definition
    , select the mapping table definition you previously created, and click
    OK
    .
    Workday displays the mapping table with the structure of the selected definition.
    Once you create a mapping table based on the definition, you can't edit the mapping table definition.
    To display accounting worktags for a mapping table when using an Enterprise Interface Builder (EIB), you must edit the template to add the Accounting Worktag columns. See Customize EIB Spreadsheet Template.
  3. As you complete mapping inputs to target output values, keep these guidelines in consideration:
    Mapping Functionality
    Guidelines
    Input Values
    For each row, enter a combination of input values that map to a particular output value.
    If you leave value blank, Workday won't evaluate the column for that row.
    Operators
    When entering input values, you can use these operators:
    • NOT: Checks whether a value isn't equal to OR isn't like an input value. Examples: NOT abc, NOT ab?
    • IS NULL: Checks whether a field value is empty.
    • IS NOT NULL: Checks whether a field value isn't empty.
    • IN (list): Checks whether a value is within a set of values. Example: IN (abc, def, xyz).
    • NOT IN (list): Checks whether a value isn't within a set of values. Example: NOT IN (abc, def, xyz).
    Wildcard Expressions
    If you selected to include wildcards when defining a parameter on the mapping definition, use ? to match any single character. Example: 10?0 matches these codes: 1020, 1030, 1080.
    Use * to match any number of characters.
    Example: A*00 matches all codes starting with A and ending with 00, such as A100, A1000, A1100, A1200.
    Range Expressions
    If you selected Range Field on the mapping table definition, enter a Range Start and Range End value.
    You can enter Alphanumeric ranges. Example: A100 - D300
    Workday evaluates range expression as a string. Example: Value of 5 falls outside a range of 1-19, but value of 05 falls within a range of 01-19.
    Output Values
    Select the desired output value resulting from the combination of input values.
    Workday evaluates rules from the top down and once it finds the mapping, it stops further evaluation. Therefore, order rules from most to least specific using
    Order
    .
  4. Once you complete creating all rules, click
    OK
     and then
    Done
    .