Create a data source field map

Field maps create a reference between the data source columns and transaction columns.

Before you begin

Role required: budget_admin, cost_transparency_admin

About this task

Transaction table is associated to a segment. Define a relationship between data source and transaction fields to allow flexible data cleansing and bucket split. Also allows for generating budget keys and actuals in budget planning.

Procedure

  1. Navigate to Data Sources from Cost Transparency or Financial Planning.
  2. Open a data source record.
  3. Click New to create a field map.
  4. Fill out the fields on the form (see table).
  5. Click Submit.
    Field descriptions to create a data source field map.
    Field Description
    Data source Auto populates the data source for which the field map is created.
    Datasource field Select a column on the data source table for field mapping.
    Segment name Choose the segment to map it to transaction table.
    Mapped to transaction field Select a column on the transaction table for field mapping.
    Used by Budgeting Select the check box to make this field map reference available for financial planning for generating actuals and budget keys.
    Used by cleansing Select the check box to make this field map reference available for cleansing in cost transparency.
    Used for Bucket split Select the check box to make this field map reference available for cost bucket split when using the Allocation Setup tab of the cost transparency workbench.