Variable & Schema Mapper

Explore DB tables, input variables, and global constants used in the Command Box.

Schema Explorer

Database tables and columns (e.g. cust_salary, credit_score, residence_type)

Table Columns Source
Customer_Info cnic, full_name, dob, residence_type, monthly_income, existing_emi, cust_salary Application form
Employment_Data employer_name, designation, tenure_months, salary_slip_verified Application form
Credit_Bureau credit_score, total_exposure, dpd_30, dpd_90, active_loans Etisalat / CRIF / Experian
Blacklist cnic, list_type, matched_at Internal / External lists

Global Constants

Update one value to change 100 rules (e.g. MIN_SALARY = 5000)

  • MIN_SALARY Minimum monthly salary
    Integer
  • MAX_DBR_PCT Max Debt Burden Ratio %
    Decimal
  • MIN_CREDIT_SCORE Minimum credit score
    Integer
  • MIN_AGE Minimum applicant age
    Integer
  • MAX_AGE Maximum applicant age
    Integer

Input Variables

Data from application form, Credit Bureau, and internal blacklists

Application Form

  • Customer_Info.*
  • Employment_Data.*
  • Application.loan_amount, tenure_months

Credit Bureau

  • Credit_Bureau.credit_score
  • Credit_Bureau.total_exposure, dpd_30, dpd_90
  • Credit_Bureau.active_loans

Blacklists

  • Blacklist.list_type (internal / external)
  • Terrorist watchlists, internal defaulters (LMS)