SQL-004 Non-typed association lookup¶
Retrieve non-typed policy associations using a data-driven procedure name.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-004 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsAssociationTypeCode |
| Criteria property | n/a (procedure name comes from data) |
| Lifecycle method | GetNonTypedAssociations (static helper) |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:inPolicyNumber |
Input | Decimal | N/A | Policy number |
recordset |
Output (Cursor) | REF CURSOR | N/A | Untyped association rows (AssociationType, PolicyNumber, IsParent, PolicyName) |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsAssociationTypeCode.GetNonTypedAssociations; the procedure name is data-driven,
-- read from ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME (see SQL-005).
CALL <ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME>(
:inPolicyNumber,
:recordset)
Operations and processes¶
Business rules¶
- BR-VP-015: Preferred association type overrides derived type
- BR-VP-020: Association type is secured when security group set
- BR-VP-021: Association category prefix classification
Sources¶
SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb