DB-CLL-024 — Retrieve a single outcome issue¶

Classification¶

Field	Value
SQL ID	DB-CLL-024
Operation type	R
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsOutcomeIssue
Criteria property	RetrieveSQL
Lifecycle method	AfterRetrieve

Parameters¶

Name	Direction	Type	Default	Description
CaseOutcomeID	Input	NUMBER	N/A	Case outcome identifier the issue row belongs to

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