SAIF.Business.Claim stored procedures

This page catalogs the 4 distinct Oracle stored procedures invoked by this library. The Legends CLI was queried individually for each of the 4 procedure names on 2026-08-31: sp82286_statutoryweeklywage returned its full PL/SQL source (schema WCIS_DBA) and is documented below with real parameters, business rules, and sample SQL. The other 3 — sp82046_CalcAggRightDates, sp82067_TimelinessOf1stPayment, sp82289_medicallystationarydt — were each queried by exact name and the CLI returned no source; their status is not-found-by-cli, not "retrieval unavailable." Because a proper retrieval attempt was made for these three and failed, their referencing .NET call sites are flagged as possibly dead code, pending further investigation — this is a hedge, not a definitive finding. clsStatutoryWeeklyWageCalculation (the caller of the one found procedure) is confirmed live code and carries no dead-code flag.

Procedure catalog

Package / Procedure	Schema	Type	Status	Purpose	Calling business objects
sp82286_statutoryweeklywage	WCIS_DBA	Standalone procedure (with one nested private procedure)	found	Calculate the statutory weekly wage for a claim	clsStatutoryWeeklyWageCalculation
sp82046_CalcAggRightDates	Unknown — not returned by CLI	Unknown — presumed procedure from the BOF call site only	not-found-by-cli	Calculate aggravation-rights dates for a claim	clsAggRightDates
sp82067_TimelinessOf1stPayment	Unknown — not returned by CLI	Unknown — presumed procedure from the BOF call site only	not-found-by-cli	Evaluate timeliness of first payment for a claim	clsTimelinessOfFirstPayment
sp82289_medicallystationarydt	Unknown — not returned by CLI	Unknown — presumed procedure from the BOF call site only	not-found-by-cli	Retrieve the medically-stationary date for a claim	clsMedicallyStationaryDate

Note on the class-name discrepancy for sp82067_TimelinessOf1stPayment: the source file is named clsITimelinessOfFirstPayment.vb (with an I), but the class it declares is clsTimelinessOfFirstPayment (no I). The class name above is correct; the file path in each page's ## Sources retains the I.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• SQL catalog
• API reference

Sources

• SAIF.Business.Claim/clsAggRightDates.vb
• SAIF.Business.Claim/clsITimelinessOfFirstPayment.vb
• SAIF.Business.Claim/clsMedicallyStationaryDate.vb
• SAIF.Business.Claim/clsStatutoryWeeklyWageCalculation.vb
• Retrieved via legends oracle query --name sp82286_statutoryweeklywage on 2026-08-31 (found); legends oracle query --name sp82046_CalcAggRightDates, legends oracle query --name sp82067_TimelinessOf1stPayment, and legends oracle query --name sp82289_medicallystationarydt on 2026-08-31 (not found by CLI)