SQL-010: Calculate minimum premium and expense constant¶
Call the Oracle rating package for minimum-premium calculation.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-010 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | N/A (Application layer) |
| Criteria property | N/A |
| Lifecycle method | PolicyMinimumPremium |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
| in_prem_hist_set_id | Input | NUMBER | N/A | Premium-history set identifier. |
| out_minimum_premium_amount | Output | NUMBER | N/A | Calculated minimum premium. |
| out_expense_constant_amount | Output | NUMBER | N/A | Calculated expense constant. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| PREM_HIST_SUMMARY | Stored procedure read | Premium-history-set context |
| POLICY_PERIOD | Stored procedure read | Policy-period context |
Sample SQL¶
pk73069_rating_procs.get_minimum_expense_constant(
in_prem_hist_set_id => :in_prem_hist_set_id,
out_minimum_premium_amount => :out_minimum_premium_amount,
out_expense_constant_amount => :out_expense_constant_amount)
Operations and processes¶
Business rules¶
- See Business rules.
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Policy\PolicyInformation.vb