SAIF.Business.Policy SQL catalog¶

This page indexes the SQL statements and stored-procedure calls used by SAIF.Business.Policy.

Read operations¶

SQL ID	Description	Type	Tables	Business object
SQL-001	Retrieve benefit-jurisdiction code-table entries.	Inline	see SQL page	`clsBenefitJurisdictionCodeMap`
SQL-002	Load hazard groups active for a supplied date.	Inline	see SQL page	`clsHazardGroupCollection`
SQL-003	Retrieve manual-class-type code-table entries.	Inline	see SQL page	`clsManualClassTypeCodeMap`
SQL-004	Retrieve anniversary rate date by policy period.	Inline	see SQL page	N/A (Application layer)
SQL-005	Call the submission-ownership Oracle function.	Inline	see SQL page	N/A (Application layer)
SQL-006	Find a printed P401 endorsement for the policy period.	Inline	see SQL page	N/A (Application layer)
SQL-007	Retrieve the persisted market-type code for a policy.	Inline	see SQL page	N/A (Application layer)
SQL-008	Retrieve the maximum period effective date for a policy.	Inline	see SQL page	N/A (Application layer)
SQL-009	Retrieve the latest eligible premium-history set.	Inline	see SQL page	N/A (Application layer)
SQL-010	Call the Oracle rating package for minimum-premium calculation.	Stored Proc	see SQL page	N/A (Application layer)
SQL-011	Retrieve policy-period expiration date by policy and effective date.	Inline	see SQL page	N/A (Application layer)