SQL-013 Get parent policy

Retrieve the parent policy number for a policy.

Classification

Field	Value
SQL ID	SQL-013
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	clsPolicyData
Criteria property	GetParentPolicySQL
Lifecycle method	GetParentPolicyData

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal	N/A	Policy number
:in_is_policyholder_user	Input	String	1	Policyholder-user flag
:v_parent_policy_num	ReturnValue	Decimal	N/A	Parent policy number

Tables

N/A — Stored procedure

Sample SQL

-- Oracle stored procedure call (CommandType.StoredProcedure, Scalar)
-- clsPolicyData.GetParentPolicyData
CALL pk72846_view_policy.getParentPolicy(
  :in_policy_num,
  :in_is_policyholder_user,
  :v_parent_policy_num)   -- ParameterDirection.ReturnValue

Operations and processes

• Authorize a user for a policy
• Retrieve affiliated policies (legacy)

Business rules

• BR-VP-009: Fallback to parent-policy authorization
• BR-VP-011: Policy always affiliated with itself

Sources

• SAIF.Business.View.Policy/clsPolicyData.vb