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

Create Mapping Table Definition

Use the
Maintain Worktag Usage
 task to enable worktag as either a primary or alternate dimension for the taggable type of Mapping Table Definition.
Security:
Set Up: Mapping Table Definitions
 domain in the Accounting Center functional area.
You can create a mapping table definition to:
  • Define the number of input values in your mapping table.
  • Define the number and type of outputs.
In addition to 1-to-1 mapping, you can also map:
  • One input value to many output values.
  • Many input values to 1 output value.
  • Many input values to many output values.
You can also use the table definition to configure how to define input values by using wildcards and ranges.
Once you create a mapping table definition and create a mapping table based on the definition, you can't edit the mapping table definition.
  1. Access the
    Create Mapping Table Definition
     task.
  2. Enter a name for the mapping table definition.
  3. (Optional) Create or select a Source System.
  4. Enable
    Ledger Account
     if you want to map ledger accounts.
  5. Select an
    Account Set
     if you're mapping to a ledger account.
  6. Click the
    Parameters
     tab.
  7. As you complete the parameters inputs for the mapping definition, consider:
    Option
    Description
    Display Name
    Enter the display name for each parameter. Example: Policy, State.
    Allow Wildcards
    Select if you want to enable wildcards when you define mapping rules.
    Workday doesn’t support wildcards in ranges.
    If you have wildcards (* and ?) in your dataset and want to evaluate them as string values, you might not want to enable this option.
    Range Field
    Select if you want to specify a range when you define mapping rules.
    You can't specify a range and wildcard for the same external code.
    You can enter a maximum of 20 parameter inputs.
  8. Click the
    Worktags
     tab.
  9. As you complete the
    Primary Worktag Types
     and
    Additional Worktag Types
     grids, consider:
    Field
    Description
    Accounting Worktag Types
    Select worktag types to which you want to map your transactional data.
    Worktag Type Required
    Set up worktag types as required. If you require a worktag type, you must select a worktag value for every row when you create mapping table rules.
    Disallow Inactive Value
    s
    Select for Workday to remove inactive values automatically.
    Each primary worktag type you define is displayed in a separate column. All additional worktag types are displayed in a single column, enabling you to select additional worktags from a single column.
  10. Click
    OK
     to create the structure for the mapping table.