Home
Derived Field: coll_risk_score
Field Details
Field Name:
coll_risk_score
Source Table:
evolved_records
Status:
Active
Expression Type:
jinja
Output Type:
INTEGER
Version:
v1
Used In:
Summaries
Display Name:
Risk Score
Expression:
{% set base_score = 50 %}
{% if coll_days_overdue is defined %}
{% if coll_days_overdue > 90 %}
{% set base_score = base_score + 40 %}
{% elif coll_days_overdue > 60 %}
{% set base_score = base_score + 30 %}
{% elif coll_days_overdue > 30 %}
{% set base_score = base_score + 20 %}
{% elif coll_days_overdue > 0 %}
{% set base_score = base_score + 10 %}
{% endif %}
{% endif %}
{% if raw_data.payment_status == "DEFAULTED" %}
{% set base_score = base_score + 30 %}
{% elif raw_data.payment_status == "OVERDUE" %}
{% set base_score = base_score + 20 %}
{% elif raw_data.payment_status == "PARTIAL" %}
{% set base_score = base_score + 10 %}
{% endif %}
{% if raw_data.area_type == "RURAL" %}
{% set base_score = base_score + 5 %}
{% endif %}
{% if coll_total_due is defined and coll_total_due > 10000 %}
{% set base_score = base_score + 10 %}
{% endif %}
{{ min(base_score, 100) }}
Joins
No joins defined
Registry Information
No registry entry found
Version History
No version history available
Field Usage
Referenced by:
Loading...