SQL-001 Get policy affiliate list¶
Retrieve affiliated policies for a policy and affiliate type.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-001 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsAffiliatedPolicyCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:in_policy_num |
Input | Decimal | N/A | Policy number |
:in_affiliate_type |
Input | String | 25 | Affiliate type code (upper-cased) |
:in_include_affil_totals |
Input | String | 4 / 5 | "TRUE" or "FALSE" — include affiliate totals |
recordset |
Output (Cursor) | REF CURSOR | N/A | Affiliated policy rows |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsAffiliatedPolicyCollection.BeforeRetrieve
CALL pk72846_view_policy.getpolicyaffiliatelist(
:in_policy_num,
:in_affiliate_type,
:in_include_affil_totals,
:recordset)
Operations and processes¶
Business rules¶
- BR-VP-011: Policy always affiliated with itself
- BR-VP-012: Affiliated policy list filtered by agent/agency
- BR-VP-013: DisplayAffiliatedPolices matrix controls display
- BR-VP-027: Create/Insert/Update/Delete SQL are invalid
Sources¶
SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb