SAIF.Business.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type. All statements are read-only; the library issues no INSERT, UPDATE, DELETE, or MERGE statements from .NET code.

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Retrieve all benefit jurisdiction codes and descriptions	Inline	BENEFIT_JURISDICTION_CODE	clsBenefitJurisdictionCodeMap
SQL-002	Retrieve hazard groups effective on a given date	Inline	HAZARD_GROUP	clsHazardGroupCollection
SQL-003	Retrieve all manual class type codes and descriptions	Inline	MANUAL_CLASS_TYPE_CODE	clsManualClassTypeCodeMap
SQL-004	Retrieve a policy's market type code	Inline	POLICY	PolicyInformation
SQL-005	Determine whether WCIS owns the policy submission	Inline (function call)	DUAL	PolicyInformation
SQL-006	Check whether a policy period's information page was printed	Inline	ENDORSEMENT	PolicyInformation
SQL-007	Retrieve the latest premium-history set id for a policy/period	Inline	PREM_HIST_SUMMARY	PolicyInformation
SQL-008	Retrieve a policy's latest period effective date	Inline	POLICY_PERIOD	PolicyInformation
SQL-009	Retrieve a policy period's anniversary rate date (WCIS or non-WCIS)	Inline	POLICY_PERIOD, POLICY_PERIOD_NON_WCIS	PolicyInformation
SQL-010	Retrieve a policy period's expiration date (WCIS or non-WCIS)	Inline	POLICY_PERIOD, POLICY_PERIOD_NON_WCIS	PolicyInformation
SQL-011	Retrieve the minimum premium and expense constant via Oracle package	Stored Proc	N/A	PolicyInformation

Related documentation

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

Sources

• SAIF.Business.Policy/PolicyInformation.vb
• SAIF.Business.Policy/clsHazardGroupCollection.vb
• SAIF.Business.Policy/CodeMaps/clsBenefitJurisdictionCodeMap.vb
• SAIF.Business.Policy/CodeMaps/clsManualClassTypeCodeMap.vb