SQL-011 Get view detail

Retrieve detailed policy view data for lazy-loaded fields.

Classification

Field	Value
SQL ID	SQL-011
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	clsPolicyData
Criteria property	RetrieveDetailSQL
Lifecycle method	RetrievePolicyDetail (lazy read)

Parameters

Parameter	Direction	Type	Max length	Description
:apolicynum	Input	Decimal	N/A	Policy number
recordset	Output (Cursor)	REF CURSOR	N/A	Detailed policy view row

Tables

N/A — Stored procedure

Sample SQL

-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsPolicyData.RetrievePolicyDetail
CALL pk72846_view_policy.getviewdetail(
  :apolicynum,
  :recordset)

Operations and processes

• Lazy retrieval of policy detail and indicators

Business rules

• BR-VP-026: Detail-read failure does not fail overall retrieve

Sources

• SAIF.Business.View.Policy/clsPolicyData.vb