Skip to content

SAIF.Business stored procedures

This page catalogs Oracle packages and standalone procedures invoked by SAIF.Business.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk73101_image WCIS_DBA Package Imaging helper package used to track report status and summarize who was alerted for an image. ImageServices
pk80001_LegalNet WCIS_DBA Package Legal-alert package that determines whether a claim has at least one legal case flagged for image alerts. ImageServices
pk82001_claim WCIS_DBA Package Claim-address package that resolves person mailing or payment addresses using date-sensitive fallback logic. ClaimServices
pk82029_titan WCIS_DBA Package Employee-leave package that performs create, list, update, and delete operations for employee leave rows. clsEmployeeLeave, clsEmployeeLeaveCollection
pk82350_eft WCIS_DBA Package EFT-authorization package that validates authorization, beneficiary enrollment, provider authorization, and card-enrollment counts. ClaimServices, EFTServices
sp62087_get_policy_address WCIS_DBA Standalone procedure Policy-address procedure that resolves mailing and correspondence addresses for a policy and correspondence type. PolicyServices
SP72232_Calc_Policy_Exp_Date WCIS_DBA Standalone function Policy-expiration function that calculates a default expiration month from the function code, effective date, and financial-system input. PolicyServices
sp82348_claim_authorization WCIS_DBA Standalone procedure Claim-authorization procedure that counts qualifying authorization-limit rows for a requesting employee and amount. ClaimServices

Sources

  • Business\SAIF.Business\ClaimServices.vb
  • Business\SAIF.Business\clsEmployeeLeave.vb
  • Business\SAIF.Business\EFTServices.vb
  • Business\SAIF.Business\ImageServices.vb
  • Business\SAIF.Business\PolicyServices.vb