DB-CLL-003 — Update case cost amounts and details
Classification
| Field |
Value |
| SQL ID |
DB-CLL-003 |
| Operation type |
U |
| Execution method |
Text |
| Database |
Oracle (Case Management) |
| Schema |
[unqualified]** |
| Command type |
Inline text SQL |
| Business object |
clsCaseCost |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Name |
Direction |
Type |
Default |
Description |
| LegalCaseID |
Input |
NUMBER |
N/A |
Legal case identifier the cost line belongs to |
| PayeeFirmProvLocID |
Input |
NUMBER |
N/A |
Payee firm provider-location identifier |
| PayeePersonProvLocID |
Input |
NUMBER |
N/A |
Payee person provider-location identifier |
| ServiceFromDate |
Input |
DATE |
N/A |
Start of the billed service period |
| ServiceToDate |
Input |
DATE |
N/A |
End of the billed service period |
| ServiceCode |
Input |
VARCHAR2 |
N/A |
Code identifying the type of service billed |
| AmountPaid |
Input |
NUMBER |
N/A |
Amount paid for the service |
| AuthorizerEmplid |
Input |
VARCHAR2 |
N/A |
Employee ID of the person who authorized the cost |
| AuthorizedDate |
Input |
DATE |
N/A |
Date the cost was authorized |
| AmountBilled |
Input |
NUMBER |
N/A |
Amount billed by the payee |
| PrepaymentFlag |
Input |
VARCHAR2 |
1 |
Indicates the cost is a prepayment |
| CancelledByCode |
Input |
VARCHAR2 |
N/A |
Code identifying who cancelled the cost, if cancelled |
| CreateDate |
Input |
DATE |
N/A |
Row creation timestamp |
| CreateUser |
Input |
VARCHAR2 |
N/A |
User who created the row |
| UpdateDate |
Input |
DATE |
N/A |
Row last-update timestamp |
| UpdateUser |
Input |
VARCHAR2 |
N/A |
User who last updated the row |
| AmountPerHour |
Input |
NUMBER |
N/A |
Hourly billing rate, if applicable |
| HoursBilled |
Input |
NUMBER |
N/A |
Number of hours billed |
| CaseCostID |
Input |
NUMBER |
N/A |
Primary key of the row to update |
Tables
| Table |
Access |
Columns/Notes |
| CASE_COST |
UPDATE |
17 non-key columns, filtered by CASE_COST_SEQ_NUM |
Sample SQL
Update CASE_COST
Set
PAYEE_FIRM_PROV_LOC_ID = :PayeeFirmProvLocID,
PAYEE_PERSON_PROV_LOC_ID = :PayeePersonProvLocID,
SERVICE_FROM_DATE = :ServiceFromDate,
SERVICE_TO_DATE = :ServiceToDate,
SERVICE_CODE = :ServiceCode,
AMOUNT_PAID = :AmountPaid,
AUTHORIZER_EMPLID = :AuthorizerEmplid,
AUTHORIZED_DATE = :AuthorizedDate,
AMOUNT_BILLED = :AmountBilled,
PREPAYMENT_FLAG = :PrepaymentFlag,
CANCELLED_BY_CODE = :CancelledByCode,
UPDATE_DATE = :UpdateDate,
UPDATE_USER = :UpdateUser,
AMOUNT_PER_HOUR = :AmountPerHour,
HOURS_BILLED = :HoursBilled
Where
CASE_COST.CASE_COST_SEQ_NUM = :CaseCostID
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb