Skip to main content

tenor

1. Description

The Tenor Calculation Type is used to extract the number of days between two date fields.

2. Screen Configuration

multikey_lookup_image

Here the number of days between AccOpenDate and AccMaturityDate is assigned to RepricingFreq. Suppose AccOpenDate='01-01-2025' and 'AccMaturityDate'= '10-01-2025', then '10' will be assigned to RepricingFreq.

Click ⬇️ to download the sample data.

3. Required Fields

  • name: Output Field Name.
  • data_type: Output Field Type.
  • derivation
    • derivation_type: The calculation type used to derive this output field, which for tenor is "TENOR".
    • req_fields
      • from_date: Date Field name from the input metadata / output config from which tenor should be calculated.
      • to_date: Date Field name from the input metadata / output config to which tenor should be calculated.