SAIF.Business.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type. All statements found are read-only — this library owns no INSERT/UPDATE/DELETE SQL.

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Retrieve benefit-jurisdiction code/description list	Inline	BENEFIT_JURISDICTION_CODE	clsBenefitJurisdictionCodeMap
SQL-002	Retrieve hazard groups effective on a date	Inline (StringBuilder-assembled)	HAZARD_GROUP	clsHazardGroupCollection
SQL-003	Retrieve manual-class-type code/description list	Inline	MANUAL_CLASS_TYPE_CODE	clsManualClassTypeCodeMap
SQL-004	Retrieve anniversary rate date for a policy period	Inline	POLICY_PERIOD, POLICY_PERIOD_NON_WCIS	PolicyInformation
SQL-005	Retrieve market type code for a policy	Inline	POLICY	PolicyInformation
SQL-006	Determine whether WCIS owns a policy submission	Inline (PL/SQL function via DUAL)	N/A (PL/SQL function)	PolicyInformation
SQL-007	Check whether the information page was printed	Inline	ENDORSEMENT	PolicyInformation
SQL-008	Retrieve maximum policy effective date	Inline	POLICY_PERIOD	PolicyInformation
SQL-009	Retrieve maximum premium-history set ID	Inline	PREM_HIST_SUMMARY	PolicyInformation
SQL-010	Retrieve minimum premium and expense constant	Stored Proc	N/A (stored procedure)	PolicyInformation
SQL-011	Retrieve policy-period expiration date	Inline	POLICY_PERIOD, POLICY_PERIOD_NON_WCIS	PolicyInformation

Related documentation

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

Sources

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