coll_template_eligibility_analysis

Edit Execute Back to List
Basic Information
Name:
coll_template_eligibility_analysis
Description:
Analysis of template eligibility across different payout types
Source Table:
evolved_records
Status:
Active
Visibility:
Public
Tags:
category_collections template_eligibility legacy_metrics
Query Configuration
Dimensions:
  • coll_product_group
  • coll_aging_bucket
Metrics:
  • * () → total_accounts
  • CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.fixed') = TRUE THEN 1 END () → fixed_eligible
  • CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.additional') = TRUE THEN 1 END () → additional_eligible
  • CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.settlement') = TRUE THEN 1 END () → settlement_eligible
  • CASE WHEN JSON_EXTRACT(coll_template_eligibility, '$.deduction') = TRUE THEN 1 END () → deduction_eligible
  • coll_emi_capping_amount () → total_emi_capping
  • coll_emi_capping_amount () → avg_emi_capping
Filters:
  • summary_data.category_code = COLLECTIONS
Recent Executions

No execution history available.

© SimSol Technologies and Services Private Limited