How Can We Help?

Search icon

Search Results

Unify Unit Hierarchies Across the Interfolio Platform

This article outlines the unit unification process required to transition to Interfolio’s Platform Unit Management. By consolidating unit hierarchies across Faculty Activity Reporting (FAR) and Lifecycle modules (Review, Promotion & Tenure (RPT), Faculty Search(FS), and Lifecycle Management(LM)), institutions gain a single, unified structure that improves consistency and simplifies downstream workflows. The article explains how to configure, download, and complete the unification spreadsheet, with critical warnings to ensure a successful upload.

 

Institutions using only Lifecycle modules or only FAR are exempt from the unit unification process. In these cases, Interfolio can simply enable the feature flag, allowing immediate access to Platform Unit Management without any additional steps.

 

Important Warnings

  • Unit Unification is Final: Once you transition to Platform Unit Management, the change is permanent. You cannot revert to the previous system.
  • Spreadsheet Downloads: You may download the unification spreadsheet multiple times for review or planning purposes. However, you may only upload it once, so you must ensure it's accurate before submission.
  • Column Restrictions: You may only rearrange units vertically within the non-source column. Do not move units between columns.
  • No Cell Modifications: Do not alter any cell content, including unit names. If changes are needed, they must be made outside of the unification process.
 

Data Refresh Timing

  • Snowflake Refresh Interval: Data changes, such as creating or deleting cases, positions, and other records, are refreshed in Snowflake every four hours. For example, if a user deletes a position to enable unit deletion, they may need to wait up to four hours before the unit deletion becomes possible.
  • FAR Refresh Interval: FAR operates on a similar delay, but its data is refreshed once nightly.
 

Setup Unit Unification

Follow the steps outlined in the accordions below to align your unit hierarchies across all Interfolio modules for a consistent and streamlined setup:

1. Setup unit hierarchy settings

  1. If your institution has not yet set up units, you’ll be directed to the Units page, which includes instructions for building a single unit hierarchy, an overview of the unification process, and configuration options under File Download Settings. 
    Units page describing how to build a single unit hierarchy, the unification process steps, and the File Download Settings
  2. Scroll down to the File Download Settings section to select the settings to be used for unification. These settings determine how the unification spreadsheet is laid out.
    File Download Settings options
    • Select a Module to Use as the Source for Units: Choose either Lifecycle or FAR as your source.

      The source units will remain unchanged. Only unmatched units from the other module may be added. 

       

      If the institution uses FAR, it is often (though not always) the more complete and up-to-date unit hierarchy. In the unit unification spreadsheet, the column corresponding to the selected source module (either Lifecycle or FAR) will display that module’s full unit hierarchy. The non-source column will contain our best attempt to match units from the other module to the source.

      At the bottom of the non-source column, you’ll find units that could not be automatically matched. These should be carefully reviewed and repositioned within the column to align with their appropriate counterpart in the source column. If unmatched units remain at the bottom, they will still be created when the unification spreadsheet is uploaded.

       
    • Configure Download or Manually Match Units: Choose whether to use the algorithm to automatically match units or leave all units unmatched for full manual control.
 
 

2. Download template file and complete unit unification

  1. Once the desired settings are selected, click the Download Template File button.

    You may download the spreadsheet multiple times to explore different formats. However, you may only upload the file once, so ensure it’s final before submission.

     

    Administrators may choose to update unit hierarchies directly within each module’s user interface rather than editing the unification spreadsheet. If they choose this approach, after making changes in the UI they must re-download the spreadsheet with the “Manually match all units” option selected. After downloading, no further edits should be made to the spreadsheet. They will simply upload it as-is to complete the unification process.

     
  2. Open the downloaded file and complete the unit unification task. To complete the unification task, review the non-source column and align each unit with its corresponding row in the source column. This ensures an accurate and unified hierarchy across modules.

    Be sure to copy and paste the rows exactly as they are and do not move units from one column to another. Only move units up and down within the non-source column to align with the correct match in the source column. It is critical that the administrator DOES NOT modify the content of any of the cells in the spreadsheet, including unit names or extra text. Any changes will cause the upload to fail.

     
  3. When the administrator downloads the unit unification spreadsheet, the layout will be consistent:
    • Column A: Lifecycle units
    • Column B: FAR units
    • Column C: Confidence % (indicating the strength of the automated match)
 
 

3. Upload finalized spreadsheet

Once the matching is completed and confirmed you will upload the finalized spreadsheet, the system will process and apply the unit hierarchy, and you’ll transition to Platform Unit Management.

Unit Unification in Progress

Unit unification is a one-time event. Once completed, no further changes can be made through this process. It is not possible to go back once you’ve moved to Platform Unit Management.

 
 
 

Affected Applications

Faculty Activity Reporting

  • Units (Administration > Setup > Units) will be read only in regards to unit details.  However, administrators can still configure administrative rights on the unit configuration page.
    FAR > Setup > Organizational Structure page
  • Upload Units and Configuring Unit Upload will no longer be available.
    Setup Upload Form page

 

 
 

Lifecycle Applications

The Users & Groups > Units tab for RPT and FS will no longer be shown. Administrators may see a call out about managing units directing them to the platform units page.

Review, Promotion & Tenure Users & Committees page of RPT
Faculty Search Users & Titles page of FS

 

 

 
 

Affected APIs & Integrations

  FAR Lifecycle Applications (RPT, FS, LM)
APIs None known at this time
Integrations FAR Unit auto-loads MUST be disabled by the Technical Services team None known at this time

FAQs

How should someone decide which module to use as the source?

Generally, you’ll choose the side that will be least impacted by the changes you need to make. If your institution has invested more time maintaining FAR, it’s often the better choice as the source, though this may vary depending on your setup.

 
 

How is the source determined when the unified spreadsheet is uploaded?

The module selected as the source when downloading the unification spreadsheet also defines the source during upload.

It is critical to use the same source for both download and upload to ensure consistency and avoid errors.

 
 
 

What happens if a unit’s level in the non-source column doesn’t match its level in the source column?

If a unit in the non-source column is assigned a different level than its corresponding unit in the source column, it will be automatically adjusted to match the level of the unit in the source column during the unification process.

 
 

We recommend downloading the spreadsheet multiple times using different matching settings. This allows you to experiment and identify the configuration that produces the most accurate unit matches for your institution.

 
 

What guidance should be provided to users during the unification file upload process?

In most cases, processing the unification file takes less than 15 minutes. While we recommend uploading the file during off-peak hours to minimize disruption, it is not necessary to block user access or take the site offline. Users can continue working in the system during processing, though we advise avoiding major unit-related changes until the upload is complete to ensure consistency.

 
 

How are blank cells treated in the spreadsheet?

  • Non-source column: Blank cells in the non-source column will be automatically filled using the corresponding unit from the source column.
  • Source column: The source column should never contain blank cells, except at the bottom of the spreadsheet where unmatched units from the non-source column are listed. Administrators should review these unmatched units to try to find their matches, if applicable, in the source column.
  • Unmatched units: If unmatched units remain at the bottom of the non-source column, Interfolio will attempt to locate their parent units within the non-source column and create them under the corresponding parent in the source column during upload.
 
 

Can unmatched or unwanted units in the non-source column be deleted from the unification sheet?

No. Units should not be removed directly from the unification spreadsheet. If there are unmatched or unwanted units in the non-source column, they should be deleted either before downloading the sheet or after the unification process is complete. Removing units from the spreadsheet itself will cause the unification process to fail.

 
 
Was this article helpful?
Give feedback about this article