Skip to content

SAIF.Business.Claim stored procedures

This page catalogs Oracle stored procedures and functions referenced by SAIF.Business.Claim.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
sp82046_CalcAggRightDates [unqualified]** Standalone procedure Referenced by code but not found in Oracle or SQL Server source. clsAggRightDates
sp82067_TimelinessOf1stPayment [unqualified]** Standalone procedure Referenced by code but not found in Oracle or SQL Server source. clsITimelinessOfFirstPayment
sp82286_statutoryweeklywage WCIS_DBA Standalone procedure Implements Oracle-side business logic. clsStatutoryWeeklyWageCalculation
sp82289_medicallystationarydt [unqualified]** Standalone procedure Referenced by code but not found in Oracle or SQL Server source. clsMedicallyStationaryDate

Note: sp82046_CalcAggRightDates, sp82067_TimelinessOf1stPayment, and sp82289_medicallystationarydt were re-checked against SQL Server (2026-08-17) via legends sqlserver query in addition to the original Oracle search; none were found in either engine.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.Claim\clsAggRightDates.vb
  • Business\SAIF.Business.Claim\clsITimelinessOfFirstPayment.vb
  • Business\SAIF.Business.Claim\clsStatutoryWeeklyWageCalculation.vb
  • Business\SAIF.Business.Claim\clsMedicallyStationaryDate.vb