---
title: "SAIF.Data.NHibernate stored procedures"
summary: Oracle and SQL Server stored procedures and packages referenced by this library
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data.NHibernate
reference_type: package
---


# SAIF.Data.NHibernate stored procedures

This page catalogs the Oracle PL/SQL packages and the SQL Server stored procedure invoked by this library (7 packages/procedures total, 6 retrieved successfully and 1 not returned by the database).

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`PK80010_LEGAL_COLLECTIONS`](pk80010-legal-collections.md) | WCIS_DBA | Package | Implements: get_cases_by_reference, get_category_totals, getDebtorSSN, getDebtorName, getPrimaryDebtorName, get_fraud_other_address, get_policy_address, get_thirdparty_address, search_collections, applyPayments (→ applyIt, legalcol_payment_ref_insert), interest_calc_select (→ get_interest_start_date), getPolicyPayments, getThirdPartyPayments, getDebtorsWithoutPayments, getDebtorsWithExpiredLocs, getBalanceBroughtToMinAmount, get_last_statement_balance | CollectionsRepository |
| [`PK80011_LEGALCOL_SOIL`](pk80011-legalcol-soil.md) | WCIS_DBA | Package | Implements: create_reference_records, create_SOIL_transactions (→ find_DOR_balance, insert_soil_tran, remove_soil_flag) | CollectionsRepository |
| [`PK72846_VIEW_POLICY`](pk72846-view-policy.md) | WCIS_DBA | Package (function) | Implements: SP73111_GET_WCIS_STD_PREMIUM | PoliciesRepository |
| [`PK73101_IMAGE`](pk73101-image.md) | WCIS_DBA | Package (procedure overload of function) | Implements: TRACK_IN_REPORT (procedure overload → remote `track_in_report@POLDB`) | PolicyPeriodPayrollAuditRepository |
| [`PK82001_CLAIM`](pk82001-claim.md) | WCIS_DBA | Package | Implements: getMissingTLPayments — ⚠️ **not present** in the retrieved spec or body (package contains only getPersonAddress_GW, typeAddressExists_GW) | MissingTimeLossRepository (⚠️ possibly dead code — the call would fail at runtime) |
| [`bp_clm_segmntn_complexity_score`](bp-clm-segmntn-complexity-score.md) | dbo | SQL Server procedure | Implements: bp_clm_segmntn_complexity_score (→ dbo.bp_clm_segmntn_complexity_score_dtl, dbo.bp_clm_segmntn_complexity_score_dtl_2026, eis_staging.dbo.bp_send_message — not retrieved**) | ClaimScoreRepository |
| [`PK82039_BILLENTRY_TASK_PROCESS`](pk82039-billentry-task-process.md) | Unknown** | Package** | ⚠️ Not returned by the database (not-found-by-cli); referencing code flagged possibly dead | None — ⚠️ possibly dead code: the named queries have no caller; ClaimBillEntryRepository delegates to ICCClaimApiService |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Security and authorization](../security-authorization.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [API reference](../api/index.md)

## Sources
- `Data/SAIF.Data.NHibernate/Mappings/**`