Field Details: coll_aging_bucket

Back to Fields
Basic Information
Field Name: coll_aging_bucket
Source Table: evolved_records
Version: 1
Expression Type: jinja
Output Type: TEXT
Status: Active
Created: 2025-10-16 04:31:29
Updated: 2025-10-16 04:31:29
Metadata
Display Name: Aging Bucket
Categories: COLLECTIONS
Group: Collection Metrics
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

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
  • coll_days_overdue