DB-CLL-027 — Retrieve the outcome staff list for an outcome¶

Classification¶

Field	Value
SQL ID	DB-CLL-027
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsOutcomeStaff collection ctor
Criteria property	MyRetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters¶

Name	Direction	Type	Default	Description
CaseOutcomeID	Input	NUMBER	N/A	Case outcome identifier used to filter staff rows

Tables¶

Table	Access	Columns/Notes
OUTCOME_STAFF	SELECT	CASE_OUTCOME_SEQ_NUM, OUTCOME_STAFF_SEQ_NUM, OUTCOME_STAFF_PERSON_SEQ_NUM

Sample SQL¶

Select
  OUTCOME_STAFF_SEQ_NUM As OutcomeStaffID,
  CASE_OUTCOME_SEQ_NUM As CaseOutcomeID,
  OUTCOME_STAFF_PERSON_SEQ_NUM As OutcomeStaffPersonID
From
  OUTCOME_STAFF
Where
  OUTCOME_STAFF.CASE_OUTCOME_SEQ_NUM = :CaseOutcomeID

Operations and processes¶

Manage case outcomes, issues, and staff

Business rules¶

BR-CLM-LGL-005

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsOutcomeStaff.vb