DB-CLL-025 — Retrieve the outcome issue list for an outcome¶

Classification¶

Field	Value
SQL ID	DB-CLL-025
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsOutcomeIssue 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 issue rows

Tables¶

Table	Access	Columns/Notes
OUTCOME_ISSUE	SELECT	CASE_OUTCOME_SEQ_NUM, all OUTCOME_ISSUE columns

Sample SQL¶

Select
  OUTCOME_ISSUE.OUTCOME_ISSUE_SEQ_NUM as OutcomeIssueID,
  OUTCOME_ISSUE.CASE_OUTCOME_SEQ_NUM as CaseOutcomeID,
  OUTCOME_ISSUE.OUTCOME_ISSUE_CODE as OutcomeIssueCode,
  OUTCOME_ISSUE.OUTCOME_GROUNDS_CODE as OutcomeGroundsCode,
  OUTCOME_ISSUE.NATURE_CODE as NatureCode,
  OUTCOME_ISSUE.WIN_LOSS_FLAG as WinLossFlag,
  OUTCOME_ISSUE.FEE_AMOUNT as FeeAmount,
  OUTCOME_ISSUE.PENALTY_FLAG as PenaltyFlag,
  OUTCOME_ISSUE.SUMMARY_TEXT as SummaryText,
  OUTCOME_ISSUE.PRIMARY_ISSUE_FLAG as PrimaryIssueFlag,
  OUTCOME_ISSUE.CREATE_DATE as CreateDate,
  OUTCOME_ISSUE.CREATE_USER as CreateUser,
  OUTCOME_ISSUE.UPDATE_DATE as UpdateDate,
  OUTCOME_ISSUE.UPDATE_USER as UpdateUser,
  OUTCOME_ISSUE.LEGAL_BODY_PART_CODE as LegalBodyPartCode
From
  OUTCOME_ISSUE
Where
  OUTCOME_ISSUE.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\clsOutcomeIssue.vb