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 the
    Attribute
     tab.
    You can define or view a single text attribute for output on the mapping table. The maximum number of attributes is limited to 1.
  11. Enter a name for the attribute.
  12. (Optional) Click the
    Is Attribute Required
     check box to make the field mandatory for all mapping rules.
  13. Click
    OK
     to create the structure for the mapping table.