Home

Derived Field: coll_risk_category

Back to List Edit Test
Field Details

Field Name:

coll_risk_category

Source Table:

evolved_records

Status:

Active

Expression Type:

jinja

Output Type:

TEXT

Version:

v1

Used In:

Summaries

Display Name:

Risk Category

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
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:

Loading...