SQL-025 CP claimprofile get group policy list¶

This stored procedure call retrieves the list of policies available to a group user so the UI can present accessible policy choices.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`@GroupKeyCode`	Input	Decimal	N/A	Group key code identifying the requesting group.
`@SpecificChapterCode`	Input	String	N/A	Specific chapter code filter for the group user.
`@rptDate`	Input	Date	N/A	Report date used to scope the accessible policy list.

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.GetPolicyListforGroup, executed against DPISql (clsSQLDataLayer)
EXEC cp_claimprofile_get_group_policy_list
  @GroupKeyCode        = @GroupKeyCode,
  @SpecificChapterCode = @SpecificChapterCode,
  @rptDate             = @rptDate
-- 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

Sources¶

SAIF.Business.View.Policy/clsPolicySecurity.vb