SQL-034 Calculate timeliness of first payment
Calls the Oracle stored procedure that evaluates timeliness of the first benefit payment, optionally requesting a 'Detail' variant.
Classification
| Field |
Value |
| SQL ID |
SQL-034 |
| Operation type |
Read |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
StoredProcedure |
| Business object |
clsTimelinessOfFirstPayment |
| Criteria property |
(procedure) |
| Lifecycle method |
BeforeRetrieve |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
inClaimID |
Input |
Decimal |
— |
Claim identifier |
requestType |
Input |
String |
6 |
Conditional — added only when Criteria.FromClaimDetail is true; value 'Detail' |
recordset |
Output (Cursor) |
REF CURSOR |
N/A |
Result cursor |
Tables
| Table |
Access |
Columns used |
|
|
|
Sample SQL
-- Stored procedure call — sp82067_TimelinessOf1stPayment
-- If Criteria.FromClaimDetail Then requestType = 'Detail'
CALL sp82067_TimelinessOf1stPayment(:inClaimID, [:requestType,] :recordset)
Procedure body resides in the Oracle database and could not be retrieved in this environment.
Operations and processes
Business rules
Sources
- SAIF.Business.Claim/clsITimelinessOfFirstPayment.vb