2.4.5 Derived Business Terms

Derived Terms are expressions or formulas used that generate values not directly available from Business Terms. Derived Terms provide users with access to pre-defined and custom data derivations. These derived terms represent calculated or logical attributes created using existing data elements, helping users understand how specific business metrics or transformations are generated.

The system provides both seeded data (predefined terms and expressions) and the ability for users to custom derive business terms tailored to specific needs.

This guide demonstrates the following.

  • View existing derived terms, including both seeded and custom terms.
  • Create new custom derived terms by defining expressions using business data.
  • Review and manage derived terms to ensure consistency, accuracy, and relevance in your data-driven processes.

    Note:

    • Derived Business Terms support only Oracle SQL single-row functions. For more details see, Single-Row Functions.
    • Aggregation and XML/JSON functions are not supported.
  1. Open the application and navigate to the Data Catalog section in the left-hand menu.
  2. Under Data Catalog, select Derived Terms. The Derived Terms page will appear, displaying all available derived terms
  3. The Derived Terms list page displays key information about each derived term.
    Column Description
    Name The name of the derived term (e.g., Account Age in Months).
    Element Type Indicates the type of data (e.g., Numerical Non-Monetary, Flag or Indicator).
    Description Provides a short explanation of how the derived term is calculated.
    View Button Opens a detailed view of the selected derived term.
  4. Use the Search bar to look up a term by name or description.
  5. Filter results by Seeded/Customized or Element Type.
  6. Use the Sort By drop down to arrange the list as needed.
  7. Click Create Derived Term to define a new derived term (if you have the appropriate permissions).
  8. On the Derived Terms list page, click the View button next to the term you wish to explore.
  9. The Derived Term Details panel opens, showing two main tabs:
    • Expression: The Expression tab displays the logic or formula used to derive the term. Example: Account Age in Months

      Description: Refers to Account Age. The attribute is derived using the difference between the Value Date and As Of Date in months.

      TRUNC(MONTHS_BETWEEN([As Of Date],[Value Date]))

    • References: The References tab lists the specific entities (data domains or subject areas) where this derived term is applied, along with the corresponding expressions.

      Note:

      In DFCS 25C release, datatype validation during Derived Business Term creation is not implemented. Ensure that the selected Element Type (datatype) matches the expected output datatype of the expression.

      Examples:

      • For expressions such as EXTRACT(YEAR FROM [As Of date]), select Date and Timestamp as the Element Type.
      • Select Numerical – Monetary or Numerical Non-Monetary as the Element Type.

      Selecting an incorrect Element Type (for example, choosing Numerical (Non-Monetary)for a date-based expression) may result in successful creation of an invalid Derived BT.

      Datatype validation will be implemented in a future DFCS release.

Creating a New Derived Term

  1. Click Create Derived Term at the top-right corner of the Derived Terms page.

    Table 2-4 Enter the following details

    Field Description
    Derived Term Name Name of the new derived term (e.g., Total Advance Payment Amount).
    Element Type Select the type of data (e.g., Monetary Amount, Text Description).
    Description A brief description of the derived term (e.g., "Testing Total Advance Payment Amount").
    Business Terms Select the relevant business terms associated with the derived term.
    Expression Enter the formula for the derived term (e.g., CONCAT or MINUS)).
    Justification Provide a justification for the term (e.g., "Justification of Total Advance Payment Amount").

    Note:

    If the expression contains syntax errors (such as missing parentheses), the system will display a Validation Failed message.
  2. Verify all the details, including the term name, expression, and justification.
  3. Under Entities, confirm where the derived term will be applied (e.g., Overdraft Accounts, Loan Contracts, Cards).
  4. Click Create to create the new derived term.
  5. After successfully creating the derived term, you will see a Submission Successful message confirming the term is created.
  6. Once the derived Business Term is created, it appears in the list of derived terms and can be added to a custom ADS connector mapping template for future connector configurations.

Edit Business Terms

The Edit option is available only for custom derived business terms.

From the term's details page, you can choose to edit its expression or delete the term if needed. For more information see, Application Data Services Connectors.
  1. To edit a derived term, navigate to the Derived Terms section in your Data Foundation for Banking interface.
  2. Use the filter to select the term type:
    • Click the filter dropdown and select either Custom or Seeded depending on the type of derived term you wish to edit.
    • You may also use the search bar to find the term by its name or description.
  3. Browse or search for the desired derived term in the list.
    1. Click the View button next to the derived term you want to edit. For example: "Custom Derived Account Status Date AllTest".
    2. On the term details pane, you will see the current definition including:
      • Derived Term Name (read-only)
      • Element Type (e.g., Date and Timestamp)
      • Description
    3. You can update the Description or other editable fields depending on the permissions.
    4. Click Continue to proceed to the Review and Update window.
    5. Click Update to update the derived term.