Retrieve maximum premium history set id

Retrieve maximum premium history set id.

Field	Value
Operation ID	OP-005
Trigger	A caller needs the current premium-history set identifier.
Inputs	IDataPortalInfo, policy number, policy period effective date
Outputs	Premium history set id or 0
Primary components	PolicyInformation
Entry point	Business\SAIF.Business.Policy\PolicyInformation.vb

Steps

1. Issue SQL-009 against PREM_HIST_SUMMARY.
2. Filter to the eligible premium-history type codes for the supplied policy period.
3. Return the maximum set id, or 0 when Oracle returns DBNull.
4. Apply related business rules: BR-POL-005, BR-POL-006

Process flow

The following diagram visualizes the main control flow for this operation.

flowchart TD

  Start([Trigger]) --> Work[Execute operation steps]

  Work --> Done([Return result])

Failure and edge-case behavior

• Business rules are cross-referenced from the catalog page and the SQL or procedure logic cited in these steps.
• Database and procedure failures surface according to the underlying implementation path.

Related documentation

• Operations and processes
• Business rules
• SQL catalog
• Database tables

Sources

• Business\SAIF.Business.Policy\PolicyInformation.vb