SQL-007: Policy header retrieval¶
clsPolicyData uses this call to load the policy header — the identity, status, dates, and flags that every policy view starts from. It is the first database call in the retrieval chain and the object that all other reads in this library hang from.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-007 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:apolicynum |
Input | Decimal | not specified | Policy number for the header row. |
recordset |
Output (Cursor) | REF CURSOR | N/A | Single-row policy header result set. |
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 pk73094_policy_data.
Sample SQL¶
-- Stored procedure call (procedure body resides in the Oracle database - WCIS_DBA.pk73094_policy_data)
CALL pk73094_policy_data.getpolicy(
apolicynum => :apolicynum,
recordset => :recordset) -- REF CURSOR output
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