SQL-013: Policy affiliate-type classification (superseded)¶
clsPolicyData used this call to classify a policy's affiliation family 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-013 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | GetAffiliateTypeSQL |
| Lifecycle method | GetAffiliateType |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:in_policy_num |
Input | Decimal | not specified | Policy number being classified. |
:in_is_policyholder_user |
Input | String | 5 | TRUE/FALSE flag stating whether the caller is a policyholder user; gates the manual-affiliation check. |
:v_affiliate_type |
ReturnValue | String | 50 | Resolved affiliate-type code. |
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.getpolicyaffiliatetype(
in_policy_num => :in_policy_num,
in_is_policyholder_user => :in_is_policyholder_user)
-- returns v_affiliate_type (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