SQL-019: Parent policy resolution (superseded)¶
clsPolicyData used this call to resolve the parent of an affiliated policy before the association type code table took over that responsibility. The calling member is marked <Obsolete>; the current path is the Associations property.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-019 |
| 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 | not specified | Policy number whose parent is being resolved. |
:in_is_policyholder_user |
Input | String | 5 | TRUE/FALSE flag passed through to the internal affiliate-type lookup. |
:v_parent_policy_num |
ReturnValue | Decimal | not specified | Resolved parent policy number, or the input policy number when the policy is non-affiliated. |
Tables¶
No table is referenced directly in the .NET source. The tables read by the procedure body reside in the Oracle database and are described under pk72846_view_policy.
Sample SQL¶
-- Stored procedure call (procedure body resides in the Oracle database - WCIS_DBA.pk72846_view_policy)
-- Called from an <Obsolete> code path
CALL pk72846_view_policy.getParentPolicy(
in_policy_num => :in_policy_num,
in_is_policyholder_user => :in_is_policyholder_user)
-- returns v_parent_policy_num (return-value output parameter)
Operations and processes¶
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.View.Policy/clsPolicyData.vb