SAIF.Data.NHibernate operations and processes¶
This page is the operation catalog and cross-operation hub for this library. Each operation's detailed, step-by-step logic lives in its own page under operations/.
Operation catalog¶
Process flow diagram¶
The following diagram visualizes the primary operational flow for collections case processing, the most cross-referenced business process in this library.
flowchart TD
Start([Collections request]) --> Lookup[Collections case lookups]
Lookup --> Interest[Interest and payment selection]
Interest --> Apply[Apply payments]
Apply --> Soil{SOIL eligible?}
Soil -->|Yes| SoilProc[SOIL processing]
Soil -->|No| EndOk([Case updated])
SoilProc --> EndOkDatabase interactions¶
The following table summarizes which operations read from or write to the database. Per-step SQL and table citations live in each operation's detail page under operations/.
Failure and edge-case behavior¶
- Claim bill queue operations (OP-SDN-01/02) delegate entirely to
ICCClaimApiService; the legacy named queries (SQL-050, SQL-051) are unused and their backing package (PK82039_BILLENTRY_TASK_PROCESS) could not be retrieved (not-found-by-cli) — see Procedures. - SOIL processing (OP-SDN-06): the acronym expansion is inferred from the package name and is not independently verified*.
- Group image filtered search (OP-SDN-13): the deleted-image visibility filter's boolean logic is anomalous (inverted) — see the HIGH-severity finding in Security and authorization.
- Missing time-loss payments (OP-SDN-10): the named query invokes
PK82001_CLAIM.getMissingTLPayments, which is absent from the retrieved package; the call would fail at runtime if ever invoked — see procedures/pk82001-claim.md.
Stored procedure operations¶
Operations implemented in Oracle and SQL Server stored procedures referenced by this library.
| Operation | Description | Source | Link |
|---|---|---|---|
| Look up collection cases by reference | Returns case headers for a case, policy or claim reference | PK80010_LEGAL_COLLECTIONS.get_cases_by_reference |
Details |
| Summarise case category totals | Category totals, subtotal and current balance for a case | PK80010_LEGAL_COLLECTIONS.get_category_totals |
Details |
| Resolve debtor name / SSN | Resolve display name or SSN across debtor types | PK80010_LEGAL_COLLECTIONS.getDebtorName, getPrimaryDebtorName, getDebtorSSN |
Details |
| Get debtor addresses | Contact info for fraud-other, policy and third-party debtors | PK80010_LEGAL_COLLECTIONS.get_fraud_other_address, get_policy_address, get_thirdparty_address |
Details |
| Search collections | Multi-branch debtor/case search | PK80010_LEGAL_COLLECTIONS.search_collections |
Details |
| Apply payments to costs | Allocates unapplied payments across cost transactions by pay-down order | PK80010_LEGAL_COLLECTIONS.applyPayments → applyIt → legalcol_payment_ref_insert |
Details |
| Calculate interest | Monthly or daily interest per interest-bearing transaction | PK80010_LEGAL_COLLECTIONS.interest_calc_select → get_interest_start_date |
Details |
| Select payments and debtors for statements | Batch selections for payment posting and statements | PK80010_LEGAL_COLLECTIONS.getPolicyPayments, getThirdPartyPayments, getDebtorsWithoutPayments, getDebtorsWithExpiredLocs, getBalanceBroughtToMinAmount, get_last_statement_balance |
Details |
| Create SOIL reference records | Snapshot SOIL-eligible debtors for the run | PK80011_LEGALCOL_SOIL.create_reference_records |
Details |
| Create SOIL adjustment transactions | Adds/changes/deletes DOR intercept balances | PK80011_LEGALCOL_SOIL.create_SOIL_transactions → find_DOR_balance, insert_soil_tran, remove_soil_flag |
Details |
| Get WCIS standard premium | Returns standard premium for a policy period | PK72846_VIEW_POLICY.SP73111_GET_WCIS_STD_PREMIUM |
Details |
| Track payroll report in | Records report receipt on the remote policy database | PK73101_IMAGE.track_in_report (procedure) |
Details |
| Score claim complexity | Persist request and run segmentation models | bp_clm_segmntn_complexity_score |
Details |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Business rules
- Database tables
- SQL catalog
- Procedures
- Security and authorization
- API reference
Sources¶
Data/SAIF.Data.NHibernate/Repositories/**