SQL-031 Team assign query

This stored procedure call retrieves the service team assignments for a policy so the library can populate team members and apply email-address derivation and masking behavior.

Classification

Field	Value
SQL ID	SQL-031
Operation type	Read
Execution method	StoredProc
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	clsTeamAssignmentCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:apolicynum	Input	Decimal	N/A	Policy number whose service team assignments are requested.
recordset	Output (Cursor)	REF CURSOR	N/A	Result set containing service team assignment rows.

Tables

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

Sample SQL

-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsTeamAssignmentCollection.BeforeRetrieve
CALL pk72846_view_policy.team_assign_query(
  :apolicynum,
  :recordset)

The procedure body resides in the Oracle database; it was not retrievable for this run.

Operations and processes

• Retrieve service team

Business rules

• BR-VP-010: Demo users see masked data
• BR-VP-022: Team member email address derivation
• BR-VP-027: Create/Insert/Update/Delete SQL are invalid

Sources

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