coll_commission_readiness

Edit Execute Back to List
Basic Information
Name:
coll_commission_readiness
Description:
Analysis of data readiness for commission calculations
Source Table:
evolved_records
Status:
Active
Visibility:
Public
Tags:
category_collections commission_readiness data_quality
Query Configuration
Dimensions:
  • coll_agency_code
  • raw_data.agency_name
Metrics:
  • * () → total_accounts
  • CASE WHEN coll_agent_code != 'UNKNOWN' THEN 1 END () → has_agent_code
  • CASE WHEN coll_commission_base_amount > 0 THEN 1 END () → has_base_amount
  • CASE WHEN coll_negative_allowed = false AND coll_commission_base_amount < 0 THEN 1 END () → negative_blocked
  • coll_commission_base_amount () → total_commission_base
  • coll_emi_capping_amount () → avg_emi_capping
  • CASE WHEN coll_is_special_case THEN 1 END () → special_case_count
Filters:
  • summary_data.category_code = COLLECTIONS
Recent Executions

No execution history available.

© SimSol Technologies and Services Private Limited