[2026-06-29 17:52:06] INFO: evaluate.received {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","has_file":true,"filename":"temp_2026-06-29_17:43:58_1782735238_co_lending_loan_decision.xlsx","size":15441,"mime":null,"ip":null}
[2026-06-29 17:52:06] INFO: import.sheet_parsed {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","rows_seen":1,"rows_kept":1,"rows_skipped":0}
[2026-06-29 17:52:06] INFO: evaluate.excel_parsed {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row_count":1}
[2026-06-29 17:52:06] INFO: policy.request {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","url":"http://localhost:7000/api/live/policy/policy-d9204242"}
[2026-06-29 17:52:07] INFO: policy.response {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","ok":true,"http_status":200,"duration_ms":937,"response":{"grade":{"rules":{"Blacksoil-Navdhan":{"rule":[{"description":["Blacksoil Age >=21 and <=60 pass else reject"],"key":"age","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Borrower Maturity Age"],"key":"borrower_maturity_age","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Co Applicant Age 2"],"key":"co_applicant_age_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Co Applicant Age 1"],"key":"co_applicant_age_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil gender Male - \"Male - approve, If female then check marital status, If Female then check else ignore this rule Marital Status- Reject single women as primary borrower"],"key":"gender","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - co_applicant_bureau_score_1 (upto 3 lakh loan, >=620 OR -1 to 18 else reject)"],"key":"co_applicant_bureau_score_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Overdue Amount\t<=1000, pass"],"key":"overdue_amount","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Household Monthly Income, >25000, pass"],"key":"household_monthly_income","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - DPD (0-6 Months) if\t<=30 pass"],"key":"dpd_0_6_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Business Vintage (Years) - >=3 years else reject"],"key":"business_vintage_years","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Co-applicant 2 Maturity Age (<=63 else reject)"],"key":"co_applicant_maturity_age_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil tenure - <=36 months else reject"],"key":"tenure","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Borrower Bureau Score (upto 3 lakh loan amount, >=650 else reject) or Loan Amount >3 Lakh and If score >700 pass else reject"],"key":"bureau_score","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence Vintage (Years)  >=3 years else reject"],"key":"residence_vintage_years","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Bank Statement 6M, Minimum 6 months"],"key":"bank_statement_6m","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Co-applicant 1 Maturity Age (<=63 else reject)"],"key":"co_applicant_maturity_age_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - co_applicant_bureau_score_2 (upto 3 lakh loan, >=620 OR -1 to 18 else reject)"],"key":"co_applicant_bureau_score_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Active Credit Lines Count - Value\t<=3 pass"],"key":"active_credit_lines_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - DPD (6-12 Months),\t<=60 pass"],"key":"dpd_6_12_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Applicant NTC, pass if no"],"key":"applicant_ntc","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Cheque Bounce Count 6M,No bounce in last 6 months, pass"],"key":"cheque_bounce_count_6m","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Enquiries Last 3 Months\tValue\t<=5 pass"],"key":"enquiries_last_3_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Household Annual Income, > 3 lakh, pass"],"key":"household_annual_income","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence to Branch Distance (km) - <=30 KM from branch else reject"],"key":"residence_to_branch_distance_km","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Loan Amount - <=4,00,000 else reject"],"key":"loan_amount","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence Ownership - Owned/Ancestral/Rent Free else reject"],"key":"residence_ownership","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Son,Father,mother,Grandfather,Grandmother,Brother, Uncle (immediate paternal and maternal uncle) - pass else reject"],"key":"co_applicant_relationship_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Son,Father,mother,Grandfather,Grandmother,Brother, Uncle (immediate paternal and maternal uncle) - pass else reject"],"key":"co_applicant_relationship_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Foir foir <= 50% pass else fail"],"key":"foir","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - 1. Expansion of existing business.
2. Purchase of additional stock / raw material / working capital
3. Purchase of machinery/equipment
4. Refinancing of existing loans in case of an existing Navadhan customer"],"key":"loan_utilization","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil bureau_loss_count > 0 fail else pass"],"key":"bureau_loss_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_dbt_count > 0 reject else pass"],"key":"bureau_dbt_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_sub_count any value received > 0 reject else pass"],"key":"bureau_sub_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_write_off_count < 1000 pass else reject"],"key":"bureau_write_off_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_settlement_count > 0 reject else pass"],"key":"bureau_settlement_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}}]}}}},"error":null}
[2026-06-29 17:52:07] INFO: policy.parsed {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","policy_count":1,"policy_names":["Blacksoil-Navdhan"]}
[2026-06-29 17:52:07] INFO: row.start {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"application_id":"MP040LE002800"}
[2026-06-29 17:52:07] INFO: row.lead_created {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"application_id":"MP040LE002800","vendor_loan_id":3}
[2026-06-29 17:52:07] INFO: row.co_applicants_saved {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"vendor_loan_id":3,"count":2}
[2026-06-29 17:52:07] INFO: row.decision_data_saved {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"vendor_loan_id":3,"decision_keys":93}
[2026-06-29 17:52:07] INFO: row.api_request {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"vendor_loan_id":3,"url":"http://localhost:8889/","policies_payload":["Blacksoil-Navdhan"],"decision_keys":["application_id","age","gender","marital_status","applicant_ntc","household_monthly_income","household_annual_income","household_expenses","existing_emi_obligations","business_income","agriculture_income","dairy_income","foir","eligible_emi","eligible_loan_amount","loan_utilization","name_of_bureau","bureau_score","bureau_pull_date","overdue_amount","dpd_0_6_months","bureau_sub_count","bureau_dbt_count","bureau_loss_count","bureau_write_off_count","bureau_settlement_count","bureau_suit_filled_count","bureau_willful_default_count","restructured_count","dpd_6_12_months","enquiries_last_3_months","active_credit_lines_count","bank_statement_6m","cheque_bounce_count_6m","loan_amount","tenure","interest_rate","apr","repayment_frequency","loan_purpose","residence_area","residence_vintage_years","residence_ownership","residence_to_branch_distance_km","business_vintage_years","asset_fridge_value","asset_air_conditioner_value","asset_washing_machine_value","asset_tv_value","asset_smart_phone_value","co_applicant_age_1","co_applicant_relationship_1","co_applicant_years_of_stay_in_current_address_1","co_applicant_ntc_1","co_applicant_financial_status_1","co_applicant_name_of_bureau_1","co_applicant_bureau_score_1","co_applicant_bureau_pull_date_1","co_applicant_overdue_amount_1","co_applicant_dpd_0_6_months_1","co_applicant_dpd_6_12_months_1","co_applicant_bureau_sub_count_1","co_applicant_bureau_dbt_count_1","co_applicant_bureau_loss_count_1","co_applicant_bureau_write_off_count_1","co_applicant_bureau_settlement_count_1","co_applicant_bureau_suit_filed_count_1","co_applicant_bureau_willful_default_count_1","co_applicant_restructured_count_1","co_applicant_enquiries_last_3_months_1","co_applicant_active_credit_lines_count_1","co_applicant_age_2","co_applicant_relationship_2","co_applicant_years_of_stay_in_current_address_2","co_applicant_ntc_2","co_applicant_financial_status_2","co_applicant_name_of_bureau_2","co_applicant_bureau_score_2","co_applicant_bureau_pull_date_2","co_applicant_overdue_amount_2","co_applicant_dpd_0_6_months_2","co_applicant_dpd_6_12_months_2","co_applicant_bureau_sub_count_2","co_applicant_bureau_dbt_count_2","co_applicant_bureau_loss_count_2","co_applicant_bureau_write_off_count_2","co_applicant_bureau_settlement_count_2","co_applicant_bureau_suit_filed_count_2","co_applicant_bureau_willful_default_count_2","co_applicant_restructured_count_2","co_applicant_enquiries_last_3_months_2","co_applicant_active_credit_lines_count_2","borrower_maturity_age"],"payload":{"grade":{"rules":{"Blacksoil-Navdhan":{"rule":[{"description":["Blacksoil Age >=21 and <=60 pass else reject"],"key":"age","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Borrower Maturity Age"],"key":"borrower_maturity_age","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Co Applicant Age 2"],"key":"co_applicant_age_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Co Applicant Age 1"],"key":"co_applicant_age_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil gender Male - \"Male - approve, If female then check marital status, If Female then check else ignore this rule Marital Status- Reject single women as primary borrower"],"key":"gender","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - co_applicant_bureau_score_1 (upto 3 lakh loan, >=620 OR -1 to 18 else reject)"],"key":"co_applicant_bureau_score_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Overdue Amount\t<=1000, pass"],"key":"overdue_amount","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Household Monthly Income, >25000, pass"],"key":"household_monthly_income","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - DPD (0-6 Months) if\t<=30 pass"],"key":"dpd_0_6_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Business Vintage (Years) - >=3 years else reject"],"key":"business_vintage_years","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Co-applicant 2 Maturity Age (<=63 else reject)"],"key":"co_applicant_maturity_age_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil tenure - <=36 months else reject"],"key":"tenure","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Borrower Bureau Score (upto 3 lakh loan amount, >=650 else reject) or Loan Amount >3 Lakh and If score >700 pass else reject"],"key":"bureau_score","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence Vintage (Years)  >=3 years else reject"],"key":"residence_vintage_years","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Bank Statement 6M, Minimum 6 months"],"key":"bank_statement_6m","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Co-applicant 1 Maturity Age (<=63 else reject)"],"key":"co_applicant_maturity_age_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - co_applicant_bureau_score_2 (upto 3 lakh loan, >=620 OR -1 to 18 else reject)"],"key":"co_applicant_bureau_score_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Active Credit Lines Count - Value\t<=3 pass"],"key":"active_credit_lines_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - DPD (6-12 Months),\t<=60 pass"],"key":"dpd_6_12_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Applicant NTC, pass if no"],"key":"applicant_ntc","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Cheque Bounce Count 6M,No bounce in last 6 months, pass"],"key":"cheque_bounce_count_6m","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Enquiries Last 3 Months\tValue\t<=5 pass"],"key":"enquiries_last_3_months","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Household Annual Income, > 3 lakh, pass"],"key":"household_annual_income","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence to Branch Distance (km) - <=30 KM from branch else reject"],"key":"residence_to_branch_distance_km","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Loan Amount - <=4,00,000 else reject"],"key":"loan_amount","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - Residence Ownership - Owned/Ancestral/Rent Free else reject"],"key":"residence_ownership","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Son,Father,mother,Grandfather,Grandmother,Brother, Uncle (immediate paternal and maternal uncle) - pass else reject"],"key":"co_applicant_relationship_1","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Son,Father,mother,Grandfather,Grandmother,Brother, Uncle (immediate paternal and maternal uncle) - pass else reject"],"key":"co_applicant_relationship_2","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil Foir foir <= 50% pass else fail"],"key":"foir","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil - 1. Expansion of existing business.
2. Purchase of additional stock / raw material / working capital
3. Purchase of machinery/equipment
4. Refinancing of existing loans in case of an existing Navadhan customer"],"key":"loan_utilization","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["Blacksoil bureau_loss_count > 0 fail else pass"],"key":"bureau_loss_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_dbt_count > 0 reject else pass"],"key":"bureau_dbt_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_sub_count any value received > 0 reject else pass"],"key":"bureau_sub_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_write_off_count < 1000 pass else reject"],"key":"bureau_write_off_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}},{"description":["bureau_settlement_count > 0 reject else pass"],"key":"bureau_settlement_count","priority":1,"value":{"against":["Over 9 levels deep, aborting normalization"],"source":["Over 9 levels deep, aborting normalization"]}}],"payload":{"application_id":"MP040LE002800","age":43,"gender":"female","marital_status":"married","applicant_ntc":"no","household_monthly_income":28300,"household_annual_income":339600,"household_expenses":85700,"existing_emi_obligations":9041,"business_income":28300,"agriculture_income":0,"dairy_income":0,"foir":47,"eligible_emi":90531,"eligible_loan_amount":100000,"loan_utilization":"expansion of existing business","name_of_bureau":"crif","bureau_score":702,"bureau_pull_date":"1983-01-01","overdue_amount":0,"dpd_0_6_months":0,"bureau_sub_count":0,"bureau_dbt_count":0,"bureau_loss_count":0,"bureau_write_off_count":0,"bureau_settlement_count":0,"bureau_suit_filled_count":0,"bureau_willful_default_count":0,"restructured_count":0,"dpd_6_12_months":0,"enquiries_last_3_months":0,"active_credit_lines_count":1,"bank_statement_6m":1,"cheque_bounce_count_6m":0,"loan_amount":100000,"tenure":36,"interest_rate":31,"apr":34.14,"repayment_frequency":"monthly","loan_purpose":"business expansion","residence_area":"rural","residence_vintage_years":20,"residence_ownership":"owned","residence_to_branch_distance_km":30,"business_vintage_years":16,"asset_fridge_value":10000,"asset_air_conditioner_value":0,"asset_washing_machine_value":12000,"asset_tv_value":8000,"asset_smart_phone_value":20000,"co_applicant_age_1":59,"co_applicant_relationship_1":"husband","co_applicant_years_of_stay_in_current_address_1":"","co_applicant_ntc_1":"no","co_applicant_financial_status_1":"financial","co_applicant_name_of_bureau_1":"crif","co_applicant_bureau_score_1":745,"co_applicant_bureau_pull_date_1":"2025-03-26","co_applicant_overdue_amount_1":0,"co_applicant_dpd_0_6_months_1":0,"co_applicant_dpd_6_12_months_1":0,"co_applicant_bureau_sub_count_1":0,"co_applicant_bureau_dbt_count_1":0,"co_applicant_bureau_loss_count_1":0,"co_applicant_bureau_write_off_count_1":0,"co_applicant_bureau_settlement_count_1":0,"co_applicant_bureau_suit_filed_count_1":0,"co_applicant_bureau_willful_default_count_1":0,"co_applicant_restructured_count_1":0,"co_applicant_enquiries_last_3_months_1":0,"co_applicant_active_credit_lines_count_1":3,"co_applicant_age_2":43,"co_applicant_relationship_2":"brother in law","co_applicant_years_of_stay_in_current_address_2":30,"co_applicant_ntc_2":"yes","co_applicant_financial_status_2":"financial","co_applicant_name_of_bureau_2":"crif","co_applicant_bureau_score_2":0,"co_applicant_bureau_pull_date_2":"2026-04-15","co_applicant_overdue_amount_2":0,"co_applicant_dpd_0_6_months_2":0,"co_applicant_dpd_6_12_months_2":0,"co_applicant_bureau_sub_count_2":0,"co_applicant_bureau_dbt_count_2":0,"co_applicant_bureau_loss_count_2":0,"co_applicant_bureau_write_off_count_2":0,"co_applicant_bureau_settlement_count_2":0,"co_applicant_bureau_suit_filed_count_2":0,"co_applicant_bureau_willful_default_count_2":0,"co_applicant_restructured_count_2":0,"co_applicant_enquiries_last_3_months_2":0,"co_applicant_active_credit_lines_count_2":0,"borrower_maturity_age":46}}}}}}
[2026-06-29 17:52:08] INFO: row.api_response {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"vendor_loan_id":3,"http_status":200,"ok":true,"duration_ms":884,"response":{"Blacksoil-Navdhan":{"failed_condition":{"key":"loan_utilization","reason":"Purchase of additional stock/ raw material/ working capital"},"policy_status":false,"rules":[{"against":["pass","equal"],"key":"age","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["pass","equal"],"key":"borrower_maturity_age","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["18","lessThanEqual"],"key":"co_applicant_age_2","log":[],"reason":"Passed: 18.0 lessThanEqual 43","result":true,"source":43},{"against":["18","lessThanEqual"],"key":"co_applicant_age_1","log":[],"reason":"Passed: 18.0 lessThanEqual 59","result":true,"source":59},{"against":["pass","equal"],"key":"gender","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["pass","equal"],"key":"co_applicant_bureau_score_1","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["1000","greaterThanEqual"],"key":"overdue_amount","log":[],"reason":"Passed: 1000.0 greaterThanEqual 0","result":true,"source":0},{"against":["25000","lessThan"],"key":"household_monthly_income","log":[],"reason":"Passed: 25000.0 lessThan 28300","result":true,"source":28300},{"against":["30","greaterThanEqual"],"key":"dpd_0_6_months","log":[],"reason":"Passed: 30.0 greaterThanEqual 0","result":true,"source":0},{"against":["3","lessThanEqual"],"key":"business_vintage_years","log":[],"reason":"Passed: 3.0 lessThanEqual 16","result":true,"source":16},{"against":["pass","equal"],"key":"co_applicant_maturity_age_2","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["36","greaterThanEqual"],"key":"tenure","log":[],"reason":"Passed: 36.0 greaterThanEqual 36","result":true,"source":36},{"against":["pass","equal"],"key":"bureau_score","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["3","lessThanEqual"],"key":"residence_vintage_years","log":[],"reason":"Passed: 3.0 lessThanEqual 20","result":true,"source":20},{"against":["pass","equal"],"key":"bank_statement_6m","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["pass","equal"],"key":"co_applicant_maturity_age_1","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["pass","equal"],"key":"co_applicant_bureau_score_2","log":[],"reason":"Passed: pass equal pass","result":true,"source":"pass"},{"against":["3","greaterThanEqual"],"key":"active_credit_lines_count","log":[],"reason":"Passed: 3.0 greaterThanEqual 1","result":true,"source":1},{"against":["60","greaterThanEqual"],"key":"dpd_6_12_months","log":[],"reason":"Passed: 60.0 greaterThanEqual 0","result":true,"source":0},{"against":["no","equal"],"key":"applicant_ntc","log":[],"reason":"Passed: no equal no","result":true,"source":"no"},{"against":["0","greaterThanEqual"],"key":"cheque_bounce_count_6m","log":[],"reason":"Passed: 0.0 greaterThanEqual 0","result":true,"source":0},{"against":["5","greaterThanEqual"],"key":"enquiries_last_3_months","log":[],"reason":"Passed: 5.0 greaterThanEqual 0","result":true,"source":0},{"against":["300000","lessThan"],"key":"household_annual_income","log":[],"reason":"Passed: 300000.0 lessThan 339600","result":true,"source":339600},{"against":["30","greaterThanEqual"],"key":"residence_to_branch_distance_km","log":[],"reason":"Passed: 30.0 greaterThanEqual 30","result":true,"source":30},{"against":["400000","greaterThanEqual"],"key":"loan_amount","log":[],"reason":"Passed: 400000.0 greaterThanEqual 100000","result":true,"source":100000},{"against":[["rented","owned","leased","owned w/o regn"],"inList"],"key":"residence_ownership","log":[],"reason":"owned","result":true,"source":"owned"},{"against":[["son","father","mother","grandfather","grandmother","brother","uncle"],"inList"],"key":"co_applicant_relationship_1","log":[],"reason":"father","result":false,"source":"husband"},{"against":[["son","father","mother","grandfather","grandmother","brother","uncle"],"inList"],"key":"co_applicant_relationship_2","log":[],"reason":"father","result":false,"source":"brother in law"},{"against":["50","greaterThanEqual"],"key":"foir","log":[],"reason":"Passed: 50.0 greaterThanEqual 47","result":true,"source":47},{"against":[["Expansion of existing business","Purchase of additional stock/ raw material/ working capital","Purchase of machinery/equipment","Refinancing of existing loans in case of an existing Navadhan customer"],"inList"],"key":"loan_utilization","log":[],"reason":"Purchase of additional stock/ raw material/ working capital","result":false,"source":"expansion of existing business"},{"against":["0","greaterThanEqual"],"key":"bureau_loss_count","log":[],"reason":"Passed: 0.0 greaterThanEqual 0","result":true,"source":0},{"against":["0","lessThanEqual"],"key":"bureau_dbt_count","log":[],"reason":"Passed: 0.0 lessThanEqual 0","result":true,"source":0},{"against":["0","lessThanEqual"],"key":"bureau_sub_count","log":[],"reason":"Passed: 0.0 lessThanEqual 0","result":true,"source":0},{"against":["1000","greaterThanEqual"],"key":"bureau_write_off_count","log":[],"reason":"Passed: 1000.0 greaterThanEqual 0","result":true,"source":0},{"against":["0","lessThanEqual"],"key":"bureau_settlement_count","log":[],"reason":"Passed: 0.0 lessThanEqual 0","result":true,"source":0}]},"status":false},"error":null}
[2026-06-29 17:52:08] INFO: row.bre_decision_saved {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","row":1,"vendor_loan_id":3,"bre_decision_id":3,"status":"success","decision":null}
[2026-06-29 17:52:08] INFO: evaluate.completed {"batch_id":"9e37c7e1-f499-4aee-a6ac-2cb7450d1873","summary":{"total":1,"succeeded":1,"failed":0,"validation_failed":0,"skipped_duplicate":0}}