DB-CLL-001 — Retrieve a single case cost by ID

Classification

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

Parameters

Name	Direction	Type	Default	Description
CaseCostID	Input	NUMBER	N/A	Primary key of the case cost row to retrieve

Tables

Table	Access	Columns/Notes
CASE_COST	SELECT	CASE_COST_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.CASE_COST_SEQ_NUM = :CaseCostID

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