Derived Field: coll_risk_category
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: