Subvention Amount Adjustment Logic – Documentation
Objective
Implement logic to adjust the claim payout calculation when a Subvention Amount is available in the matched Bank File (BF) or Tentative Bank File (TBF).Functional Requirement
Matching Source
The system shall first identify the matched:- Bank File (BF)
- Tentative Bank File (TBF) — only if no BF match is found
Subvention Adjustment Logic
Condition
If a Subvention Amount is present in the matched BF/TBF record, then the system shall deduct the following from the payout calculation base amount:- Subvention Amount
OR - Disbursal Amount available in BF/TBF
(as per configured rate/ratio calculation logic)
Calculation Rule
Existing Logic
Currently: Claim Amount = Rate/Ratio × Disbursal AmountUpdated Logic
When Subvention Amount exists: Eligible Amount = Disbursal Amount - Subvention Amount Then: Claim Amount = Rate/Ratio × Eligible AmountSystem Behaviour
Case 1 — Subvention Amount Present
Input
- Disbursal Amount = ₹5,000
- Subvention Amount = ₹1,000
- Rate = 10%
Calculation
Eligible Amount = 5,000 - 1,000 = 4,000 Claim Amount = 10% of 4,000 = ₹400Expected Result
System should calculate payout on ₹4,000 only.Case 2 — Subvention Amount Not Present
Input
- Disbursal Amount = ₹5,000
- Subvention Amount = NULL
- Rate = 10%
Calculation
Claim Amount = 10% of 5,000 = ₹500Expected Result
Normal payout calculation should continue.Validation Rules
- Subvention deduction shall apply only when:
- BF/TBF is successfully matched
- Subvention Amount is greater than 0
- If Subvention Amount exceeds Disbursal Amount:
- System should block processing
- Validation message:
Priority Logic
- Use matched Bank File (BF) data first
- If BF not available, use Tentative Bank File (TBF)
- Apply subvention deduction on the selected matched source only
Impacted Modules
- Lead Claim Calculation
- Bank File Matching
- Tentative Bank File Matching
- ERP Push Validation
- Claim Summary/Reports