DB-CLL-052 — Stamp the file-create date on a legal case
Classification
| Field |
Value |
| SQL ID |
DB-CLL-052 |
| Operation type |
Misc |
| Execution method |
StoredProc |
| Database |
Oracle (Case Management) |
| Schema |
[unqualified]** |
| Command type |
Stored procedure call |
| Business object |
clsCreateFile.UpdateCreateFile |
| Criteria property |
n/a (custom method) |
| Lifecycle method |
n/a |
Parameters
| Name |
Direction |
Type |
Default |
Description |
| LegalCaseID |
Input |
NUMBER |
N/A |
Legal case identifier |
| FileCreateDate |
Input |
DATE |
N/A |
Date the physical/electronic file was created |
Tables
| Table |
Access |
Columns/Notes |
| LEGAL_CASE |
UPDATE |
LegalCaseID, FileCreateDate |
Sample SQL
EXEC Pk80001_Legalnet.setFileCreateDate(:LegalCaseID, :FileCreateDate);
Operations and processes
Sources
SAIF.Business.Claim.Legal\LegalNet\clsCreateFile.vb