Skip to Content
Product Information
Author's profile photo Xavier Le Garrec

Publish to MDF demo and deep dive

This recording is a deep dive into the new Publish to MDF feature that will be live on Preview servers on October 15, 2021 and on Production servers on November 19, 2021.

Getting data into Compensation worksheets from MDF objects has been available since the First Half 2020 release but this new publish to MDF enhancement opens up many possibilities for data management over the years as well as more flexibility for implementations of complex compensation programs.

Use cases include :

  • Long Term Incentives vesting over several years.
  • Complex compensation requirements specific to a customer (for example a process where the requirement is to use data from several effective dates to get to an output and there is no need to keep the data in EC because it is very specific to a few hundred employees).
  • Removing complexity from Compensation templates to place it in MDF (calculations can be built in MDF custom fields), please see the example in the recording from the blog at 12’30).


Key takeaways of the Publish to MDF feature :

  • The MDF must have a field called “cust_templateId” of data type “Number”.
  • The standard field “externalCode” of the MDF must be of type “User”.
  • The administrator running the publish to MDF must have read and edit permissions on the new MDF in Role Based Permissions (on top of Manage Compensation > “Store Compensation Data in MDF” permissions).
  • Only the following fields are supported : Amount, Money, Date and Text.
  • In the Compensation template XML there can only be one MDF publish section per MDF.
  • Additional custom fields that are not used in the publish back can be configured in the MDF and updated through an On Save business rule.
  • In order to override a first publish to MDF, administrators must select the “Allow Override” checkbox in “Publish selected employees to the MDF”.
  • When we need the publish the MDF record with a different effective date for each employee it is advised to have the date column on the worksheet in a read-only mode and have it populated from a lookup table (in that sense it is different from the recording). An example of date column populated from a lookup table can be found here.
  • Known limitation : Publish to MDF is only available for Compensation templates, it is not supported yet for Total Compensation and Variable Pay templates.
  • For a more technical details and use cases regarding the Publish to MDF feature, please visit the official Product Management blog post here :






How to mass delete published back MDF records :




Thank you,


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.