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
© SimSol Technologies and Services Private Limited