Working with Mapped Translation Codes

You can add new mapped translation codes on the File Layout Setup page. You can also update an existing mapped translation code if an account/product ID, organization, current expected credit loss (CECL) category, or other value is mapped incorrectly.

Incorrect or unmapped translation codes can lead to exceptions in the daily or monthly update process.
  1. Select Update, and then select either Daily Update Process or Monthly Update Process from the menu.
  2. Select the correct Update Date or Update Month.
  3. Select the link in the Layout Name column for the file.
    The File Layout Setup page opens.
  4. Select the field from the field list.
  5. Locate the Translations section.

    File Layout Setup page Translations section.

  6. Select a sorting option from the Sort By drop-down list, if needed.
  7. Select a situation and follow the corresponding steps.
    Situation Steps
    Adding Translation Codes

    1. Select Get Codes to view a list of currently unmapped codes.

      You can select the values and save codes from the Get Codes dialog box, if they appear in the list.

    2. Select "" Add.
    3. Enter the Code.
    4. Select the corresponding value from the drop-down list.

    5. Select a Treatment, if applicable.

      This field is not available for all translations.
    Updating Translation Codes
    1. Locate the Code to update.
    2. Select a different corresponding value from the drop-down list.

    3. Select a different Treatment, if applicable.

      This field is not available for all translations.
    Copying Translation Codes

    You can copy the translation codes from Financial Performance Suite (FPS) and paste them into another application.

    1. Select Copy.

      All translations are copied to the computer clipboard.

    2. Open the application to paste the translation codes into.

      You can paste the translation codes into any application, for example, Excel®.

    3. Paste the translation codes into the application.
    Pasting Translation Codes

    You can copy and paste translation codes from Excel® into FPS.

    1. Copy the translation codes and corresponding values from Excel® to the computer clipboard.

      The Excel® spreadsheet must contain the Code in one column and the corresponding value in a second column. The corresponding values must match the exact values that are in the FPS Setup pages.

    2. Select Paste in the FPS Translations section.
    3. Verify that each Code and corresponding value is mapped correctly.
    Deleting Translation Codes
    1. Select the check box for all codes that you want to delete.
    2. Select "" Delete.
    3. Select Delete to confirm the deletion.
  8. Select Save.
Parent topic: File Layout Setup