SQL-026 CP claimprofile get SC book

This stored procedure call retrieves the list of policies assigned to a safety consultant so the library can expose that user's accessible policy list.

Classification

Field	Value
SQL ID	SQL-026
Operation type	Read
Execution method	StoredProc
Database	SQL Server (BDS)
Schema	[unqualified]**
Command type	StoredProcedure
Business object	clsPolicySecurity
Criteria property	N/A
Lifecycle method	GetPolicyListForSafetyConsultant

Parameters

Parameter	Direction	Type	Max length	Description
@losscontrol	Input	String	N/A	Loss control user identifier whose accessible policy list is requested.

Tables

Table	Access	Columns used
N/A — Stored procedure	SELECT	Procedure body resides in the database.

Sample SQL

-- SQL Server (BDS) stored procedure call (CommandType.StoredProcedure, ResultSet)
-- clsPolicySecurity.GetPolicyListForSafetyConsultant, executed against DPISql (clsSQLDataLayer)
EXEC cp_claimprofile_get_sc_book
  @losscontrol = @losscontrol
-- returns columns: policy_number, policy_name

The procedure body resides in the SQL Server (BDS) database; it was not retrievable for this run.

Operations and processes

• Retrieve accessible policy list

Business rules

• BR-VP-005: Access granted per user-access-level matrix
• BR-VP-007: Loss control prefix match

Sources

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