SQL-016 Appeal number review level list for a case

StringBuilder/concatenation (const APEALNUMLEVELSQL + CurrentCaseID → GetCodeCollection) for clsOutcomeManager.

Classification

Field	Value
SQL ID	SQL-016
Operation type	Read
Execution method	StringBuilder/concatenation (const APEALNUMLEVELSQL + CurrentCaseID → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsOutcomeManager
Criteria property	N/A
Lifecycle method	AppealNumLevelList property getter

Tables

Table	Access	Columns used
APPEAL	SELECT	See database table section
REVIEW_LEVEL_CODE	SELECT	See database table section
DUAL	SELECT	See database table section

Sample SQL

-- Reconstructed: APEALNUMLEVELSQL & CurrentCaseID.ToString
SELECT
  '0',
  'Hearings Level'
FROM dual
UNION
SELECT
  to_char(APPEAL.APPEAL_SEQ_NUM) as code,
  CODE_DESCR || decode(appeal.appeal_num, null, '', '-' || APPEAL.APPEAL_NUM) as description
FROM APPEAL
  LEFT OUTER JOIN REVIEW_LEVEL_CODE
    ON REVIEW_LEVEL_CODE = CODE
WHERE APPEAL.LEGAL_CASE_SEQ_NUM = <CurrentCaseID>

Operations and processes

• Case outcome entry — appeal level selector

Sources

• SAIF.Application.Claim.Legal\LegalNet\clsOutcomeManager.vb