View Derived Field - SimPay

Derived Field: coll_aging_bucket

Back to List Edit Test

Field Details

Field Name:

coll_aging_bucket

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

TEXT

Version:

v1

Used In:

Summaries

Display Name:

Aging Bucket

Expression:

            {% if raw_data.aging_bucket is defined %}
                "{{ raw_data.aging_bucket }}"
            {% elif coll_days_overdue is defined %}
                {% if coll_days_overdue == 0 %}
                    "Current"
                {% elif coll_days_overdue <= 30 %}
                    "0-30 days"
                {% elif coll_days_overdue <= 60 %}
                    "31-60 days"
                {% elif coll_days_overdue <= 90 %}
                    "61-90 days"
                {% else %}
                    "90+ days"
                {% endif %}
            {% else %}
                "Unknown"
            {% endif %}

Dependencies

Field	Type	Actions
coll_days_overdue	Derived	View

Joins

No joins defined

Registry Information

No registry entry found

Version History

No version history available

Field Usage

Referenced by:

Basic Syntax

Jinja2 expressions can access context variables directly by name and apply operations or filters:

{{ total_amount * 0.10 }}

Filters

Filters transform values and are applied using the pipe operator:

{{ amount|round(2) }}

Available custom filters include:

date_format: Format dates, e.g., {{ date|date_format("%Y-%m-%d") }}
month_name: Convert month number to name, e.g., {{ month|month_name }}
round_to: Round to specified precision, e.g., {{ number|round_to(2) }}
percentage: Format as percentage, e.g., {{ ratio|percentage }}
default_if_none: Provide default value, e.g., {{ value|default_if_none("N/A") }}

Conditional Logic

You can use conditional expressions:

{{ "High Value" if amount > 1000 else "Standard" }}

Advanced Logic

For more complex logic, wrap in expressions:

{% set tier = "premium" if transactions > 10 else "standard" %}{{ tier }}

Basic Syntax

JSONLogic expressions are JSON objects that represent operations:

{"*": [{"var": "total_amount"}, 0.10]}

Accessing Variables

Use the var operator to access context variables:

{"var": "customer_name"}

Comparison Operators

Various comparison operators are available:

{">": [{"var": "amount"}, 1000]}

Logical Operators

Combine conditions with logical operators:

{"and": [
  {">": [{"var": "amount"}, 1000]},
  {"<": [{"var": "amount"}, 5000]}
]}

Conditional Logic

Use the if operator for conditional logic:

{"if": [
  {">": [{"var": "amount"}, 1000]},
  "High Value",
  "Standard"
]}