SQL-025 Retrieve medically-stationary date
Calls the Oracle stored procedure that determines a claim's medically-stationary date via a REF CURSOR result.
Classification
| Field |
Value |
| SQL ID |
SQL-025 |
| Operation type |
Read |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
StoredProcedure |
| Business object |
clsMedicallyStationaryDate |
| Criteria property |
(procedure) |
| Lifecycle method |
BeforeRetrieve |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
inSaifClaimNum |
Input |
String |
7 |
SAIF claim number |
recordset |
Output (Cursor) |
REF CURSOR |
N/A |
Result cursor |
Tables
| Table |
Access |
Columns used |
|
|
|
Sample SQL
-- Stored procedure call — sp82289_medicallystationarydt
CALL sp82289_medicallystationarydt(:inSaifClaimNum, :recordset)
Procedure body resides in the Oracle database and could not be retrieved in this environment.
Operations and processes
Sources
- SAIF.Business.Claim/clsMedicallyStationaryDate.vb