Basic Information
| Field Name: |
coll_risk_category |
| 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: |
Risk Category |
| Categories: |
COLLECTIONS
|
| Group: |
Risk Assessment |
Usage
| Used in Summary: |
Yes
|
| Used in Template: |
No
|
Description
No description available
Expression
{% set risk_factors = 0 %}
{% if coll_days_overdue > 90 %}
{% set risk_factors = risk_factors + 3 %}
{% elif coll_days_overdue > 60 %}
{% set risk_factors = risk_factors + 2 %}
{% elif coll_days_overdue > 30 %}
{% set risk_factors = risk_factors + 1 %}
{% endif %}
{% if raw_data.bounce_count is defined and raw_data.bounce_count > 2 %}
{% set risk_factors = risk_factors + 2 %}
{% endif %}
{% if raw_data.product_product_risk_level is defined %}
{% if raw_data.product_product_risk_level == "HIGH" %}
{% set risk_factors = risk_factors + 2 %}
{% elif raw_data.product_product_risk_level == "MEDIUM" %}
{% set risk_factors = risk_factors + 1 %}
{% endif %}
{% endif %}
{% if risk_factors >= 5 %}
"CRITICAL"
{% elif risk_factors >= 3 %}
"HIGH"
{% elif risk_factors >= 1 %}
"MEDIUM"
{% else %}
"LOW"
{% endif %}
Dependencies
© SimSol Technologies and Services Private Limited
SimPay