SQL-035: PoliciesRepository.GetPolicyStandardPremium

This statement is a read operation invoked through StoredProc (named query Policies_GetPolicyStandardPremium, function from dual). Executed by PoliciesRepository.GetPolicyStandardPremium.

Classification

Field	Value
SQL ID	SQL-035
Operation type	Read
Execution method	StoredProc (named query Policies_GetPolicyStandardPremium, function from dual)
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	PoliciesRepository
Criteria property	N/A — no IBusinessCriteria
Lifecycle method	GetPolicyStandardPremium

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	NUMBER (.NET long)	N/A	Policy number
:in_pol_per_eff_date	Input	DATE	N/A	Policy period effective date
standardPremium	Return	NUMBER → System.Decimal	N/A	WCIS standard premium

Tables

Table	Access	Columns used
DUAL	Read	See Sample SQL**
internals delegated to pk73059_prem_hist_summary (not retrieved**)	Read	See Sample SQL**

Sample SQL

Source: Data/SAIF.Data.NHibernate/Mappings/Policies/Policies.hbm.xml:3

select PK72846_VIEW_POLICY.SP73111_GET_WCIS_STD_PREMIUM(
    :in_policy_num,
    :in_pol_per_eff_date
) as standardPremium from dual

Operations and processes

• Policy standard premium

Business rules

• PROC-RULE-040
• PROC-RULE-041

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Data/SAIF.Data.NHibernate/Repositories/PoliciesRepository.cs:14