---
title: "Collections interest and payment selection"
summary: Operation implemented by CollectionsRepository
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data.NHibernate
reference_type: package
operation_id: "OP-SDN-05"
trigger: "See steps below"
---


# Collections interest and payment selection

Collections interest and payment selection is implemented by `CollectionsRepository` and is documented as OP-SDN-05 in the Stage 1 analysis.

| Field | Value |
| --- | --- |
| **Operation ID** | OP-SDN-05 |
| **Trigger** | See steps below |
| **Primary components** | `CollectionsRepository` |

## Steps

1. `GetInterest(caseId, runDate)`: [SQL-013](../sql/SQL-013-collections-repository-get-interest.md).
2. `GetMissingPolicyPayments(selectDate)` ([SQL-014](../sql/SQL-014-collections-repository-get-missing-policy-payments.md)) and `GetThirdPartyPayments(selectDate)` ([SQL-015](../sql/SQL-015-collections-repository-get-third-party-payments.md)).
3. `DebtorsWithoutPayments(lastStatementDate)` ([SQL-016](../sql/SQL-016-collections-repository-debtors-without-payments.md)) and `DebtorsWithExpiredLocs(selectDate)` ([SQL-017](../sql/SQL-017-collections-repository-debtors-with-expired-locs.md)).
4. `BalanceBroughtToMinAmountTransactions(selectDate)`: [SQL-018](../sql/SQL-018-collections-repository-balance-brought-to-min-amount-transactions.md).

## Process flow

The following diagram visualizes this operation's control flow.

```mermaid
flowchart TD
	Start(["Collections interest and payment selection"]) --> S1["`CollectionsRepository`"]
	S1 --> S2{"Rules satisfied?"}
	S2 -->|Yes| EndOk([Result returned])
	S2 -->|No| EndErr([Exception / empty result])
```

## Related documentation
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- `Data/SAIF.Data.NHibernate/Repositories/CollectionsRepository.cs`