DB-CLL-006 — Retrieve case cost list for a legal case

Classification

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

Parameters

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Legal case identifier used to filter the cost list

Tables

Table	Access	Columns/Notes
CASE_COST	SELECT	LEGAL_CASE_SEQ_NUM, all CASE_COST columns

Sample SQL

Select
  CASE_COST.CASE_COST_SEQ_NUM as CaseCostID,
  CASE_COST.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  CASE_COST.PAYEE_FIRM_PROV_LOC_ID as PayeeFirmProvLocID,
  CASE_COST.PAYEE_PERSON_PROV_LOC_ID as PayeePersonProvLocID,
  CASE_COST.SERVICE_FROM_DATE as ServiceFromDate,
  CASE_COST.SERVICE_TO_DATE as ServiceTODate,
  CASE_COST.SERVICE_CODE as ServiceCode,
  CASE_COST.AMOUNT_PAID as AmountPaid,
  CASE_COST.AUTHORIZER_EMPLID as AuthorizerEmplid,
  CASE_COST.AUTHORIZED_DATE as AuthorizedDate,
  CASE_COST.AMOUNT_BILLED as AmountBilled,
  CASE_COST.PREPAYMENT_FLAG as PrepaymentFlag,
  CASE_COST.CANCELLED_BY_CODE as CancelledBYCode,
  CASE_COST.CREATE_DATE as CreateDate,
  CASE_COST.CREATE_USER as CreateUser,
  CASE_COST.UPDATE_DATE as UpdateDate,
  CASE_COST.UPDATE_USER as UpdateUser,
  CASE_COST.AMOUNT_PER_HOUR as AmountPerHour,
  CASE_COST.HOURS_BILLED as HoursBilled
From
  CASE_COST
Where
  CASE_COST.LEGAL_CASE_SEQ_NUM = :LegalCaseID
Order by
  CASE_COST.SERVICE_FROM_DATE desc

Operations and processes

• Manage case cost entries

Business rules

• BR-CLM-LGL-001
• BR-CLM-LGL-002
• BR-CLM-LGL-003
• BR-CLM-LGL-005

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb