SQL-014 Get policy affiliate type¶
Retrieve the affiliate type for a policy.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-014 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | GetAffiliateTypeSQL (<Obsolete>) |
| Lifecycle method | GetAffiliateType |
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_affiliate_type |
ReturnValue | String | 20 | Affiliate type code |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure, Scalar)
-- clsPolicyData.GetAffiliateType [Obsolete]
CALL pk72846_view_policy.getpolicyaffiliatetype(
:in_policy_num,
:in_is_policyholder_user,
:v_affiliate_type) -- ParameterDirection.ReturnValue
Operations and processes¶
Business rules¶
- BR-VP-012: Affiliated policy list filtered by agent/agency
- BR-VP-013: DisplayAffiliatedPolices matrix controls display
Sources¶
SAIF.Business.View.Policy/clsPolicyData.vb