DB-CLL-016 — Retrieve case notes for a legal case
Classification
| Field |
Value |
| SQL ID |
DB-CLL-016 |
| Operation type |
R |
| Execution method |
StoredProc |
| Database |
Oracle (Case Management) |
| Schema |
[unqualified]** |
| Command type |
Stored procedure call |
| Business object |
clsCaseNote |
| Criteria property |
RetrieveSQL |
| Lifecycle method |
BeforeRetrieve |
Parameters
| Name |
Direction |
Type |
Default |
Description |
| LegalCaseID |
Input |
NUMBER |
N/A |
Legal case identifier used to filter notes |
| RefCursor |
Output (Cursor) |
REF CURSOR |
N/A |
Result set of matching case note rows |
Tables
| Table |
Access |
Columns/Notes |
| CASE_NOTE |
SELECT |
LegalCaseID filter, cursor result set |
Sample SQL
EXEC Pk80001_Legalnet.GetCaseNote(:LegalCaseID, :RefCursor OUT);
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\LegalNet\clsCaseNote.vb