Field Details: coll_recommended_strategy

Back to Fields
Basic Information
Field Name: coll_recommended_strategy
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: Recommended Collection Strategy
Categories: COLLECTIONS
Group: Collection Strategy
Usage
Used in Summary: Yes
Used in Template: No

Description

No description available

Expression

            {% if coll_priority_level is defined and coll_risk_score is defined %}
                {% if coll_priority_level == "HIGH" %}
                    {% if coll_risk_score >= 80 %}
                        "IMMEDIATE_ESCALATION"
                    {% else %}
                        "PRIORITY_CONTACT"
                    {% endif %}
                {% elif coll_priority_level == "MEDIUM" %}
                    {% if coll_days_overdue > 60 %}
                        "STRUCTURED_PAYMENT_PLAN"
                    {% else %}
                        "REMINDER_SEQUENCE"
                    {% endif %}
                {% else %}
                    "REGULAR_FOLLOW_UP"
                {% endif %}
            {% else %}
                "NEEDS_ASSESSMENT"
            {% endif %}
            
Dependencies
  • coll_priority_level
  • coll_risk_score
  • coll_days_overdue